public static ExpenseLookupRespObj LoadExpenseLookups(ExpenseLookupSearchObj regObj, string username)
{
var response = new ExpenseLookupRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage(),
},
};
try
{
var apiResponse = new APIHelper(APIEndpoints.LOAD_EXPENSES_LOOKUP_ENDPOINT, username, Method.POST).ProcessAPI <ExpenseLookupSearchObj, ExpenseLookupRespObj>(regObj, out var msg);
if (msg.Code == 0 && string.IsNullOrEmpty(msg.TechMessage) && string.IsNullOrEmpty(msg.Message))
{
return(apiResponse);
}
response.Status.Message.FriendlyMessage = msg.Message;
response.Status.Message.TechnicalMessage = msg.TechMessage;
return(response);
}
catch (Exception ex)
{
UtilTools.LogE(ex.StackTrace, ex.Source, ex.GetBaseException().Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
return(response);
}
}
public ActionResult AddItemLookup(int?categoryId, int?clientId, int?productId)
{
try
{
ViewBag.Error = "";
ViewBag.SessionError = "";
#region Curret User Session Check
var userData = MvcApplication.GetUserData(User.Identity.Name) ?? new UserData();
if (userData.UserId < 1)
{
ViewBag.SessionError = "Your session has expired! Please re-login";
return(View(new ExpenseLookupObj()));
}
#endregion
#region Client Product productItem Session Check
var userClientSession = (AppSession)Session["_UserClientSession_"];
if (userClientSession == null || userClientSession.ClientId < 1 || userClientSession.ProductId < 1 || userClientSession.ProductItemId < 1)
{
return(RedirectToAction("Index", "Dashboard"));
}
var ClientId = clientId ?? userClientSession.ClientId;
var ProductId = productId ?? userClientSession.ProductId;
var ProductItemId = userClientSession.ProductItemId;
ViewBag.ClientId = ClientId;
ViewBag.ProductId = ProductId;
ViewBag.ProductItemId = ProductItemId;
#endregion
#region Expense Item Lookup from Expense items service
ExpenseLookupRespObj retVal = null;
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status == null && retVal.ExpenseLookups == null)
{
return(View(new ExpenseLookupObj()));
}
var itemsLKP = retVal.ExpenseLookups
.Where(m => m.LookupName.Trim().ToLower().ToStandardHash()
== ExpenseLookupItems.ExpenseItem.ToString().Trim().ToLower().ToStandardHash())
.OrderBy(m => m.ExpenseLookupId).ToList();
if (itemsLKP == null || !itemsLKP.Any())
{
return(View(new ExpenseLookupObj()));
}
var clientProdItemsLKP = itemsLKP.SingleOrDefault(m => m.ClientId == clientId && m.ProductId == productId);
if (clientProdItemsLKP == null || clientProdItemsLKP.ExpenseLookupId < 1)
{
return(View(new ExpenseLookupObj()));
}
Session["_clientProdCategoryLKP_"] = clientProdItemsLKP;
string[] itemIds;
itemIds = clientProdItemsLKP.InclusionList.Split(',');
return(View(clientProdItemsLKP));
#endregion
}
catch (Exception ex)
{
ViewBag.Error = "Error Occurred! Please try again later";
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(View(new RegExpenseLookupObj()));
}
}
public JsonResult ProcessAddDepenDentLKPRequest(RegExpenseLookupObj model)
{
try
{
#region Current user Session check
var userData = MvcApplication.GetUserData(User.Identity.Name) ?? new UserData();
if (userData.UserId < 1)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
#endregion
#region model validations
if (model == null)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
if (model.ClientId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "client required " }));
}
if (model.ProductItemId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "Product Item required " }));
}
if (model.ProductId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "Product required " }));
}
if (string.IsNullOrEmpty(model.InclusionList) || model.InclusionList.Length < 0)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "No Item Selected" }));
}
if (string.IsNullOrEmpty(model.LookupName) || model.LookupName.Length < 2)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Lookup Name is required" }));
}
#endregion
#region Expense Lookup from service
var searchObjLKP = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
var retValLKP = ExpenseLookUpServices.LoadExpenseLookups(searchObjLKP, userData.Username);
if (retValLKP?.Status == null && retValLKP.ExpenseLookups == null)
{
}
var LKPList = retValLKP.ExpenseLookups
.Where(m => m.LookupName.Trim().ToLower().ToStandardHash()
== model.LookupName.ToString().Trim().ToLower().ToStandardHash())
.OrderBy(m => m.ExpenseLookupId).ToList();
if (LKPList == null || !LKPList.Any())
{
return(Json(new { IsSuccessful = false, IsAuthenticated = true }));
}
var thisClientProdLKP = LKPList.SingleOrDefault(m => m.ClientId == model.ClientId && m.ProductId == model.ProductId);
if (thisClientProdLKP == null || thisClientProdLKP.ExpenseLookupId < 1)
{
return(Json(new { IsSuccessful = false, IsAuthenticated = true, Error = "Something went wrong" }));
}
thisClientProdLKP.InclusionList = thisClientProdLKP.InclusionList.TrimStart(',').TrimEnd(',');
string[] NewLKPIdsArray;
string[] addedLkpIds = thisClientProdLKP.InclusionList.Trim().Split(',');
string[] modelLKPIds = model.InclusionList.Trim().Split(',');
NewLKPIdsArray = addedLkpIds.Concat(modelLKPIds).ToArray();
HashSet <string> newList = new HashSet <string>(NewLKPIdsArray);
newList.UnionWith(addedLkpIds);
string lkpIDtoAdd = string.Join(",", newList);
#endregion
#region Build Request Object
var requestObj = new EditExpenseLookupObj
{
ClientId = model.ClientId,
ProductId = model.ProductId,
AdminUserId = userData.UserId,
ChannelCode = thisClientProdLKP.ChannelCode,
ExclusionList = " 10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001",
InclusionList = lkpIDtoAdd,
IsEnabled = thisClientProdLKP.IsEnabled,
LookupItem = model.LookupItem,
LookupName = model.LookupName,
RegisteredBy = userData.UserId,
Status = 1,
TimeStampRegistered = DateTime.Now.ToString("ddd-mmm-yyyy"),
ProductItemId = thisClientProdLKP.ProductItemId,
ExpenseLookupId = thisClientProdLKP.ExpenseLookupId,
};
#endregion
#region Request and response validations
var response = ExpenseLookUpServices.UpdateExpenseLookup(requestObj, userData.Username);
if (response?.Status == null)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Error Occurred! Please try again later" }));
}
if (!response.Status.IsSuccessful)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = string.IsNullOrEmpty(response.Status.Message.TechnicalMessage) ? "Process Failed! Unable to add nomination Source" : response.Status.Message.TechnicalMessage }));
}
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
var retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status != null && retVal.ExpenseLookups != null)
{
var ExpenseLookups = retVal.ExpenseLookups.OrderBy(m => m.ExpenseLookupId).ToList();
Session["_ExpenseLookupList_"] = ExpenseLookups;
}
#endregion
ViewBag.ClientId = model.ClientId;
ViewBag.ProductId = model.ProductId;
ViewBag.ProductItemId = model.ProductItemId;
return(Json(new { IsAuthenticated = true, IsSuccessful = true, IsReload = false, Error = "" }));
}
catch (Exception ex)
{
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Process Error Occurred! Please try again later" }));
}
}
public ActionResult AddClassificationLookup(int?categoryId, int?clientId, int?productId)
{
try
{
ViewBag.Error = "";
ViewBag.SessionError = "";
#region Current User Session Check
var userData = MvcApplication.GetUserData(User.Identity.Name) ?? new UserData();
if (userData.UserId < 1)
{
ViewBag.SessionError = "Your session has expired! Please re-login";
return(View(new ExpenseLookupObj()));
}
#endregion
#region Client Product productItem Session Check
var userClientSession = (AppSession)Session["_UserClientSession_"];
if (userClientSession == null || userClientSession.ClientId < 1 || userClientSession.ProductId < 1 || userClientSession.ProductItemId < 1)
{
return(RedirectToAction("Index", "Dashboard"));
}
var ClientId = clientId ?? userClientSession.ClientId;
var ProductId = productId ?? userClientSession.ProductId;
var ProductItemId = userClientSession.ProductItemId;
ViewBag.ClientId = ClientId;
ViewBag.ProductId = ProductId;
ViewBag.ProductItemId = ProductItemId;
#endregion
#region Fetch Client and Product Added Category
var searchObjFiltered = new FilteredLookupSearchObj
{
AdminUserId = userData.UserId,
ProductId = productId ?? 0,
ClientId = clientId ?? 0,
};
var retValForCat = ExpenseLookUpServices.LoadFilteredExpenseCategories(searchObjFiltered, userData.Username);
var catList = retValForCat.ExpenseCategories.OrderBy(m => m.ExpenseCategoryId);
ViewBag.CategoryList = catList;
#endregion
#region Check if List Session is null else return to view
//if (!(Session["_ExpenseLookupList_"] is List<ExpenseLookupObj> ExpenseLookupList) || ExpenseLookupList.Count < 1)
//{
// return View(new ExpenseLookupObj());
//}
#endregion
#region Expense Category Lookup from Category service or Session is not null
ExpenseLookupRespObj retVal = null;
//if (Session["_clientProdCategoryLKP_"] is ExpenseLookupObj ExpenseLookup)
//{
// return View(ExpenseLookup);
//}
//else
//{
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status == null && retVal.ExpenseLookups == null)
{
return(View(new ExpenseLookupObj()));
}
//}
var classificationLKP = retVal.ExpenseLookups
.Where(m => m.LookupName.Trim().ToLower().ToStandardHash()
== ExpenseLookupItems.ExpenseClassification.ToString().Trim().ToLower().ToStandardHash())
.OrderBy(m => m.ExpenseLookupId).ToList();
if (classificationLKP == null || !classificationLKP.Any())
{
return(View(new ExpenseLookupObj()));
}
var clientProdClassificationLKP = classificationLKP.SingleOrDefault(m => m.ClientId == clientId && m.ProductId == productId);
if (clientProdClassificationLKP == null || clientProdClassificationLKP.ExpenseLookupId < 1)
{
return(View(new ExpenseLookupObj()));
}
Session["_clientProdClassificationLKP_"] = clientProdClassificationLKP;
string[] classificationIds;
classificationIds = clientProdClassificationLKP.InclusionList.Split(',');
return(View(clientProdClassificationLKP));
#endregion
}
catch (Exception ex)
{
ViewBag.Error = "Error Occurred! Please try again later";
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(View(new RegExpenseLookupObj()));
}
}
public JsonResult ProcessEditExpenseLookupRequest(ExpenseLookupObj model)
{
try
{
#region Current User Session Check
var userData = MvcApplication.GetUserData(User.Identity.Name) ?? new UserData();
if (userData.UserId < 1)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
#endregion
#region Validation Checks
var selExpenseLookup = Session["_CurrentSelExpenseLookup_"] as ExpenseLookupObj;
if (selExpenseLookup == null || selExpenseLookup.ExpenseLookupId < 1)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
if (model.ClientId < 1)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Client required " }));
}
if (model.ExpenseLookupId < 1)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "ExpenseLookupId required" }));
}
if (string.IsNullOrEmpty(model.LookupName) || model.LookupName.Length < 2)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Lookup Name is required" }));
}
if (!GenericVal.Validate(model, out var msg))
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = $"Validation Error Occurred! Detail: {msg}" }));
}
#endregion
#region Build Requesr Object
var passObj = new EditExpenseLookupObj()
{
ClientId = model.ClientId,
ProductId = model.ProductId,
AdminUserId = userData.UserId,
ChannelCode = "Channel",
ExclusionList = model.ExclusionList,
InclusionList = model.InclusionList,
IsEnabled = model.IsEnabled,
LookupItem = model.LookupItem,
LookupName = model.LookupName,
RegisteredBy = 1,
Status = 1,
TimeStampRegistered = DateTime.Now.ToString("ddd-mmm-yyyy"),
ExpenseLookupId = model.ExpenseLookupId,
ProductItemId = model.ProductItemId
};
#endregion
#region Request and responses Validation checks
var response = ExpenseLookUpServices.UpdateExpenseLookup(passObj, userData.Username);
if (response?.Status == null)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Error Occurred! Please try again later" }));
}
if (!response.Status.IsSuccessful)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = string.IsNullOrEmpty(response.Status.Message.TechnicalMessage) ? "Process Failed! Unable to add course of study" : response.Status.Message.TechnicalMessage }));
}
Session["_CurrentSelExpenseLookup_"] = null;
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
var retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status != null && retVal.ExpenseLookups != null)
{
var ExpenseLookups = retVal.ExpenseLookups.OrderBy(m => m.ExpenseLookupId).ToList();
Session["_ExpenseLookupList_"] = ExpenseLookups.Where(m => m.ProductId == model.ProductId && m.ClientId == model.ClientId && m.ProductItemId == model.ProductItemId).ToList();
}
#endregion
return(Json(new { IsAuthenticated = true, IsSuccessful = true, IsReload = false, Error = "" }));
}
catch (Exception ex)
{
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Process Error Occurred! Please try again later" }));
}
}
public ActionResult Index(int?clientId, int?productId)
{
try
{
ViewBag.Error = "";
#region Client Product productItem Session Check
var userClientSession = (AppSession)Session["_UserClientSession_"];
if (userClientSession == null || userClientSession.ClientId < 1 || userClientSession.ProductId < 1 || userClientSession.ProductItemId < 1)
{
return(RedirectToAction("Index", "Dashboard"));
}
var ClientId = clientId ?? userClientSession.ClientId;
var ProductId = productId ?? userClientSession.ProductId;
var ProductItemId = userClientSession.ProductItemId;
#endregion
#region Current User Session Check
var userData = MvcApplication.GetUserData(User.Identity.Name);
if (userData == null || userData.UserId < 1)
{
ViewBag.Error = "Session Has Expired! Please Re-Login";
return(View(new List <ExpenseLookupObj>()));
}
#endregion
#region Check if session list is empty else return to view
if (Session["_ExpenseLookupList_"] is List <ExpenseLookupObj> expenseLookup && expenseLookup.Any())
{
var clientProd = expenseLookup.Where(m => m.ClientId == ClientId && m.ProductId == ProductId).ToList();
return(View(clientProd));
}
#endregion
#region Request And Response Validations
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = 1
};
var retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status == null)
{
ViewBag.Error = " ExpenseLookup list is empty!";
return(View(new List <ExpenseLookupObj>()));
}
if (!retVal.Status.IsSuccessful)
{
ViewBag.Error = string.IsNullOrEmpty(retVal.Status.Message.FriendlyMessage)
? " ExpenseLookup list is empty!"
: retVal.Status.Message.FriendlyMessage;
return(View(new List <ExpenseLookupObj>()));
}
if (retVal.ExpenseLookups == null || !retVal.ExpenseLookups.Any())
{
ViewBag.Error = " ExpenseLookup list is empty!";
return(View(new List <ExpenseLookupObj>()));
}
#endregion
#region List Initialization into Session
var ExpenseLookups = retVal.ExpenseLookups.OrderBy(m => m.ExpenseLookupId).ToList();
var ClientProdList = ExpenseLookups.Where(m => m.ClientId == ClientId && m.ProductId == ProductId).ToList();
Session["_ExpenseLookupList_"] = ClientProdList;
#endregion
var clientProdExpLkps = ExpenseLookups.Where(m => m.ClientId == ClientId && m.ProductId == ProductId).ToList();
return(View(clientProdExpLkps));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(View(new List <ExpenseLookupObj>()));
}
}
public JsonResult ProcessAddExpenseLookupRequest(ExpenseLookupObj model)
{
try
{
#region Current User Session Check
var userData = MvcApplication.GetUserData(User.Identity.Name) ?? new UserData();
if (userData.UserId < 1)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
#endregion
#region Model validations
if (model == null)
{
return(Json(new { IsSuccessful = false, Error = "Your session has expired", IsAuthenticated = false }));
}
if (model.ClientId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "client required " }));
}
if (model.ProductItemId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "Product Item required " }));
}
if (model.ProductId < 1)
{
return(Json(new { isauthenticated = true, issuccessful = false, isreload = false, error = "Product required " }));
}
if (string.IsNullOrEmpty(model.InclusionList) || model.InclusionList.Length < 0)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "No Item Selected" }));
}
if (string.IsNullOrEmpty(model.LookupName) || model.LookupName.Length < 2)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Lookup Name is required" }));
}
#endregion
#region Expense Lookup from service
var searchObjLKP = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
var retValLKP = ExpenseLookUpServices.LoadExpenseLookups(searchObjLKP, userData.Username);
if (retValLKP?.Status == null && retValLKP.ExpenseLookups == null)
{
}
var LKPList = retValLKP.ExpenseLookups
.Where(m => m.LookupName.Trim().ToLower().ToStandardHash()
== model.LookupName.ToString().Trim().ToLower().ToStandardHash() &&
m.ClientId == model.ClientId && m.ProductId == model.ProductId && m.ProductItemId == model.ProductItemId).ToList();
if (LKPList.Count() != 0)
{
return(Json(new { IsSuccessful = false, IsAuthenticated = true }));
}
#endregion
#region Build Request Object
ExpenseLookupRegRespObj response = null;
var previousExpenseLookupList = (List <ExpenseLookupObj>)Session["_ExpenseLookupList_"];
var requestObjAdd = new RegExpenseLookupObj
{
ClientId = model.ClientId,
ProductId = model.ProductId,
AdminUserId = userData.UserId,
ChannelCode = "Channel",
ExclusionList = " 10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001,10001",
InclusionList = model.InclusionList,
IsEnabled = model.IsEnabled,
LookupItem = model.LookupItem,
LookupName = model.LookupName,
RegisteredBy = userData.UserId,
Status = 1,
TimeStampRegistered = DateTime.Now.ToString("ddd-mmm-yyyy"),
ProductItemId = model.ProductItemId,
};
response = ExpenseLookUpServices.AddExpenseLookup(requestObjAdd, userData.Username);
#endregion
#region Request Responses And Validations
if (response?.Status == null)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Error Occurred! Please try again later" }));
}
if (!response.Status.IsSuccessful)
{
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = string.IsNullOrEmpty(response.Status.Message.TechnicalMessage) ? "Process Failed! Unable to add nomination Source" : response.Status.Message.TechnicalMessage }));
}
var searchObj = new ExpenseLookupSearchObj
{
AdminUserId = userData.UserId,
ExpenseLookupId = 0,
Status = -2
};
var retVal = ExpenseLookUpServices.LoadExpenseLookups(searchObj, userData.Username);
if (retVal?.Status != null && retVal.ExpenseLookups != null)
{
var ExpenseLookups = retVal.ExpenseLookups.OrderBy(m => m.ExpenseLookupId).ToList();
Session["_ExpenseLookupList_"] = ExpenseLookups.Where(m => m.ProductId == model.ProductId && m.ClientId == model.ClientId && m.ProductItemId == model.ProductItemId).ToList();
}
#endregion
return(Json(new { IsAuthenticated = true, IsSuccessful = true, IsReload = false, Error = "" }));
}
catch (Exception ex)
{
UtilTools.LogE(ex.StackTrace, ex.Source, ex.Message);
return(Json(new { IsAuthenticated = true, IsSuccessful = false, IsReload = false, Error = "Process Error Occurred! Please try again later" }));
}
}