protected void ddlTruckNo_SelectedIndexChanged(object sender, EventArgs e) { try { if ((ddlTruckNo.SelectedIndex >= 0)) { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); obj.selectOwnerName(Convert.ToInt32(ddlTruckNo.SelectedValue)); var lst = obj.selectOwnerName(Convert.ToInt32(ddlTruckNo.SelectedValue)); if (lst != null) { txtOwnrNme.Text = Convert.ToString(lst.Owner_Name + '-' + ((lst.Pan_No == null) ? "" : lst.Pan_No) + "-" + ((lst.Lorry_Type == 0) ? "O" : "H")); hidOwnerId.Value = Convert.ToString(lst.Prty_Idno); } } else { txtOwnrNme.Text = ""; } ddlTruckNo.Focus(); } catch (Exception Ex) { } }
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e) { try { double dblChallanAmnt = 0; if (e.Row.RowType == DataControlRowType.DataRow) { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); Int64 ChlnIdno = Convert.ToInt64(DataBinder.Eval(e.Row.DataItem, "Chln_Idno")); if ((obj.CheckBilled(ChlnIdno, ApplicationFunction.ConnectionString())) > 0) { LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); lnkbtnDelete.Visible = false; e.Row.ForeColor = System.Drawing.Color.Maroon; } obj = null; dblChallanAmnt = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Net_Amnt")); dblTChallanAmnt = dblChallanAmnt + dblTChallanAmnt; } else if (e.Row.RowType == DataControlRowType.Footer) { Label lblTChallanAmnt = (Label)e.Row.FindControl("lblNetAmnt"); lblTChallanAmnt.Text = dblTChallanAmnt.ToString("N2"); } } catch (Exception ex) { throw; } }
private void BindMaxNo(Int32 FromCityIdno, Int32 YearId) { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); Int64 MaxNo = obj.MaxNo(YearId, FromCityIdno, ApplicationFunction.ConnectionString()); txtchallanNo.Text = Convert.ToString(MaxNo); }
public void Countall() { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); Int64 count = obj.CountALL(); if (count > 0) { lblTotalRecord.Text = "T. Record (s):" + count; } else { lblTotalRecord.Text = "T. Record (s): 0 "; } }
protected void DdlfromcityHead_SelectedIndexChanged(object sender, EventArgs e) { try { ChlnBookingCrsngDAL objGR = new ChlnBookingCrsngDAL(); Int64 MaxCRNo = 0; MaxCRNo = objGR.MaxNo(Convert.ToInt32(ddldateRange.SelectedValue), Convert.ToInt32(Convert.ToString(DdlfromcityHead.SelectedValue) == "" ? 0 : Convert.ToInt32(DdlfromcityHead.SelectedValue)), ApplicationFunction.ConnectionString()); txtchallanNo.Text = Convert.ToString(MaxCRNo); DdlfromcityHead.Focus(); txtchallanNo.SelectText(); return; } catch (Exception Ex) { } }
private void Populate(Int64 HeadId) { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); tblChlnBookHead chlnBookhead = obj.selectHead(HeadId); ddldateRange.SelectedValue = Convert.ToString(chlnBookhead.Year_Idno); ddldateRange_SelectedIndexChanged(null, null); ddldateRange.Enabled = false; txtchallanNo.Text = chlnBookhead.Chln_No; txtDate.Text = Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy"); ddlTranspoter.SelectedValue = Convert.ToString(chlnBookhead.Transprtr_Idno); txtchlnRef.Text = Convert.ToString(chlnBookhead.Ref_No); ddlTruckNo.SelectedValue = Convert.ToString(chlnBookhead.Truck_Idno); ddlTruckNo_SelectedIndexChanged(null, null); txtgrossAmnt.Text = Convert.ToDouble(chlnBookhead.Gross_Amnt).ToString("N2"); txtKattAmnt.Text = Convert.ToDouble(chlnBookhead.Other_Amnt).ToString("N2"); txtNetAmnt.Text = Convert.ToDouble(chlnBookhead.Net_Amnt).ToString("N2"); hidWorkType.Value = Convert.ToString(chlnBookhead.Work_type); DdlfromcityHead.SelectedValue = Convert.ToString(chlnBookhead.BaseCity_Idno); dtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId); ViewState["dt"] = dtTemp; this.BindGridT(); // imgSearch.Enabled = false; Int64 value = 0; value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString()); if (value > 0) { lnkbtnSave.Enabled = false; } else { lnkbtnSave.Enabled = true; } obj = null; }
private void BindGrid() { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); DateTime? dtfrom = null; DateTime? dtto = null; String challanNo = txtReceiptNo.Text; if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false) { dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDatefrom.Text)); } if (string.IsNullOrEmpty(Convert.ToString(txtReceiptDatefrom.Text)) == false) { dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtReceiptDateto.Text)); } // int delvPlace = Convert.ToInt32(ddlDelvPlacce.SelectedValue); int cityfrom = Convert.ToInt32((drpCityFrom.SelectedIndex <= 0) ? "0" : drpCityFrom.SelectedValue); int TruckId = Convert.ToInt32((ddltruckNo.SelectedIndex <= 0) ? "0" : ddltruckNo.SelectedValue); Int64 UserIdno = 0; if (Convert.ToString(Session["Userclass"]) != "Admin") { UserIdno = Convert.ToInt64(Session["UserIdno"]); } var lstGridData = obj.search(Convert.ToInt32(ddldateRange.SelectedValue), challanNo, dtfrom, dtto, cityfrom, TruckId, UserIdno); obj = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("SrNo", typeof(string)); dt.Columns.Add("ChlnDate", typeof(string)); dt.Columns.Add("ChlnNo", typeof(string)); dt.Columns.Add("LorryNo", typeof(string)); dt.Columns.Add("FromCity", typeof(string)); dt.Columns.Add("NetAmnt", typeof(string)); double TNet = 0; for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr[0] = Convert.ToString(i + 1); dr["ChlnDate"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Chln_Date")).ToString("dd-MM-yyyy"); dr["ChlnNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Chln_No")); dr["LorryNo"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No")); dr["FromCity"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "FromCity")); dr["NetAmnt"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")).ToString("N2"); dt.Rows.Add(dr); TNet += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")); if (i == lstGridData.Count - 1) { DataRow drr = dt.NewRow(); drr["ChlnDate"] = ""; drr["ChlnNo"] = ""; drr["LorryNo"] = ""; drr["FromCity"] = "Total"; drr["NetAmnt"] = (TNet).ToString("N2"); dt.Rows.Add(drr); } } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } // grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; Double TotalNetAmount = 0; for (int i = 0; i < lstGridData.Count; i++) { TotalNetAmount += Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Net_Amnt")); } lblNetTotalAmount.Text = TotalNetAmount.ToString("N2"); int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; imgBtnExcel.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; lblcontant.Visible = false; divpaging.Visible = false; imgBtnExcel.Visible = false; } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { #region Validation Messages for Challan Details if (ddlTranspoter.SelectedIndex == 0) { this.ShowMessage("Please select Transporter."); ddlTranspoter.Focus(); return; } if (ddlTruckNo.SelectedIndex == 0) { this.ShowMessage("Please select Truck No."); ddlTruckNo.Focus(); return; } if (txtchlnRef.Text == "") { this.ShowMessage("Please Enter Challan Ref.No ."); ddlTruckNo.Focus(); return; } string msg = ""; 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 #region Declare Input Variables for Challan Details //string strMsg = string.Empty; //Int64 intGrPrepIdno = 0; //Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddldateRange.SelectedValue); //DateTime strChallanDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim().ToString())); //Int64 intChallanNo = string.IsNullOrEmpty(txtchallanNo.Text.Trim()) ? 0 : Convert.ToInt64(txtchallanNo.Text.Trim()); //Int32 intTranspoter = string.IsNullOrEmpty(ddlTranspoter.SelectedValue) ? 0 : Convert.ToInt32(ddlTranspoter.SelectedValue); //Int32 TruckNoIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue); //Int32 strChlnRefno = string.IsNullOrEmpty(txtchlnRef.Text) ? 0 : Convert.ToInt32(txtchlnRef.Text); //DateTime? dtInstDate; //if (txtInstDate.Text == "") //{ // dtInstDate = null; //} //else //{ // dtInstDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text)); //} #endregion #region Insert/Update with Transaction using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { string intGrPrepIdno = ""; string ChlnNo = txtchallanNo.Text; Int32 TrunckIdno = Convert.ToInt32(ddlTruckNo.SelectedValue); Int32 YearIdno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue); GRPrepDAL objDAL = new GRPrepDAL(); isTBBRate = objDAL.SelectTBBRate(); tblUserPref userpref = objDAL.selectuserpref(); itruckcitywise = Convert.ToInt32(userpref.Work_Type); DataTable dtDetail = (DataTable)ViewState["dt"]; try { ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL(); tblChlnBookHead objtblChlnBookHead = new tblChlnBookHead(); objtblChlnBookHead.Chln_No = txtchallanNo.Text; objtblChlnBookHead.Chln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); objtblChlnBookHead.BaseCity_Idno = Convert.ToInt32((DdlfromcityHead.SelectedIndex <= 0) ? "0" : DdlfromcityHead.SelectedValue); objtblChlnBookHead.DelvryPlc_Idno = Convert.ToInt32(0); objtblChlnBookHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue); objtblChlnBookHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue); objtblChlnBookHead.Driver_Idno = Convert.ToInt32(1); objtblChlnBookHead.Delvry_Instrc = ""; objtblChlnBookHead.Inv_Idno = 0; objtblChlnBookHead.Gross_Amnt = Convert.ToDouble(txtgrossAmnt.Text); objtblChlnBookHead.Commsn_Amnt = Convert.ToDouble(0.00); objtblChlnBookHead.Transprtr_Idno = Convert.ToInt32(ddlTranspoter.SelectedValue); objtblChlnBookHead.Chln_type = 2; objtblChlnBookHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); objtblChlnBookHead.Other_Amnt = Convert.ToDouble(txtKattAmnt.Text); objtblChlnBookHead.Work_type = Convert.ToInt32(hidWorkType.Value); objtblChlnBookHead.Ref_No = Convert.ToString(txtchlnRef.Text); objtblChlnBookHead.Adv_Amnt = Convert.ToDouble(0.00); objtblChlnBookHead.RcptType_Idno = Convert.ToInt32(1); objtblChlnBookHead.Bank_Idno = Convert.ToInt32(0); objtblChlnBookHead.Inst_No = Convert.ToInt32(0); objtblChlnBookHead.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); objtblChlnBookHead.Date_Added = Convert.ToDateTime(DateTime.Now); Int64 value = 0; if (string.IsNullOrEmpty(hidid.Value) == true) { if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0) { ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL(); intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail); obj1 = null; } value = obj.Insert(objtblChlnBookHead, dtTemp, intGrPrepIdno); // obj = null; } else { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); Int32 ChlnIdno = Convert.ToInt32(hidid.Value); TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == ChlnIdno).FirstOrDefault(); List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList(); foreach (TblGrDetl rgd in GrDetl) { db.TblGrDetls.DeleteObject(rgd); db.SaveChanges(); } db.TblGrHeads.DeleteObject(GrHEad); db.SaveChanges(); db.Connection.Close(); } if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0) { ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL(); intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail); obj1 = null; } value = obj.Update(objtblChlnBookHead, Convert.ToInt32(hidid.Value), dtTemp, intGrPrepIdno); } if (value > 0) { tScope.Complete(); } if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); Response.Redirect("ChlnBookingCrsng.aspx", false); } else if (value == -1) { ShowMessage("Challan No Already Exist"); } else { ShowMessage("Record Not Update"); } if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessage("Record saved Successfully "); Response.Redirect("ChlnBookingCrsng.aspx", false); } else if (value == -1) { tScope.Dispose(); ShowMessage("Challan No Already Exist"); } else { ShowMessage("Record Not saved Successfully "); } } catch (Exception Ex) { tScope.Dispose(); } #endregion } }
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 (base.View == false) { lblViewList.Visible = false; } if (!Page.IsPostBack) { this.ValidateControls(); if (Convert.ToString(Session["Userclass"]) == "Admin") { this.BindCity(); } else { this.BindCity(Convert.ToInt64(Session["UserIdno"])); } //if (Convert.ToString(Session["Userclass"]) == "Admin") //{ // BindDropdownDAL obja = new BindDropdownDAL(); // var senderLst = obja.BindSender(); // ddlSenderName.DataSource = senderLst; // ddlSenderName.DataTextField = "Acnt_Name"; // ddlSenderName.DataValueField = "Acnt_Idno"; // ddlSenderName.DataBind(); // ddlSenderName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); //} //else //{ // this.BindDropdown(); //} this.BindDateRange(); this.BindDropdown(); ddldateRange.SelectedValue = Convert.ToString(base.UserDateRng); ddlSenderName.SelectedValue = Convert.ToString(base.Sender); DdlfromcityHead.SelectedValue = Convert.ToString(base.UserFromCity); this.BindMaxNo(Convert.ToInt32((DdlfromcityHead.SelectedValue) == "" ? 0 : Convert.ToInt32(DdlfromcityHead.SelectedValue)), Convert.ToInt32(ddldateRange.SelectedValue)); dtTemp = CreateDt(); ViewState["dt"] = dtTemp; ChlnBookingCrsngDAL objChlnBookingDAL = new ChlnBookingCrsngDAL(); tblUserPref obj = objChlnBookingDAL.selectUserPref(); if (obj != null) { hidWorkType.Value = Convert.ToString(obj.Work_Type); } if (Request.QueryString["q"] != null) { Populate(Convert.ToInt64(Request.QueryString["q"])); hidid.Value = Convert.ToString(Request.QueryString["q"]); lnkbtnMnNew.Visible = true; } else { lnkbtnMnNew.Visible = false; } txtKattAmnt.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);"); this.ddldateRange_SelectedIndexChanged(null, null); } }