protected void btnSave_click(object sender, EventArgs e)
{
string selCountrow = "SELECT COUNT(*) from route where delStatus<>1 AND routeCode='" + txtRouteCode.Text + "' ";
int rowNumber = Convert.ToInt32(dataProvider.getResultString(selCountrow));
string DepartTime = ((ddlDepartTimeHH.Text).ToString() + lblDepartTime1.Text + (ddlDepartTimeMM.Text).ToString() + (ddlDepartAmPm.Text).ToString());
string ArriveTime = ((ddlArrivTimeHH.Text).ToString() + lblArrivTime1.Text + (ddlArrivTimeMM.Text).ToString() + (ddlArrivAmPm.Text).ToString());
bllcreate.ROUTECODE = txtRouteCode.Text;
bllcreate.ROUTENAMEBAN = txtRouteNameBan.Text;
bllcreate.ROUTENAME = txtRouteName.Text;
bllcreate.SORTINGORDER = txtSortingOrder.Text;
bllcreate.STARTPOINT = ddlStartPoint.SelectedItem.Text;
bllcreate.ENDPOINT = ddlEndPoint.SelectedItem.Text;
bllcreate.DEPARTTIME = DepartTime;
bllcreate.ARRIVTIME = ArriveTime;
bllcreate.CREATEDATE = DateTime.Now;
bllcreate.AUDITUSER = Session["UserName"].ToString();
bllcreate.DISTANCE = Convert.ToInt32(txtDistance.Text);
if (hdnRouteId.Value != "" && hdnRouteId.Value != null)
{
bllcreate.ROUTEID = Convert.ToInt32(hdnRouteId.Value);
bllcreate.Update();
hdnRouteId.Value = "";
btnSave.Text = "Create";
DdlHH();
DdlMM();
}
else
{
if (rowNumber == 0)
{
bllcreate.Insert();
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "errorsmg", "alert('Route Code Already Created, Try Another Route Code...');", true);
}
}
bindRoute();
txtRouteCode.Text = "";
txtRouteNameBan.Text = "";
txtRouteName.Text = "";
txtSortingOrder.Text = "";
}
