public int Delete(Int64 HeadId, Int64 UserIdno, string con) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { clsAccountPosting objclsAccountPosting = new clsAccountPosting(); tblAmntRecvdGR_Head CH = db.tblAmntRecvdGR_Head.Where(h => h.Head_Idno == HeadId).FirstOrDefault(); List <tblAmntRecvGR_Detl> CD = db.tblAmntRecvGR_Detl.Where(d => d.Head_Idno == HeadId).ToList(); if (CH != null) { foreach (var d in CD) { SqlParameter[] objSqlPara = new SqlParameter[3]; objSqlPara[0] = new SqlParameter("@Action", "DeleteRcvdAmntAgnstGR"); objSqlPara[1] = new SqlParameter("@Idno", HeadId); objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno); Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara); db.tblAmntRecvGR_Detl.DeleteObject(d); db.SaveChanges(); } db.tblAmntRecvdGR_Head.DeleteObject(CH); Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "ARGR"); db.SaveChanges(); if (intValue > 0) { value = 1; } } } return(value); }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { //DtTemp = (DataTable)ViewState["dt"]; //BindGrid(); //if (DtTemp != null && DtTemp.Rows.Count <= 0) //{ // if (DtTemp.Rows.Count <= 0) // { // ShowMessage("Please enter details"); // return; // } //} if (Convert.ToDouble(txtNetAmnt.Text) <= 0) { ShowMessageErr("Net Amount Must be Greater Than Zero."); grdMain.Focus(); return; } if (grdMain.Rows.Count > 0) { DtTemp = CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGrIdno"); Label lblGrno = (Label)row.FindControl("lblGrno"); Label lblGrDate = (Label)row.FindControl("lblGrDate"); HiddenField hidRecivrIdno = (HiddenField)row.FindControl("hidRecivrIdno"); Label lblGrFrom = (Label)row.FindControl("lblGrFrom"); HiddenField hidToCityIdno = (HiddenField)row.FindControl("hidToCityIdno"); HiddenField hidFromCityIdno = (HiddenField)row.FindControl("hidFromCityIdno"); Label lblAmount = (Label)row.FindControl("lblAmount"); Label lblTotRecvd = (Label)row.FindControl("lblTotRecvd"); Label lblCurBal = (Label)row.FindControl("lblCurBal"); TextBox txtRcvdAmnt = (TextBox)row.FindControl("txtRcvdAmnt"); ApplicationFunction.DatatableAddRow(DtTemp, hidGrIdno.Value, lblGrno.Text, (ApplicationFunction.mmddyyyy(lblGrDate.Text)), hidRecivrIdno.Value, "BK", hidToCityIdno.Value, hidFromCityIdno.Value, lblAmount.Text, lblTotRecvd.Text, lblCurBal.Text, txtRcvdAmnt.Text); } RcvdAmntAgnstGRDAL obj = new RcvdAmntAgnstGRDAL(); tblAmntRecvdGR_Head objRGH = new tblAmntRecvdGR_Head(); objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text); objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue); objRGH.FromCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue); objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGRDate.Text)); objRGH.Party_IdNo = Convert.ToInt64(ddlPartyName.SelectedValue); objRGH.Inst_No = Convert.ToString(txtInstNo.Text); objRGH.Date_Added = System.DateTime.Now; objRGH.Date_Modified = null; objRGH.CustBank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue); objRGH.RcptTyp_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue); objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]); if (txtInstDate.Text == "") { objRGH.Inst_Date = null; } else { objRGH.Inst_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text)); } objRGH.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text); objRGH.Remark = Convert.ToString(TxtRemark.Text); objRGH.status = true; objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (string.IsNullOrEmpty(hidid.Value) == true) { value = obj.Insert(objRGH, DtTemp); obj = null; } else { value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value))), DtTemp); obj = null; } if (value > 0) { if (this.PostIntoAccounts(Convert.ToDouble(txtNetAmnt.Text), value, "ARGR", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true) { if (string.IsNullOrEmpty(hidid.Value) == false) { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); this.Clear(); } else if (value == -1) { ShowMessageErr("Rcpt No Already Exist"); } else if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessageErr("Record Not Update"); } } else { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessage("Record Saved successfully"); this.Clear(); } else if (value == -1) { ShowMessageErr("Rcpt No Already Exist"); } else if ((string.IsNullOrEmpty(hidid.Value) == true)) { ShowMessageErr("Record Not Saved successfully"); } } tScope.Complete(); } else { if (string.IsNullOrEmpty(hidpostingmsg.Value) == true) { if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false) { hidpostingmsg.Value = "Record(s) not updated."; } else { hidpostingmsg.Value = "Record(s) not saved."; } tScope.Dispose(); } tScope.Dispose(); ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidpostingmsg.Value) + "')", true); return; } } } } else { ShowMessageErr("Please Enter Detais"); return; } }
public Int64 Insert(tblAmntRecvdGR_Head obj, DataTable Dttemp) { Int64 AmntHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblAmntRecvdGR_Head AmtHead = new tblAmntRecvdGR_Head(); db.Connection.Open(); //using (DbTransaction dbTran = db.Connection.BeginTransaction()) //{ try { tblAmntRecvdGR_Head RH = db.tblAmntRecvdGR_Head.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.BaseCity_Idno == obj.BaseCity_Idno).FirstOrDefault(); if (RH != null) { AmntHeadId = -1; } else { db.tblAmntRecvdGR_Head.AddObject(obj); db.SaveChanges(); AmntHeadId = obj.Head_Idno; if (Dttemp != null && Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { if (Convert.ToDouble(Dr["Recv_Amount"]) > 0) { tblAmntRecvGR_Detl objtblAmntRecvGR_Detl = new tblAmntRecvGR_Detl(); objtblAmntRecvGR_Detl.Head_Idno = AmntHeadId; objtblAmntRecvGR_Detl.Gr_Idno = Convert.ToInt64(Dr["Gr_Idno"]); objtblAmntRecvGR_Detl.Gr_No = Convert.ToInt64(Dr["Gr_no"]); objtblAmntRecvGR_Detl.Gr_Date = Convert.ToDateTime(Dr["Gr_Date"]); objtblAmntRecvGR_Detl.Recivr_Idno = Convert.ToInt64(Dr["Recivr_Idno"]); objtblAmntRecvGR_Detl.GR_Frm = Convert.ToString(Dr["GR_From"]); objtblAmntRecvGR_Detl.To_City = Convert.ToInt64(Dr["To_City"]); objtblAmntRecvGR_Detl.From_City = Convert.ToInt64(Dr["From_City"]); objtblAmntRecvGR_Detl.Gr_Amnt = Convert.ToDouble(Dr["Amount"]); objtblAmntRecvGR_Detl.Recvd_Amnt = Convert.ToDouble(Dr["Recv_Amount"]); objtblAmntRecvGR_Detl.Cur_Bal = Convert.ToDouble(Dr["cur_Bal"]); objtblAmntRecvGR_Detl.Tot_Recvd = Convert.ToDouble(Dr["Tot_Recvd"]); db.tblAmntRecvGR_Detl.AddObject(objtblAmntRecvGR_Detl); db.SaveChanges(); } } // dbTran.Commit(); } } } catch { //dbTran.Rollback(); } // } return(AmntHeadId); } }
public Int64 Update(tblAmntRecvdGR_Head obj, Int32 Head_Idno, DataTable Dttemp) { Int64 AmntHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); //using (DbTransaction dbTran = db.Connection.BeginTransaction()) //{ try { tblAmntRecvdGR_Head CH = db.tblAmntRecvdGR_Head.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.Head_Idno != Head_Idno && rh.BaseCity_Idno == obj.BaseCity_Idno).FirstOrDefault(); if (CH != null) { AmntHeadId = -1; } else { tblAmntRecvdGR_Head TBH = db.tblAmntRecvdGR_Head.Where(rh => rh.Head_Idno == Head_Idno).FirstOrDefault(); if (TBH != null) { TBH.Rcpt_No = obj.Rcpt_No; TBH.Rcpt_date = obj.Rcpt_date; TBH.Year_IdNo = obj.Year_IdNo; TBH.RcptTyp_Idno = obj.RcptTyp_Idno; TBH.Party_IdNo = obj.Party_IdNo; TBH.Inst_No = obj.Inst_No; TBH.Inst_Date = obj.Inst_Date; TBH.CustBank_Idno = obj.CustBank_Idno; TBH.Comp_Id = obj.Comp_Id; TBH.Remark = obj.Remark; TBH.status = obj.status; TBH.Date_Modified = obj.Date_Modified; TBH.Net_Amnt = obj.Net_Amnt; TBH.FromCity_Idno = obj.FromCity_Idno; db.SaveChanges(); AmntHeadId = TBH.Head_Idno; List <tblAmntRecvGR_Detl> ChlnDetl = db.tblAmntRecvGR_Detl.Where(rd => rd.Head_Idno == Head_Idno).ToList(); foreach (tblAmntRecvGR_Detl rgd in ChlnDetl) { db.tblAmntRecvGR_Detl.DeleteObject(rgd); db.SaveChanges(); } if (Dttemp != null && Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { if (Convert.ToDouble(Dr["Recv_Amount"]) > 0) { tblAmntRecvGR_Detl objtblAmntRecvGR_Detl = new tblAmntRecvGR_Detl(); objtblAmntRecvGR_Detl.Head_Idno = Head_Idno; objtblAmntRecvGR_Detl.Gr_Idno = Convert.ToInt64(Dr["Gr_Idno"]); objtblAmntRecvGR_Detl.Gr_No = Convert.ToInt64(Dr["Gr_no"]); objtblAmntRecvGR_Detl.Gr_Date = Convert.ToDateTime(Dr["Gr_Date"]); objtblAmntRecvGR_Detl.Recivr_Idno = Convert.ToInt64(Dr["Recivr_Idno"]); objtblAmntRecvGR_Detl.GR_Frm = Convert.ToString(Dr["GR_From"]); objtblAmntRecvGR_Detl.To_City = Convert.ToInt64(Dr["To_City"]); objtblAmntRecvGR_Detl.From_City = Convert.ToInt64(Dr["From_City"]); objtblAmntRecvGR_Detl.Gr_Amnt = Convert.ToDouble(Dr["Amount"]); objtblAmntRecvGR_Detl.Recvd_Amnt = Convert.ToDouble(Dr["Recv_Amount"]); objtblAmntRecvGR_Detl.Cur_Bal = Convert.ToDouble(Dr["Cur_Bal"]); objtblAmntRecvGR_Detl.Tot_Recvd = Convert.ToDouble(Dr["Tot_Recvd"]); db.tblAmntRecvGR_Detl.AddObject(objtblAmntRecvGR_Detl); db.SaveChanges(); } } } // dbTran.Commit(); } } } catch { // dbTran.Rollback(); } //} } return(AmntHeadId); }