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);
}
