C# (CSharp) cs_checkFiled.sql_checkDuplicate Examples

Example #1

File: haulier_abbrDuplicate.aspx.cs Project: parnupongk/primary

        protected void Page_Load(object sender, EventArgs e)
        {
            cs_checkFiled checkDuplicate      = new cs_checkFiled();
            int           afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 Haulier_TaxID FROM Haulier_Info where Haulier_Abbr='" + Request.Form["var01"].ToString() + "'");

            Response.Write(afterCheckDuplicate);
        }

Example #2

File: userDuplicate.aspx.cs Project: parnupongk/primary

        protected void Page_Load(object sender, EventArgs e)
        {
            cs_checkFiled checkDuplicate      = new cs_checkFiled();
            int           afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 UserID FROM User_Profile where UserName='******'");

            Response.Write(afterCheckDuplicate);
        }

Example #3

File: vender_nameEnDuplicate.aspx.cs Project: parnupongk/primary

 protected void Page_Load(object sender, EventArgs e)
 {
     cs_checkFiled checkDuplicate = new cs_checkFiled();
     string vendor_type = "";
     if (Request.Form["var02"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var02"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; }
     int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 Vendor_TaxID FROM Vendor_Info where Vendor_Name_En='" + Request.Form["var01"].ToString() + "' and vendor_type='"+vendor_type+"'");
     Response.Write(afterCheckDuplicate);
 }

Example #4

File: ajax_duVendorCode.aspx.cs Project: parnupongk/primary

        protected void Page_Load(object sender, EventArgs e)
        {
            cs_checkFiled checkDuplicate = new cs_checkFiled();
            string        vendor_type    = "";

            if (Request.Form["var02"].ToString().Substring(0, 1) == "B")
            {
                vendor_type = "BH";
            }
            else if (Request.Form["var02"].ToString().Substring(0, 1) == "F")
            {
                vendor_type = "FZ";
            }
            else
            {
                vendor_type = "VD";
            }
            int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 VendorID FROM Vendor_Group where Vendor_Code='" + Request.Form["var01"].ToString() + "' and vendor_type='" + vendor_type + "'");

            Response.Write(afterCheckDuplicate);
        }

Example #5

File: dc_nameEditDuplicate.aspx.cs Project: parnupongk/primary

 protected void Page_Load(object sender, EventArgs e)
 {
     cs_checkFiled checkDuplicate = new cs_checkFiled();
     int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 DC_NO FROM DC_Info where DC_Name='" + Request.Form["var01"].ToString() + "'");
     Response.Write(afterCheckDuplicate);
 }