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);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            cs_checkFiled PPHCheck  = new cs_checkFiled();
            string        ajaxValue = PPHCheck.sql_getAjaxAnswer("SELECT top 1 Contact_Person FROM User_Profile where UserName='******'");

            Response.Write(ajaxValue);
        }
Example #3
0
        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);
        }
 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 #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     main_function PPHfunction = new main_function();
     cs_checkFiled getLast = new cs_checkFiled();
     string vnID = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info order by VendorID desc");
     int m = Int32.Parse(vnID);
     string vendor_type = "";
     if (Request.Form["var04"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var04"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; }
     PPHfunction.QueryExecuteNonQuery("insert into Vendor_Info (VendorID, Vendor_TaxID, Vendor_Name_En, Vendor_Name_Th, StampTime, vendor_type) values ('" + (m + 1) + "', '" + Request.Form["var01"].ToString() + "','" + Request.Form["var02"].ToString() + "','" + Request.Form["var03"].ToString() + "','" + DateTime.Now + "','" + vendor_type + "')");
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     main_function PPHfunction = new main_function();
     cs_checkFiled getLast = new cs_checkFiled();
     //string vnID = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info  where Vendor_TaxID ='" + Request.Form["var02"].ToString() + "'");
     string vendor_type = "";
     if (Request.Form["var04"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var04"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; }
     string vnID = Request.Form["var02"].ToString();
     PPHfunction.QueryExecuteNonQuery("insert into Vendor_Group (VendorID, Vendor_Code, vendor_type) values ('" + vnID + "', '" + Request.Form["var01"].ToString() + "', '" + vendor_type + "')");
 }
Example #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (!IsPostBack)
         {
             cs_checkFiled getLast = new cs_checkFiled();
             string        frValue = getLast.sql_getAjaxAnswer("SELECT top 1 VAT_Rate FROM VAT_Default ");
             txtVatRate.Text = frValue;
         }
     }
     catch (Exception ex)
     {
         lblErr.Text = ex.Message;
         PH_ExceptionManager.WriteError(ex.Message);
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (!IsPostBack)
         {
             cs_checkFiled getLast = new cs_checkFiled();
             string frValue = getLast.sql_getAjaxAnswer("SELECT top 1 Fuel_Rate FROM Fuel_Rate_Default");
             txtFuelRate.Text = frValue;
         }
     }
     catch (Exception ex)
     {
         lblErr.Text = ex.Message;
         PH_ExceptionManager.WriteError(ex.Message);
     }
 }
        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 #10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            main_function PPHfunction = new main_function();
            cs_checkFiled getLast     = new cs_checkFiled();
            string        vnID        = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info order by VendorID desc");
            int           m           = Int32.Parse(vnID);
            string        vendor_type = "";

            if (Request.Form["var04"].ToString().Substring(0, 1) == "B")
            {
                vendor_type = "BH";
            }
            else if (Request.Form["var04"].ToString().Substring(0, 1) == "F")
            {
                vendor_type = "FZ";
            }
            else
            {
                vendor_type = "VD";
            }
            PPHfunction.QueryExecuteNonQuery("insert into Vendor_Info (VendorID, Vendor_TaxID, Vendor_Name_En, Vendor_Name_Th, StampTime, vendor_type) values ('" + (m + 1) + "', '" + Request.Form["var01"].ToString() + "','" + Request.Form["var02"].ToString() + "','" + Request.Form["var03"].ToString() + "','" + DateTime.Now + "','" + vendor_type + "')");
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            main_function PPHfunction = new main_function();
            cs_checkFiled getLast     = new cs_checkFiled();
            //string vnID = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info  where Vendor_TaxID ='" + Request.Form["var02"].ToString() + "'");
            string vendor_type = "";

            if (Request.Form["var04"].ToString().Substring(0, 1) == "B")
            {
                vendor_type = "BH";
            }
            else if (Request.Form["var04"].ToString().Substring(0, 1) == "F")
            {
                vendor_type = "FZ";
            }
            else
            {
                vendor_type = "VD";
            }
            string vnID = Request.Form["var02"].ToString();

            PPHfunction.QueryExecuteNonQuery("insert into Vendor_Group (VendorID, Vendor_Code, vendor_type) values ('" + vnID + "', '" + Request.Form["var01"].ToString() + "', '" + vendor_type + "')");
        }
 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);
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     cs_checkFiled PPHCheck = new cs_checkFiled();
     string ajaxValue = PPHCheck.sql_getAjaxAnswer("SELECT top 1 Contact_Person FROM User_Profile where UserName='******'");
     Response.Write(ajaxValue);
 }