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