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); } }