namespace WR_ID 
{
    public class WUID : tw.com.dsc.easyflowDotNet.kernelBasePage.TEIBasePage
    {
        string s_plants = "";
        string commstring = "";
        public string WR_UID(string S_FORMID, string S_SHEETNO, string P_Name)
        {
            
            
            string DB_String;
            DB_String = objEFPara.EF_getCompanyParameterData("EF_DBName").ToString().Trim();
            string S_EF_DBName = string.Format("{0}", DB_String);
            string[] S_EF_END = S_EF_DBName.Split(new char[] { ';' });
            string EF_1 = S_EF_END[0];
            string EF_2 = S_EF_END[1];
            string EF_3 = S_EF_END[2];
            string EF_4 = S_EF_END[3];

            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
            builder.DataSource = EF_1.Trim();
            builder.InitialCatalog = EF_2.Trim();
            builder.UserID = EF_3.Trim();
            builder.Password = EF_4.Trim();

            SqlConnection connn = new SqlConnection(builder.ConnectionString);
            SqlConnection conn = new SqlConnection(builder.ConnectionString);
            SqlConnection conn_splant = new SqlConnection(builder.ConnectionString);

            StringBuilder tSql = new StringBuilder();
            StringBuilder tSq2 = new StringBuilder();
            StringBuilder tSq3 = new StringBuilder();
            connn.Open();
            tSq2.AppendFormat("SELECT resda016 FROM resda ");
            tSq2.AppendFormat(" WHERE resda001 ='{0}' AND resda002 = '{1}'", formID, SheetNo);
            SqlCommand tCommand = new SqlCommand(tSq2.ToString(), connn);
            SqlDataReader rd = tCommand.ExecuteReader();//read uid
            if (rd.Read())
            {
                commstring = rd["resda016"].ToString();
                // Session["log"] = commstring.ToString();
                // Response.Redirect("log.aspx");

                tSql.Remove(0, tSql.Length);
              //  try
                {
                    conn.Open();
                    tSql.AppendFormat("UPDATE {0} SET IDNUMBER = '{1}'", P_Name, commstring);
                    tSql.AppendFormat(" WHERE {0}002 = '{1}' ", P_Name, SheetNo);
                    SqlCommand tCommand_wte = new SqlCommand(tSql.ToString(), conn);
                    tCommand_wte.ExecuteNonQuery();


                    conn_splant.Open();
                    tSq3.AppendFormat("SELECT resak301 FROM resak ");
                    tSq3.AppendFormat(" WHERE resak001 = '{0}'", commstring.ToString());
                    SqlCommand tCommand_ruid = new SqlCommand(tSq3.ToString(), conn_splant);
                    SqlDataReader rid = tCommand_ruid.ExecuteReader();//read uid
                    if (rid.Read())
                    {
                        s_plants = rid["resak301"].ToString();
                    }
                   

                }
             //   catch (Exception ex)
                {
                    //throw new Exception(ex.tSql);
                }
              //  finally
                {
                    conn.Close();
                    conn.Dispose();
                    conn_splant.Close();
                    conn_splant.Dispose();

                }

            }
            connn.Close();
            connn.Dispose();

            return s_plants;
        }
    }
}