public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType, string src = "") { List <TblUnit> lst = new List <TblUnit>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } int total = uow.Modules.Unit.Count(src); WidgetPaginationModel Pagination = new WidgetPaginationModel(MVCAction, MVCController, MVCArea) { Page = (page ?? 1), Size = (size ?? 10), SearchCri = new Dictionary <string, dynamic>() { { "src", src } }, SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = uow.Modules.Unit.Gets(Pagination.Page, Pagination.Size, src); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage(true) }; ViewBag.Alert = Alert; } return(View(lst)); }
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType) { SysRole role = CurrentUser.Role(3).Role(); ViewBag.canWrite = role.SysRolePermission.Where(x => x.MenuId == 3920 && x.PermissionId == 2 && x.PermissionFlag).Count() > 0; ViewBag.canDelete = role.SysRolePermission.Where(x => x.MenuId == 3920 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0; List <SysRole> lst = new List <SysRole>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } int total = uow.Role.Counts(SITE_ID); WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Role", "") { Page = (page ?? 1), Size = (size ?? 10), SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = uow.Role.Gets(Pagination.Page, Pagination.Size, SITE_ID); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(lst)); }
private ActionResult ViewDetail(TblInvoice ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optSaleOrder"] = uow.Modules.SaleOrder.Gets() .Where(so => so.StatusId == 1) .ToList(); ViewData["optQuotation"] = uow.Modules.Quotation.Gets() .Where(q => q.StatusId == 3) .ToList(); ViewData["optPayment"] = uow.Modules.PaymentCondition.Gets(); return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewStation(TblKptStation ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } return(View("Station", ob)); } catch (Exception ex) { if (ob == null) { return(RedirectToAction("Index", new { controller = "KPT", msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } return(RedirectToAction("Detail", new { id = ob.KptId, controller = "KPT", msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(TransferStockHeader ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optCustomer"] = uow.Modules.Customer.GetAllAddress(); ViewData["optCustomerAddress"] = uow.Modules.CustomerAddress.Gets(); ViewData["optProduct"] = uow.Modules.Product.Gets(); ViewData["optContact"] = uow.Modules.CustomerContact.Gets(); ViewData["optEmployee"] = uow.Modules.Employee.Gets(); ViewData["optWareHouse"] = uow.Modules.WareHouse.Gets(); CurrentUser.TblEmployee = uow.Modules.Employee.GetEmployeeByAccount(CurrentUID); ViewData["userAccount"] = CurrentUser; return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(TblPayment ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } AccountPermission permission = new AccountPermission(); permission = GetPermissionSale(CurrentUser.AccountId, ob.CreatedBy); ViewData["optBankAccount"] = uow.Modules.BankAccount.GetList(1); CurrentUser.TblEmployee = uow.Modules.Employee.GetEmployeeByAccount(CurrentUID); ViewData["userAccount"] = CurrentUser; ViewData["optPermission"] = permission; ViewData["optEmployee"] = uow.Modules.Employee.Gets(); return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(TblEmployee ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optPrefix"] = uow.Modules.Enum.PrefixGets(); ViewData["optDepartment"] = uow.Modules.Department.Gets(); ViewData["optPosition"] = uow.Modules.Position.Gets(1, 0); ViewData["optLead"] = uow.Modules.Employee.Gets(); ViewData["optAccount"] = uow.Modules.Account.Gets(); ViewData["optEmpPermission"] = uow.Modules.EmployeeUserPermission.Gets(src: ob.AccountId.ToString()); return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(SysAccount ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optRole"] = uow.Role.Gets(1, 0, 3); ViewData["optRoleCal"] = uow.Role.Gets(1, 0, 3); ViewData["optStaff"] = (from d in db.SysAccount where d.AccountId != ob.AccountId && !db.CalcAccountStaff.Where(x => x.AccountId == ob.AccountId).Select(x => x.AccountId).Contains(d.AccountId) select d).ToList(); return(View("Detail", ob)); } catch (Exception ex) { return(RedirectToAction("Index", new { area = "", controller = "Account", msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType) { List <SysRole> lst = new List <SysRole>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } int total = uow.Modules.Role.Counts(SiteId); WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Role", "") { Page = (page ?? 1), Size = (size ?? 10), SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = uow.Modules.Role.Gets(Pagination.Page, Pagination.Size, SiteId); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(lst)); }
private ActionResult ViewDetail(TblProduct ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optCategory"] = uow.Modules.ProductCategory.Gets(); ViewData["optModel"] = uow.Modules.ProductModel.Gets(); ViewData["optUnit"] = uow.Modules.Unit.Gets(); ViewData["optWareHouse"] = uow.Modules.WareHouse.Gets(); ViewData["optProductOfWareHouse"] = uow.Modules.ProductOfWareHouse.Gets(ob.ProductId); return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(TeamOperation ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optOperation"] = uow.Modules.TeamOperation.GetNotMembers(); AccountPermission permission = new AccountPermission(); permission = GetPermissionOperation(CurrentUser.AccountId, null); ViewData["userAccount"] = CurrentUser; ViewData["optPermission"] = permission; return(View("Detail", ob)); } catch (Exception ex) { Dictionary <string, dynamic> rs = new Dictionary <string, dynamic>() { { "msg", ex.GetMessage() }, { "msgType", AlertMsgType.Danger } }; return(UrlRedirect(PathHelper.OperationTeam, rs)); } }
public ActionResult GetTransferSInList() { List <TransferHeader> lst = new List <TransferHeader>(); try { lst = uow.Modules.Transfer.GetList("I"); foreach (var ls in lst.ToList()) { ls.StrTransferDate = ls.TransferDate.HasValue ? ls.TransferDate.Value.Day.ToString("00") + "/" + ls.TransferDate.Value.Month.ToString("00") + "/" + ls.TransferDate.Value.Year : ""; } } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage(true) }; ViewBag.Alert = Alert; } return(Json(lst)); }
private ActionResult ViewDetail(SysAccount ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optRole"] = uow.Modules.Role.Gets(1, 0, SiteId); ViewData["optRoleCal"] = uow.Modules.Role.Gets(1, 0, 2); return(View("Detail", ob)); } catch (Exception ex) { return(RedirectToAction("Index", new { area = "", controller = "Account", msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
private ActionResult ViewDetail(TransferHeader ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } AccountPermission permission = new AccountPermission(); if (ob.JobOrder != null) { ob.JobOrder.Team = uow.Modules.TeamOperation.Get(ob.JobOrder.TeamId.HasValue ? ob.JobOrder.TeamId.Value : 0); permission = GetPermissionOperation(CurrentUID, ob.JobOrder.Team); } else { List <TeamOperation> manager = uow.Modules.TeamOperation.Manager(CurrentUID); if (manager != null) { permission.IsManager = true; permission.IsEdit = true; permission.IsTeam = true; permission.IsAdminTeam = false; } } ViewData["optCustomer"] = uow.Modules.Customer.GetAllAddress(); ViewData["optCustomerAddress"] = uow.Modules.CustomerAddress.Gets(); ViewData["optProduct"] = uow.Modules.Product.Gets(); ViewData["optContact"] = uow.Modules.CustomerContact.Gets(); ViewData["optEmployee"] = uow.Modules.Employee.Gets(); ViewData["userAccount"] = CurrentUser; ViewData["optPermission"] = permission; if (ob.RefTransferId != null) { ob.RefTransfer = uow.Modules.Transfer.GetTransferHeader(ob.TransferId); } return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType) { SysRole role = CurrentUser.Role(3).Role(); ViewBag.canWrite = role.SysRolePermission.Where(x => x.MenuId == 3220 && x.PermissionId == 2 && x.PermissionFlag).Count() > 0; ViewBag.canDelete = role.SysRolePermission.Where(x => x.MenuId == 3220 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0; ViewBag.canExport = role.SysRolePermission.Where(x => x.MenuId == 3220 && x.PermissionId == 4 && x.PermissionFlag).Count() > 0; List <TblKpt> lst = new List <TblKpt>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } var data = uow.db.TblKpt.AsQueryable(); if (!CurrentUser.FlagAdminCalc) { var staffs = db.CalcAccountStaff.Where(x => x.AccountId == CurrentUID).Select(x => x.StaffId).ToList(); if (staffs.Count() > 0) { data = data.Where(x => staffs.Contains(x.CreatedBy) || x.CreatedBy == CurrentUID); } else { data = data.Where(x => x.CreatedBy == CurrentUID); } } int total = data.Count(); WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "KPT", "") { Page = (page ?? 1), Size = (size ?? 10), SearchCri = new Dictionary <string, dynamic>(), SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = data .OrderByDescending(x => x.KptDate) .ThenBy(x => x.ProjectName) .Include(x => x.TblKptDetail) .Skip((Pagination.Page - 1) * Pagination.Size) .Take(Pagination.Size) .ToList(); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(lst)); }
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType, int year, int month, string src = "") { List <CalendarDayModel> data = new List <CalendarDayModel>(); List <TblSaleOrder> lst = new List <TblSaleOrder>(); List <TblJobOrder> joblst = new List <TblJobOrder>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } AccountPermission permission = GetPermission(CurrentUID); ViewData["optPermission"] = permission; DateTime firstDt = new DateTime(year, month, 1); ViewBag.FocusDate = firstDt; if (permission.TeamType == TeamType.Admin || permission.TeamType == TeamType.Sale) //administrator of sale { int total = uow.Modules.SaleOrder.Count(month, src); lst = uow.Modules.SaleOrder.GetAll(1, -1, month, src, (permission.IsAdminTeam || permission.IsManager) ? 0 : CurrentUID); #region Calculate first week for (int i = firstDt.DayOfWeek.ToInt(); i > 0; i--) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(-i), Jobs = new List <TblSaleOrder>(), TeamType = permission.TeamType }; data.Add(day); } #endregion int offset = data.Count; for (int i = offset; i <= 42; i++) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(i - offset), Jobs = new List <TblSaleOrder>(), TeamType = permission.TeamType }; if (day.Date.Month == month) { var dayJobs = lst.Where(x => x.SaleOrderDate.HasValue && x.SaleOrderDate.Value.Date == day.Date.Date); day.Jobs = dayJobs.Count() > 0 ? dayJobs.ToList() : new List <TblSaleOrder>(); } data.Add(day); } } else if (permission.TeamType == TeamType.Operation) ///operation { joblst = uow.Modules.JobOrder.GetAll(1, -1, month, src, (permission.IsAdminTeam) ? 0 : permission.TeamId); #region Calculate first week for (int i = firstDt.DayOfWeek.ToInt(); i > 0; i--) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(-i), JobsOrder = new List <TblJobOrder>(), TeamType = permission.TeamType }; data.Add(day); } #endregion int offset = data.Count; for (int i = offset; i <= 42; i++) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(i - offset), JobsOrder = new List <TblJobOrder>(), TeamType = permission.TeamType }; if (day.Date.Month == month) { var dayJobs = joblst.Where(x => x.StartDate.HasValue && x.StartDate.Value.Date == day.Date.Date ); day.JobsOrder = dayJobs.Count() > 0 ? dayJobs.ToList() : new List <TblJobOrder>(); } data.Add(day); } } else { #region Calculate first week for (int i = firstDt.DayOfWeek.ToInt(); i > 0; i--) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(-i), JobsOrder = new List <TblJobOrder>(), TeamType = permission.TeamType }; data.Add(day); } #endregion int offset = data.Count; for (int i = offset; i <= 42; i++) { CalendarDayModel day = new CalendarDayModel() { Date = firstDt.AddDays(i - offset) }; data.Add(day); } } } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(data)); }
public ActionResult Maps(int?page, int?size, string dateStart, string dateEnd, string msg, AlertMsgType?msgType) { DateTime?dtStart = dateStart.ParseDateNullable(DateFormat.ddMMyyyy); DateTime?dtEnd = dateEnd.ParseDateNullable(DateFormat.ddMMyyyy); ViewData["GoogleMapsAPIKey"] = ConfigurationManager.AppSettings["GoogleMapsAPI"]; SysRole role = CurrentUser.Role(3).Role(); ViewBag.canWrite = role.SysRolePermission.Where(x => x.MenuId == 3710 && x.PermissionId == 2 && x.PermissionFlag).Count() > 0; ViewBag.canDelete = role.SysRolePermission.Where(x => x.MenuId == 3710 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0; ViewBag.canExport = role.SysRolePermission.Where(x => x.MenuId == 3710 && x.PermissionId == 4 && x.PermissionFlag).Count() > 0; List <TblKpt> lst = new List <TblKpt>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } var data = uow.db.TblKpt.AsQueryable(); if (dtStart.HasValue) { data = data.Where(x => DbFunctions.TruncateTime(x.CreatedDate) >= dtStart.Value); } if (dtEnd.HasValue) { data = data.Where(x => DbFunctions.TruncateTime(x.CreatedDate) <= dtEnd.Value); } ViewData["dateStart"] = dtStart.ParseString(DateFormat.ddMMyyyy); ViewData["dateEnd"] = dtEnd.ParseString(DateFormat.ddMMyyyy); int total = data.Count(); WidgetPaginationModel Pagination = new WidgetPaginationModel("Maps", "Report", "") { Page = (page ?? 1), Size = (size ?? 10), SearchCri = new Dictionary <string, dynamic>(), SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = data .OrderByDescending(x => x.KptDate) .ThenBy(x => x.ProjectName) .Include(x => x.TblKptDetail) .Skip((Pagination.Page - 1) * Pagination.Size) .Take(Pagination.Size) .ToList(); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(lst)); }
public ActionResult Index(int?page, int?size, string dateStart, string dateEnd, string msg, AlertMsgType?msgType) { DateTime? dtStart = dateStart.ParseDateNullable(DateFormat.ddMMyyyy); DateTime? dtEnd = dateEnd.ParseDateNullable(DateFormat.ddMMyyyy); List <TblCalLoad> lst = new List <TblCalLoad>(); try { if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } var data = db.TblCalLoad.AsQueryable(); if (dtStart.HasValue) { data = data.Where(x => DbFunctions.TruncateTime(x.CreatedDate) >= dtStart.Value); } if (dtEnd.HasValue) { data = data.Where(x => DbFunctions.TruncateTime(x.CreatedDate) <= dtEnd.Value); } int total = data.Count(); ViewData["dateStart"] = dtStart.ParseString(DateFormat.ddMMyyyy); ViewData["dateEnd"] = dtEnd.ParseString(DateFormat.ddMMyyyy); WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Report", "") { Page = (page ?? 1), Size = (size ?? 10), SearchCri = new Dictionary <string, dynamic>(), SortExp = "", Total = total }; ViewBag.Pagination = Pagination; lst = (from d in data join m in db.TblPile on d.ModelId equals m.PileId orderby d.CreatedDate descending , m.PileName ascending , d.InputC ascending select d) .Skip((Pagination.Page - 1) * Pagination.Size) .Take(Pagination.Size) .ToList(); } catch (Exception ex) { WidgetAlertModel Alert = new WidgetAlertModel() { Type = AlertMsgType.Danger, Message = ex.GetMessage() }; ViewBag.Alert = Alert; } return(View(lst)); }
private ActionResult ViewDetail(TblSaleOrder ob, string msg, AlertMsgType?msgType) { List <TblQuotation> quotationList = null; try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } quotationList = uow.Modules.Quotation.GetQuatationNotSale() .Where(q => q.StatusId == 3) .ToList(); if (quotationList == null) { quotationList = new List <TblQuotation>(); } AccountPermission permission = new AccountPermission(); permission = GetPermissionSale(CurrentUser.AccountId, ob.CreatedBy.HasValue ? ob.CreatedBy.Value : 0); quotationList.Add(uow.Modules.Quotation.Get(ob.QuotationNo)); ViewData["optSoDetail"] = uow.Modules.SaleOrderDetail.Gets(ob.SaleOrderId); ViewData["optQuotation"] = quotationList; ViewData["optCustomer"] = uow.Modules.Customer.GetAllAddress(); ViewData["optCustomerAddress"] = uow.Modules.CustomerAddress.Gets(); ViewData["optProduct"] = uow.Modules.Product.Gets("0"); ViewData["optContact"] = uow.Modules.CustomerContact.Gets(); ViewData["optEmployee"] = uow.Modules.Employee.Gets(); ViewData["optPayment"] = uow.Modules.PaymentCondition.Gets(); ViewData["optAttachment"] = uow.Modules.SaleOrderAttachment.Gets(ob.SaleOrderId); ViewData["optTeam"] = uow.Modules.TeamOperation.Gets(); ViewData["userAccount"] = CurrentUser; ViewData["optPermission"] = permission; ViewData["optWareHouse"] = uow.Modules.WareHouse.Gets(); return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }