public bool LoggedOffUser(string ActivationCode, bool IsLoggedIn) { using (AIMFinServDBEntities db = new AIMFinServDBEntities()) { string activationcode = ActivationCode.ToString(); var getuserdetails = db.tblUsers.Where(p => p.ActivaitonCode == activationcode && p.IsLoggedIn == true).FirstOrDefault(); if (getuserdetails != null) { getuserdetails.IsLoggedIn = false; getuserdetails.ActivaitonCode = string.Empty; db.SaveChanges(); } return(true); } }
private string LoggedInUser(string UserEmailId, string password) { using (AIMFinServDBEntities db = new AIMFinServDBEntities()) { string strActcode = string.Empty; var getusrdetails = db.tblUsers.Where(p => p.Email.ToLower() == UserEmailId.ToLower() && p.Password.ToLower() == password.ToLower()).FirstOrDefault(); if (getusrdetails != null) { getusrdetails.IsLoggedIn = true; getusrdetails.LastLoggedOn = DateTime.Now; strActcode = Guid.NewGuid().ToString().Substring(0, 7); getusrdetails.ActivaitonCode = strActcode; db.SaveChanges(); } return(strActcode); } }
public bool AddLoanMasterDetails(LoanMasterDetails _objLoanMasterDetails) { try { using (AIMFinServDBEntities db = new AIMFinServDBEntities()) { if (_objLoanMasterDetails != null) { Guid LoanAppnoGuid = db.tblLoanApplicationForms.Single(x => x.AutoID == _objLoanMasterDetails.AutoID).LoanApplicationNo; tblLoanMaster _tblLoanMaster = new tblLoanMaster(); _tblLoanMaster.LANNumber = Guid.NewGuid(); _tblLoanMaster.LoanApplicationNo = LoanAppnoGuid; _tblLoanMaster.PropertyTypeID = _objLoanMasterDetails.PropertyTypeID; _tblLoanMaster.StatusID = _objLoanMasterDetails.StatusID; _tblLoanMaster.LoanTypeID = _objLoanMasterDetails.LoanTypeID; _tblLoanMaster.ClientID = _objLoanMasterDetails.ClientID; _tblLoanMaster.ROIOffered = _objLoanMasterDetails.ROIOffered; _tblLoanMaster.LoanTermOffered = _objLoanMasterDetails.LoanTermOffered; _tblLoanMaster.RateTypeOffered = _objLoanMasterDetails.RateTypeOffered; _tblLoanMaster.FrequencyOffered = _objLoanMasterDetails.FrequencyOffered; _tblLoanMaster.LoanValueRatio = _objLoanMasterDetails.LoanValueRatio; _tblLoanMaster.LoanAmountOffered = _objLoanMasterDetails.LoanAmountOffered; _tblLoanMaster.EMIStartDay = _objLoanMasterDetails.EMIStartDay; _tblLoanMaster.EMIStartMonth = _objLoanMasterDetails.EMIStartMonth; _tblLoanMaster.LoanProcessingFee = _objLoanMasterDetails.LoanProcessingFee; _tblLoanMaster.AnyLegalCharges = _objLoanMasterDetails.AnyLegalCharges; _tblLoanMaster.NoOfEMI = _objLoanMasterDetails.NoOfEMI; _tblLoanMaster.Loanprovider = _objLoanMasterDetails.Loanprovider; _tblLoanMaster.PropertyCost = _objLoanMasterDetails.PropertyCost; _tblLoanMaster.FinanceDate = _objLoanMasterDetails.FinanceDate; _tblLoanMaster.SettlementDate = _objLoanMasterDetails.SettlementDate; _tblLoanMaster.CreatedOn = DateTime.Now; db.tblLoanMasters.Add(_tblLoanMaster); db.SaveChanges(); } return(true); } } catch (Exception ex) { return(false); } }
public bool UpdateLoanMasterDetails(LoanMasterDetails _objLoanMasterDetails) { try { using (AIMFinServDBEntities db = new AIMFinServDBEntities()) { var FetchLoanMasterDetails = db.tblLoanMasters.Where(p => p.LANNumber == _objLoanMasterDetails.LANNumber).FirstOrDefault(); if (FetchLoanMasterDetails != null) { FetchLoanMasterDetails.LoanApplicationNo = _objLoanMasterDetails.LoanApplicationNo; FetchLoanMasterDetails.LANNumber = _objLoanMasterDetails.LANNumber; FetchLoanMasterDetails.ROIOffered = _objLoanMasterDetails.ROIOffered; FetchLoanMasterDetails.AutoID = _objLoanMasterDetails.AutoID; FetchLoanMasterDetails.LoanTermOffered = _objLoanMasterDetails.LoanTermOffered; FetchLoanMasterDetails.RateTypeOffered = _objLoanMasterDetails.RateTypeOffered; FetchLoanMasterDetails.FrequencyOffered = _objLoanMasterDetails.FrequencyOffered; FetchLoanMasterDetails.LoanValueRatio = _objLoanMasterDetails.LoanValueRatio; FetchLoanMasterDetails.LoanAmountOffered = _objLoanMasterDetails.LoanAmountOffered; FetchLoanMasterDetails.ClientID = _objLoanMasterDetails.ClientID; FetchLoanMasterDetails.EMIStartDay = _objLoanMasterDetails.EMIStartDay; FetchLoanMasterDetails.EMIStartMonth = _objLoanMasterDetails.EMIStartMonth; FetchLoanMasterDetails.LoanProcessingFee = _objLoanMasterDetails.LoanProcessingFee; FetchLoanMasterDetails.AnyLegalCharges = _objLoanMasterDetails.AnyLegalCharges; FetchLoanMasterDetails.NoOfEMI = _objLoanMasterDetails.NoOfEMI; FetchLoanMasterDetails.Loanprovider = _objLoanMasterDetails.Loanprovider; FetchLoanMasterDetails.PropertyCost = _objLoanMasterDetails.PropertyCost; FetchLoanMasterDetails.FinanceDate = _objLoanMasterDetails.FinanceDate; FetchLoanMasterDetails.SettlementDate = _objLoanMasterDetails.SettlementDate; FetchLoanMasterDetails.PropertyTypeID = _objLoanMasterDetails._propertyTypeDetails.ID; FetchLoanMasterDetails.StatusID = _objLoanMasterDetails._typeOfStatusDetails.ID; FetchLoanMasterDetails.LoanTypeID = _objLoanMasterDetails._typeOfLoanDetails.ID; FetchLoanMasterDetails.ModifiedOn = DateTime.Now; db.SaveChanges(); } return(true); } } catch (Exception ex) { return(false); } }