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 == 3210 && x.PermissionId == 2 && x.PermissionFlag).Count() > 0;
ViewBag.canDelete = role.SysRolePermission.Where(x => x.MenuId == 3210 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0;
ViewBag.canExport = role.SysRolePermission.Where(x => x.MenuId == 3210 && x.PermissionId == 4 && x.PermissionFlag).Count() > 0;
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
.Where(x => x.CreatedBy == CurrentUID);
int total = data.Count();
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Soil", "")
{
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
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));
}
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType,
string src = "", string username = "")
{
SysRole role = CurrentUser.Role(SITE_ID).Role();
ViewBag.canWrite = role.SysRolePermission.Where(x => x.MenuId == 2910 && x.PermissionId == 2 && x.PermissionFlag).Count() > 0;
ViewBag.canDelete = role.SysRolePermission.Where(x => x.MenuId == 2910 && x.PermissionId == 3 && x.PermissionFlag).Count() > 0;
List <SysAccount> lst = new List <SysAccount>();
try
{
if (!string.IsNullOrWhiteSpace(msg))
{
WidgetAlertModel alert = new WidgetAlertModel()
{
Message = msg
};
if (msgType.HasValue)
{
alert.Type = msgType.Value;
}
ViewBag.Alert = alert;
}
int total = uow.Account.Counts(src, username);
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Account", "")
{
Page = (page ?? 1),
Size = (size ?? 10),
SearchCri = new Dictionary <string, dynamic>()
{
{ "src", src },
{ "username", username }
},
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
lst = uow.Account.Gets(Pagination.Page, Pagination.Size, src, username);
}
catch (Exception ex)
{
WidgetAlertModel Alert = new WidgetAlertModel()
{
Type = AlertMsgType.Danger,
Message = ex.GetMessage()
};
ViewBag.Alert = Alert;
}
return(View(lst));
}
// GET: TransferStockIn
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType,
string src = "")
{
List <TransferStockHeader> lst = new List <TransferStockHeader>();
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.TransferStock.Count(0, "I");
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "TransferStockIn", "")
{
Page = (page ?? 1),
Size = (size ?? 10),
SearchCri = new Dictionary <string, dynamic>()
{
{ "src", src }
},
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
lst = uow.Modules.TransferStock.Gets(Pagination.Page, Pagination.Size, src, "I");
foreach (var ls in lst.ToList())
{
ls.Employee = uow.Modules.Employee.GetByCondition(ls.EmpId);
}
}
catch (Exception ex)
{
WidgetAlertModel Alert = new WidgetAlertModel()
{
Type = AlertMsgType.Danger,
Message = ex.GetMessage(true)
};
ViewBag.Alert = Alert;
}
return(View(lst));
}
// GET: Payment
public ActionResult Index(int?page, int?size, string msg, AlertMsgType?msgType,
string src = "")
{
List <TblPayment> lst = new List <TblPayment>();
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.Payment.Count(src);
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Payment", "")
{
Page = (page ?? 1),
Size = (size ?? 10),
SearchCri = new Dictionary <string, dynamic>()
{
{ "src", src }
},
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
lst = uow.Modules.Payment.Gets(Pagination.Page, Pagination.Size, src);
foreach (var ls in lst.ToList())
{
ls.AcctReceive = uow.Modules.BankAccount.Get(ls.AcctReceiveId.HasValue ? ls.AcctReceiveId.Value : 0);
}
}
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,
string src = "", string phone = "", string email = "")
{
List <TblEmployee> lst = new List <TblEmployee>();
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.Employee.Counts(src, phone, email);
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Account", "")
{
Page = (page ?? 1),
Size = (size ?? 10),
SearchCri = new Dictionary <string, dynamic>()
{
{ "src", src },
{ "phone", phone },
{ "email", email }
},
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
lst = uow.Modules.Employee.Gets(Pagination.Page, Pagination.Size, src, phone, email);
}
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,
string src = "")
{
List <TblPile> lst = new List <TblPile>();
try
{
if (!string.IsNullOrWhiteSpace(msg))
{
WidgetAlertModel alert = new WidgetAlertModel()
{
Message = msg
};
if (msgType.HasValue)
{
alert.Type = msgType.Value;
}
ViewBag.Alert = alert;
}
int total = db.TblPile.Count();
WidgetPaginationModel Pagination = new WidgetPaginationModel("Index", "Pile", "")
{
Page = (page ?? 1),
Size = (size ?? 10),
SearchCri = new Dictionary <string, dynamic>()
{
{ "src", src }
},
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
lst = db.TblPile.Include("TblPileSeries")
.OrderBy(x => x.TblPileSeries.SeriesOrder).ThenBy(x => x.PileSeriesOrder).Skip((Pagination.Page - 1) * Pagination.Size).Take(Pagination.Size).ToList();
}
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)
{
List <TeamSale> lst = new List <TeamSale>();
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.TeamSale.Count();
WidgetPaginationModel Pagination = new WidgetPaginationModel(PathHelper.SaleTeam)
{
Page = (page ?? 1),
Size = (size ?? 10),
SortExp = "",
Total = total
};
ViewBag.Pagination = Pagination;
AccountPermission permission = new AccountPermission();
permission = GetPermissionSale(CurrentUser.AccountId, CurrentUser.AccountId);
ViewData["userAccount"] = CurrentUser;
ViewData["optPermission"] = permission;
lst = uow.Modules.TeamSale.Gets(Pagination.Page, Pagination.Size).FindAll(o => o.DepartmentId == departmentID);
}
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,
string src = "")
{
List <TblProduct> lst = new List <TblProduct>();
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.Product.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.Product.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));
}
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));
}
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 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));
}
