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