protected void Application_Error(object sender, EventArgs e)
{
Exception exception = Server.GetLastError();
if (exception != null)
{
string errorMessage = exception.Message;
Server.ClearError();
Response.Clear();
if (HttpContext.Current != null)
{
if (HttpContext.Current.Session != null)
{
if (!errorMessage.Contains("after HTTP headers have been sent"))
{
var strErr = writeApplicationError(exception.ToString());
ErrorHandling.LogError(strErr);
GenericResultModel result = new GenericResultModel()
{
MaintenanceMessage = "", MaintenanceMode = false
};
result.HasError = true;
result.IsValidationError = false;
result.Feedback = errorMessage;
Response.ContentType = "application/json; charset=utf-8";
Response.Write(JsonConvert.SerializeObject(result));
Response.End();
}
}
}
}
}
public JsonResult CreateAPIUser(NewUsersModel nUsermodel)
{
try
{
var newUserResult = _db.Query <CreatedUserResultModel>(";Exec Supreme_InsertUser @UserName,@Password,@CompanyName,@Address,@CreatedBy",
new
{
UserName = nUsermodel.UserName,
Password = GetHashedPassword(nUsermodel.Password),
CompanyName = nUsermodel.CompanyName,
Address = nUsermodel.Address,
CreatedBy = nUsermodel.CreatedBy
}).SingleOrDefault();
nUsermodel.Password = string.Empty;
logger.LogWrite(JsonConvert.SerializeObject(nUsermodel).ToString());
return(Json(newUserResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddNewAccount(AddAccountModel accountmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(accountmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <AccountResultModel>(";Exec Supreme_AddNewAccount @ClientID,@AccountName,@ProductID,@Address,@CityID,@CountryID,@Mobile,@OperatingModeID,@OperatorID",
new
{
ClientID = accountmodel.ClientID,
AccountName = accountmodel.AccountName,
ProductID = accountmodel.ProductID,
Address = accountmodel.Address,
CityID = accountmodel.CityID,
CountryID = accountmodel.CountryID,
Mobile = accountmodel.Mobile,
OperatingModeID = accountmodel.OperatingModeID,
OperatorID = SecurityController.GetValidOperator(accountmodel.TokenCode).ToString()
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(accountmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult LoanProcessing(ProcessLoanModel loanmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(loanmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <LoanProcessResultModel>(";Exec Supreme_ProcessNewLoan @ClientID,@ProductID,@LoanAmount,@LoanTerm,@InterestRate,@LoanPeriodID,@PurposeCodeID,@CreditOfficerID,@Remarks,@OperatorID",
new
{
ClientID = loanmodel.ClientID,
ProductID = loanmodel.ProductID,
LoanAmount = loanmodel.LoanAmount,
LoanTerm = loanmodel.LoanTerm,
InterestRate = loanmodel.InterestRate,
LoanPeriodID = loanmodel.LoanPeriodID,
PurposeCodeID = loanmodel.PurposeCodeID,
CreditOfficerID = loanmodel.CreditOfficerID,
Remarks = loanmodel.Remarks,
OperatorID = SecurityController.GetValidOperator(loanmodel.TokenCode).ToString()//loanmodel.OperatorID
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(loanmodel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult PingPort(SysCodeModel sysmodel)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "SUCESS";
AccListResult2.Remarks = "SUCESS";
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
public JsonResult AddCashTrx(CashTrxAddModel addcashTrxmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(addcashTrxmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <TrfResultModel>(";Exec Supreme_AddCashTrx @AccountTypeID, @AccountID, @TrxAmount, @Narration, @RefNumber,@OperatorID,@TrxTypeID",
new
{
AccountTypeID = addcashTrxmodel.AccountTypeID,
AccountID = addcashTrxmodel.AccountID,
TrxAmount = addcashTrxmodel.TrxAmount,
Narration = addcashTrxmodel.Narration,
RefNumber = addcashTrxmodel.RefNumber,
OperatorID = SecurityController.GetValidOperator(addcashTrxmodel.TokenCode).ToString(),
TrxTypeID = addcashTrxmodel.TrxTypeID
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(addcashTrxmodel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
//return Json(UserListResult, JsonRequestBehavior.AllowGet);
}
public JsonResult FetchAccountStatement(AccountStmParamsModel Accmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(Accmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <AccountStatementModel>(";Exec Supreme_GetAccountTransactions @OurBranchID,@AccountID,@FromDate,@ToDate,@OperatorID",
new
{
OurBranchID = Accmodel.OurBranchID,
AccountID = Accmodel.AccountID,
FromDate = Accmodel.FromDate,
ToDate = Accmodel.ToDate,
OperatorID = SecurityController.GetValidOperator(Accmodel.TokenCode).ToString()
}).ToList();
logger.LogWrite(JsonConvert.SerializeObject(Accmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FetchAccountList(AccountSearchModel Smodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(Smodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <AccountListModel>(";Exec Supreme_AccountListing @Offset,@SearchTypeID,@SearchStatement",
new
{
Offset = Smodel.Offset,
SearchTypeID = Smodel.SearchTypeID,
SearchStatement = Smodel.SearchStatement
}).ToList();
logger.LogWrite(JsonConvert.SerializeObject(Smodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
//return Json(UserListResult, JsonRequestBehavior.AllowGet);
}
public JsonResult FetchWFLoanList(WFParamsModel Smodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(Smodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <WFLoanListModel>(";Exec Supreme_GetWorkflowLoan @Offset,@Records,@ADVStageID,@AppStatusID",
new
{
Offset = Smodel.Offset,
Records = Smodel.Records,
ADVStageID = Smodel.ADVStageID,
AppStatusID = Smodel.AppStatusID
}).ToList();
logger.LogWrite(JsonConvert.SerializeObject(Smodel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult LoanSanction(SanctionLoanModel loanmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(loanmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <LoanAppResultModel>(";Exec Supreme_LoanSanction @ApplicationID,@ApprovedBy,@Remarks,@OperatorID",
new
{
ApplicationID = loanmodel.ApplicationID,
ApprovedBy = loanmodel.ApprovedBy,
Remarks = loanmodel.Remarks,
OperatorID = SecurityController.GetValidOperator(loanmodel.TokenCode).ToString()
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(loanmodel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FetchLoanDetails(LoanDetailsParamsModel Smodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(Smodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <LoanDetailsModel>(";Exec Supreme_GetLoanDetails @OurBranchID,@AccountID,@LoanSeries",
new
{
OurBranchID = Smodel.OurBranchID,
AccountID = Smodel.AccountID,
LoanSeries = Smodel.LoanSeries
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(Smodel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public ActionResult FetchTransferTrxList(TrxModel tModel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(tModel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <TrfTrxListModel>(";Exec Supreme_GetTransferTrxList @OurBranchID,@Offset",
new
{
OurBranchID = tModel.OurBranchID,
Offset = tModel.Offset
}).ToList();
logger.LogWrite(JsonConvert.SerializeObject(tModel).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FetchClientAccounts(ClientParamModel Accmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(Accmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <ClientAccountsModel>(";Exec Supreme_GetClientAccounts @ClientID",
new
{
ClientID = Accmodel.ClientID
}).ToList();
logger.LogWrite(JsonConvert.SerializeObject(Accmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetAuthenticationStatus(GenericRequestModel request)
{
GenericResultModel a = new GenericResultModel()
{
ErrorReference = "",
Feedback = "",
HasError = false,
IsAuthenticationError = false,
IsValidationError = false,
MaintenanceMessage = "",
MaintenanceMode = false,
FullName = request.SessionUserName
};
return(Json(a, JsonRequestBehavior.DenyGet));
}
public JsonResult FetchClientSearchTypes(OffsetModel offmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(offmodel.TokenCode);
try
{
if (validation.Validated == true)
{
//var AccListResult = _db.Query<AccountListModel>("Supreme_AccountListing",commandType: CommandType.StoredProcedure).ToList();
var AccListResult = _db.Query <SubCodeModel>(";Exec Supreme_getClientSearchTypes").ToList();
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
logger.LogWrite(message);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FetchSystemCodes(SysCodeModel sysmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(sysmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var SysListResult = _db.Query <SysCodeDetailModel>(";Exec Supreme_getSystemCodes @SubCodeID", new { SubCodeID = sysmodel.SubCodeID, }).ToList();
return(Json(SysListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Disbursement(MovementParamModel sysmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(sysmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var SysListResult = _db.Query <DisbursmentModel>(";Exec Supreme_DashDisbursement @Offset", new { Offset = sysmodel.Offset }).ToList();
return(Json(SysListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult APILogin(MyUsersModel Tokenmodel)
{
try
{
var loginResult = _db.Query <MyUserResultModel>(";Exec Supreme_AuthenticateUser @UserName,@Password",
new
{
UserName = Tokenmodel.UserName,
Password = GetHashedPassword(Tokenmodel.Password)
}).SingleOrDefault();
Tokenmodel.UserID = loginResult.UserID;
Tokenmodel.SecurityStamp = Guid.NewGuid().ToString();
var token = Managers.TokenManager.GenerateToken(ConfirmLoginTokenPurpose, Tokenmodel);
_db.Query(";Exec Supreme_UpdateUserToken @UserID,@TokenID,@SecurityStamp",
new
{
UserID = Tokenmodel.UserID,
TokenID = token,
SecurityStamp = Tokenmodel.SecurityStamp
});
MyTokenResultModel tokenResult = new MyTokenResultModel();
tokenResult.tokenAuth = token;
Tokenmodel.Password = string.Empty;
logger.LogWrite(JsonConvert.SerializeObject(Tokenmodel).ToString());
return(Json(tokenResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddNewClient(AddClientModel clientmodel)
{
string errMessage = string.Empty;
if (ModelState.IsValid)
{
var validation = SecurityController.ValidateToken(clientmodel.TokenCode);
try
{
if (validation.Validated == true)
{
var AccListResult = _db.Query <ClientResultModel>(";Exec Supreme_AddNewClient @ClientTypeID,@TitleID,@FirstName,@MiddleName,@LastName,@GenderID,@DateOfBirth,@IDTypeID,@IDNumber, @CountryID, @CityID, @Address, @ZipCodeID, @Mobile, @EmailAddress, @Phone1,@OperatorID",
new
{
ClientTypeID = clientmodel.ClientTypeID,
TitleID = clientmodel.TitleID,
FirstName = clientmodel.FirstName,
MiddleName = clientmodel.MiddleName,
LastName = clientmodel.LastName,
GenderID = clientmodel.GenderID,
DateOfBirth = clientmodel.DateOfBirth,
IDTypeID = clientmodel.IDTypeID,
IDNumber = clientmodel.IDNumber,
CountryID = clientmodel.CountryID,
CityID = clientmodel.CityID,
Address = clientmodel.Address,
ZipCodeID = clientmodel.ZipCodeID,
Mobile = clientmodel.Mobile,
EmailAddress = clientmodel.EmailAddress,
Phone1 = clientmodel.Phone1,
OperatorID = SecurityController.GetValidOperator(clientmodel.TokenCode).ToString()
}).SingleOrDefault();
logger.LogWrite(JsonConvert.SerializeObject(clientmodel).ToString() + ":-" + JsonConvert.SerializeObject(AccListResult).ToString());
return(Json(AccListResult, JsonRequestBehavior.AllowGet));
}
else
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = validation.Errors[0].ToString();
logger.LogWrite(JsonConvert.SerializeObject(validation).ToString());
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ee)
{
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = ee.Message;
GeneralService.WriteErrorLog(ref ee);
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
else
{
var message = string.Join(" | ", ModelState.Values
.SelectMany(v => v.Errors)
.Select(e => e.ErrorMessage));
GenericResultModel AccListResult2 = new GenericResultModel();
AccListResult2.Status = "Fail";
AccListResult2.Remarks = message;
return(Json(AccListResult2, JsonRequestBehavior.AllowGet));
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
string authenticationTokenHeaderIndex = "authenticationToken";
string deviceUUIDHeaderIndex = "deviceUUID";
string environmentHeaderIndex = "environment";
bool isAjax = true;
if (!isAjax)
{
}
else
{
string authenticationToken = "";
string deviceUUID = "";
string urlBit = "";
string environment = "MobileApp";
if (HttpContext.Current.Request.HttpMethod == "GET")
{
environment = "WebApp";
}
string declarationsCycleMode = "current";
string feedBackMessage = "Invalid User Access.";
bool isValid = true;
string usercode = "Unknown";
string username = "******";
try
{
urlBit = (filterContext.RouteData.Route as System.Web.Routing.Route).Url;
if (HttpContext.Current.Request.Headers[authenticationTokenHeaderIndex] != null)
{
authenticationToken = HttpContext.Current.Request.Headers[authenticationTokenHeaderIndex].ToString();
}
if (HttpContext.Current.Request.Headers[deviceUUIDHeaderIndex] != null)
{
deviceUUID = HttpContext.Current.Request.Headers[deviceUUIDHeaderIndex].ToString();
}
if (HttpContext.Current.Request.Headers[environmentHeaderIndex] != null)
{
environment = HttpContext.Current.Request.Headers[environmentHeaderIndex].ToString();
}
if ((authenticationToken.Trim() == "" || deviceUUID.Trim() == "") && (environment == "MobileApp"))
{
isValid = false;
feedBackMessage = "Invalid User Access.";
}
if (isValid)
{
AuthenticatedUserModel user = null;
if (user == null)
{
isValid = true;
}
else
{
var prmList = filterContext.ActionParameters;
foreach (var prm in prmList)
{
var prmObj = prm.Value as GenericRequestModel;
if (prmObj != null)
{
usercode = user.LoginUserName;
username = user.FullName;
prmObj.SessionUserName = user.FullName;
prmObj.SessionUserId = user.UserId;
prmObj.DeviceIdentifier = deviceUUID;
prmObj.RootWebFolder = HttpContext.Current.Server.MapPath("~");
prmObj.RootAPIURL = HttpContext.Current.Request.Url.AbsoluteUri.Replace(
HttpContext.Current.Request.RawUrl, "");
if (!prmObj.RootAPIURL.EndsWith("/"))
{
prmObj.RootAPIURL += "/";
}
if (prmObj.RootAPIURL.Contains("localhost"))
{
}
else if (prmObj.RootAPIURL.Contains("testza"))
{
}
else
{
prmObj.RootAPIURL += "api";
}
prmObj.Environment = environment;
}
}
if (IsOpenMethod)
{
isValid = IsOpenMethod;
}
else
{
isValid = SystemUserLogic.UserHasAccessToLocation(user, Roles);
}
}
}
}
catch (Exception error)
{
isValid = false;
feedBackMessage = error.ToString();
}
if (!isValid)
{
GenericResultModel result = new GenericResultModel()
{
HasError = true, Feedback = feedBackMessage, IsValidationError = false,
IsAuthenticationError = true, FullName = username, WindowsUser = usercode
};
filterContext.Result = new JsonResult
{
Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
else
{
base.OnActionExecuting(filterContext);
}
}
}
