private void DataBindDDl()
{
try
{
DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB);
ddlDateWeek.DataTextField = "dateweek";
ddlDateWeek.DataValueField = "dateweek";
ddlDateWeek.DataSource = ds;
ddlDateWeek.DataBind();
/*DataTable dt = PH_UserVendor.PH_UserVendor_SelectAll(AppCode.strConnDB);
* ddlVendorCode.DataTextField = "vendor_code";
* ddlVendorCode.DataValueField = "vendor_code";
* ddlVendorCode.DataSource = dt;
* ddlVendorCode.DataBind();*/
DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB);
ddlHaluier.DataTextField = "haulier_abbr";
ddlHaluier.DataValueField = "haulier_abbr";
ddlHaluier.DataSource = dt;
ddlHaluier.DataBind();
}
catch (Exception ex)
{
lblErr.Text = ex.Message;
PH_ExceptionManager.WriteError(ex.Message);
}
}
public string[] GetHaulierCode(string prefixText)
{
DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB);
List <string> items = new List <string>(dt.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
string strName = dt.Rows[i]["haulier_taxid"].ToString() + "-" + dt.Rows[i]["haulier_name_en"].ToString() + "-" + dt.Rows[i]["haulier_name_th"].ToString();
items.Add(strName);
}
return(items.ToArray());
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (PHCore_User.SelAllUserName(AppCode.strConnDB, txtUserName.Text).Trim() != "")
{
lblErrUserName.Text = ConfigurationManager.AppSettings["PH_AddNew_UserName_Err"];
}
else if (GetRoleId() == PHCore_Status.RoleID.HL.ToString() && PH_HaulierInfo.PH_Haulier_SelByTaxId(AppCode.strConnDB, txtHaulierCode.Text).Trim() == "")
{
lblErrHaulierCode.Text = ConfigurationManager.AppSettings["PH_AddNew_Haulier_Err"];
}
else
{
InsertUserProfile();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
PH_ExceptionManager.WriteError(ex.Message);
}
}
