public ChequeMaster GetCheque(int slipNo, int instrNo)
{
try
{
SingleEntities db = new SingleEntities();
Chequemaster objCheque = new Chequemaster();
var obj1 = db.Chequemasters.Where(x => x.chm_fromno == slipNo && x.chm_instcd == instrNo)
.Join(db.Client_master1, ch => ch.chm_cmcd, cl => cl.cm_cd, (ch, cl) => new { ch, cl })
.FirstOrDefault();
if (obj1 != null)
{
objCheque = obj1.ch;
ChequeMaster obj = new ChequeMaster();
obj.companyCode = objCheque.chm_cmcd;
obj.companyName = obj1.cl.cm_name;
obj.secondName = obj1.cl.cm_sech_name;
obj.thirdName = obj1.cl.cm_thih_name;
obj.chequeNo = Convert.ToInt32(objCheque.chm_chqno);
obj.instrumentCode = objCheque.chm_instcd;
obj.bookSize = objCheque.chm_booksize;
obj.refNo = objCheque.chm_refno;
obj.refDate = objCheque.chm_refdate;
obj.status = objCheque.chm_status;
obj.issueDate = objCheque.chm_issuedate;
obj.remarks = objCheque.chm_remarks;
obj.branchCode = objCheque.chm_branchcd;
obj.makerDate = objCheque.mkrdt;
obj.chequeFromNo = Convert.ToInt32(objCheque.chm_fromno);
obj.chequeToNo = Convert.ToInt32(objCheque.chm_tono);
return obj;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddCheque(ChequeMaster obj)
{
try
{
Chequemaster objCheque = new Chequemaster();
objCheque.chm_cmcd = obj.companyCode;
objCheque.chm_chqno = obj.chequeNo;
objCheque.chm_instcd = obj.instrumentCode;
objCheque.chm_booksize = obj.bookSize;
objCheque.chm_refno = obj.refNo;
objCheque.chm_refdate = obj.refDate;
objCheque.chm_status = obj.status;
objCheque.chm_issuedate = obj.issueDate;
objCheque.chm_remarks = obj.remarks;
objCheque.chm_branchcd = obj.branchCode;
objCheque.mkrid = HttpContext.Current.Session["UserId"].ToString();
objCheque.mkrdt = obj.makerDate;
objCheque.chm_fromno = obj.chequeFromNo;
objCheque.chm_tono = obj.chequeToNo;
SingleEntities db = new SingleEntities();
db.Chequemasters.Add(objCheque);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
