private List <BeneficiaryPayment> GetBeneficiaryPayment(SettingSearchObj searchObj)
{
try
{
if (searchObj.Status == -2)
{
var sql = new StringBuilder();
sql.Append($"SELECT * FROM \"NewVPlusSales\".\"BeneficiaryPayment\"");
var agentInfo = _repositiory.RepositoryContext().Database
.SqlQuery <BeneficiaryPayment>(sql.ToString()).ToList();
return(!agentInfo.Any() ? new List <BeneficiaryPayment>() : agentInfo);
}
else
{
var sql2 = new StringBuilder();
sql2.Append($"SELECT * FROM \"NewVPlusSales\".\"BeneficiaryPayment\" WHERE \"Status\" = {searchObj.Status}");
var agentInfo = _repositiory.RepositoryContext().Database
.SqlQuery <BeneficiaryPayment>(sql2.ToString()).ToList();
return(!agentInfo.Any() ? new List <BeneficiaryPayment>() : agentInfo);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <BeneficiaryPayment>());
}
}
private List <Card> GetCards(SettingSearchObj searchObj)
{
try
{
var sql = new StringBuilder();
if (searchObj.Status == -2)
{
sql.Append(
$"SELECT * FROM \"NewVPlusSale\".\"Card\" WHERE \"Status\" != {(int)CardStatus.Defective} AND \"Status\" !={(int)CardStatus.Deleted} ");
}
else
{
sql.Append(
$"SELECT * FROM \"NewVPlusSale\".\"Card\" WHERE \"Status\" != {searchObj.Status} ");
}
var agentInfo = _repository.RepositoryContext().Database.SqlQuery <Card>(sql.ToString()).ToList();
return(!agentInfo.Any() ? new List <Card>() : agentInfo);
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <Card>());
}
}
public CardCommissionRespObj LoadCardcommission(SettingSearchObj searchObj)
{
var response = new CardCommissionRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage()
}
};
try
{
if (searchObj.Equals(null))
{
response.Status.Message.FriendlyMessage = "Error Occurred! Unable to proceed with your request";
response.Status.Message.TechnicalMessage = "Registration Object is empty / invalid";
return(response);
}
if (!EntityValidatorHelper.Validate(searchObj, out var valResults))
{
var errorDetail = new StringBuilder();
if (!valResults.IsNullOrEmpty())
{
errorDetail.AppendLine("Following error occurred:");
valResults.ForEachx(m => errorDetail.AppendLine(m.ErrorMessage));
}
else
{
errorDetail.AppendLine("Validation error occurred! Please check all supplied parameters and try again");
}
response.Status.Message.FriendlyMessage = errorDetail.ToString();
response.Status.Message.TechnicalMessage = errorDetail.ToString();
response.Status.IsSuccessful = false;
return(response);
}
if (!HelperMethods.IsUserValid(searchObj.AdminUserId, searchObj.SysPathCode, new[] { "PortalAdmin", "CRMAdmin", "CRMManager" }, ref response.Status.Message))
{
return(response);
}
var thisCardCommission = GetCardCommissions();
if (!thisCardCommission.Any())
{
response.Status.Message.FriendlyMessage = "No Card Type Information found!";
response.Status.Message.TechnicalMessage = "No Card Type Information found!";
return(response);
}
if (searchObj.Status > 1)
{
thisCardCommission = thisCardCommission.FindAll(m => m.Status == (Status)searchObj.Status).ToList();
}
var thisCardCommissionItem = new List <CardCommissionItemObj>();
thisCardCommission.ForEachx(m =>
{
thisCardCommissionItem.Add(new CardCommissionItemObj
{
CardCommissionId = m.CardCommissionId,
CommissionRate = m.CommissionRatee,
CardTypeId = m.CardTypeId,
CardTypeName = new CardCommissionRepository().GetCardTypeInfo(m.CardTypeId).Name,
LowerAmount = m.LowerAmount,
UpperAmount = m.UpperAmount,
Status = (int)m.Status,
Statuslabel = m.Status.ToString().Replace("_", "")
});
});
response.Status.IsSuccessful = true;
response.CardCommissions = thisCardCommissionItem;
return(response);
}
catch (DbEntityValidationException ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
}
public StaffRoleRespObj LoadStaffRole(SettingSearchObj searchObj)
{
var response = new StaffRoleRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage()
}
};
try
{
if (searchObj.Equals(null))
{
response.Status.Message.FriendlyMessage = "Error Occurred! Unable to proceed with your request";
response.Status.Message.TechnicalMessage = "Registration Object is empty / invalid";
return(response);
}
if (!EntityValidatorHelper.Validate(searchObj, out var valResults))
{
var errorDetail = new StringBuilder();
if (!valResults.IsNullOrEmpty())
{
errorDetail.AppendLine("Following error occurred:");
valResults.ForEachx(m => errorDetail.AppendLine(m.ErrorMessage));
}
else
{
errorDetail.AppendLine(
"Validation error occurred! Please check all supplied parameters and try again");
}
response.Status.Message.FriendlyMessage = errorDetail.ToString();
response.Status.Message.TechnicalMessage = errorDetail.ToString();
response.Status.IsSuccessful = false;
return(response);
}
if (!HelperMethods.IsUserValid(searchObj.AdminUserId, searchObj.SysPathCode,
HelperMethods.getAllRoles(), ref response.Status.Message))
{
return(response);
}
var thisRoles = GetRoles();
if (!thisRoles.Any())
{
response.Status.Message.FriendlyMessage = "No Role Information found!";
response.Status.Message.TechnicalMessage = "No Role Information found!";
return(response);
}
if (searchObj.Status > -1)
{
thisRoles = thisRoles.FindAll(p => p.Status == (ItemStatus)searchObj.Status);
}
var roleItems = new List <StaffRoleObj>();
thisRoles.ForEachx(m =>
{
roleItems.Add(new StaffRoleObj
{
StaffRoleId = m.StaffRoleId,
Name = m.Name,
Status = (int)m.Status,
StatusLabel = m.Status.ToString().Replace("_", " ")
});
});
response.Status.IsSuccessful = true;
response.StaffRoles = roleItems;
return(response);
}
catch (DbEntityValidationException ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
}
public static StaffRoleRespObj LoadStaffRoles(SettingSearchObj regObj)
{
return(new StaffRoleRepository().LoadStaffRole(regObj));
}
public CardRespObj LoadCards(SettingSearchObj searchObj)
{
var response = new CardRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage()
}
};
try
{
if (searchObj.Equals(null))
{
response.Status.Message.FriendlyMessage = "Error Occurred! Unable to proceed with your request";
response.Status.Message.TechnicalMessage = "Registration Object is empty / invalid";
return(response);
}
if (!EntityValidatorHelper.Validate(searchObj, out var valResults))
{
var errorDetail = new StringBuilder();
if (!valResults.IsNullOrEmpty())
{
errorDetail.AppendLine("Following error occurred:");
valResults.ForEachx(m => errorDetail.AppendLine(m.ErrorMessage));
}
else
{
errorDetail.AppendLine("Validation error occurred! Please check all supplied parameters and try again");
}
response.Status.Message.FriendlyMessage = errorDetail.ToString();
response.Status.Message.TechnicalMessage = errorDetail.ToString();
response.Status.IsSuccessful = false;
return(response);
}
if (!HelperMethods.IsUserValid(searchObj.AdminUserId, searchObj.SysPathCode, HelperMethods.getRequesterRoles(), ref response.Status.Message))
{
return(response);
}
var thisCard = GetCards(searchObj);
if (!thisCard.Any())
{
response.Status.Message.FriendlyMessage = "No Card Production Information found!";
response.Status.Message.TechnicalMessage = "No Card Production Information found!";
return(response);
}
var cards = new List <CardObj>();
foreach (var m in thisCard)
{
var cardItem = new List <CardItemObj>();
var CardItemList = getCardItems(m.CardId);
if (!CardItemList.Any())
{
response.Status.Message.FriendlyMessage = "No Card Item Production Information found!";
response.Status.Message.TechnicalMessage = "No Card Item Production Information found!";
return(response);
}
foreach (var item in CardItemList)
{
cardItem.Add(new CardItemObj
{
CardItemId = item.CardItemId,
CardId = item.CardId,
CardTypeId = item.CardTypeId,
BatchId = item.BatchId,
BatchStartNumber = item.StartBatchNumber,
BatchStopNumber = item.StopBatchNumber,
AvailableQuantity = item.AvailableQuantity,
BatchQuantity = item.BatchQuantity,
DefectiveBatchNumbers = item.DefectiveBatchNumber,
DefectiveQuantity = item.DefectiveQuantity,
DeliveredQuantity = item.DeliveredQuantity,
IssuedQuantity = item.IssuedQuantity,
MissingQuantity = item.MissingQuantity,
RegisteredBy = item.RegisteredBy,
Status = (int)item.Status,
StatusLabel = item.Status.ToString().Replace("_", " "),
TimeStampDelivered = item.TimeStampDelivered,
TimeStampIssued = item.TimeStampLastIssued,
TimeStampRegistered = item.TimeStampRegisered
});
}
cards.Add(new CardObj()
{
CardId = m.CardId,
CardTypeId = m.CardTypeId,
CardTitle = m.CardTitle,
BatchKey = m.BatchKey,
StartBatchId = m.StartBatchId,
StopBatchId = m.StopBatchId,
NoOfBatches = m.NumberOfBatches,
QuantityPerBatch = m.QuantityPerBatch,
TotalQuantity = m.TotalQuantity,
TimeStampRegistered = m.TimeStampRegisered,
Status = (int)m.Status,
StatusLabel = m.Status.ToString().Replace("_", " "),
CardItems = cardItem
});
}
response.Status.IsSuccessful = true;
response.Cards = cards;
return(response);
}
catch (DbEntityValidationException ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
response.Status.Message.FriendlyMessage = "Error Occurred! Please try again later";
response.Status.Message.TechnicalMessage = "Error: " + ex.GetBaseException().Message;
response.Status.IsSuccessful = false;
return(response);
}
}