public ActionResult Dashboard()
{
int adminId = Convert.ToInt16(Session["AdminId"]);
DashboardViewModel _model = new Models.DashboardViewModel();
jobServices _ser = new Database.jobServices();
_model = _ser.getAllTodayjobs(adminId);
return(View(_model));
}
// GET: Dashboard
public ActionResult Index()
{
var userId = User.Identity;
var model = new Models.DashboardViewModel
{
usuario = obtenerUsuario(userId.Name)
};
return(View(model));
}
public ActionResult Index()
{
var newModel = new Models.DashboardViewModel()
{
Domains = _exerciseResultService.GetDomains(),
Subjects = _exerciseResultService.GetSubjects(),
};
foreach (var domain in newModel.Domains)
{
domain.Users = _exerciseResultService.GetUsers(domain.Id);
}
return View(newModel);
}
public DashboardViewModel getAllTodayjobs(int adminId)
{
DashboardViewModel _profile = new Models.DashboardViewModel();
List <jobViewItem> _itemList = new List <jobViewItem>();
Global _global = new Database.Global();
CRMClassDataContext _idc = new Database.CRMClassDataContext(_global.con);
try
{
var contacts = _idc.tbllogins.Where(a => a.UserId == adminId).FirstOrDefault();
var contactImage = string.IsNullOrEmpty(contacts.Image) ? "/assets/images/icon/staff.png" : contacts.Image;
var query = from post in _idc.tblJobMasters.Where(a => a.OpenBy == adminId.ToString() && a.CreatedDate.Value.Date == DateTime.Now.Date && a.IsActive == true)
join meta in _idc.tblcontacts on post.AssignTo equals meta.ContactId
join s in _idc.tblstatus on post.StatusId equals s.Id
join t in _idc.tbljobTypes on post.TypeId equals t.Id
select new { Post = post, Meta = meta, s = s, t = t };
string image = "/assets/images/icon/staff.png";
foreach (var i in query)
{
jobViewItem _items = new Models.jobViewItem();
_items.AssignTo = i.Meta.Name;
_items.AssignToImage = !string.IsNullOrEmpty(i.Meta.ImagePath) ? i.Meta.ImagePath : image;
_items.OpenBy = contacts.FirstName;
_items.OpenByImage = contactImage;
_items.Date = i.Post.CreatedDate.ToString();
_items.Detail = i.Post.Detail;
_items.JobId = i.Post.Id;
_items.name = i.Post.Name;
_items.Po = i.Post.PoNumber;
_items.StatusId = i.Post.StatusId.Value;
_items.Status = i.s.StatusName;
_items.Type = i.t.Name;
_itemList.Add(_items);
}
_profile._jobs = _itemList;
}
catch (Exception ex)
{
}
finally
{
_idc.Dispose();
}
return(_profile);
}
