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