public UserDetailsVm Login(LoginDetails loginDetails)
{
UserDetail userDetails = new UserDetail();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
userDetails = db.UserDetails.Where(x => x.UserName.Equals(loginDetails.UserName, StringComparison.OrdinalIgnoreCase) && x.Password == loginDetails.Password).FirstOrDefault();
}
UserDetailsVm userDetailsVm = new UserDetailsVm();
if (userDetails != null)
{
userDetailsVm = new UserDetailsVm()
{
Id = userDetails.Id,
UserName = userDetails.UserName,
Password = string.Empty,
RoleType = userDetails.RoleType
}
}
;
else
{
userDetailsVm = null;
}
return(userDetailsVm);
}
public bool AddCompany(CompanyDetailsVM model)
{
try
{
CompanyDetail dataModel = new CompanyDetail()
{
CompanyStatus = (int)model.CompanyStatus,
CompanyName = model.CompanyName,
ManagingPartner = model.ManagingPartner,
LaunchedYear = model.LaunchedYear,
Stage = (int)model.Stage,
NumberOfMembers = model.NumberOfMembers,
WebSite = model.WebSite,
Email = model.Email,
Phone = model.Phone,
Country = model.Country,
City = model.City,
Pincode = model.Pincode,
CreatedBy = model.CreatedBy
};
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
db.CompanyDetails.Add(dataModel);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <CompanyDetailsVM> GetAllCompanyDetails()
{
List <CompanyDetail> dbCompanyList = new List <CompanyDetail>();
bool isAdmin = AccountService.IsAdmin();
List <CompanyDetailsVM> companyDetails = new List <CompanyDetailsVM>();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
companyDetails = db.CompanyDetails.Where(x => isAdmin || (!isAdmin && x.CompanyStatus == (int)CompanyStatusEnum.Activate))
.Join(db.StageDetails,
x => x.Stage,
y => y.Id, (cd, sd) => new CompanyDetailsVM {
Id = cd.Id,
CompanyStatus = (CompanyStatusEnum)cd.CompanyStatus,
CompanyName = cd.CompanyName,
ManagingPartner = cd.ManagingPartner,
LaunchedYear = cd.LaunchedYear,
Stage = (CompanyStageEnum)cd.Stage,
NumberOfMembers = cd.NumberOfMembers,
WebSite = cd.WebSite,
Email = cd.Email,
Phone = cd.Phone,
Country = cd.Country,
City = cd.City,
Pincode = cd.Pincode,
CreatedBy = cd.CreatedBy,
StageString = sd.StageInfo
}).ToList();
}
return(companyDetails);
}
public bool UpdateCompany(CompanyDetailsVM model)
{
try
{
CompanyDetail dbCompanyList = new CompanyDetail();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
dbCompanyList = db.CompanyDetails.Where(x => x.Id == model.Id).FirstOrDefault();
if (dbCompanyList != null)
{
dbCompanyList.Id = dbCompanyList.Id;
dbCompanyList.CompanyStatus = (int)dbCompanyList.CompanyStatus;
dbCompanyList.CompanyName = dbCompanyList.CompanyName;
dbCompanyList.ManagingPartner = dbCompanyList.ManagingPartner;
dbCompanyList.LaunchedYear = dbCompanyList.LaunchedYear;
dbCompanyList.Stage = (int)dbCompanyList.Stage;
dbCompanyList.NumberOfMembers = dbCompanyList.NumberOfMembers;
dbCompanyList.WebSite = dbCompanyList.WebSite;
dbCompanyList.Email = dbCompanyList.Email;
dbCompanyList.Phone = dbCompanyList.Phone;
dbCompanyList.Country = dbCompanyList.Country;
dbCompanyList.City = dbCompanyList.City;
dbCompanyList.Pincode = dbCompanyList.Pincode;
db.SaveChanges();
return(true);
}
}
return(false);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeactivateCompany(int id)
{
CompanyDetail dbCompanyList = new CompanyDetail();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
dbCompanyList = db.CompanyDetails.Where(x => x.Id == id).FirstOrDefault();
if (dbCompanyList != null)
{
dbCompanyList.CompanyStatus = (int)CompanyStatusEnum.Deactivate;
db.SaveChanges();
return(true);
}
}
return(false);
}
public static bool Login(string UserName, string Password)
{
UserDetail userDetails = new UserDetail();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
userDetails = db.UserDetails.Where(x => x.UserName.Equals(UserName, StringComparison.OrdinalIgnoreCase) && x.Password == Password).FirstOrDefault();
}
if (userDetails != null)
{
return(true);
}
else
{
return(false);
}
}
public static bool IsAdmin()
{
string userName = Thread.CurrentPrincipal.Identity.Name;
UserDetail userDetails = new UserDetail();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
userDetails = db.UserDetails.Where(x => x.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
}
if (userDetails != null && (RoleTypeEnum)userDetails.RoleType == RoleTypeEnum.Admin)
{
return(true);
}
else
{
return(false);
}
}
public CompanyDetailsVM GetCompanyById(int id)
{
CompanyDetail dbCompanyList = new CompanyDetail();
bool isAdmin = AccountService.IsAdmin();
using (GrowUpIncubatorEntities db = new GrowUpIncubatorEntities())
{
dbCompanyList = db.CompanyDetails.Where(x => x.Id == id && (isAdmin || (!isAdmin && x.CompanyStatus == (int)CompanyStatusEnum.Activate))).FirstOrDefault();
}
CompanyDetailsVM companyDetails = new CompanyDetailsVM();
if (dbCompanyList != null)
{
companyDetails = new CompanyDetailsVM()
{
Id = dbCompanyList.Id,
CompanyStatus = (CompanyStatusEnum)dbCompanyList.CompanyStatus,
CompanyName = dbCompanyList.CompanyName,
ManagingPartner = dbCompanyList.ManagingPartner,
LaunchedYear = dbCompanyList.LaunchedYear,
Stage = (CompanyStageEnum)dbCompanyList.Stage,
NumberOfMembers = dbCompanyList.NumberOfMembers,
WebSite = dbCompanyList.WebSite,
Email = dbCompanyList.Email,
Phone = dbCompanyList.Phone,
Country = dbCompanyList.Country,
City = dbCompanyList.City,
Pincode = dbCompanyList.Pincode,
CreatedBy = dbCompanyList.CreatedBy
};
}
else
{
return(null);
}
return(companyDetails);
}