public int Delete(int intChlnIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPayRecAgChlnBk objpay = (from mast in db.tblPayRecAgChlnBks
where mast.Chln_Idno == intChlnIdno
select mast).FirstOrDefault();
if (objpay != null)
{
db.tblPayRecAgChlnBks.DeleteObject(objpay);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
public Int32 Insert(DataTable DtTemp, Int32 ChlnIdno, double NetAmnt)
{
Int32 HeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
IList <tblPayRecAgChlnBk> QH = db.tblPayRecAgChlnBks.Where(qh => qh.Chln_Idno == ChlnIdno).ToList();
if (QH != null)
{
foreach (tblPayRecAgChlnBk qtd in QH)
{
db.tblPayRecAgChlnBks.DeleteObject(qtd);
db.SaveChanges();
}
//tblPayRecAgChlnBk objpay = new tblPayRecAgChlnBk();
//foreach (DataRow Dt in DtTemp.Rows)
//{
// //Sumry_No,Recvng_date,Recvng_Amnt,Remark
// objpay.Chln_Idno = ChlnIdno;
// objpay.Sumry_No = Convert.ToString(Dt["Sumry_No"]);
// objpay.Recvng_date = Convert.ToDateTime((Dt["Recvng_date"]).ToString());
// objpay.Recvng_Amnt = Convert.ToDouble(Dt["Recvng_Amnt"]);
// objpay.Remark = Convert.ToString(Dt["Remark"]);
// objpay.Net_Amnt = NetAmnt;
// db.tblPayRecAgChlnBks.AddObject(objpay);
// db.SaveChanges();
//}
//dbTran.Commit();
}
//else
//{
foreach (DataRow Dt in DtTemp.Rows)
{
tblPayRecAgChlnBk obj = new tblPayRecAgChlnBk();
//Sumry_No,Recvng_date,Recvng_Amnt,Remark
obj.Chln_Idno = ChlnIdno;
obj.Sumry_No = Convert.ToString(Dt["Sumry_No"]);
obj.Recvng_date = Convert.ToDateTime((Dt["Recvng_date"]).ToString());
obj.Recvng_Amnt = Convert.ToDouble(Dt["Recvng_Amnt"]);
obj.Remark = Convert.ToString(Dt["Remark"]);
obj.Net_Amnt = NetAmnt;
db.tblPayRecAgChlnBks.AddObject(obj);
db.SaveChanges();
}
dbTran.Commit();
// }
}
catch (Exception Ex)
{
dbTran.Rollback();
}
}
}
return(HeadId = 1);
}
