public object Save([FromBody] TblDisburseCompanyInfo tblDisburseCompanyInfo)
{
try
{
tblDisburseCompanyInfo.CompanyId = Convert.ToInt16(_disbursementService.GetMaxCompanyId()) + 1;
_disbursementService.Add(tblDisburseCompanyInfo);
//Insert into audit trial audit and detail
_auditTrailService.InsertModelToAuditTrail(tblDisburseCompanyInfo, tblDisburseCompanyInfo.entry_user, 10, 3, "Disbursement Company", tblDisburseCompanyInfo.CompanyId.ToString(), "Saved Successfully!");
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
return(true);
}
public object Save([FromBody] ApplicationUser model)
{
try
{
if (model.Id != 0)
{
ApplicationUser prevModel = usersService.SingleOrDefault(model.Id, new ApplicationUser());
model.UpdatedDate = DateTime.Now;
usersService.Update(model);
//Insert into audit trial audit and detail
//ApplicationUser prevModel = usersService.SingleOrDefault(model.Id, new ApplicationUser());
//prevModel.Status = "default";//insert for only audit trail
_auditTrailService.InsertUpdatedModelToAuditTrail(model, prevModel, model.UpdatedBy, 7, 4, "Application User", model.Username, "Updated Successfully!");
return(model);
}
else
{
model = generateSecuredCredentials(model);
model = usersService.Add(model);
string messagePrefix = ", Your Account Has been Created on OK Wallet Admin Application. Your username is " + model.Username + " and password is " + model.PlainPassword;
MessageModel messageModel = new MessageModel()
{
Mphone = model.MobileNo,
MessageId = "999",
MessageBody = "Dear " + model.Name + messagePrefix + ". Thank you."
};
MessageService messageService = new MessageService();
messageService.SendMessage(messageModel);
//Insert into audit trial audit and detail
_auditTrailService.InsertModelToAuditTrail(model, model.CreatedBy, 7, 3, "Application User", model.Username, "Saved Successfully!");
return(model);
}
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object ExecuteEOD(string todayDate, string userName)
{
try
{
string response = null;
DateRangeModel date = new DateRangeModel();
date.FromDate = string.IsNullOrEmpty(todayDate) == true ? DateTime.Now : DateTime.Parse(todayDate);
response = transMastService.ExecuteEOD(date.FromDate, userName).ToString();
//Insert into audit trial audit and detail
var model = new { todayDate, userName };
_auditTrailService.InsertModelToAuditTrail(model, userName, 10, 4, "End of Day (EOD)", date.FromDate.ToString(), response);
return(response);
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object Save(bool isEditMode, string evnt, [FromBody] TblCashEntry cashEntry)
{
try
{
if (isEditMode != true)
{
try
{
cashEntry.Status = "";
cashEntry.TransNo = _distributorDepositService.GetTransactionNo();
cashEntry.TransDate = System.DateTime.Now;
_distributorDepositService.Add(cashEntry);
//Insert into audit trial audit and detail
cashEntry.Status = "default";//insert for only audit trail
_auditTrailService.InsertModelToAuditTrail(cashEntry, cashEntry.CreateUser, 9, 3, "Distributor Deposit", cashEntry.AcNo, "Saved Successfully!");
}
catch (Exception)
{
throw;
}
return(true);
}
else
{
if (evnt == "edit")
{
try
{
cashEntry.Status = "";
cashEntry.UpdateDate = System.DateTime.Now;
_distributorDepositService.UpdateByStringField(cashEntry, "TransNo");
//Insert into audit trial audit and detail
cashEntry.Status = "default"; //insert for only audit trail
TblCashEntry prevModel = _distributorDepositService.GetDestributorDepositByTransNo(cashEntry.TransNo);
prevModel.Status = "default"; //insert for only audit trail
_auditTrailService.InsertUpdatedModelToAuditTrail(cashEntry, prevModel, cashEntry.UpdateUser, 9, 4, "Distributor Deposit", cashEntry.AcNo, "Updated Successfully!");
}
catch (Exception ex)
{
throw;
}
return(true);
}
else if (evnt == "register")
{
cashEntry.Status = "P";
cashEntry.CheckedDate = System.DateTime.Now;
//insert into gl_trans_dtl and gl_trans_mst and RegInfo
var successOrErrorMsg = _distributorDepositService.DataInsertToTransMSTandDTL(cashEntry);
//Insert into audit trial audit and detail
TblCashEntry prevModel = _distributorDepositService.GetDestributorDepositByTransNo(cashEntry.TransNo);
prevModel.Status = "default";//insert for only audit trail
prevModel.CheckedUser = "";
_auditTrailService.InsertUpdatedModelToAuditTrail(cashEntry, prevModel, cashEntry.CheckedUser, 9, 4, "Distributor Deposit", cashEntry.AcNo, "Approved Successfully!");
return(successOrErrorMsg);
}
else
{
cashEntry.Status = "M";// M means pass to maker
cashEntry.CheckedDate = System.DateTime.Now;
_distributorDepositService.UpdateByStringField(cashEntry, "TransNo");
//Insert into audit trial audit and detail
TblCashEntry prevModel = _distributorDepositService.GetDestributorDepositByTransNo(cashEntry.TransNo);
prevModel.Status = "default";//insert for only audit trail
prevModel.CheckedUser = "";
_auditTrailService.InsertUpdatedModelToAuditTrail(cashEntry, prevModel, cashEntry.CheckedUser, 9, 4, "Distributor Deposit", cashEntry.AcNo, "Pass to Maker Successfully!");
return(true);
}
}
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public async Task <object> ConfirmBill([FromBody] BillCollectionCommon objBillCollectionCommon)
{
try
{
using (var httpClient = new HttpClient())
{
string[] param = new string[9];
param[0] = "PAY";
if (objBillCollectionCommon.MethodName.Contains("."))
{
param[1] = objBillCollectionCommon.MethodName + objBillCollectionCommon.SubMenuId;
}
else
{
param[1] = objBillCollectionCommon.MethodName;
}
param[2] = objBillCollectionCommon.BillId;
param[3] = objBillCollectionCommon.bill2;
param[4] = "M";
param[5] = objBillCollectionCommon.Amount.ToString();
param[6] = "5555";
param[7] = objBillCollectionCommon.BeneficiaryNumber;
param[8] = "";
List <BillApiCalling> billApiCallingList = new List <BillApiCalling>();
BillApiCalling objBillApiCalling = new BillApiCalling();
//objBillApiCalling.appid = "payapicall";
//objBillApiCalling.appchk = "589500e2dd1a2d985901cca01205aaba";
//for live
//objBillApiCalling.appid = "payapiLIVEcall";
//objBillApiCalling.appchk = "4945bdda77eba2bd6fa38add869a08d0";
objBillApiCalling.call = "msgin";
objBillApiCalling.mphone = "BP";
objBillApiCalling.parts = param;
string json = JsonConvert.SerializeObject(objBillApiCalling);
string base64Encoded = Convert.ToBase64String(Encoding.UTF8.GetBytes(json));
HttpContent httpContent = new StringContent(base64Encoded, Encoding.UTF8);
//HttpContent httpContent = new StringContent(JsonConvert.SerializeObject(telemetry), Encoding.UTF8);
httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
BillApiInfo apiInfo = new BillApiInfo();
dynamic apiResponse = null;
BillCollectionCheckResponse result = new BillCollectionCheckResponse();
using (var response = await httpClient.PostAsync(apiInfo.Ip + apiInfo.ApiUrl, httpContent))
{
apiResponse = await response.Content.ReadAsStringAsync();
byte[] data = Convert.FromBase64String(apiResponse);
string decodedString = Encoding.UTF8.GetString(data);
result = JsonConvert.DeserializeObject <BillCollectionCheckResponse>(decodedString);
}
//Insert into audit trial audit and detail
_auditTrailService.InsertModelToAuditTrail(objBillCollectionCommon, objBillCollectionCommon.EntryUser, objBillCollectionCommon.ParentPenuId, 3, objBillCollectionCommon.Title, objBillCollectionCommon.BillId, result.msg);
return(result);
}
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status400BadRequest, ex.ToString()));
}
}
public string UploadExcel(int organizationId, string batchno, string makerId, double amount)
{
string message = "";
HttpResponseMessage result = null;
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
HttpPostedFile file = httpRequest.Files[0];
Stream stream = file.InputStream;
IExcelDataReader reader = null;
if (file.FileName.EndsWith(".xls"))
{
reader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (file.FileName.EndsWith(".xlsx"))
{
reader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
message = "This file format is not supported";
}
DataSet excelRecords = reader.AsDataSet();
reader.Close();
var finalRecords = excelRecords.Tables[0];
bool isUploaded = false;
int lastRow = finalRecords.Rows.Count - 1;
double disburseTotal = Convert.ToDouble(finalRecords.Rows[lastRow][2]);
if (disburseTotal > 0)
{
if (disburseTotal > amount)
{
isUploaded = false;
message = "Disbursed total amount is greater than company total.";
}
else
{
for (int i = 1; i < finalRecords.Rows.Count - 1; i++)
{
TblDisburseTmp objTblDisburseTmp = new TblDisburseTmp();
objTblDisburseTmp.AcNo = finalRecords.Rows[i][1].ToString().Trim();
objTblDisburseTmp.Amount = Convert.ToDouble(finalRecords.Rows[i][2]);
objTblDisburseTmp.MakerId = makerId.ToString();
objTblDisburseTmp.Batchno = batchno.ToString();
objTblDisburseTmp.Sl = Convert.ToInt16(finalRecords.Rows[i][0]);
objTblDisburseTmp.OrganizationId = organizationId;
_TblDisburseTmpService.Add(objTblDisburseTmp);
}
isUploaded = true;
if (isUploaded)
{
message = "Excel file has been successfully uploaded";
//Insert into audit trial audit and detail
CompanyDisbursementUpload objCompanyDisbursementUpload = new CompanyDisbursementUpload();
objCompanyDisbursementUpload.CompanyId = organizationId;
objCompanyDisbursementUpload.BatchNo = batchno;
objCompanyDisbursementUpload.MakerId = makerId;
_auditTrailService.InsertModelToAuditTrail(objCompanyDisbursementUpload, objCompanyDisbursementUpload.MakerId, 10, 3, "Disbursement Process", objCompanyDisbursementUpload.CompanyId.ToString(), "Uploaded Successfully!");
}
else
{
message = "Excel file uploaded has fiald";
}
}
}
else
{
message = "Disbursed total amount must be greater than 0.";
}
}
else
{
result = Request.CreateResponse(HttpStatusCode.BadRequest);
}
return(message);
}
public object Save([FromBody] DisbursementUser model)
{
try
{
if (model.Id != 0)
{
//DisbursementUser prevModel = disbursementUserService.SingleOrDefault(model.Id, new DisbursementUser());
//model.UpdatedDate = DateTime.Now;
//disbursementUserService.Update(model);
////Insert into audit trial audit and detail
//_auditTrailService.InsertUpdatedModelToAuditTrail(model, prevModel, model.UpdatedBy, 7, 4, "Application User", model.Username, "Updated Successfully!");
//return model;
if (string.IsNullOrEmpty(model.PlainPassword))
{
return(disbursementUserService.Update(model));
}
else
{
//model = generateSecuredCredentials(model);
disbursementUserService.Update(model);
return(HttpStatusCode.OK);
}
}
else
{
model = generateSecuredCredentials(model);
model = disbursementUserService.Add(model);
if (!string.IsNullOrEmpty(model.MobileNo))
{
string messagePrefix = ", Your Account Has been Created on OK Wallet Admin Application. Your username is " + model.Username + " and password is " + model.PlainPassword;
MessageModel messageModel = new MessageModel()
{
Mphone = model.MobileNo,
MessageId = "999",
MessageBody = "Dear " + model.Name + messagePrefix + ". Thank you."
};
MessageService messageService = new MessageService();
messageService.SendMessage(messageModel);
//Insert into audit trial audit and detail
_auditTrailService.InsertModelToAuditTrail(model, model.CreatedBy, 7, 3, "Disbursement User", model.Username, "Saved Successfully!");
return(HttpStatusCode.OK);
}
else
{
return(HttpStatusCode.OK);
}
}
}
catch (Exception ex)
{
errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString());
return(HttpStatusCode.BadRequest);
}
}
public object SaveCommissionConversion(bool isEditMode, string evnt, [FromBody] TblCommissionConversion tblCommissionConversion)
{
try
{
if (isEditMode != true)
{
try
{
tblCommissionConversion.Status = "";
tblCommissionConversion.TransNo = _CommissionConversionService.GetTransactionNo();
tblCommissionConversion.CreateDate = System.DateTime.Now;
//_CommissionConversionService.Add(tblCommissionConversion);
_CommissionConversionService.AddBySP(tblCommissionConversion);
//Insert into audit trial audit and detail
tblCommissionConversion.Status = "default";//insert for only audit trail
_auditTrailService.InsertModelToAuditTrail(tblCommissionConversion, tblCommissionConversion.CreateUser, 9, 3, "Distributor Deposit", tblCommissionConversion.Mphone, "Saved Successfully!");
}
catch (Exception)
{
throw;
}
return(true);
}
else
{
//if (evnt == "edit")
//{
// try
// {
// tblCommissionConversion.Status = "";
// _CommissionConversionService.UpdateByStringField(tblCommissionConversion, "TransNo");
// //Insert into audit trial audit and detail
// tblCommissionConversion.Status = "default";//insert for only audit trail
// TblCashEntry prevModel = _CommissionConversionService.GetDestributorDepositByTransNo(tblCommissionConversion.TransNo);
// prevModel.Status = "default";//insert for only audit trail
// _auditTrailService.InsertUpdatedModelToAuditTrail(tblCommissionConversion, prevModel, tblCommissionConversion.UpdateUser, 9, 4, "Distributor Deposit", cashEntry.AcNo, "Updated Successfully!");
// }
// catch (Exception ex)
// {
// throw;
// }
// return true;
//}
//else if (evnt == "register")
if (evnt == "register")
{
tblCommissionConversion.Status = "P";
tblCommissionConversion.CheckedDate = System.DateTime.Now;
//insert into gl_trans_dtl and gl_trans_mst and RegInfo
var successOrErrorMsg = _CommissionConversionService.DataInsertToTransMSTandDTL(tblCommissionConversion);
//Insert into audit trial audit and detail
TblCommissionConversion prevModel = _CommissionConversionService.GetCommissionConversionByTransNo(tblCommissionConversion.TransNo);
prevModel.Status = "default";//insert for only audit trail
prevModel.CheckedUser = "";
_auditTrailService.InsertUpdatedModelToAuditTrail(tblCommissionConversion, prevModel, tblCommissionConversion.CheckedUser, 9, 4, "Commission Conversion", tblCommissionConversion.Mphone, "Approved Successfully!");
return(successOrErrorMsg);
}
else
{
tblCommissionConversion.Status = "R";// R means Reject
tblCommissionConversion.CheckedDate = System.DateTime.Now;
_CommissionConversionService.UpdateByStringField(tblCommissionConversion, "TransNo");
//Insert into audit trial audit and detail
TblCommissionConversion prevModel = _CommissionConversionService.GetCommissionConversionByTransNo(tblCommissionConversion.TransNo);
prevModel.Status = "default";//insert for only audit trail
prevModel.CheckedUser = "";
_auditTrailService.InsertUpdatedModelToAuditTrail(tblCommissionConversion, prevModel, tblCommissionConversion.CheckedUser, 9, 4, "Commission Conversion", tblCommissionConversion.Mphone, "Rejected Successfully!");
return(true);
}
}
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object SaveMapOrRemapCbsAccount(BatchUpdateModel model)
{
StringBuilderService builder = new StringBuilderService();
var cbsInfosList = ConvertBatchUpdateModelToMtCbsinfoModel(model);
string inactiveCbsAccountNo = string.Empty;
int allowAccNo = 3;
int count = 0;
int countPending = 0;
int totalCount = 0;
bool allowMap = false;
count = _repository.CheckEligibilityMappingByMphone(cbsInfosList[0].Mphone);
foreach (var value in cbsInfosList)
{
if (value.MakeStatus == "A")
{
countPending++;
}
}
totalCount = count + countPending;
if (count <= 2 && totalCount <= 3)
{
allowMap = true;
}
if (totalCount > 3)
{
return("Please do not try to activate more than three account");
}
if (countPending > 3)
{
return("Please do not try to activate more than three account");
}
if (count > 3)
{
return("Three accont activated already");
}
foreach (var item in cbsInfosList)
{
bool isRegInfoExist = _repository.IsRegInfoExist(item.Mphone);
if (!isRegInfoExist)
{
return("Ok Account: " + item.Mphone + " is Not exist"); //reginfo not exist
}
if (String.IsNullOrEmpty(item.MakeBy))
{
return(HttpStatusCode.Unauthorized);
}
if (item.Status == null && item.MakeStatus == "A")
{
var IsAccNoIsMappedByMblNo = _repository.CheckAccNoIsMappedByMblNo(item.Mobnum, item.Accno);
if (Convert.ToInt32(IsAccNoIsMappedByMblNo) == 0)
{
_repository.Add(item);
auditTrailService.InsertModelToAuditTrail(item, item.MakeBy, 8, 3, "Customer Acc Mapping", item.Mphone, "Mapped Suucessful");
}
else
{
return(HttpStatusCode.BadRequest);
}
}
if ((item.Status != item.MakeStatus) && item.Status != null)
{
if (item.MakeStatus == "A")
{
if (allowMap)
{
var cbsInfoPrev = _repository.GetMappedAccountByAccNo(item.Accno);
_repository.ActiveCbsAccountByAccountNo(item.Accno, item.MakeBy, item.Ubranch);
var cbsInfoCurrent = _repository.GetMappedAccountByAccNo(item.Accno);
auditTrailService.InsertUpdatedModelToAuditTrail(cbsInfoCurrent, cbsInfoPrev, item.MakeBy, 8, 4, "Customer Acc Mapping", item.Mphone, "Successfully Map or Remapped");
}
else
{
break;
}
}
else
{
var cbsInfoPrev = _repository.GetMappedAccountByAccNo(item.Accno);
_repository.InactiveCbsAccountByAccountNo(item.Accno, item.MakeBy, item.Ubranch);
var cbsInfoCurrent = _repository.GetMappedAccountByAccNo(item.Accno);
auditTrailService.InsertUpdatedModelToAuditTrail(cbsInfoCurrent, cbsInfoPrev, item.MakeBy, 8, 4, "Customer Acc Mapping", item.Mphone, "Successfully Map or Remapped");
}
}
}
return(HttpStatusCode.OK);
}
