public List<LotSize> LotSizeList() { List<LotSize> list = new List<LotSize>(); using (var db = new SingleEntities()) { foreach(Lot_size x in db.Lot_size) { LotSize obj = new LotSize(); obj.lz_lotno = x.lz_lotno; obj.lz_type=x.lz_type; obj.lz_size = x.lz_size; obj.lz_status = x.lz_status; obj.mkrid=x.mkrid; obj.mkrdt=x.mkrdt; list.Add(obj); } } return list; }
public LotSize GetLotSize(decimal lotNo, int instrNo) { try { SingleEntities db = new SingleEntities(); Lot_size objCheque = new Lot_size(); string insType = getInstype(instrNo); var obj = db.Lot_size.Where(x => x.lz_lotno == lotNo && x.lz_type == insType).FirstOrDefault(); if (obj != null) { LotSize obj1 = new LotSize(); obj1.lz_lotno = obj.lz_lotno; obj1.lz_size = obj.lz_size; obj1.lz_type = obj.lz_type; obj1.lz_status = obj.lz_status; obj1.mkrid = obj.mkrid; obj1.mkrdt = obj.mkrdt; obj1.lz_branchcd = obj.lz_branchcd; return obj1; } else { return null; } } catch (Exception ex) { throw ex; } }
public void UpdateLotSize(LotSize obj) { try { SingleEntities db = new SingleEntities(); Lot_size objLot = db.Lot_size.First(x => x.lz_lotno == obj.lz_lotno && x.lz_type == obj.lz_type); //objLot.lz_status = obj.lz_status; db.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void AddLotSize(LotSize obj) { try { Lot_size objLot = new Lot_size(); objLot.lz_lotno = obj.lz_lotno; objLot.lz_size = obj.lz_size; objLot.lz_type = obj.lz_type; objLot.lz_status = obj.lz_status; objLot.mkrid = obj.mkrid; objLot.mkrdt = obj.mkrdt; objLot.lz_branchcd = obj.lz_branchcd; SingleEntities db = new SingleEntities(); db.Lot_size.Add(objLot); db.SaveChanges(); } catch (Exception ex) { throw ex; } }