public IActionResult UpdateReceipt(ReceiptPaymentViewModel model)
{
try
{
return(Ok(rp.UpdateReceipt(model)));
}
catch (Exception ex)
{
Exceptions(ex);
return(StatusCode(500));
}
}
public int UpdateReceipt(ReceiptPaymentViewModel model)
{
try
{
return(receipt.UpdateReceipt(model));
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Class Name: {nameof(ReceiptPresenter)} - Method name: {nameof(UpdateReceipt)}", stackTrace: ex.StackTrace);
return(0);
}
}
public int CreateNewReceipt(ReceiptPaymentViewModel model)
{
try
{
var IsReceiptExists = dbContext.TblReceipt.Where(x => x.Sno == model.Sno).FirstOrDefault();
if (IsReceiptExists != null)
{
return(0);
}
else
{
int receiptCount = dbContext.Database.ExecuteSqlCommand($"sp_CreateReceipt {model.Sno},{model.FileId},{model.HouseId},{model.MessrsId},{model.ReceiptDate},{model.CaseTotalCost},{model.Amount},{model.Description}");
return(receiptCount);
}
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(ReceiptRepository)} - Method name: {nameof(CreateNewReceipt)}", stackTrace: ex.StackTrace);
return(0);
}
}
public int UpdateReceipt(ReceiptPaymentViewModel model)
{
try
{
var receiptTable = dbContext.TblReceipt.Select(x => x).Where(x => x.HouseId == model.HouseId).FirstOrDefault();
//var paymentTable = dbContext.TblPayments.Select(x => x).Where(x => x.ReceiptId == receiptTable.Id).order
//var viewModel = new Order();
//viewModel.GL = "model ki value";
//viewModel.BLIC = "model ki value1";
//var checkReciept = orderDetail;
var payments = new TblPayments();
foreach (var item in model.GetType().GetProperties())
{
var columnName = item.Name;
var val = model.GetType().GetProperty(columnName).GetValue(model);
if (receiptTable.GetType().GetProperty(columnName) != null)
{
if (val != null && !string.IsNullOrEmpty(val.ToString()) && val.ToString() != "0")
{
receiptTable.GetType().GetProperty(columnName).SetValue(receiptTable, val);
}
}
if (payments.GetType().GetProperty(columnName) != null)
{
if (val != null && !string.IsNullOrEmpty(val.ToString()) && val.ToString() != "0")
{
payments.GetType().GetProperty(columnName).SetValue(payments, val);
}
}
//var IsReceiptExists = dbContext.TblReceipt.Where(x => x.HouseId == model.HouseId).FirstOrDefault();
//if (IsReceiptExists == null)
// return 0;
//else
//{
// int updateReceiptCount = dbContext.Database.ExecuteSqlCommand($"sp_UpdateReceipt {model.HouseId},{model.Amount},{model.PaymentDate}");
// return updateReceiptCount;
//}
}
if (payments != null)
{
payments.ReceiptId = receiptTable.Id;
dbContext.TblPayments.Add(payments);
}
if (receiptTable != null)
{
dbContext.Entry(receiptTable).State = EntityState.Modified;
}
return(dbContext.SaveChanges());
}
catch (Exception ex)
{
StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(ReceiptRepository)} - Method name: {nameof(UpdateReceipt)}", stackTrace: ex.StackTrace);
return(0);
}
}
