public JsonResult GetGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { ColumnCollection col = requestModel.Columns; string OrderBy = "PositionID", OrderDirection = "ASC"; foreach (Column item in col) { //if (item.IsOrdered && item.Data!="EmpPoint") if (item.IsOrdered) { OrderBy = item.Data; OrderDirection = item.SortDirection == Column.OrderDirection.Ascendant ? "ASC" : "DESC"; break; } } SearchFilter SearchKey = new SearchFilter() { CompanyID = CurrentUser.CompanyID, Keyword = requestModel.Search.Value, Page = (requestModel.Start / requestModel.Length) + 1, PageSize = requestModel.Length, ColumnsName = "PositionID,Description", OrderBy = OrderBy, OrderDirection = OrderDirection, }; EPPositionCollection collection = EPPositionManager.Search(SearchKey); int TotalRecord = 0; if (collection.Count > 0) { TotalRecord = collection[0].TotalRecord; } //EPPositionCollection data = EPPositionManager.GetAll(CurrentUser.CompanyID); return(Json(new DataTablesResponse(requestModel.Draw, collection, TotalRecord, TotalRecord), JsonRequestBehavior.AllowGet)); }
public ActionResult EPPositionEvt(string[] PositionID, string Action) { // You have your books IDs on the deleteInputs array switch (Action.ToLower()) { case "delete": if (PositionID != null && PositionID.Length > 0) { int length = PositionID.Length; EPPosition objItem; for (int i = 0; i <= length - 1; i++) { objItem = EPPositionManager.GetById(PositionID[i], CurrentUser.CompanyID); if (objItem != null) { EPPositionManager.Delete(objItem); } } return(View(ViewFolder + "list.cshtml", EPPositionManager.GetAll(CurrentUser.CompanyID))); } break; } return(View("PostFrm")); }
public ContentResult Search(SearchFilter SearchKey) { SearchKey.OrderBy = string.IsNullOrEmpty(SearchKey.OrderBy) ? "PositionID" : SearchKey.OrderBy; EPPositionCollection collection = EPPositionManager.Search(SearchKey); return(Content(JsonConvert.SerializeObject(collection), "application/json")); }
public ContentResult Save(string objdata, string value) { JsonObject js = new JsonObject(); js.StatusCode = 200; js.Message = "Upload Success"; try { EPPosition obj = JsonConvert.DeserializeObject <EPPosition>(objdata); obj = EPPositionManager.Update(obj); if (string.IsNullOrEmpty(obj.PositionCD)) { js.StatusCode = 400; js.Message = "Has Errors. Please contact Admin for more information"; } else { js.Data = obj; } } catch (Exception objEx) { js.StatusCode = 400; js.Message = objEx.Message; } return(Content(JsonConvert.SerializeObject(js), "application/json")); }
/// <summary> /// use for setting up default value /// </summary> /// <returns></returns> public ActionResult Update(string PositionID, string TargetID = "EPPositionlist") { EPPosition objItem = EPPositionManager.GetById(PositionID, CurrentUser.CompanyID); objItem.EPPositionKey = objItem.PositionID; objItem.TargetDisplayID = TargetID; return(View(ViewFolder + "Create.cshtml", objItem)); }
/// <summary> /// ExportExcel File /// </summary> /// <returns></returns> public string ExportExcel() { EPPositionCollection collection = EPPositionManager.GetAll(CurrentUser.CompanyID); DataTable dt = collection.ToDataTable <EPPosition>(); string fileName = "EPPosition_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy"); string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate" }; for (int i = 0; i < RemoveColumn.Length; i++) { if (dt.Columns.Contains(RemoveColumn[i])) { dt.Columns.Remove(RemoveColumn[i]); } } FileInputHelper.ExportExcel(dt, fileName, "EPPosition List", false); return(fileName); }
public ActionResult Update(EPPosition model) { try { if (ModelState.IsValid) { // TODO: Add insert logic here EPPositionManager.Update(model); //return RedirectToAction("Index"); } return(View(model)); } catch { return(View(model)); } }
public ContentResult SaveExcel(string item) { //string b = Request["item"]; IEnumerable <EPPosition> objItemList = JsonConvert.DeserializeObject <IEnumerable <EPPosition> >(item); JsonObject obj = new JsonObject(); obj.StatusCode = 200; obj.Message = "The process is sucessed"; foreach (EPPosition objitem in objItemList) { //default value objitem.CreatedUser = CurrentUser.UserName; objitem.CreatedDate = SystemConfig.CurrentDate; objitem.CompanyID = CurrentUser.CompanyID; EPPositionManager.Add(objitem); } return(Content(JsonConvert.SerializeObject(obj), "application/json")); }
public ActionResult Create(EPPosition model) { try { if (ModelState.IsValid) { model.CompanyID = CurrentUser.CompanyID; if (model.EPPositionKey.Trim() != SystemConst.AddNew) { //get default value EPPosition objOldEPPosition = EPPositionManager.GetById(model.PositionID, CurrentUser.CompanyID); if (objOldEPPosition != null) { model.CreatedDate = objOldEPPosition.CreatedDate; model.CreatedUser = objOldEPPosition.CreatedUser; } EPPositionManager.Update(model); } else { // TODO: Add insert logic here model.CreatedUser = CurrentUser.UserName; model.CreatedDate = SystemConfig.CurrentDate; EPPositionManager.Add(model); } return(View(ViewFolder + "list.cshtml", EPPositionManager.GetAll(CurrentUser.CompanyID))); } } catch (Exception ObjEx) { // LogHelper.AddLog(new IfindLog() { LinkUrl = Request.Url.AbsoluteUri, Exception = ObjEx.Message, Message = ObjEx.StackTrace }); return(View(model)); } return(View(model)); }
public ActionResult Get(string PositionID, string action) { EPPosition objItem = EPPositionManager.GetById(PositionID, CurrentUser.CompanyID); return(Content(JsonConvert.SerializeObject(objItem), "application/json")); }
public ActionResult Get(string PositionID) { EPPosition objItem = EPPositionManager.GetById(PositionID, CurrentUser.CompanyID); return(View(objItem)); }
public ActionResult list() { EPPositionCollection collection = EPPositionManager.GetAll(1); return(View(ViewFolder + "list.cshtml", collection)); }