public Inward GetInwardEntry(int scrollNo) { try { Inward_entry obj = new Inward_entry(); SingleEntities db = new SingleEntities(); obj = db.Inward_entry.Where(x => x.ie_scrollno == scrollNo).FirstOrDefault(); if (obj != null) { Inward objInw = new Inward(); objInw.ie_lotno = obj.ie_lotno; objInw.ie_trxtype = obj.ie_trxtype; objInw.ie_instno = obj.ie_instno; objInw.ie_slipno = obj.ie_slipno; objInw.ie_cmcd = obj.ie_cmcd; objInw.ie_dt = obj.ie_dt; objInw.ie_execdt = obj.ie_execdt; objInw.ie_nooftrx = obj.ie_nooftrx; objInw.ie_noofcert = obj.ie_noofcert; objInw.ie_rejected = obj.ie_rejected; objInw.ie_scrollno = obj.ie_scrollno; objInw.mkrid = obj.mkrid; objInw.mkrdt = obj.mkrdt; objInw.ie_charge = obj.ie_charge; objInw.ie_mode = obj.ie_mode; objInw.ie_remark = obj.ie_remark; objInw.ie_pri_key = obj.ie_pri_key; objInw.ie_branchcd = obj.ie_branchcd; return objInw; } else { return null; } } catch (Exception ex) { throw ex; } }
public int AddInwardEntry(Inward obj) { try { Inward_entry objInw = new Inward_entry(); objInw.ie_lotno = obj.ie_lotno; objInw.ie_trxtype = obj.ie_trxtype.Trim(); objInw.ie_instno = obj.ie_instno.Trim(); objInw.ie_slipno = obj.ie_slipno.Trim(); objInw.ie_cmcd = obj.ie_cmcd.Trim(); objInw.ie_dt = obj.ie_dt; objInw.ie_execdt = obj.ie_execdt; objInw.ie_nooftrx = obj.ie_nooftrx; objInw.ie_noofcert = obj.ie_noofcert; objInw.ie_rejected = obj.ie_rejected; objInw.mkrid = obj.mkrid; objInw.mkrdt = obj.mkrdt; objInw.ie_charge = obj.ie_charge; objInw.ie_mode = obj.ie_mode; objInw.ie_remark = obj.ie_remark.Trim(); objInw.ie_pri_key = obj.ie_pri_key; objInw.ie_branchcd = obj.ie_branchcd; SingleEntities db = new SingleEntities(); db.Inward_entry.Add(objInw); return db.SaveChanges(); } catch (Exception ex) { throw ex; } }