public CustomerLoginDetail AuthenticateUserAPI(string LoginId, string Password)
{
DatabaseDetail DBDetails = new DatabaseDetail();
CustomerLoginDetail userDetail = new CustomerLoginDetail();
using (var context = new CommonDBContext())
{
userDetail = context.CustomerLoginDetails.Where(a => a.LoginId == LoginId && a.Password == Password).FirstOrDefault();
}
return(userDetail);
}
public CustomerLoginDetail GetUserDetailsByLoginID(string LoginId)
{
CustomerLoginDetail userDetail = new CustomerLoginDetail();
DatabaseDetail DBDetails = new DatabaseDetail();
using (var context = new CommonDBContext())
{
userDetail = context.CustomerLoginDetails.Where(a => a.LoginId == LoginId).FirstOrDefault();
if (userDetail != null)
{
if (userDetail.GroupId != null)
{
DBDetails = context.DatabaseDetails.Where(x => x.GroupId == userDetail.GroupId).FirstOrDefault();
//CustomerConnString.ConnectionStringCustomer = DBDetails.DBName;
userDetail.connectionString = "Data Source = " + DBDetails.IPAddress + "; Initial Catalog = " + DBDetails.DBName + "; user id = " + DBDetails.DBId + "; password = "******"";
}
}
}
return(userDetail);
}
public CustomerLoginDetail AuthenticateUser(LoginModel objLoginModel)
{
DatabaseDetail DBDetails = new DatabaseDetail();
CustomerLoginDetail userDetail = new CustomerLoginDetail();
using (var context = new CommonDBContext())
{
userDetail = context.CustomerLoginDetails.Where(a => a.LoginId == objLoginModel.LoginId && a.Password == objLoginModel.Password && a.UserStatus.Value == true).FirstOrDefault();
if (userDetail != null)
{
if (userDetail.GroupId != null)
{
DBDetails = context.DatabaseDetails.Where(x => x.GroupId == userDetail.GroupId).FirstOrDefault();
//CustomerConnString.ConnectionStringCustomer = DBDetails.DBName;
userDetail.connectionString = "Data Source = " + DBDetails.IPAddress + "; Initial Catalog = " + DBDetails.DBName + "; user id = " + DBDetails.DBId + "; password = "******"";
}
}
}
return(userDetail);
}
public bool Save(string dbname, int websiteid, string websitename, Guid userid, string username)
{
DatabaseDetail dbdetail = new DatabaseDetail();
dbdetail.CreatedBy = username;
dbdetail.CreatedOn = DateTime.Now;
dbdetail.DatabaseName = dbname;
dbdetail.DbForWebsiteId = websiteid;
dbdetail.UpdatedOn = DateTime.Now;
dbdetail.UserId = userid;
dbdetail.Username = username;
dbdetail.WebsiteName = websitename;
try
{
dbContext.DatabaseDetails.InsertOnSubmit(dbdetail);
dbContext.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
