protected void Page_Load(object sender, EventArgs e) { if (Request.UrlReferrer == null) { base.AutoRedirect(); } if (base.CheckUserRights(intFormId) == false) { Response.Redirect("PermissionDenied.aspx"); } if (base.ADD == false) { lnkbtnSave.Visible = false; } if (!Page.IsPostBack) { this.ValidateControls(); this.BindDropdown(); this.BindCityDropDown(); dtTemp = CreateDt(); ViewState["dt"] = dtTemp; DdlVehicleNo.Focus(); if (Request.QueryString["q"] != null) { Populate(Convert.ToInt64(Request.QueryString["q"])); hidid.Value = Convert.ToString(Request.QueryString["q"]); lnkbtnMnNew.Visible = true; } } }
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = ""; if (e.CommandName == "cmdedit") { Response.Redirect("Tracking.aspx?q=" + e.CommandArgument, true); } if (e.CommandName == "cmddelete") { Int64 UserIdno = Convert.ToInt64(Session["UserIdno"]); TrackingDAL obj = new TrackingDAL(); Int32 intValue = obj.Delete(Convert.ToInt32(e.CommandArgument), UserIdno, ApplicationFunction.ConnectionString()); obj = null; if (intValue > 0) { this.BindGrid(); ShowMessage("Record deleted Successfully"); DdlVehicleNo.Focus(); } else { if (intValue == -1) { ShowMessage("Record can not be deleted. It is in use."); } else { ShowMessage("Record not deleted."); } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { Int64 intIdno = 0; #region Validation Messages for Tracking Details if (DdlVehicleNo.SelectedIndex == 0) { this.ShowMessage("Please Enter Vehicle No"); DdlVehicleNo.Focus(); return; } if (DdlLane.SelectedIndex == 0) { this.ShowMessage("Please select Lane"); DdlLane.Focus(); return; } if (DdlFromCity.SelectedIndex == 0) { this.ShowMessage("Please select From City"); DdlFromCity.Focus(); return; } if (DdlToCity.SelectedIndex == 0) { this.ShowMessage("Please select To City"); DdlToCity.Focus(); return; } if (DdlCompName.SelectedIndex == 0) { this.ShowMessage("Please Enter Company Name"); DdlCompName.Focus(); return; } if (DdlFromLoc.SelectedIndex == 0) { this.ShowMessage("Please Enter From Location"); DdlFromLoc.Focus(); return; } dtTemp = (DataTable)ViewState["dt"]; if (dtTemp != null) { if (dtTemp.Rows.Count <= 0) { ShowMessage("Please enter details"); return; } } if (grdMain.Rows.Count <= 0) { ShowMessage("Please enter details"); return; } #endregion Int64 trackingIdno = 0; TrackingDAL objtrackingDAL = new TrackingDAL(); if (Request.QueryString["q"] != null) { trackingIdno = Convert.ToInt64(Request.QueryString["q"]); } Int64 VehicleNo = Convert.ToInt64(DdlVehicleNo.SelectedValue); string Date = txtDate.Text; Int64 LaneIdno = Convert.ToInt64(DdlLane.SelectedValue); Int64 CompName = Convert.ToInt64(DdlCompName.SelectedValue); Int64 FromLoc = Convert.ToInt64(DdlFromLoc.SelectedValue); Int64 FromCityIdno = Convert.ToInt64(DdlFromCity.SelectedValue); Int64 ToCityIdno = Convert.ToInt64(DdlToCity.SelectedValue); DataTable dtDetail = (DataTable)ViewState["dt"]; if (this.ValidationEstNoSave((Request.QueryString["q"] != null) ? Convert.ToInt64(Request.QueryString["q"]) : 0)) // if (this.ValidationEstNoSave((Request.QueryString["q"] != null) ? Convert.ToInt64(Request.QueryString["q"]) : 0)) { using (TransactionScope dbTran = new TransactionScope(TransactionScopeOption.Required)) { try { if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0) { if (string.IsNullOrEmpty(hidid.Value) == false) { intIdno = objtrackingDAL.Update(trackingIdno, VehicleNo, Date, LaneIdno, FromCityIdno, ToCityIdno, CompName, FromLoc, dtDetail); } else { intIdno = objtrackingDAL.Insert(trackingIdno, VehicleNo, Date, LaneIdno, FromCityIdno, ToCityIdno, CompName, FromLoc, dtDetail); } objtrackingDAL = null; } if (intIdno > 0) { dbTran.Complete(); dbTran.Dispose(); ShowMessage("Record saved Successfully"); } else if (intIdno < 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Vehicle already made with this No.')", true); dbTran.Dispose(); } else { if (Request.QueryString["q"] != null) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record not updated.')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record(s) not saved.')", true); } dbTran.Dispose(); } Clear(); ClearItems(); BindCityDropDown(); grdMain.DataSource = null; grdMain.DataBind(); } catch (Exception exe) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Some issue occure, Please Contact Cogxim Support Executive.')", true); dbTran.Dispose(); } } } }
protected void lnkbtnCancel_OnClick(object sender, EventArgs e) { this.Clear(); this.ClearItems(); DdlVehicleNo.Focus(); }
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(); }