public OperationModel AddTransactionData(CollectionTransactionViewModel collectionTransactionViewModel) { try { OperationModel operationModel = new OperationModel(); CollectionTransactionModel collectionTransactionModel = new CollectionTransactionModel(); collectionTransactionModel.ApplicantName = collectionTransactionViewModel.ApplicantName; collectionTransactionModel.MobileNumber = collectionTransactionViewModel.MobileNumber; collectionTransactionModel.Address = collectionTransactionViewModel.Address; collectionTransactionModel.AadhaarNumber = collectionTransactionViewModel.AadhaarNumber; collectionTransactionModel.PanNumber = collectionTransactionViewModel.PanNumber; collectionTransactionModel.ApplicantGSTNumber = collectionTransactionViewModel.ApplicantGSTNumber; collectionTransactionModel.TotalAmount = collectionTransactionViewModel.TotalAmount; collectionTransactionModel.CreatedBy = collectionTransactionViewModel.CreatedBy; collectionTransactionModel.TransactionId = Guid.NewGuid().ToString().Trim(); collectionTransactionModel.TransactionStatus = (int)TransactionStatus.Pending; collectionTransactionModel.Remarks = collectionTransactionViewModel.Remarks; collectionTransactionModel.DepartmentId = collectionTransactionViewModel.DepartmentId; DataTable dataTable = new DataTable("dbo.TransactionServiceList"); dataTable.Columns.Add("ServiceId", typeof(Int16)); dataTable.Columns.Add("Rate", typeof(decimal)); dataTable.Columns.Add("Quantity", typeof(Int16)); dataTable.Columns.Add("Remarks", typeof(string)); for (int i = 0; i < collectionTransactionViewModel.TransactionServiceModelList.Count; i++) { DataRow dr = dataTable.NewRow(); dr["ServiceId"] = collectionTransactionViewModel.TransactionServiceModelList[i].ServiceId; dr["Rate"] = collectionTransactionViewModel.TransactionServiceModelList[i].Rate; dr["Quantity"] = collectionTransactionViewModel.TransactionServiceModelList[i].Quantity; dr["Remarks"] = collectionTransactionViewModel.TransactionServiceModelList[i].Remarks; dataTable.Rows.Add(dr); } using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { operationModel = collectionTransactionDB.AddTransactionData(collectionTransactionModel, dataTable); } if (operationModel.OperationStatus == (int)EnumModel.OperationStatus.Success) { EmailMessageHelper emailMessageHelper = new EmailMessageHelper(); EmailMessageModel emailMessageModel = new EmailMessageModel(); emailMessageModel.ReceiverEmailAddress = collectionTransactionViewModel.EmailAddress; emailMessageModel.ApplicantName = collectionTransactionViewModel.ApplicantName; emailMessageModel.TransactionId = operationModel.OperationLogId; emailMessageHelper.SendEmail(emailMessageModel); } return(operationModel); } catch (Exception e) { throw e; } }
public CollectionTransactionViewModel GetCollectionTransactionDetails(string txnId) { try { CollectionTransactionViewModel collectionTransactionViewModel = new CollectionTransactionViewModel(); CollectionTransactionModel collectionTransactionModel = new CollectionTransactionModel(); using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { collectionTransactionModel = collectionTransactionDB.GetTransactionData(txnId); collectionTransactionViewModel.TransactionServiceModelList = collectionTransactionDB.GetTransationServices(collectionTransactionModel.CollectionTransactionId); collectionTransactionViewModel.ApplicantName = collectionTransactionModel.ApplicantName; collectionTransactionViewModel.MobileNumber = collectionTransactionModel.MobileNumber; collectionTransactionViewModel.Address = collectionTransactionModel.Address; collectionTransactionViewModel.AadhaarNumber = collectionTransactionModel.AadhaarNumber; collectionTransactionViewModel.PanNumber = collectionTransactionModel.PanNumber; collectionTransactionViewModel.ApplicantGSTNumber = collectionTransactionModel.ApplicantGSTNumber; collectionTransactionViewModel.TotalAmount = collectionTransactionModel.TotalAmount; collectionTransactionViewModel.CreatedBy = collectionTransactionModel.CreatedBy; collectionTransactionViewModel.TransactionId = collectionTransactionModel.TransactionId; collectionTransactionViewModel.TransactionStatus = collectionTransactionModel.TransactionStatus; collectionTransactionViewModel.Remarks = collectionTransactionModel.Remarks; collectionTransactionViewModel.DepartmentName = collectionTransactionModel.DepartmentName; collectionTransactionViewModel.CollectionTransactionId = collectionTransactionModel.CollectionTransactionId; collectionTransactionViewModel.ModeOfPayment = collectionTransactionModel.ModeOfPayment; if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.Cheque) { collectionTransactionViewModel.BankAddressC = collectionTransactionModel.BankAddress; collectionTransactionViewModel.BankNameC = collectionTransactionModel.BankName; collectionTransactionViewModel.ChequeNumber = collectionTransactionModel.ChequeNumber; } else if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.DD) { collectionTransactionViewModel.BankAddressD = collectionTransactionModel.BankAddress; collectionTransactionViewModel.BankNameD = collectionTransactionModel.BankName; collectionTransactionViewModel.DDNumber = collectionTransactionModel.DDNumber; } else if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.Cash) { collectionTransactionViewModel.Denomination1H = collectionTransactionModel.Denomination1H; collectionTransactionViewModel.Denomination2H = collectionTransactionModel.Denomination2H; collectionTransactionViewModel.Denomination5H = collectionTransactionModel.Denomination5H; collectionTransactionViewModel.Denomination2K = collectionTransactionModel.Denomination2K; } } return(collectionTransactionViewModel); } catch (Exception e) { throw e; } }
public List <DepartmentModel> GetAllDepartments() { try { List <DepartmentModel> departmentList = new List <DepartmentModel>(); using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { departmentList = collectionTransactionDB.GetAllDepartments(); } return(departmentList); } catch (Exception e) { throw e; } }
public List <ServiceModel> GetAllServices(int departmentId) { try { List <ServiceModel> serviceList = new List <ServiceModel>(); using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { serviceList = collectionTransactionDB.GetAllServices(departmentId); } return(serviceList); } catch (Exception e) { throw e; } }
public ServiceModel GetServicebyId(int serviceId) { try { ServiceModel serviceModel = new ServiceModel(); using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { serviceModel = collectionTransactionDB.GetServicebyId(serviceId); } return(serviceModel); } catch (Exception e) { throw e; } }
public OperationModel SavePaymentDetails(CollectionTransactionViewModel collectionTransactionViewModel) { try { OperationModel operationModel = new OperationModel(); CollectionTransactionModel collectionTransactionModel = new CollectionTransactionModel(); collectionTransactionModel.ModeOfPayment = collectionTransactionViewModel.ModeOfPayment; if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.Cheque) { collectionTransactionModel.BankAddress = collectionTransactionViewModel.BankAddressC; collectionTransactionModel.BankName = collectionTransactionViewModel.BankNameC; collectionTransactionModel.ChequeNumber = collectionTransactionViewModel.ChequeNumber; } if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.DD) { collectionTransactionModel.BankAddress = collectionTransactionViewModel.BankAddressD; collectionTransactionModel.BankName = collectionTransactionViewModel.BankNameD; collectionTransactionModel.DDNumber = collectionTransactionViewModel.DDNumber; } if (collectionTransactionModel.ModeOfPayment == (int)EnumModel.ModeofPayment.Cash) { collectionTransactionModel.Denomination2K = collectionTransactionViewModel.Denomination2K; collectionTransactionModel.Denomination5H = collectionTransactionViewModel.Denomination5H; collectionTransactionModel.Denomination2H = collectionTransactionViewModel.Denomination2H; collectionTransactionModel.Denomination1H = collectionTransactionViewModel.Denomination1H; } collectionTransactionModel.UpdatedBy = collectionTransactionViewModel.CreatedBy; collectionTransactionModel.CollectionTransactionId = collectionTransactionViewModel.CollectionTransactionId; collectionTransactionModel.TransactionStatus = (int)TransactionStatus.Success; using (CollectionTransactionDB collectionTransactionDB = new CollectionTransactionDB()) { operationModel = collectionTransactionDB.SavePaymentDetails(collectionTransactionModel); } return(operationModel); } catch (Exception e) { throw e; } }