// GET: Detail
public ActionResult Detail(string id)
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <TasklistModel> dataResponse = DataFunction.GetCustomObjectListFromService <TasklistModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@SSID", "", "@ACTION", "", "@OBJECTID", "", "@USERID", SEmployee.EmployeeCode, "@StatusType", "", "@TaskType", "", "@TaskID", id
}, "[dbo].[NI09_TaskList_Items_GetlList]"
);
List <ListTasklistStatusModel> dataResponse2 = DataFunction.GetCustomObjectListFromService <ListTasklistStatusModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
}, "[dbo].[NI09_TaskList_GetListStatus]"
);
ViewBag.ListStatus = dataResponse2;
TasklistModel model = new TasklistModel();
TasklistModel taskParentDetail = new TasklistModel();
ViewBag.taskParentDetail = taskParentDetail;
if (dataResponse.Count > 0)
{
model = dataResponse.FirstOrDefault();
model.OptionListDB = new SqlSelectListDao().GetSelectLists("NI09_TaskList_OptionList_GetList");
model.OptionListView = (from a in model.OptionStringItemList
join b in model.OptionListDB on a.KeyName equals b.Code
select new OptionListModel
{
Code = a.KeyName,
Name = b.Name,
Val = a.KeyVal
}).ToList();
if (model.ParentID > 0)
{
List <TasklistModel> dataResponse3 = DataFunction.GetCustomObjectListFromService <TasklistModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@SSID", "", "@ACTION", "", "@OBJECTID", "", "@USERID", "", "@StatusType", "", "@TaskType", "", "@TaskID", model.ParentID.ToString()
}, "[dbo].[NI09_TaskList_Items_GetlList]"
);
if (dataResponse3.Count > 0)
{
taskParentDetail = dataResponse3.FirstOrDefault();
ViewBag.taskParentDetail = taskParentDetail;
}
}
}
// model.TaskTypeList = new SqlSelectListDao().GetSelectLists("spSelectList_NI09_TaskList_TaskTypeList");
return(View(model));
}
public ActionResult MenuInfo()
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
NI10_Employee employee = (Session["EmployeeLogin"] != null) ? (NI10_Employee)Session["EmployeeLogin"] : new NI10_Employee();
List <NI10_Menu> menus = DataFunction.GetCustomObjectListFromService <NI10_Menu>(serviceUrl, "Request/GetData", "", new List <string>()
{
"@employeeCode", employee.EmployeeCode
}, "[dbo].[NI10_Menu_GetByEmployeeCode]");
return(View(menus));
}
// GET: AddUpdate
public ActionResult AddUpdate(string id)
{
TasklistModel model = new TasklistModel();
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
if (!String.IsNullOrEmpty(id))
{
List <TasklistModel> content = DataFunction.GetCustomObjectListFromService <TasklistModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@SSID", "", "@ACTION", "", "@OBJECTID", "", "@USERID", SEmployee.EmployeeCode, "@StatusType", "", "@TaskType", "", "@TaskID", id
}, "[dbo].[NI09_TaskList_Items_GetlList]"
);
model = content.FirstOrDefault();
model.OptionListDB = new SqlSelectListDao().GetSelectLists("NI09_TaskList_OptionList_GetList");
model.OptionListView = (from a in model.OptionStringItemList
join b in model.OptionListDB on a.KeyName equals b.Code
select new OptionListModel
{
Code = a.KeyName,
Name = b.Name,
Val = a.KeyVal
}).ToList();
}
else
{
model.OptionListDB = new SqlSelectListDao().GetSelectLists("NI09_TaskList_OptionList_GetList");
model.OptionListView = (from a in model.OptionListDB
select new OptionListModel
{
Code = a.Code,
Name = a.Name,
Val = false
}).ToList();
}
model.TaskTypeList = new SqlSelectListDao().GetSelectLists("spSelectList_NI09_TaskList_TaskTypeList");
model.ObjectInChargeTypeList = new SqlSelectListDao().GetSelectLists("spSelectList_NI09_TaskList_ObjectInChargeTypeList");
model.PriorityList = new SqlSelectListDao().GetSelectLists("spSelectList_NI09_TaskList_PriorityLevel");
List <ListTasklistStatusModel> dataResponse2 = DataFunction.GetCustomObjectListFromService <ListTasklistStatusModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
}, "[dbo].[NI09_TaskList_GetListStatus]"
);
ViewBag.ListStatus = dataResponse2;
return(View(model));
}
public JsonResult AddTaskType(string ItemName)
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <BussinessObjects.SelectList> dataList = DataFunction.GetCustomObjectListFromService <BussinessObjects.SelectList>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@ItemName", ItemName
}, "[dbo].[NI09_TaskList_ListTaskType_Save]"
);
return(Json(dataList, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchTaskParent(string TaskTitle = "")
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <BussinessObjects.SelectList> dataList = DataFunction.GetCustomObjectListFromService <BussinessObjects.SelectList>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@TaskTitle", TaskTitle
}, "[dbo].[NI09_TaskList_Items_Search]"
);
return(Json(dataList, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadObjectInChargeTypeByUser(string lstItemCode = "", string ItemType = "")
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <BussinessObjects.SelectList> dataList = DataFunction.GetCustomObjectListFromService <BussinessObjects.SelectList>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@lstItemCode", lstItemCode, "ItemType", ItemType
}, "[dbo].[NI09_TaskList_ObjectInCharge_List_GetByListItemCode]"
);
return(Json(dataList, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadObjectInChargeType(string itemCode = "", string ItemCode_KeySeach = "")
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <BussinessObjects.SelectList> dataList = DataFunction.GetCustomObjectListFromService <BussinessObjects.SelectList>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@SSID", "", "@ACTION", "", "@OBJECTID", "", "@USERID", SEmployee.EmployeeCode, "@ItemCode", itemCode, "@ItemCode_KeySeach", ItemCode_KeySeach
}, "[dbo].[NI09_TaskList_ObjectInCharge_GetListByType]"
);
return(Json(dataList, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewCol(string typeAction = "", string status = "", string taskType = "")
{
string serviceUrl = ConfigurationManager.AppSettings["ServiceUrl"];
List <TasklistModel> dataResponse = DataFunction.GetCustomObjectListFromService <TasklistModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
"@SSID", "", "@ACTION", typeAction, "@OBJECTID", "", "@USERID", SEmployee.EmployeeCode, "@StatusType", status, "@TaskType", taskType, "@TaskID", ""
}, "[dbo].[NI09_TaskList_Items_GetlList]"
);
List <ListTasklistStatusModel> dataResponse2 = DataFunction.GetCustomObjectListFromService <ListTasklistStatusModel>
(
serviceUrl, "Request/GetData", "", new List <string>()
{
}, "[dbo].[NI09_TaskList_GetListStatus]"
);
ViewBag.ListStatus = dataResponse2;
return(View(dataResponse));
}
