public Int64 Insert(tblPayToOwnAcc obj) { Int64 AmntHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblPayToOwnAcc AmtHead = new tblPayToOwnAcc(); db.Connection.Open(); // using (DbTransaction dbTran = db.Connection.BeginTransaction()) // { try { tblPayToOwnAcc RH = db.tblPayToOwnAccs.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_IdNo == obj.Year_IdNo).FirstOrDefault(); if (RH != null) { AmntHeadId = -1; } else { obj.Date_Added = DateTime.Now; obj.Date_Modified = DateTime.Now; db.tblPayToOwnAccs.AddObject(obj); db.SaveChanges(); AmntHeadId = obj.Id; } } catch { // dbTran.Rollback(); } return(AmntHeadId); } }
public Int64 Update(tblPayToOwnAcc obj, Int32 Head_Idno) { Int64 AmntHeadId = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { //db.Connection.Open(); //using (DbTransaction dbTran = db.Connection.BeginTransaction()) //{ try { tblPayToOwnAcc CH = db.tblPayToOwnAccs.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.Id != Head_Idno && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_IdNo == obj.Year_IdNo).FirstOrDefault(); if (CH != null) { AmntHeadId = -1; } else { tblPayToOwnAcc TBH = (from mast in db.tblPayToOwnAccs where mast.Id == Head_Idno select mast).FirstOrDefault(); if (TBH != null) { TBH.Rcpt_No = obj.Rcpt_No; TBH.Rcpt_date = obj.Rcpt_date; TBH.Year_IdNo = obj.Year_IdNo; TBH.RcptType_Idno = obj.RcptType_Idno; TBH.Driver_IdNo = obj.Driver_IdNo; TBH.Inst_No = obj.Inst_No; TBH.Inst_Dt = obj.Inst_Dt; TBH.Bank_Idno = obj.Bank_Idno; TBH.Comp_Id = obj.Comp_Id; TBH.Remark = obj.Remark; TBH.Date_Modified = obj.Date_Modified; TBH.Amnt = obj.Amnt; TBH.UserIdno = obj.UserIdno; TBH.BaseCity_Idno = obj.BaseCity_Idno; TBH.Date_Modified = DateTime.Now; db.SaveChanges(); AmntHeadId = TBH.Id; //dbTran.Commit(); } } } catch { //dbTran.Rollback(); } // } } return(AmntHeadId); }
private void Populate(Int64 HeadId) { PaymentToOwnDAL obj = new PaymentToOwnDAL(); tblPayToOwnAcc AmntGrhead = obj.selectHead(HeadId); ddldateRange.SelectedValue = Convert.ToString(AmntGrhead.Year_IdNo); ddldateRange_SelectedIndexChanged(null, null); ddldateRange.Enabled = false; txtRcptNo.Text = Convert.ToString(AmntGrhead.Rcpt_No); txtRcptNo.Visible = true; ddlFromCity.SelectedValue = Convert.ToString(AmntGrhead.BaseCity_Idno); BindPartName(); txtDate.Text = Convert.ToDateTime(AmntGrhead.Rcpt_date).ToString("dd-MM-yyyy"); //ddlDriverName.SelectedValue = Convert.ToString(AmntGrhead.Party_IdNo); ddlRcptTyp.SelectedValue = Convert.ToString(AmntGrhead.RcptType_Idno); ddlRcptType_SelectedIndexChanged(null, null); ddlChallan.SelectedValue = Convert.ToString(AmntGrhead.Chln_IdNo); ddlChallan_SelectedIndexChanged(null, null); ddlCustmerBank.SelectedValue = Convert.ToString(AmntGrhead.Bank_Idno); txtInstNo.Text = Convert.ToString(AmntGrhead.Inst_No); txtInstDate.Text = (Convert.ToString(AmntGrhead.Inst_Dt) == "") ? "" : Convert.ToDateTime(AmntGrhead.Inst_Dt).ToString("dd-MM-yyyy"); TxtRemark.Text = Convert.ToString(AmntGrhead.Remark); txtAmount.Text = Convert.ToString(AmntGrhead.Amnt); ViewState["dt"] = DtTemp; //For Daulat Print string strChlnIdno = string.Empty; for (int j = 0; j <= DtTemp.Rows.Count - 1; j++) { strChlnIdno = strChlnIdno + DtTemp.Rows[j]["Chln_Idno"].ToString() + ","; } if (strChlnIdno != "") { strChlnIdno = strChlnIdno.Substring(0, strChlnIdno.Length - 1); } //Int64 ChlnIdno = obj.GetChlnIdno(HeadId); if (Convert.ToString(hidPrintType.Value) != "") { if (Convert.ToInt32(hidPrintType.Value) == 2) { if (strChlnIdno != "") { PrintChlnDetails(strChlnIdno); } } } obj = null; }
public int Delete(Int64 HeadId, Int64 UserIdno, string con) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { clsAccountPosting objclsAccountPosting = new clsAccountPosting(); tblPayToOwnAcc CH = db.tblPayToOwnAccs.Where(h => h.Id == HeadId).FirstOrDefault(); if (CH != null) { db.tblPayToOwnAccs.DeleteObject(CH); db.SaveChanges(); value = 1; } } return(value); }
public void UpdateIsPosting(Int64 PayID) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { tblPayToOwnAcc GH = (from G in db.tblPayToOwnAccs where G.Id == PayID select G).FirstOrDefault(); if (GH != null) { GH.IS_Post = true; db.SaveChanges(); } } catch (Exception e) { } } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { DtTemp = CreateDt(); PaymentToOwnDAL obj = new PaymentToOwnDAL(); tblPayToOwnAcc objRGH = new tblPayToOwnAcc(); objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text); objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue); objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); objRGH.Chln_IdNo = Convert.ToInt64(ddlChallan.SelectedValue); objRGH.Driver_IdNo = Convert.ToInt64(hidDriverIdno.Value); objRGH.Inst_No = Convert.ToInt64(Convert.ToString(txtInstNo.Text) == "" ? 0 : Convert.ToInt64(txtInstNo.Text)); objRGH.Date_Added = System.DateTime.Now; objRGH.Date_Modified = null; objRGH.Bank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue); objRGH.RcptType_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue); objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]); if (txtInstDate.Text == "") { objRGH.Inst_Dt = null; } else { objRGH.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text)); } objRGH.Remark = Convert.ToString(TxtRemark.Text); objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue); objRGH.Amnt = Convert.ToDouble(txtAmount.Text.Trim()); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (string.IsNullOrEmpty(hidid.Value) == true) { value = obj.Insert(objRGH); } else { value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value)))); } if (value > 0) { if (this.PostIntoAccounts(Convert.ToDouble(txtAmount.Text), value, "PTD", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true) { obj.UpdateIsPosting(value); if ((string.IsNullOrEmpty(hidid.Value) == false)) { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { ShowMessage("Record Update successfully"); this.Clear(); ddlFromCity_SelectedIndexChanged(null, null); } else if (value == -1) { ShowMessageErr("Pay 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(); ddlFromCity_SelectedIndexChanged(null, null); } else if (value == -1) { ShowMessageErr("Pay 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 { if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false) { hidpostingmsg.Value = "Record(s) not updated."; } else { hidpostingmsg.Value = "Record(s) not saved."; } tScope.Dispose(); ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidid.Value) + "')", true); return; } } this.BindMaxNo(Convert.ToInt32(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue)), Convert.ToInt32(Convert.ToString(ddldateRange.SelectedValue) == "" ? 0 : Convert.ToInt32(ddldateRange.SelectedValue))); }