private void GetGraphDetails(ref GraphDetails objGraphDetails)
{
using (AVOAIALifeEntities entity = new AVOAIALifeEntities())
{
int reportID = objGraphDetails.ReportID;
var graphDetails = entity.tblDashboardReports.Where(a => a.ReportID == reportID).FirstOrDefault();
objGraphDetails.ReportName = graphDetails.ReportTitle;
objGraphDetails.Theme = graphDetails.Theme;
objGraphDetails.Type = graphDetails.Type;
//objGraphDetails.CategoryField = graphDetails.YAxisTitle;
objGraphDetails.StartDuration = Convert.ToInt32(graphDetails.StartDuration);
objGraphDetails.PlotAreaFillAlphas = graphDetails.PlotAreaFillAlphas ?? 0;
objGraphDetails.GraphHeight = graphDetails.Height;
objGraphDetails.GraphWidth = graphDetails.Width;
objGraphDetails.IsGrowth = graphDetails.IsGrowth ?? false;
objGraphDetails.Rotate = graphDetails.Rotate ?? false;
objGraphDetails.valueAxes.position = graphDetails.VAPosition;
objGraphDetails.valueAxes.labelsEnabled = graphDetails.VALabelsEnabled ?? false;
objGraphDetails.valueAxes.title = graphDetails.ValueAxisTitle;
objGraphDetails.valueAxes.unit = graphDetails.ValueAxisUnit;
objGraphDetails.lstvalueAxes.Add(objGraphDetails.valueAxes);
objGraphDetails.strvalueAxes = JsonConvert.SerializeObject(objGraphDetails.lstvalueAxes);
objGraphDetails.categoryAxis.gridPosition = "start";
objGraphDetails.categoryAxis.position = "left";
objGraphDetails.categoryAxis.axisAlpha = 0;
objGraphDetails.categoryAxis.tickLength = 0;
objGraphDetails.categoryAxis.labelRotation = graphDetails.LabelRotation ?? 0;
objGraphDetails.strcategoryAxis = JsonConvert.SerializeObject(objGraphDetails.categoryAxis);
objGraphDetails.IsDrillDown = graphDetails.IsDrillDown ?? false;
objGraphDetails.Depth3D = graphDetails.depth3D != null ? graphDetails.depth3D : 0;
objGraphDetails.Angle = graphDetails.angle != null ? graphDetails.angle : 0;
}
}
public void UpdateLeadStatus(AVOAIALifeEntities Context, int leadNo, int status)
{
try
{
LeadStatus leadStatus = new LeadStatus();
leadStatus.samsLeadNumber = leadNo;
leadStatus.status = status;
leadStatus.statusDateTime = DateTime.Now.ToString("yyyy-MM-dd h:mm tt");
#region Log Input
tbllogxml objlogxml = new tbllogxml();
objlogxml.Description = "Lead status request";
objlogxml.PolicyID = leadNo.ToString();
objlogxml.XMlData = Newtonsoft.Json.JsonConvert.SerializeObject(leadStatus);
objlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(objlogxml);
#endregion
LeadResponse leadResponse = new LeadResponse();
InvokeApi <LeadStatus, LeadResponse>(leadStatus, "sams/update/status", ref leadResponse);
#region Log output
tbllogxml outlogxml = new tbllogxml();
outlogxml.Description = "Lead Update Response";
outlogxml.PolicyID = leadNo.ToString();
outlogxml.XMlData = Newtonsoft.Json.JsonConvert.SerializeObject(leadResponse);
outlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(outlogxml);
#endregion
}
catch (Exception ex)
{
}
}
public ActionResult SaveManualAllocation(string Selected)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
ManualAllocation objAllocationModel = new ManualAllocation();
objAllocationModel.objLstAllocationProposals = new List <AllocationProposals>();
var SelectedArray = Selected.Split(',');
for (int i = 0; i < SelectedArray.Count(); i++)
{
var Combined = SelectedArray[i].Split('-');
var ProposalNo = Combined[0] + "-" + Combined[1];
var LoginID = Combined[2];
var UserID = Context.tblUserDetails.Where(a => a.LoginID == LoginID).Select(a => a.UserID).FirstOrDefault();
AllocationProposals obj = new AllocationProposals();
obj.ISSelected = true;
obj.ProposalNo = ProposalNo;
obj.AssignTo = UserID.ToString();
objAllocationModel.objLstAllocationProposals.Add(obj);
}
objAllocationModel = objAllocationBusiness.SaveManualAllocation(objAllocationModel);
return(Json(objAllocationModel.Message, JsonRequestBehavior.AllowGet));
}
public string SendDialogOnlinePremium(PaymentModel paymentModel)
{
AIAOnlinePremiumService.LifeClient lifeClient = new AIAOnlinePremiumService.LifeClient();
string instType = ConfigurationManager.AppSettings["OPSINSTTYPE"].ToString();
string clientID = ConfigurationManager.AppSettings["OPSCLIENTID"].ToString();
string password = ConfigurationManager.AppSettings["OPSPWD"].ToString();
using (AVOAIALifeEntities Context = new AVOAIALifeEntities())
{
#region Log Input
tbllogxml objlogxml = new tbllogxml();
objlogxml.Description = "online reciept request";
objlogxml.PolicyID = paymentModel.ProposalNo;
objlogxml.XMlData = paymentModel.ProposalNo + "|" + instType + "|" + paymentModel.TransactionNo + "|" + paymentModel.PayableAmount + "|" + clientID + "|" + password;
objlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(objlogxml);
Context.SaveChanges();
#endregion
string receipt = lifeClient.uploadPayment(paymentModel.ProposalNo, instType, paymentModel.TransactionNo, Convert.ToDouble(paymentModel.PayableAmount), clientID, password);
#region Log Output
tbllogxml objlogxml1 = new tbllogxml();
objlogxml1.Description = "online reciept response";
objlogxml1.PolicyID = paymentModel.ProposalNo;
objlogxml1.XMlData = receipt;
objlogxml1.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(objlogxml1);
Context.SaveChanges();
#endregion
return(receipt);
}
}
public bool PayUtilitiesDirect(Models.Payment.PaymentModel paymentModel)
{
McashRequest mcash = new McashRequest();
mcash.merchant_data.merchant_id = _mcashMerchantID;
mcash.merchant_data.merchant_transaction_id = paymentModel.TransactionNo;
mcash.merchant_data.pin_code = paymentModel.McashPin;
mcash.merchant_data.mobile_number = paymentModel.McashMobile;
mcash.utility_data.customer_mobile_number = paymentModel.Mobile;
mcash.utility_data.merchant_outlet_code = "AIA outlet";
mcash.utility_data.transaction_amount = Convert.ToDecimal(paymentModel.PayableAmount);
mcash.utility_data.utility_account_number = paymentModel.ProposalNo;
mcash.utility_data.utility_code = _mcashUtilityCode;
mcash.utility_data.note = "Nexgen ipos transaction";
var jsonData = Newtonsoft.Json.JsonConvert.SerializeObject(mcash);
jsonData = jsonData.Replace('_', '-');
AVOAIALifeEntities Context = new AVOAIALifeEntities();
#region Log Input
tbllogxml objlogxml = new tbllogxml();
objlogxml.Description = "MCash request";
objlogxml.PolicyID = paymentModel.ProposalNo;
objlogxml.UserID = paymentModel.UserName;
objlogxml.XMlData = jsonData;
objlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(objlogxml);
Context.SaveChanges();
#endregion
string result = McashBase.InvokeApi(jsonData);
#region Log output
tbllogxml outlogxml = new tbllogxml();
outlogxml.Description = "MCash response";
outlogxml.PolicyID = paymentModel.ProposalNo;
outlogxml.UserID = paymentModel.UserName;
outlogxml.XMlData = result;
outlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(outlogxml);
Context.SaveChanges();
#endregion
Dictionary <string, string> res = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, string> >(result);
string responseCode = res.Where(a => a.Key == "response-code").Select(a => a.Value).FirstOrDefault();
if (responseCode == "1000")
{
return(true);
}
else
{
paymentModel.Message = "Error";
paymentModel.Error.ErrorMessage = res.Where(a => a.Key == "response").Select(a => a.Value).FirstOrDefault();
return(false);
}
}
private string GetTransactionNumber(string startchar)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
ObjectParameter nextNo = new ObjectParameter("NextNo", SqlDbType.Int);
int genteratedNo = Context.usp_GetNextTxnNumber("TransactionNo", nextNo);
Int64 seqNo = Convert.ToInt64(nextNo.Value);
string value = seqNo.ToString("D9");
string transactionNo = startchar + value;
return(transactionNo);
}
/// <summary>
/// It Getnerates Unique QuoteNo or proposalNo for all products
/// </summary>
/// <returns>Quote/Proposal No</returns>
public String GenerateQuoteNo()
{
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
//var iSeqno = objEntities.usp_GetNextQuoteNumber("QuoteNo",param1);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
String QuoteNumber = System.Configuration.ConfigurationManager.AppSettings["QuoteNumberFixedCode"] + NextSeqNo.ToString().PadLeft(7, '0');
return(QuoteNumber);
}
/// <summary>
/// It Generates Unique IMD Code for temp purpose
/// </summary>
/// <returns>IMD Code</returns>
public String GenerateIMDCode()
{
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
//var iSeqno = objEntities.usp_GetNextIMDCode(param1);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
String IMDCode = "$IMD" + NextSeqNo.ToString().PadLeft(5, '0');
return(IMDCode);
}
/// <summary>
/// Generate Marine Profile ID
/// </summary>
/// <returns></returns>
public String GenerateMarineProfileNo()
{
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
// var iSeqno = objEntities.usp_GetNextMarineProfileId(param1);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
String ProfileNo = NextSeqNo.ToString().PadLeft(6, '0');
return(ProfileNo);
}
public ManualAllocation SaveManualAllocation(ManualAllocation objAllocationModel)
{
try
{
using (AVOAIALifeEntities Context = new AVOAIALifeEntities())
{
foreach (var Item in objAllocationModel.objLstAllocationProposals.Where(a => a.ISSelected == true).ToList())
{
if (!string.IsNullOrEmpty(Item.AssignTo))
{
DateTime Date = DateTime.Now;
var policy = Context.tblPolicies.Where(a => a.ProposalNo == Item.ProposalNo).FirstOrDefault();
if (policy != null)
{
decimal PolicyID = policy.PolicyID;
var PolicyAllocation = Context.tblPolicyUWAllocations.Where(a => a.PolicyID == PolicyID).FirstOrDefault();
if (PolicyAllocation != null)
{
PolicyAllocation.AllocatedFrom = PolicyAllocation.AllocatedTo;
PolicyAllocation.AllocatedTo = Item.AssignTo.ToUpper();
PolicyAllocation.AllocatedDate = Date;
policy.IsAllocated = true;
policy.ModifiedDate = Date;
}
else
{
tblPolicyUWAllocation objPolicyUWAllocation = new tblPolicyUWAllocation();
objPolicyUWAllocation.PolicyID = PolicyID;
objPolicyUWAllocation.AllocatedFrom = string.Empty;
objPolicyUWAllocation.AllocatedTo = Item.AssignTo;
objPolicyUWAllocation.AllocatedDate = Date;
objPolicyUWAllocation.Remarks = string.Empty;
objPolicyUWAllocation.CreatedDate = Date;
Context.tblPolicyUWAllocations.Add(objPolicyUWAllocation);
policy.IsAllocated = true;
policy.ModifiedDate = Date;
}
}
Context.SaveChanges();
}
}
}
objAllocationModel.Message = "Success";
}
catch (Exception ex)
{
log4net.GlobalContext.Properties["ErrorCode"] = Codes.GetErrorCode();
Logger.Error(ex);
objAllocationModel.Message = "Error";
}
return(objAllocationModel);
}
public static string GetUserName(Guid?userID)
{
string userName = "";
if (userID.HasValue)
{
AVOAIALifeEntities entities = new AVOAIALifeEntities();
userName = entities.tblUserDetails.Where(a => a.UserID == userID).FirstOrDefault().LoginID;
}
return(userName);
}
/// <summary>
/// It Generates Unique UserId or Sub UserId based on IMD code
/// </summary>
/// <param name="AgentCode">Intermediary Code</param>
/// <returns>UserId or SubUser Id</returns>
public String GenerateUserID(string AgentCode)
{
//AgentCode = "User1234";
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
ObjectParameter param1 = new ObjectParameter("NextNo", SqlDbType.Int);
// System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
var iSeqno = objEntities.usp_GetNextUserId(param1, AgentCode);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
String UserID = AgentCode + "_" + NextSeqNo.ToString().PadLeft(3, '0');
return(UserID);
}
public string AUthenticateImo(User user)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
#region Log Input
tbllogxml objlogxml = new tbllogxml();
objlogxml.Description = "Imo Login Request";
objlogxml.PolicyID = user.userName;
objlogxml.XMlData = Newtonsoft.Json.JsonConvert.SerializeObject(user);
objlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(objlogxml);
Context.SaveChanges();
#endregion
Error error = AuthenticateSams(user);
#region Log output
tbllogxml outlogxml = new tbllogxml();
outlogxml.Description = "Imo Login Response";
outlogxml.PolicyID = user.userName;
outlogxml.XMlData = Newtonsoft.Json.JsonConvert.SerializeObject(error);
outlogxml.CreatedDate = DateTime.Now;
Context.tbllogxmls.Add(outlogxml);
Context.SaveChanges();
#endregion
if (error != null)
{
switch (error.errorCode)
{
case "200":
return("Success");
case "401":
return("Invalid username or password. Please enter correct credentials");
case "402":
return("Invalid username or password. Your account will be locked next time");
case "403":
return("Your iMO account is locked. Please reset the password from iMO and try again");
case "405":
return("Invalid user account. Please contact the IT HelpDesk");
default:
return("Invalid username or password. Please enter correct credentials");
}
}
else
{
return("Invalid username or password. Please enter correct credentials");
}
}
public PaymentModel FetchPendingPayments(PaymentModel objPaymentModel)
{
try
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
var pendingReceipts = Context.usp_FetchPendingPaymentProposal().ToList();
foreach (var item in pendingReceipts)
{
PaymentModel paymentModel = new PaymentModel();
paymentModel.QuoteNo = item;
paymentModel.lstPaymentItems = (from objpolicy in Context.tblPolicies.Where(a => a.QuoteNo == paymentModel.QuoteNo)
join objtblpolicyrelationship in Context.tblPolicyRelationships on objpolicy.PolicyID equals objtblpolicyrelationship.PolicyID
join objtblpolicyclients in Context.tblPolicyClients on objtblpolicyrelationship.PolicyClientID equals objtblpolicyclients.PolicyClientID
join objProposalPayments in Context.tblProposalPremiums on objpolicy.PolicyID equals objProposalPayments.PolicyID
join objProduct in Context.tblProducts on objpolicy.ProductID equals objProduct.ProductId
//where objpolicy.PolicyStageStatusID == 1153 && objpolicy.QuoteNo == objPaymentModel.QuoteNo // Payment Pending
select new PaymentItems
{
ProposalNo = objpolicy.ProposalNo,
InsuredName = objtblpolicyclients.FirstName,
PlanName = objProduct.ProductName,
PolicyId = objpolicy.PolicyID,
PolicyTerm = objpolicy.PolicyTerm,
IssueDate = objpolicy.CreatedDate,
Premium = objpolicy.PolicyStageStatusID == 2376 ? objProposalPayments.AdditionalPremium : objProposalPayments.AnnualPremium,
CustomerMobile = objtblpolicyclients.MobileNo,
PreferredLanguage = objpolicy.PreferredLanguage,
Salutation = objtblpolicyclients.Title,
PolicyStartDate = objpolicy.PolicyStartDate,
ProductID = objProduct.ProductId,
PolicyEndDate = objpolicy.PolicyEndDate,
Email = objtblpolicyclients.EmailID,
PrefferedMode = objpolicy.PaymentFrequency,
PlanId = objpolicy.PlanID,
Mobile = objtblpolicyclients.MobileNo,
QuoteNo = objpolicy.QuoteNo,
ProductCode = objProduct.ProductCode,
PlanCode = Context.tblMasProductPlans.Where(pp => pp.PlanId == objpolicy.PlanID).FirstOrDefault().PlanCode,
IsAfc = objpolicy.IsAfc,
UserName = Context.tblUserDetails.Where(a => a.UserID.ToString() == objpolicy.Createdby).Select(a => a.LoginID).FirstOrDefault()
}).OrderByDescending(a => a.PolicyId).ToList();
objPaymentModel.lstPaymentItems.AddRange(paymentModel.lstPaymentItems);
}
return(objPaymentModel);
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateILStatusLog(ILStatus iLStatus)
{
using (AVOAIALifeEntities context = new AVOAIALifeEntities())
{
tblLogILUpdate logILUpdate = new tblLogILUpdate();
logILUpdate.CreatedDate = DateTime.Now;
logILUpdate.ProposalNo = iLStatus.ProposalNo;
logILUpdate.ServiceName = iLStatus.ServiceName;
logILUpdate.ServiceStatus = iLStatus.ServiceStatus;
logILUpdate.UpdatedDate = DateTime.Now;
context.tblLogILUpdates.Add(logILUpdate);
context.SaveChanges();
}
}
public static void CreateServiceLog(TpServiceLog tpServiceLog)
{
using (AVOAIALifeEntities context = new AVOAIALifeEntities())
{
tblLogTPService logTPService = new tblLogTPService();
logTPService.CreatedDate = DateTime.Now;
logTPService.ServiceRequest = tpServiceLog.ServiceRequest;
logTPService.ServiceTraceID = tpServiceLog.ServiceTraceID;
logTPService.UpdatedDate = DateTime.Now;
logTPService.ServiceResponse = tpServiceLog.ServiceResponse;
context.tblLogTPServices.Add(logTPService);
context.SaveChanges();
}
}
public AllocationModel ResetAllocation(AllocationModel objAllocationModel)
{
try
{
using (AVOAIALifeEntities Context = new AVOAIALifeEntities())
{
List <string> UWNames = objAllocationModel.objUWdetails.Where(a => a.IsChecked == true).Select(a => a.UWName).ToList();
if (UWNames != null)
{
string UserInfo = string.Empty;
#region Coma Seperated User Ids
int Count = 0;
foreach (string Userid in Context.AspNetUsers.Where(a => UWNames.Contains(a.UserName)).Select(a => a.Id).ToList())
{
if (Count == 0)
{
UserInfo = Userid;
}
else
{
UserInfo = "," + Userid;
}
Count++;
}
#endregion
var idParam = new SqlParameter
{
ParameterName = "UserId",
Value = UserInfo
};
var Result = Context.Database.SqlQuery <string>(
"exec usp_UnAllocateProposals @UserId ", idParam).FirstOrDefault();
}
}
objAllocationModel.Message = "Success";
}
catch (Exception ex)
{
log4net.GlobalContext.Properties["ErrorCode"] = Codes.GetErrorCode();
Logger.Error(ex);
objAllocationModel.Message = "Error";
}
return(objAllocationModel);
}
public String GeneratePGTransactionNO()
{
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
string strProposalNo = string.Empty;
strProposalNo = DateTime.Today.Day.ToString().PadLeft(2, '0') + DateTime.Today.Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString().Substring(2, 2);
System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
//var iSeqno = objEntities.usp_getNextProposalNo(strProposalNo, param1);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
string ProposalNo = "PGT" + strProposalNo + NextSeqNo.ToString().PadLeft(5, '0'); //DateTime.Now.ToString("ddMMyyHHmmss");
return(ProposalNo);
}
public void LeadDocumentUpload(HttpPostedFileBase file, string FileName = null, string DepartmentCode = null, string AgentCode = null, string ContactID = null, string DocumentCode = null, string strUser = null)
{
try
{
if (file != null)
{
//BinaryReader reader = new BinaryReader(new FileStream(FileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite));
AVOAIALifeEntities Context = new AVOAIALifeEntities();
string UserName = User.Identity.Name;
AgentCode = Context.tblMasIMOUsers.Where(a => a.UserID == UserName).Select(a => a.AgentCode).FirstOrDefault();
//if (ProposalNo == "")
//{
// ProposalNo = "PBBBQ100023";
//}
DepartmentCode = "Document";
string directryPath = ConfigurationManager.AppSettings["FileUpload"] + "\\" + DepartmentCode + "\\" + AgentCode + "\\" + ContactID;
if (!Directory.Exists(directryPath))
{
Directory.CreateDirectory(directryPath);
}
var fileName = Path.GetFileName(file.FileName);
var ext = Path.GetExtension(file.FileName);
if (FileName != null)
{
fileName = DocumentCode + "" + ext;
var filename = Path.Combine(directryPath, fileName);
file.SaveAs(filename);
System.IO.File.Copy(filename, ConfigurationManager.AppSettings["FileUpload"] + "\\" + fileName);
}
else
{
fileName = Path.GetFileName(file.FileName);
var filename = Path.Combine(directryPath, fileName);
file.SaveAs(filename);
}
}
}
catch (Exception ex)
{
ViewBag.ExceptionMessage = "Internal Error Occurred in the system : Please contact Administrator.";
}
}
public AllocationModel LoadAllocationDetails(AllocationModel objAllocationModel)
{
try
{
using (AVOAIALifeEntities Context = new AVOAIALifeEntities())
{
string RoleID = Context.AspNetRoles.Where(a => a.Name == "UW User").FirstOrDefault().Id;
var idParam = new SqlParameter
{
ParameterName = "@RoleId",
Value = RoleID
};
List <string> UserIDs = Context.Database.SqlQuery <string>(
"exec GetUsersByRoleId @RoleId", idParam).ToList();
if (UserIDs != null)
{
objAllocationModel.objUWdetails = (from aspnetusers in Context.AspNetUsers.Where(a => UserIDs.Contains(a.Id))
join userdetails in Context.tblUserDetails
on aspnetusers.UserName equals userdetails.LoginID
select new UWDetails
{
UWName = aspnetusers.UserName,
ID = aspnetusers.Id,
Availabiliy = false
}).ToList();
}
objAllocationModel.objChannelDetails = (from objchannel in Context.tblmasChannels
select new ChannelDetails
{
ChannelName = objchannel.ChannelName,
ChannelId = objchannel.ChannelID,
Availabiliy = false
}).ToList();
objAllocationModel.Message = "Success";
return(objAllocationModel);
}
}
catch (Exception ex)
{
log4net.GlobalContext.Properties["ErrorCode"] = Codes.GetErrorCode();
Logger.Error(ex);
objAllocationModel.Message = "Error";
return(objAllocationModel);
}
}
public PaymentModel CheckPaymentStatusUpdate(PaymentModel objPaymentModel)
{
try
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
tblPolicy policy = Context.tblPolicies.Where(a => a.QuoteNo == objPaymentModel.QuoteNo).FirstOrDefault();
if (policy != null)
{
objPaymentModel = AckPaymentandProcess(Context, objPaymentModel, policy);
}
return(objPaymentModel);
}
catch (Exception ex)
{
throw ex;
}
}
public string GenerateQuoteNo(string BranchCode, string Version)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
ObjectParameter nextNo = new ObjectParameter("NextNo", SqlDbType.Int);
Context.usp_GetNextQuoteNumber("QuoteNo", nextNo);
Int64 seqNo = Convert.ToInt64(nextNo.Value);
string value = seqNo.ToString("D7");
DateTime CurrentDate = DateTime.Now;
string GetYear = CurrentDate.Year.ToString();
GetYear = GetYear.Substring(GetYear.Length - 2);
// string QuoteNo = "QL-" + BranchCode + "-" + GetYear + "-" + value+"-"+ Version;
string QuoteNo = "Q" + BranchCode + GetYear + value + "-" + Version;
return(QuoteNo);
}
//public static Guid GetUserId()
//{
// if (HttpContext.Current != null && HttpContext.Current.User.Identity.IsAuthenticated && LoginUser.GetUserName() != "")
// {
// FutureGeneraliEntities entities = new FutureGeneraliEntities();
// string UserName = LoginUser.GetUserName();
// var user = entities.tblUserDetails.FirstOrDefault(a => a.LoginID == UserName);
// if (user == null)
// {
// return new Guid();
// }
// return new Guid(user.UserID.ToString());
// }
// else
// {
// return new Guid();
// }
//}
//obul added below code at 20-09-2013 for External Service.
public static Guid GetCurrentUserId(string userName)
{
if (!string.IsNullOrEmpty(userName))
{
AVOAIALifeEntities entities = new AVOAIALifeEntities();
var user = entities.Users.FirstOrDefault(a => a.UserName == userName);
if (user == null)
{
return(new Guid());
}
return(user.UserId);
}
else
{
return(new Guid());
}
}
public PaymentModel SavePGTransaction(PaymentModel objPaymentModel)
{
try
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
tblPolicy objtblpolicy = new tblPolicy();
objtblpolicy = Context.tblPolicies.Where(a => a.ProposalNo == objPaymentModel.ProposalNo).FirstOrDefault();
if (objtblpolicy != null)
{
tblPolicyPaymentMap policyPaymentMap = new tblPolicyPaymentMap();
policyPaymentMap.CreatedDate = DateTime.Now;
tblPayment payment = new tblPayment();
payment.CreatedDate = DateTime.Now;
payment.TxnNo = objPaymentModel.TransactionNo;
payment.PaidAmount = Convert.ToDecimal(objPaymentModel.PayableAmount);
payment.ChequeSubmission = false;
payment.ReceiptNo = "NOTACK";
payment.PayerType = objPaymentModel.ReqId;
if (payment.PaymentID == decimal.Zero)
{
Context.tblPayments.Add(payment);
}
policyPaymentMap.Premium = objtblpolicy.tblProposalPremiums.FirstOrDefault().AnnualPremium;
policyPaymentMap.PaidAmount = 0;
policyPaymentMap.PendingAmount = policyPaymentMap.Premium - policyPaymentMap.PaidAmount;
policyPaymentMap.tblPayment = payment;
policyPaymentMap.tblPolicy = objtblpolicy;
if (policyPaymentMap.PolicyPaymentMapID == decimal.Zero)
{
Context.tblPolicyPaymentMaps.Add(policyPaymentMap);
}
}
Context.SaveChanges();
return(objPaymentModel);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult RedirectAvo()
{
string msg = Request["Msg"];
string userName = "";
string token = string.Empty;
string key = "ho01otrf77155gxsdfcbhhg1671bhgghh1";
if (!string.IsNullOrEmpty(msg))
{
var sp = msg.Split('|');
userName = sp[0];
token = sp[1];
}
SHA1Managed sha1 = new SHA1Managed();
byte[] hash = sha1.ComputeHash(Encoding.UTF8.GetBytes(userName + "|" + key));
StringBuilder sb = new StringBuilder(hash.Length * 2);
foreach (byte b in hash)
{
sb.Append(b.ToString("x2"));
}
string res = sb.ToString();
AVOAIALifeEntities entities = new AVOAIALifeEntities();
bool userStatus = entities.tblUserDetails.Where(a => a.LoginID == userName).Select(a => a.Status).FirstOrDefault() ?? false;
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
if (res == token && userStatus)
{
var result = SignInManager.PasswordSignIn(userName, "Pass@123", false, shouldLockout: false);
if (result == SignInStatus.Success)
{
return(RedirectToLocal("Home/Index"));
}
else
{
return(View("~/Views/Home/UnAuthorized.cshtml"));
}
}
else
{
return(View("~/Views/Home/UnAuthorized.cshtml"));
}
}
public void DownloadUploadedfile(string FileName)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
DocumentDetails objDocumentDetails = new DocumentDetails();
tblProspect objtblProspect = null;
var directorypath = System.Web.HttpContext.Current.Server.MapPath("Upload");
var PolicyFileName = Path.Combine(directorypath, Path.GetFileName(FileName));
string result = PolicyFileName;
string Filecontenttype = Context.tblProspectDocuments.Where(a => a.ProspectID == objtblProspect.ProspectID).FirstOrDefault().DocType;
objDocumentDetails.FileContent = Encoding.ASCII.GetBytes(Context.tblProspectDocuments.Where(a => a.ProspectID == objtblProspect.ProspectID).FirstOrDefault().DocPath);
System.Web.HttpContext.Current.Response.ContentType = Filecontenttype;
System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(PolicyFileName));
System.Web.HttpContext.Current.Response.Charset = "";
System.Web.HttpContext.Current.Response.OutputStream.Write(objDocumentDetails.FileContent, 0, objDocumentDetails.FileContent.Length);
System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.Close();
}
public void SMSReminder()
{
AIA.Life.Models.Opportunity.SMSReminder objSMSReminder = new Life.Models.Opportunity.SMSReminder();
AIA.Life.Business.Quote.QuoteBusiness objQuoteBusiness = new AIA.Life.Business.Quote.QuoteBusiness();
AVOAIALifeEntities Context = new AVOAIALifeEntities();
var objLst = Context.Usp_GetOutStandingDocList().ToList();
var NoOfDays = 0;
var PolicyID = "";
foreach (var item in objLst)
{
objSMSReminder.NoOfDays = Convert.ToInt32(item.NoOfDays);
objSMSReminder.PolicyID = Convert.ToString(item.PolicyId);
//}
//if (objLst.Count>0)
//{
objQuoteBusiness.SMSReminder(objSMSReminder);
}
}
public String GenerateIRNo(string branchCode, string Date, string AgencyCode = null)
{
AVOAIALifeEntities objEntities = new AVOAIALifeEntities();
System.Data.Objects.ObjectParameter param1 = new System.Data.Objects.ObjectParameter("NextNo", SqlDbType.Int);
//var iSeqno = objEntities.usp_GetNextIRNumber("IRNo", param1);
Int32 NextSeqNo = Convert.ToInt32(param1.Value);
String IRNumber = null;
if (AgencyCode == null)
{
IRNumber = branchCode + "-" + "SGN" + "-" + Date + "-" + NextSeqNo.ToString().PadLeft(6, '0');
}
else
{
IRNumber = branchCode + "-" + AgencyCode + "-" + Date + "-" + NextSeqNo.ToString().PadLeft(6, '0');
}
return(IRNumber);
}
public static object BizDate(object obj)
{
if (_enableIL)
{
AVOAIALifeEntities Context = new AVOAIALifeEntities();
var accMonth = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTMN").FirstOrDefault();
var accYear = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTYR").FirstOrDefault();
accMonth.FieldValue = (DateTime.Now.Month).ToString().PadLeft(2, '0');
accYear.FieldValue = DateTime.Now.Year.ToString();
Context.SaveChanges();
string responseText = integrator.GeneratePlainText(obj, "BIZDateRequest", "BIZDateResponse");
if (responseText != null && responseText.ToUpper().Contains("ACCT PERD OUTSIDE RANGE"))
{
var accMonth2 = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTMN").FirstOrDefault();
var accYear2 = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTYR").FirstOrDefault();
accMonth2.FieldValue = (DateTime.Now.Month - 1).ToString().PadLeft(2, '0');
accYear2.FieldValue = DateTime.Now.Year.ToString();
Context.SaveChanges();
string responseText1 = integrator.GeneratePlainText(obj, "BIZDateRequest", "BIZDateResponse");
if (responseText != null && responseText1.ToUpper().Contains("ACCT PERD OUTSIDE RANGE"))
{
var accMonth1 = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTMN").FirstOrDefault();
var accYear1 = Context.tblILIntegrations.Where(a => a.ColumnName == "ACCTYR").FirstOrDefault();
accMonth1.FieldValue = (DateTime.Now.Month - 1).ToString().PadLeft(2, '0');
accYear1.FieldValue = (DateTime.Now.Year - 1).ToString();
Context.SaveChanges();
string responseText2 = integrator.GeneratePlainText(obj, "BIZDateRequest", "BIZDateResponse");
obj = integrator.ReadResponseString(responseText2, obj, "BIZDateResponse");
}
else
{
obj = integrator.ReadResponseString(responseText1, obj, "BIZDateResponse");
}
}
else
{
obj = integrator.ReadResponseString(responseText, obj, "BIZDateResponse");
}
}
return(obj);
}
public string GetUserName(string UserID)
{
string UserName = string.Empty;
if (!string.IsNullOrEmpty(UserID))
{
try
{
using (AVOAIALifeEntities Context = new AVOAIALifeEntities())
{
UserName = Context.AspNetUsers.Where(a => a.Id == UserID).FirstOrDefault().UserName;
}
}
catch (Exception ex)
{
log4net.GlobalContext.Properties["ErrorCode"] = Codes.GetErrorCode();
Logger.Error(ex);
}
}
return(UserName);
}
