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);
}
}