public int Delete(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
tblChlnAmntPayment_Head CH = db.tblChlnAmntPayment_Head.Where(h => h.Id == HeadId).FirstOrDefault();
List <tblChlnAmntPayment_Detl> CD = db.tblChlnAmntPayment_Detl.Where(d => d.Head_Idno == HeadId).ToList();
if (CH != null)
{
SqlParameter[] objSqlPara = new SqlParameter[3];
objSqlPara[0] = new SqlParameter("@Action", "DeleteChlnAmntPayment");
objSqlPara[1] = new SqlParameter("@Idno", HeadId);
objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno);
Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara);
foreach (var d in CD)
{
db.tblChlnAmntPayment_Detl.DeleteObject(d);
db.SaveChanges();
}
db.tblChlnAmntPayment_Head.DeleteObject(CH);
Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "ACB");
db.SaveChanges();
if (intValue > 0)
{
value = 1;
}
}
}
return(value);
}
public Int64 Insert(tblChlnAmntPayment_Head obj, DataTable Dttemp)
{
Int64 AmntHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnAmntPayment_Head AmtHead = new tblChlnAmntPayment_Head();
db.Connection.Open();
// using (DbTransaction dbTran = db.Connection.BeginTransaction())
// {
try
{
tblChlnAmntPayment_Head RH = db.tblChlnAmntPayment_Head.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.tblChlnAmntPayment_Head.AddObject(obj);
db.SaveChanges();
AmntHeadId = obj.Id;
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblChlnAmntPayment_Detl objtblAmntRecvGR_Detl = new tblChlnAmntPayment_Detl();
objtblAmntRecvGR_Detl.Head_Idno = AmntHeadId;
objtblAmntRecvGR_Detl.Chln_Idno = Convert.ToInt64(Dr["chln_Idno"]);
objtblAmntRecvGR_Detl.Chln_No = Convert.ToInt64(Dr["Chln_No"]);
objtblAmntRecvGR_Detl.Chln_Date = Convert.ToDateTime(Dr["Chln_Date"]);
objtblAmntRecvGR_Detl.FromCity_Idno = Convert.ToInt64(Dr["Fromcity_Idno"]);
objtblAmntRecvGR_Detl.Challan_Amnt = Convert.ToDouble(Dr["Challan_Amnt"]);
objtblAmntRecvGR_Detl.Recvd_Amnt = Convert.ToDouble(Dr["Recvd_Amnt"]);
objtblAmntRecvGR_Detl.Truck_Idno = Convert.ToInt64(Dr["Truck_Idno"]);
objtblAmntRecvGR_Detl.Driver_Idno = Convert.ToInt64(Dr["Driver_Idno"]);
db.tblChlnAmntPayment_Detl.AddObject(objtblAmntRecvGR_Detl);
db.SaveChanges();
}
//dbTran.Commit();
}
}
}
catch
{
// dbTran.Rollback();
}
// }
return(AmntHeadId);
}
}
public void UpdateIsPosting(Int64 ID)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblChlnAmntPayment_Head GH = (from G in db.tblChlnAmntPayment_Head where G.Id == ID select G).FirstOrDefault();
if (GH != null)
{
GH.IS_Post = true;
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
}
public Int64 Update(tblChlnAmntPayment_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
{
tblChlnAmntPayment_Head CH = db.tblChlnAmntPayment_Head.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
{
tblChlnAmntPayment_Head TBH = db.tblChlnAmntPayment_Head.Where(rh => rh.Id == 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.RcptType_Idno = obj.RcptType_Idno;
TBH.Party_IdNo = obj.Party_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.Net_Amnt = obj.Net_Amnt;
TBH.BaseCity_Idno = obj.BaseCity_Idno;
TBH.Loc_Idno = obj.Loc_Idno;
TBH.Date_Modified = DateTime.Now;
db.SaveChanges();
AmntHeadId = TBH.Id;
List <tblChlnAmntPayment_Detl> ChlnDetl = db.tblChlnAmntPayment_Detl.Where(rd => rd.Head_Idno == Head_Idno).ToList();
foreach (tblChlnAmntPayment_Detl rgd in ChlnDetl)
{
db.tblChlnAmntPayment_Detl.DeleteObject(rgd);
db.SaveChanges();
}
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblChlnAmntPayment_Detl objtblAmntRecvGR_Detl = new tblChlnAmntPayment_Detl();
objtblAmntRecvGR_Detl.Head_Idno = AmntHeadId;
objtblAmntRecvGR_Detl.Chln_Idno = Convert.ToInt64(Dr["chln_Idno"]);
objtblAmntRecvGR_Detl.Chln_No = Convert.ToInt64(Dr["Chln_No"]);
objtblAmntRecvGR_Detl.Chln_Date = Convert.ToDateTime(Dr["Chln_Date"]);
objtblAmntRecvGR_Detl.FromCity_Idno = Convert.ToInt64(Dr["Fromcity_Idno"]);
objtblAmntRecvGR_Detl.Challan_Amnt = Convert.ToDouble(Dr["Challan_Amnt"]);
objtblAmntRecvGR_Detl.Recvd_Amnt = Convert.ToDouble(Dr["Recvd_Amnt"]);
objtblAmntRecvGR_Detl.Truck_Idno = Convert.ToInt64(Dr["Truck_Idno"]);
objtblAmntRecvGR_Detl.Driver_Idno = Convert.ToInt64(Dr["Driver_Idno"]);
db.tblChlnAmntPayment_Detl.AddObject(objtblAmntRecvGR_Detl);
db.SaveChanges();
}
}
}
}
}
catch
{
}
//}
}
return(AmntHeadId);
}