public bool DeleteByMasterID(int?MasterID)
{
var existCaliberTrans = billCailberTransRepo.Filter(p => p.BillMasterID == MasterID).ToList();
if (existCaliberTrans.Count > 0)
{
foreach (var entity in existCaliberTrans)
{
BillCaliberTransactions bp = new BillCaliberTransactions
{
BillMasterID = entity.BillMasterID,
CaliberTransID = entity.CaliberTransID,
ColName = entity.ColName,
ColQuantity = entity.ColQuantity,
Col24 = entity.Col24,
Col22 = entity.Col22,
Col21 = entity.Col21,
Col18 = entity.Col18,
TransQuant = entity.TransQuant
};
billCailberTransRepo.Delete(bp, entity.CaliberTransID);
}
}
return(true);
}
public Task <bool> InsertWithMasterID(List <BillCaliberTransactionsVM> caliberTransList)
{
return(Task.Run <bool>(() =>
{
bool delete = DeleteByMasterID(caliberTransList[0].BillMasterID);
if (delete == true)
{
foreach (var entity in caliberTransList)
{
BillCaliberTransactions bp = new BillCaliberTransactions
{
BillMasterID = entity.BillMasterID,
CaliberTransID = entity.CaliberTransID,
ColName = entity.ColName,
ColQuantity = entity.ColQuantity,
Col24 = entity.Col24,
Col22 = entity.Col22,
Col21 = entity.Col21,
Col18 = entity.Col18,
TransQuant = entity.TransQuant
};
billCailberTransRepo.Add(bp);
}
}
return true;
}));
}
public Task <bool> UpdateWithMasterID(List <BillCaliberTransactionsVM> entityList, int masterID)
{
return(Task.Run <bool>(() =>
{
List <BillCaliberTransactions> billCaliberList = billCailberTransRepo.Filter(c => c.BillMasterID == masterID).ToList();
if (billCaliberList.Count > 0)
{
foreach (var item in billCaliberList)
{
billCailberTransRepo.Delete(item, item.CaliberTransID);
}
}
foreach (var entity in entityList)
{
BillCaliberTransactions bc = new BillCaliberTransactions();
{
bc.BillMasterID = entity.BillMasterID;
bc.CaliberTransID = entity.CaliberTransID;
bc.ColName = entity.ColName;
bc.ColQuantity = entity.ColQuantity;
bc.Col24 = entity.Col24;
bc.Col22 = entity.Col22;
bc.Col21 = entity.Col21;
bc.Col18 = entity.Col18;
bc.TransQuant = entity.TransQuant;
}
billCailberTransRepo.Add(bc);
}
return true;
}));
}
public Task <bool> InsertAsync(BillCaliberTransactionsVM entity)
{
return(Task.Run <bool>(() =>
{
BillCaliberTransactions bc = new BillCaliberTransactions
{
BillMasterID = entity.BillMasterID,
CaliberTransID = entity.CaliberTransID,
ColName = entity.ColName,
ColQuantity = entity.ColQuantity,
Col24 = entity.Col24,
Col22 = entity.Col22,
Col21 = entity.Col21,
Col18 = entity.Col18,
TransQuant = entity.TransQuant
};
billCailberTransRepo.Add(bc);
return true;
}));
}
