private async Task <ReturnValue> CollectionEntryVerify(MainViewModel.CollectionVerificationEntry[] collListObj)
{
using (TransactionScope scope = TransactionScopeUtils.CreateTransactionScope())
{
ReturnValue retVal = new ReturnValue();
try
{
collListObj.ToList().ForEach(collObj =>
{
db.Database.ExecuteSqlCommand(String.Format(@"exec[dbo].[PsetCollectionDue] @SubsCollId={0},@custId={1},@Subsid={2},@CollectorId={3}, @CollectionAmt={4},@CollDiscount={5},@CollectionDate='{6}',@PostedBy={7}",
collObj.Subscollid, collObj.CustId, collObj.subsid, collObj.CollectorId, collObj.CollectionAmt, collObj.DiscountAmt, collObj.CollectionDate, Global.UserId));
});
var data = String.Format("select COUNT(*) OVER() AS TotalCount, subsid, Subsno as SubsNo, CustomerName, LocationName, DueBalance as MonthlyAmount, Debit, Status from fgetSubscriptionDueReport('" + DateTime.Now + "') where custid = " + collListObj.SingleOrDefault().CustId);
List <MainViewModel.CollectionVerificationEntry> returnData = db.Database.SqlQuery <MainViewModel.CollectionVerificationEntry>(data).ToList();
scope.Complete();
retVal.Status = true;
retVal.ColVerData = returnData;
}
catch (Exception ex)
{
scope.Dispose();
retVal.Status = false;
retVal.ColVerData = new List <MainViewModel.CollectionVerificationEntry>();
throw;
}
return(retVal);
}
}
public async Task <ReturnValue> ExecuteDataSync([FromBody] List <CollectorViewModel> collListObj)
{
using (TransactionScope scope = TransactionScopeUtils.CreateTransactionScope())
{
ReturnValue retVal = new ReturnValue();
try
{
collListObj.ToList().ForEach(collObj =>
{
if (collObj.Discount == null)
{
collObj.Discount = 0;
}
db.Database.ExecuteSqlCommand(String.Format(@"exec[dbo].[PsetCollectionDueMobile] @custId={0},@Subsid={1},@CollectorId={2}, @CollectionAmt={3},@CollDiscount={4},@CollectionDate='{5}',@PostedBy={6}",
collObj.custid, collObj.SubsId, collObj.CollectorId, collObj.ReceivedAmount, collObj.Discount, collObj.CollectionDate, collObj.UserId));
});
//var data = String.Format("select COUNT(*) OVER() AS TotalCount, subsid, Subsno as SubsNo, CustomerName, LocationName, DueBalance as MonthlyAmount, Debit, Status from fgetSubscriptionDueReport('" + DateTime.Now + "') where custid = " + collListObj.SingleOrDefault().custid);
//List<MainViewModel.CollectionEntry> returnData = db.Database.SqlQuery<MainViewModel.CollectionEntry>(data).ToList();
scope.Complete();
retVal.Status = true;
//retVal.Data = returnData;
}
catch (Exception ex)
{
scope.Dispose();
retVal.Status = false;
throw;
}
return(retVal);
}
}
