public ValidationMsg Delete(long id)
{
var rem = new EXP_TransportChallanCI();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
var transChln = _context.EXP_TransportChallan.FirstOrDefault(ob => ob.TransportChallanID == id);
if (transChln != null)
{
var transChlnCi =
_context.EXP_TransportChallanCI.Where(ob => ob.TransportChallanID == id).ToList();
if (transChlnCi.Count > 0)
{
foreach (var ci in transChlnCi)
{
var expCi = _context.EXP_CI.FirstOrDefault(ob => ob.CIID == ci.CIID);
if (expCi != null)
{
_context.EXP_TransportChallanCI.Remove(ci);
}
else
{
_msg.Type = Enums.MessageType.Error;
_msg.Msg = "Relation exists with commercial invoice.";
return(_msg);
}
}
}
_context.EXP_TransportChallan.Remove(transChln);
}
_context.SaveChanges();
tx.Complete();
_msg.Type = Enums.MessageType.Delete;
_msg.Msg = "Deleted successfully.";
}
}
}
catch
{
_msg.Type = Enums.MessageType.Error;
_msg.Msg = "Failed to delete.";
}
return(_msg);
}
public ValidationMsg DeleteTrnsChlnCi(long trnsId, long ciId)
{
var rem = new EXP_TransportChallanCI();
try
{
using (_context)
{
var transChlnCi =
_context.EXP_TransportChallanCI.FirstOrDefault(
ob => ob.TransportChallanID == trnsId && ob.CIID == ciId);
if (transChlnCi != null)
{
//var expCi = _context.EXP_CI.FirstOrDefault(ob => ob.CIID == transChlnCi.CIID);
//if (expCi != null)
//{
_context.EXP_TransportChallanCI.Remove(transChlnCi);
//}
//else
//{
// _msg.Type = Enums.MessageType.Error;
// _msg.Msg = "Relation exists with commercial invoice.";
// return _msg;
//}
}
_context.SaveChanges();
_msg.Type = Enums.MessageType.Delete;
_msg.Msg = "Deleted successfully.";
}
}
catch
{
_msg.Type = Enums.MessageType.Error;
_msg.Msg = "Failed to delete.";
}
return(_msg);
}
