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