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