public static Role GetRole(string name)
{
var roles = from e in CH.DB.EmployeeRoles
from r in CH.DB.Roles
where e.AccountName == name && e.RoleID == r.ID
select r;
if (roles.FirstOrDefault() != null)
{
return(roles.FirstOrDefault());
}
else
{
var roleid = GetProfile("RoleLevelID", name).ToString();
int id;
int.TryParse(roleid, out id);
var role = CH.GetDataById <Role>(id);
if (role != null)
{
var emp = new EmployeeRole()
{
RoleID = role.ID, AccountName = name, CreatedDate = DateTime.Now
};
CH.DB.Set <EmployeeRole>().Add(emp);
CH.DB.SaveChanges();
}
return(role);
}
}
public static List <SelectListItem> LeadSelectListByCRMID(int?crmid, int?selectVal = null)
{
if (crmid == null)
{
return(new List <SelectListItem>());
}
int?companyid = CH.GetDataById <CompanyRelationship>(crmid).CompanyID;
//var ls = from l in CH.DB.Leads where l.CompanyID == companyid select new { Text = l.Name_CH + " | " + l.Name_EN, Value = l.ID };
List <SelectListItem> selectList = new List <SelectListItem>();
var leads = from c in CH.DB.Leads where c.CompanyID == companyid select c;
//CH.GetAllData<Lead>().Where(l => l.CompanyID == companyid);
foreach (Lead lead in leads)
{
SelectListItem selectListItem = new SelectListItem {
Text = lead.Name, Value = lead.ID.ToString()
};
if (selectVal.HasValue && lead.ID == selectVal.Value)
{
selectListItem.Selected = true;
}
selectList.Add(selectListItem);
}
return(selectList);
}
public ActionResult DisplayImage(int id)
{
var image = CH.GetDataById <Image>(id);
if (image != null)
{
byte[] imageData = image.ImageData;
if (imageData == null)
{
return(null);
}
return(File(imageData, image.ContentType));
}
return(null);
}
public static IEnumerable <SelectListItem> CompanyLeadsSelectList(int companyid, int?selectVal = null)
{
List <SelectListItem> selectList = new List <SelectListItem>();
//var query = from c in CH.DB.CompanyRelationships.Where(w => w.Project.ID == projectid && w.Company.ID == companyid) select c.Company.Leads;
//var leads = CH.GetAllData<Lead>().Where(l => l.CompanyID == companyid);
var leads = CH.GetDataById <Company>(companyid).Leads;
foreach (Lead lead in leads)
{
SelectListItem selectListItem = new SelectListItem {
Text = lead.Name, Value = lead.ID.ToString()
};
if (selectVal.HasValue && lead.ID == selectVal.Value)
{
selectListItem.Selected = true;
}
selectList.Add(selectListItem);
}
return(selectList);
}