private void BindCityDropDown()
{
TrackingDAL obj = new TrackingDAL();
var ToCity = obj.BindAllToCity();
obj = null;
DdlFromCty.DataSource = ToCity;
DdlFromCty.DataTextField = "city_name";
DdlFromCty.DataValueField = "city_idno";
DdlFromCty.DataBind();
DdlFromCty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
DdlToCty.DataSource = ToCity;
DdlToCty.DataTextField = "city_name";
DdlToCty.DataValueField = "city_idno";
DdlToCty.DataBind();
DdlToCty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (DdlVehicleNo.SelectedValue == "0")
{
ShowMessage("Please Select Vehicle No.");
DdlVehicleNo.Focus();
return;
}
if (DdlLane.SelectedValue == "0")
{
ShowMessage("Please Select Lane.");
DdlLane.Focus();
return;
}
if (DdlFromCity.SelectedValue == "0")
{
ShowMessage("Please Enter from City.");
DdlFromCity.Focus();
return;
}
if (DdlToCity.SelectedValue == "0")
{
ShowMessage("Please Enter To City.");
DdlToCity.Focus();
return;
}
if (DdlFromLoc.SelectedValue == "0")
{
ShowMessage("Please Enter From Location.");
DdlFromLoc.Focus();
return;
}
if (DdlCompName.SelectedValue == "0")
{
ShowMessage("Please Enter Company Name.");
DdlCompName.Focus();
return;
}
if (DdlFromCty.SelectedValue == "0")
{
ShowMessage("Please Enter from City.");
DdlFromCty.Focus();
return;
}
if (DdlToCty.SelectedValue == "0")
{
ShowMessage("Please Enter To City.");
DdlToCty.Focus();
return;
}
if (txtLeg.Text == "")
{
ShowMessage("Leg should be greater than zero.");
txtLeg.Focus();
return;
}
if (txtETA.Text == "" || txtETA.Text == "0:00")
{
ShowMessage("ETA should be greater than zero.");
txtETA.Focus();
return;
}
if (txtATA.Text == "" || txtATA.Text == "0:00")
{
ShowMessage("ATA should be greater than zero.");
txtATA.Focus();
return;
}
if (txtETD.Text == "" || txtETD.Text == "0:00")
{
ShowMessage("ETD should be greater than zero.");
txtETD.Focus();
return;
}
if (txtATD.Text == "" || txtATD.Text == "0:00")
{
ShowMessage("ATD should be greater than zero.");
txtATD.Focus();
return;
}
if (txtTAThrs.Text == "" || txtTAThrs.Text == "0:00")
{
ShowMessage("TAT In Hrs should be greater than zero.");
txtTAThrs.Focus();
return;
}
if (Txtdelayhrs.Text == "" || Txtdelayhrs.Text == "0:00")
{
ShowMessage("Delay In Hrs should be greater than zero.");
Txtdelayhrs.Focus();
return;
}
if (Hidrowid.Value != string.Empty)
{
dtTemp = (DataTable)ViewState["dt"];
foreach (DataRow dtrow in dtTemp.Rows)
{
if (Convert.ToString(dtrow["Id"]) == Convert.ToString(Hidrowid.Value))
{
dtrow["FromCity"] = DdlFromCty.SelectedItem.Text;
dtrow["ToCity"] = DdlToCty.SelectedItem.Text;
dtrow["Leg"] = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim());
dtrow["ETA"] = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim());
dtrow["ATA"] = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim());
dtrow["ETD"] = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim());
dtrow["ATD"] = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim());
dtrow["TAT_in_hrs"] = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim());
dtrow["Delay_in_hrs"] = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim());
dtrow["Remarks"] = txtremark.Text;
dtrow["FromCityIdno"] = string.IsNullOrEmpty(DdlFromCty.SelectedValue.ToString()) ? "0" : (DdlFromCty.SelectedValue.ToString());
dtrow["ToCityIdno"] = string.IsNullOrEmpty(DdlToCty.SelectedValue.ToString()) ? "0" : (DdlToCty.SelectedValue.ToString());
}
}
}
else
{
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp == null)
{
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["Id"])) + 1;
string strFromCity = DdlFromCty.SelectedItem.Text;
string strToCity = DdlToCty.SelectedItem.Text;
string strLeg = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim());
string strETA = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim());
string strATA = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim());
string strETD = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim());
string strATD = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim());
string strTAThrs = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim());
string strdelayhrs = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim());
string strReamrks = txtremark.Text.Trim();
string strFromCityIdno = DdlFromCty.SelectedValue;
string strToCityIdno = DdlToCty.SelectedValue;
ApplicationFunction.DatatableAddRow(dtTemp, id, strFromCity, strToCity, strLeg, strETA, strATA, strETD, strATD, strTAThrs, strdelayhrs, strReamrks, strFromCityIdno, strToCityIdno);
ViewState["dt"] = dtTemp;
}
this.BindGridT();
ClearItems();
BindCityDropDown();
}
