public JsonResult Delete(int ID)
{
permisionVM = this.getPermisionControllerViewModel();
if (!(permisionVM.isAllow_Delete))
{
ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
returnMachineMtn.Code = "99";
returnMachineMtn.Message = "Không được cấp quyền/ Not permission!";
return(Json(returnMachineMtn, JsonRequestBehavior.AllowGet));
}
return(Json(machineMtnDB.DeleteByID(ID), JsonRequestBehavior.AllowGet));
}
public JsonResult SelectByPageDataTable([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, MachineMtn machineMtn)
{
//DataTables.
int pageSize = requestModel.Length != 0 ? requestModel.Length : 10;
int pageNumber = requestModel.Start / requestModel.Length + 1;
string where = " where 1=1 ";
string where_MachineID = "";
string where_FrequencyID = "";
string where_MaintenanceDate = "";
string where_Shift = "";
string where_Week = "";
string where_Month = "";
string where_Year = "";
if (!string.IsNullOrEmpty(machineMtn.MachineID))
{
where_MachineID = " and tMachineMtn.MachineID = '" + machineMtn.MachineID + "'";
}
if (machineMtn.FrequencyID != 0)
{
where_FrequencyID = " and tMachineMtn.FrequencyID = '" + machineMtn.FrequencyID + "' ";
}
if (machineMtn.MaintenanceDate != DateTime.MinValue)
{
where_MaintenanceDate = " and tMachineMtn.MaintenanceDate = '" + machineMtn.MaintenanceDate + "' ";
}
if (machineMtn.Shift != 0)
{
where_Shift = " and Shift = '" + machineMtn.Shift + "' ";
}
if (machineMtn.Week != 0)
{
where_Week += " AND Week = '" + machineMtn.Week + "' ";
}
if (machineMtn.Month != 0)
{
where_Month += " AND Month = '" + machineMtn.Month + "' ";
}
if (machineMtn.Year != 0)
{
where_Year += " AND Year = '" + machineMtn.Year + "' ";
}
//tong hop cau lenh where.
if (machineMtn.FrequencyID == 0) // lay tat ca.
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
where += where_Week + where_Month + where_Year;
}
if (machineMtn.FrequencyID == 1)
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
}
if (machineMtn.FrequencyID == 2)
{
where += where_MachineID + where_FrequencyID + where_Week + where_Year;
}
if (machineMtn.FrequencyID == 3 || machineMtn.FrequencyID == 4 || machineMtn.FrequencyID == 5)
{
where += where_MachineID + where_FrequencyID + where_Month + where_Year;
}
if (machineMtn.FrequencyID == 6)
{
where += where_MachineID + where_FrequencyID + where_Year;
}
if (!string.IsNullOrEmpty(machineMtn.CheckerResult))
{
where += " AND CheckerResult = '" + machineMtn.CheckerResult + "' ";
}
if (!string.IsNullOrEmpty(machineMtn.Result))
{
where += " AND Result = '" + machineMtn.Result + "' ";
}
//Execute.
ReturnMachineMtn _returnMachineMtn = machineMtnDB.SelectByPage(where, pageNumber, pageSize);
// DataTables.
// Avoid from datatables.net getting stuck (if data=null).
if (_returnMachineMtn.lstMachineMtn == null)
{
_returnMachineMtn.lstMachineMtn = new List <MachineMtn>();
}
//Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
IEnumerable <MachineMtn> IEnum_MachineMtn = _returnMachineMtn.lstMachineMtn.OrderBy(orderByString ==
string.Empty ? "MachineID asc" : orderByString);
_returnMachineMtn.lstMachineMtn = IEnum_MachineMtn.ToList <MachineMtn>();
//Permission.
_returnMachineMtn.permisionControllerVM = this.getPermisionControllerViewModel();
//DataTables.
//return View.
var DataTablesResponse = new
{
draw = requestModel.Draw,
data = _returnMachineMtn,
recordsFiltered = _returnMachineMtn.Total,
recordsTotal = _returnMachineMtn.Total
};
return(Json(DataTablesResponse, JsonRequestBehavior.AllowGet));
}
//public JsonResult SelectByCondition(string MachineID, string FrequencyID, string MaintenanceDate, string Shift, string Week, string Month, string Year, string CheckerResult, string Result)
//{
// string where = "1=1 ";
// string where_MachineID = "";
// string where_FrequencyID = "";
// string where_MaintenanceDate = "";
// string where_Shift = "";
// string where_Week = "";
// string where_Month = "";
// string where_Year = "";
// if (!string.IsNullOrEmpty(MachineID))
// where_MachineID = " and tMachineMtn.MachineID = '" + MachineID + "'";
// if (!string.IsNullOrEmpty(FrequencyID))
// where_FrequencyID = " and tMachineMtn.FrequencyID = '" + FrequencyID + "' ";
// if (!string.IsNullOrEmpty(MaintenanceDate))
// where_MaintenanceDate = " and tMachineMtn.MaintenanceDate = '" + MaintenanceDate + "' ";
// if (!string.IsNullOrEmpty(Shift))
// where_Shift = " and Shift = '" + Shift + "' ";
// if (!string.IsNullOrEmpty(Week))
// where_Week += " AND Week = '" + Week + "' ";
// if (!string.IsNullOrEmpty(Month))
// where_Month += " AND Month = '" + Month + "' ";
// if (!string.IsNullOrEmpty(Year))
// where_Year += " AND Year = '" + Year + "' ";
// //tong hop cau lenh where.
// if (string.IsNullOrEmpty(FrequencyID)) // lay tat ca.
// {
// where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
// where += where_Week + where_Month + where_Year;
// }
// if (FrequencyID == "1")
// where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
// if (FrequencyID == "2")
// where += where_MachineID + where_FrequencyID + where_Week + where_Year;
// if (FrequencyID == "3" || FrequencyID == "4" || FrequencyID == "5")
// where += where_MachineID + where_FrequencyID + where_Month + where_Year;
// if (FrequencyID == "6")
// where += where_MachineID + where_FrequencyID + where_Year;
// if (!string.IsNullOrEmpty(CheckerResult))
// where += " AND CheckerResult = '" + CheckerResult + "' ";
// if (!string.IsNullOrEmpty(Result))
// where += " AND Result = '" + Result + "' ";
// ReturnMachineMtn _returnMachineMtn = machineMtnDB.SelectByCondition(where);
// _returnMachineMtn.permisionControllerVM = ClassCommon.getPermisionControllerViewModel(RouteData.Values["controller"].ToString(), (Session["UserPermission"] as ReturnUserPermission));
// _returnMachineMtn.TotalPage = (_returnMachineMtn.Total + pageSize - 1) / pageSize;
// _returnMachineMtn.TotalPage = _returnMachineMtn.TotalPage == 0 ? 1 : _returnMachineMtn.TotalPage;
// return Json(_returnMachineMtn, JsonRequestBehavior.AllowGet);
//}
public JsonResult SelectByPage(string MachineID, string FrequencyID, string MaintenanceDate, string Shift, string Week, string Month, string Year, string CheckerResult, string Result, int pageNumber)
{
string where = " 1=1 ";
string where_MachineID = "";
string where_FrequencyID = "";
string where_MaintenanceDate = "";
string where_Shift = "";
string where_Week = "";
string where_Month = "";
string where_Year = "";
if (!string.IsNullOrEmpty(MachineID))
{
where_MachineID = " and tMachineMtn.MachineID = '" + MachineID + "'";
}
if (!string.IsNullOrEmpty(FrequencyID))
{
where_FrequencyID = " and tMachineMtn.FrequencyID = '" + FrequencyID + "' ";
}
if (!string.IsNullOrEmpty(MaintenanceDate))
{
where_MaintenanceDate = " and tMachineMtn.MaintenanceDate = '" + MaintenanceDate + "' ";
}
if (!string.IsNullOrEmpty(Shift))
{
where_Shift = " and Shift = '" + Shift + "' ";
}
if (!string.IsNullOrEmpty(Week))
{
where_Week += " AND Week = '" + Week + "' ";
}
if (!string.IsNullOrEmpty(Month))
{
where_Month += " AND Month = '" + Month + "' ";
}
if (!string.IsNullOrEmpty(Year))
{
where_Year += " AND Year = '" + Year + "' ";
}
//tong hop cau lenh where.
if (string.IsNullOrEmpty(FrequencyID)) // lay tat ca.
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
where += where_Week + where_Month + where_Year;
}
if (FrequencyID == "1")
{
where += where_MachineID + where_FrequencyID + where_MaintenanceDate + where_Shift;
}
if (FrequencyID == "2")
{
where += where_MachineID + where_FrequencyID + where_Week + where_Year;
}
if (FrequencyID == "3" || FrequencyID == "4" || FrequencyID == "5")
{
where += where_MachineID + where_FrequencyID + where_Month + where_Year;
}
if (FrequencyID == "6")
{
where += where_MachineID + where_FrequencyID + where_Year;
}
if (!string.IsNullOrEmpty(CheckerResult))
{
where += " AND CheckerResult = '" + CheckerResult + "' ";
}
if (!string.IsNullOrEmpty(Result))
{
where += " AND Result = '" + Result + "' ";
}
ReturnMachineMtn _returnMachineMtn = machineMtnDB.SelectByPage(where, pageNumber, pageSize);
_returnMachineMtn.permisionControllerVM = this.getPermisionControllerViewModel(); //permission
_returnMachineMtn.TotalPage = (_returnMachineMtn.Total + pageSize - 1) / pageSize;
_returnMachineMtn.TotalPage = _returnMachineMtn.TotalPage == 0 ? 1 : _returnMachineMtn.TotalPage;
return(Json(_returnMachineMtn, JsonRequestBehavior.AllowGet)); //Trả về dạng List<>
}
