public DateTime MtrlTransfDate(Int64 MtrlTransfIdno) { DateTime Value; ChallanDelverdDAL objMtrlRcptHODAL = new ChallanDelverdDAL(); Value = objMtrlRcptHODAL.MtrlTransfDate(MtrlTransfIdno); objMtrlRcptHODAL = null; return(Value); }
private void BindGrid() { if ((ddlChallanDetl.SelectedIndex > 0) && (txtDate.Text.Trim() != "")) { ChallanDelverdDAL obj = new ChallanDelverdDAL(); int rec = 0; Int64 MtrlRcptIdno = (Convert.ToString(hidMtrlRcptid.Value) != "" ? Convert.ToInt64(hidMtrlRcptid.Value) : 0); rec = obj.IsExeistMtrlTransf(Convert.ToInt64(ddlChallanDetl.SelectedValue), Convert.ToInt32(ddlDateRange.SelectedValue), MtrlRcptIdno); if (rec > 0) { grdMain.Visible = false; string msg = "Receipt of the transfer no. : " + ddlChallanDetl.SelectedItem.Text + " is already generated."; grdMain.DataSource = null; grdMain.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessageError('" + msg + "')", true); } else { DateTime dMtrlDt = obj.MtrlTransfDate(Convert.ToInt64(ddlChallanDetl.SelectedValue)); hidMtrlTrnsfDt.Value = dMtrlDt.ToString("dd-MM-yyyy"); if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidMtrlTrnsfDt.Value)) > Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text))) { grdMain.Visible = false; grdMain.DataSource = null; grdMain.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessageError('Date must be Greater than or equal to Transfer Date [" + dMtrlDt.Date.ToString("dd-MMM-yyyy") + "].')", true); } else { DataSet Ds = obj.SelectGridDetl(ApplicationFunction.ConnectionString(), "SelectTransfDetl", Convert.ToInt64(ddlChallanDetl.SelectedValue), Convert.ToInt32(ddlToCity.SelectedValue)); obj = null; LocGrAmnt = 0; OutGrAmnt = 0; if (Ds != null && Ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in Ds.Tables[0].Rows) { Int32 DelvPlcIdno = Convert.ToInt32(dr["DelvryPlce_Idno"]); double dGrAmnt = Convert.ToDouble(dr["Amount"]); if (Convert.ToInt32(ddlToCity.SelectedValue) == DelvPlcIdno) { LocGrAmnt += dGrAmnt; } else { OutGrAmnt += dGrAmnt; } } } txtLocGrAmnt.Text = LocGrAmnt.ToString("N2"); txtoutGrAmnt.Text = OutGrAmnt.ToString("N2"); txtNetAmnt.Text = Convert.ToDouble(LocGrAmnt + OutGrAmnt).ToString("N2"); ViewState["dt"] = (DataTable)Ds.Tables[0]; grdMain.DataSource = ViewState["dt"]; grdMain.DataBind(); grdMain.Visible = true; } } obj = null; } else { grdMain.Visible = false; ddlChallanDetl.SelectedIndex = 0; ddlChallanDetl.Focus(); grdMain.DataSource = null; grdMain.DataBind(); } }
protected void lnkBtnSave_Click(object sender, EventArgs e) { string msg = string.Empty; bool bflag = false; double IssueQty = 0, IssueWT = 0; if (grdMain.Rows.Count <= 0) { ShowMessage("Please Enter Challan Details"); } else { DtTemp = (DataTable)ViewState["dt"]; DtTemp = CreateDt(); ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL(); Int64 MtrlRcptId = 0, MtrlRcptDetlId = 0; string strMsgTyp = String.Empty; int yearIdno = Convert.ToInt32(ddlDateRange.SelectedValue); Int64 Value = 0; tblChlnDelvHead ObjMtrlRcptHead = new tblChlnDelvHead(); ObjMtrlRcptHead.ChlnDelv_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); ObjMtrlRcptHead.ToCity_Idno = Convert.ToInt32(ddlToCity.SelectedValue); ObjMtrlRcptHead.ChlnTransf_Idno = Convert.ToInt32(ddlChallanDetl.SelectedValue); ObjMtrlRcptHead.Date_Added = ApplicationFunction.GetIndianDateTime().Date; // DateTime.Now.Date; ObjMtrlRcptHead.Date_Modified = ApplicationFunction.GetIndianDateTime().Date; ObjMtrlRcptHead.ChlnDelv_No = MaxRcptHeadNo(Convert.ToInt32(ddlToCity.SelectedValue), Convert.ToInt32(ddlDateRange.SelectedValue)); ObjMtrlRcptHead.CrsngGR_Amnt = Convert.ToDouble(txtoutGrAmnt.Text); ObjMtrlRcptHead.LocGR_Amnt = Convert.ToDouble(txtLocGrAmnt.Text); ObjMtrlRcptHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); ObjMtrlRcptHead.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGridno"); HiddenField hidItemidno = (HiddenField)row.FindControl("hidItemidno"); HiddenField hidUnitidno = (HiddenField)row.FindControl("hidUnitidno"); Label lblrateType = (Label)row.FindControl("lblrateType"); Label lblQty = (Label)row.FindControl("lblQty"); Label lblWeight = (Label)row.FindControl("lblWeight"); Label lblAmount = (Label)row.FindControl("lblAmount"); TextBox txtRecQty = (TextBox)row.FindControl("txtRecQty"); TextBox txtRecWT = (TextBox)row.FindControl("txtRecWT"); TextBox txtRecWt = (TextBox)row.FindControl("txtRecWt"); TextBox txtRemark = (TextBox)row.FindControl("txtRemark"); TextBox txtRecAmt = (TextBox)row.FindControl("txtRecAmt"); if (lblrateType.Text == "Rate") { if (txtRecQty.Text == "") { ShowMessageErr("Please Enter Receiving QTY!"); return; } if (Convert.ToDouble(txtRecQty.Text) < 0.00) { ShowMessageErr("You Cannot Enter Receiving QTY Less than 1!"); return; } IssueQty = Convert.ToDouble(lblQty.Text); if (IssueQty < Convert.ToDouble(txtRecQty.Text)) { txtRecQty.Focus(); txtRecQty.Text = "0.00"; ShowMessageErr("You Cannot Enter Receiving QTY more than GR QTY!"); return; } } else { if (txtRecWT.Text == "") { ShowMessageErr("Please Enter Receiving Weight!"); return; } if (Convert.ToDouble(txtRecWT.Text) < 0.00) { ShowMessageErr("You Cannot Enter Receiving Weight Less than 1!"); return; } IssueWT = Convert.ToDouble(lblWeight.Text); if (IssueWT < Convert.ToDouble(txtRecWT.Text)) { txtRecWT.Focus(); txtRecWT.Text = "0.00"; ShowMessageErr("You Cannot Enter Receiving Weight more than GR Weight!"); return; } } ApplicationFunction.DatatableAddRow(DtTemp, hidGrIdno.Value, hidItemidno.Value, hidUnitidno.Value, ((lblrateType.Text) == "Rate") ? "1" : "2", lblQty.Text, lblWeight.Text, lblAmount.Text, txtRecQty.Text, txtRecWt.Text, txtRecAmt.Text, txtRemark.Text); } using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { try { ChallanDelverdDAL obj = new ChallanDelverdDAL(); DateTime dMtrlDt = obj.MtrlTransfDate(Convert.ToInt64(ddlChallanDetl.SelectedValue)); hidMtrlTrnsfDt.Value = dMtrlDt.ToString("dd-MM-yyyy"); if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidMtrlTrnsfDt.Value)) > Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text))) { txtDate.Focus(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessageError('Delivery Date must be greater than or equal to Challan Date [" + dMtrlDt.Date.ToString("dd-MMM-yyyy") + "].')", true); return; } if (string.IsNullOrEmpty(hidMtrlRcptid.Value) == true) { MtrlRcptId = obj.InsertMtrlRcptHOHead(ObjMtrlRcptHead, DtTemp); if (MtrlRcptId > 0) { tScope.Complete(); } } else { tblChlnDelvHead ObjMtrlRcptHeadU = new tblChlnDelvHead(); ObjMtrlRcptHeadU.ChlnDelv_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); ObjMtrlRcptHeadU.ToCity_Idno = Convert.ToInt32(ddlToCity.SelectedValue); ObjMtrlRcptHeadU.ChlnTransf_Idno = Convert.ToInt32(ddlChallanDetl.SelectedValue); ObjMtrlRcptHeadU.Date_Modified = ApplicationFunction.GetIndianDateTime().Date; ObjMtrlRcptHeadU.CrsngGR_Amnt = Convert.ToDouble(txtoutGrAmnt.Text); ObjMtrlRcptHeadU.LocGR_Amnt = Convert.ToDouble(txtLocGrAmnt.Text); ObjMtrlRcptHeadU.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); ObjMtrlRcptHeadU.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue); MtrlRcptId = obj.UpdateMtrlRcptHOHead(ObjMtrlRcptHeadU, DtTemp, Convert.ToInt32(hidMtrlRcptid.Value)); if ((MtrlRcptId > 0)) { tScope.Complete(); } } } catch (Exception ex) { // ApplicationFunction.ErrorLog(ex.ToString()); } } if (string.IsNullOrEmpty(hidMtrlRcptid.Value) == true) { if (MtrlRcptId > 0) { ShowMessage("Record Saved Successffully"); } } else { if ((MtrlRcptId > 0)) { ShowMessage("Record Update successfully"); } } if (MtrlRcptId == -1) { ShowMessage("Challan No. already Delivered !"); bflag = false; strMsgTyp = "RecExst"; ddlChallanDetl.Focus(); } else { ClearControls(); } } }