/// <summary> /// This Method use to get list and details of complaints submitted by users. /// </summary> /// <param name="cardholderId">Id of logged in user</param> /// <param name="SkipCount">The skip count.</param> /// <param name="PageSize">Size of the page.</param> /// <param name="RecordCount">The record count.</param> /// <returns>List of complaints</returns> /// <remarks></remarks> public List <CH_Complaint_DtlDTO> getComplaintsDetails(long cardholderId, int SkipCount, int PageSize, ref int RecordCount) { // RecodeCount = repCH_Complaint_Dtl.GetAll().Count(); IRepository <CH_ComplaintType_Mst> cht = ObjectFactory.GetInstance <IRepository <CH_ComplaintType_Mst> >(); List <CH_Complaint_DtlDTO> lst = new List <CH_Complaint_DtlDTO>(); CardHolderManager chm = new CardHolderManager(); lst = (from x in repCH_Complaint_Dtl.GetAll() join y in chm.repCardHolder_Mst.GetQuery() on x.CardHolder_Id equals y.CardHolder_Id join a in cht.GetAll() on x.ComplaintType_Id equals a.ComplaintType_Id where cardholderId == y.CardHolder_Id select new CH_Complaint_DtlDTO() { Complaint_Dtl_Id = x.Complaint_Dtl_Id, Complaint_Dt = x.Complaint_Dt, CardHolder_Id = x.CardHolder_Id, ComplaintType_Id = x.ComplaintType_Id, ComplaintType = a.ComplaintType_nm, Remarks = x.Remarks, Complaint_Status = x.Complaint_Status, UID = x.UID, AdminRemarks = x.AdminRemarks }).OrderByDescending(t => t.Complaint_Dt).ToList(); RecordCount = lst.Count(); lst = lst.Skip(SkipCount).Take(PageSize).ToList(); return(lst); }
/// <summary> /// Updates the card holder payment status. /// </summary> /// <param name="transaction_number">The transaction_number.</param> /// <param name="accountNumber">The account number.</param> /// <param name="amountDue">The amount due.</param> /// <param name="TxnRefrenceNo">The TXN refrence no.</param> /// <returns></returns> /// <remarks></remarks> public string UpdateCardHolderPaymentStatus(string transaction_number, string BillDeskOnlineID, double amountDue, string TxnRefrenceNo, string paymentStatus, string BankRefNo, string BankId, string AuthStatus) // Add BillDeskOnlineID instead of Accnum 20-jan-2015 { //commented by abhijeet on 21/08/2019 //string Transaction_number = ""; //CH_PaymentStatus_Dtl obj = repCardHolderPaymentStatus.SingleOrDefault(c => c.BillDeskOnlineID == BillDeskOnlineID // && c.Transaction_number == transaction_number // && c.AmountDue == amountDue && c.PaymentStatus.Trim().ToLower() == "unsuccessful"); //if (obj != null) //{ // obj.PaymentStatus = paymentStatus; // obj.TxnReferenceNo = TxnRefrenceNo; // obj.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id; // obj.Updated_dt = DateTime.Now; // obj.BankRefNo = BankRefNo; // obj.BankId = BankId; // obj.AuthStatus = AuthStatus; // GeneralManager.Commit(); // Transaction_number = obj.Transaction_number; //} //return Transaction_number; //Added by abhijeet on 21/08/2019 BOBCardEntities _db = new BOBCardEntities(); _db.UpdatePaymentStatus_Dtl(BillDeskOnlineID, transaction_number, amountDue, paymentStatus, TxnRefrenceNo, CardHolderManager.GetLoggedInUser().CardHolder_Id, DateTime.Now, BankRefNo, BankId, AuthStatus); return(transaction_number); }
/// <summary> /// Authenticates the user. /// </summary> /// <param name="Username">The username.</param> /// <param name="PublicIP">The public IP.</param> /// <returns></returns> /// <remarks></remarks> public CardHolder_MstDTO AuthenticateUser(string Username, string PublicIP = "") { //var users = repCardHolder_Mst.Find(u => u.User_nm == Username).Select(u => new CardHolder_MstDTO() //{ // CardHolder_Id = u.CardHolder_Id, // User_nm = u.User_nm, // User_pwd = u.User_pwd, // Created_dt = u.Created_dt, // Updated_dt = u.Updated_dt, // IP_Address = u.IP_Address, // Personal_Msg = u.Personal_Msg, // IsActive = u.IsActive, // IsPermanentDisable = u.IsPermanentDisable, // //IsLoggedInCurrently = u.IsLoggedInCurrently, // Oracle_Customer_Id = u.Oracle_Customer_Id, // credit_card_number = u.credit_card_number, // creditcard_acc_number = u.creditcard_acc_number, // CurrentLoginDate = u.CurrentLoginDate, // LastLoginDate = u.LastLoginDate, // LocalIP_Address = u.Local_IpAddress //}).ToList(); var Objusers = new CardHolder_MstDTO(); //if (users.Count < 2) // Objusers = users.SingleOrDefault(); //else // Objusers = users.First(); if (true) //Objusers != null { //var obj = repCardHolder_Mst.SingleOrDefault(c => c.User_nm == Username && c.IsActive == true && c.IsPermanentDisable == false); CardHolderManager _objManager = new CardHolderManager(); var obj = _objManager.FindActiveUser(Username); //var obj = repCardHolder_Mst.Find .SingleOrDefault(c => c.User_nm == Username && c.IsActive == true && c.IsPermanentDisable == false); if (obj != null) { Objusers = obj; //if (obj.CurrentLoginDate.HasValue) //{ // obj.LastLoginDate = obj.CurrentLoginDate; //} //obj.CurrentLoginDate = DateTime.Now; //IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork); //if (localAddress != null) // obj.LocalIP_Address = Convert.ToString(localAddress); //if (PublicIP != "") // Objusers.IP_Address = PublicIP; //GeneralManager.Commit(); } } return(Objusers); }
/// <summary> /// This method is used for getting card details for Auto Debit Payment Type /// </summary> /// <param name="cDto">cDto</param> /// <returns>CH_CardDTO</returns> public long GetRequestTypeId(string requestTypeName) { IQueryable <CH_RequestType_Mst> repCH_RequestType_Dtl = ObjectFactory.GetInstance <IRepository <CH_RequestType_Mst> >().GetQuery(); /// Step 1 Join CH Requests And CH CardHolderManager chm = new CardHolderManager(); var requestTypeId = (from a in repCH_RequestType_Dtl where a.RequestType_nm == requestTypeName select a).FirstOrDefault(); return(requestTypeId.RequestType_Id); }
/// <summary> /// Updates the card holder payment status bobibanking. /// </summary> /// <param name="prn">The PRN.</param> /// <param name="accountNumber">The account number.</param> /// <param name="amountDue">The amount due.</param> /// <param name="bid">The bid.</param> /// <param name="debtAccountNo">The debt account no.</param> /// <returns></returns> /// <remarks></remarks> public string UpdateCardHolderPaymentStatusBobibanking(string prn, string accountNumber, double amountDue, string PID, string bid, string debtAccountNo, string status) { //commented by abhijeet on 21/08/2019 //string Transaction_number = ""; //CH_BobibankingPaymentStatus_Dtl obj = repCardHolderBobibankingPaymentStatus.SingleOrDefault(c => c.Creditcard_acc_number == accountNumber // && c.PRN == prn && c.AmountDue == amountDue && c.PaymentStatus.Trim() == "unsuccessful"); //if (obj != null) //{ // obj.PaymentStatus = status; // obj.BID = bid; // obj.DebtAccountNo = debtAccountNo; // obj.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id; // obj.Updated_dt = DateTime.Now; // GeneralManager.Commit(); // Transaction_number = obj.PRN; //} //return Transaction_number; BOBCardEntities _db = new BOBCardEntities(); _db.Update_BobibankingPaymentStatus_Dtl(accountNumber, prn, amountDue, status, bid, debtAccountNo, DateTime.Now, CardHolderManager.GetLoggedInUser().CardHolder_Id.ToString()); return(prn); }
//public IRepository<CH_Sessions_Dtl> repCHSessionDtl //{ // get // { // return ObjectFactory.GetInstance<IRepository<CH_Sessions_Dtl>>(); // } //} /// <summary> /// Updates the card holder. /// </summary> /// <param name="userDTO">The user DTO.</param> /// <returns></returns> /// <remarks></remarks> public string UpdateCardHolder(CardHolder_MstDTO userDTO) { try { //commented by Avani on 21-08-2019 //IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork); //CardHolder_Mst user = repCardHolder_Mst.SingleOrDefault(u => u.CardHolder_Id == userDTO.CardHolder_Id); //user.User_pwd = userDTO.User_pwd; //user.Local_IpAddress = Convert.ToString(localAddress); //user.Updated_by = CardHolderManager.GetLoggedInUser().CardHolder_Id; //user.Updated_dt = DateTime.Now; //GeneralManager.Commit(); //return "0"; /***/ // Added by Avani on 21-08-2019 BOBCardEntities _db = new BOBCardEntities(); IPAddress localAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList.FirstOrDefault(ip => ip.AddressFamily == AddressFamily.InterNetwork); _db.UpdateCardHolderPasswordDetail(userDTO.CardHolder_Id, userDTO.User_pwd, localAddress.ToString(), CardHolderManager.GetLoggedInUser().CardHolder_Id, DateTime.Now); return("0"); } catch (Exception exp) { return(Constants.GeneralErrorMessage); } }