public Boolean Save(tbl_000_H_ITEM_TABULATION_VP record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
db.ItemTabulationVPList.Add(record);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
public Boolean Delete(tbl_000_H_ITEM_TABULATION_VP record)
{
try
{
if (record == null)
{
throw new Exception("Invalid Parameter!");
}
if (!itvpdal.IsExistID(record.DocID))
{
throw new Exception("Record does not exist!");
}
return(itvpdal.Delete(record));
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Delete(tbl_000_H_ITEM_TABULATION_VP record)
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
//var existrecord = GetByID(record.YEARUSED, record.ItemNo, record.PartNo);
var existrecord = GetByID(record.DocID);
db.ItemTabulationVPList.Remove(existrecord);
db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
public Boolean Save(tbl_000_H_ITEM_TABULATION_VP record)
{
try
{
if (record == null)
{
throw new Exception("Invalid Parameter!");
}
if (itvpdal.IsExistID(record.DocID))
{
throw new Exception("VP No. already taken!");
}
if (itvpdal.IsExistPartName(record.PartName))
{
throw new Exception(" VP Name already taken!");
}
return(itvpdal.Save(record));
}
catch (Exception ex)
{
throw ex;
}
}
