public ContentResult Search(SearchFilter SearchKey) { SearchKey.OrderBy = string.IsNullOrEmpty(SearchKey.OrderBy) ? "EmpTypeID" : SearchKey.OrderBy; T_CMS_Master_EmploymentTypeCollection collection = T_CMS_Master_EmploymentTypeManager.Search(SearchKey); return(Content(JsonConvert.SerializeObject(collection), "application/json")); }
public static T_CMS_Master_EmploymentTypeCollection Search(SearchFilter value) { T_CMS_Master_EmploymentTypeCollection items = new T_CMS_Master_EmploymentTypeCollection(); string key = string.Format(SETTINGS_Search_KEY, value.Keyword, value.Page, value.PageSize, value.OrderBy, value.OrderDirection); if (SystemConfig.AllowSearchCache) { object obj2 = HttpCache.Get(key); if ((obj2 != null)) { return((T_CMS_Master_EmploymentTypeCollection)obj2); } } using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue)) { HttpResponseMessage response = client.PostAsJsonAsync(Resource + "?method=search", value).GetAwaiter().GetResult(); if (response.IsSuccessStatusCode) { items = response.Content.ReadAsAsync <T_CMS_Master_EmploymentTypeCollection>().GetAwaiter().GetResult(); } } if (SystemConfig.AllowSearchCache) { HttpCache.Max(key, items); } return(items); }
/// <summary> /// use for scrolling page /// </summary> /// <returns></returns> public ContentResult GetPg(int page, int pagesize) { string condition = ""; SearchFilter SearchKey = SearchFilter.SearchPG(1, page, pagesize, "EmpTypeID", "EmpTypeID", "Desc", condition); T_CMS_Master_EmploymentTypeCollection objItem = T_CMS_Master_EmploymentTypeManager.Search(SearchKey); return(Content(JsonConvert.SerializeObject(objItem), "application/json")); }
public JsonResult GetGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { SearchFilter SearchKey = SearchFilter.SearchData(1, requestModel, "EmpTypeID", "EmpTypeID"); T_CMS_Master_EmploymentTypeCollection collection = T_CMS_Master_EmploymentTypeManager.Search(SearchKey); int TotalRecord = 0; if (collection.Count > 0) { TotalRecord = collection[0].TotalRecord; } return(Json(new DataTablesResponse(requestModel.Draw, collection, TotalRecord, TotalRecord), JsonRequestBehavior.AllowGet)); }
public static T_CMS_Master_EmploymentTypeCollection GetbyUser(string CreatedUser) { T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection(); T_CMS_Master_EmploymentType obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_EmploymentTypeCollection Search(SearchFilter SearchKey) { T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_EmploymentTypeCollection GetAllItem() { T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAll", null)) { while (reader.Read()) { T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
/// <summary> /// ExportExcel File /// </summary> /// <returns></returns> public string ExportExcel() { T_CMS_Master_EmploymentTypeCollection collection = T_CMS_Master_EmploymentTypeManager.GetAll(); DataTable dt = collection.ToDataTable <T_CMS_Master_EmploymentType>(); string fileName = "T_CMS_Master_EmploymentType_" + 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, "T_CMS_Master_EmploymentType List", false); return(fileName); }
public static T_CMS_Master_EmploymentTypeCollection GetAllItemByEnity(int EntityID) { T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@EntityID", EntityID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAllByEntityID", sqlParams)) { while (reader.Read()) { T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_EmploymentType GetAllByEntityID(int EntityID, string EmpTypeCode) { T_CMS_Master_EmploymentType objItem = null; T_CMS_Master_EmploymentTypeCollection items = GetAllByEntityID(EntityID); if (items.Count > 0) { foreach (T_CMS_Master_EmploymentType item in items) { if (item.EmpTypeCode.ToLower() == EmpTypeCode.ToLower()) { objItem = item; break; } } } return(objItem); }
public static T_CMS_Master_EmploymentTypeCollection GetAllByEntityID(int EntityID) { T_CMS_Master_EmploymentTypeCollection items = new T_CMS_Master_EmploymentTypeCollection(); string key = String.Format(SETTINGS_ALL_KEY_EntityID, EntityID);; object obj2 = HttpCache.Get(key); if ((obj2 != null)) { return((T_CMS_Master_EmploymentTypeCollection)obj2); } using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue)) { //HttpResponseMessage response = client.GetAsync(Resource).GetAwaiter().GetResult(); HttpResponseMessage response = client.GetAsync(string.Format(Resource + "?EntityID={0}&method=1", EntityID)).GetAwaiter().GetResult(); if (response.IsSuccessStatusCode) { items = response.Content.ReadAsAsync <T_CMS_Master_EmploymentTypeCollection>().GetAwaiter().GetResult(); } } HttpCache.Max(key, items); return(items); }
public static T_CMS_Master_EmploymentTypeCollection GetAllByUser(string CreatedUser) { T_CMS_Master_EmploymentTypeCollection items = new T_CMS_Master_EmploymentTypeCollection(); string key = String.Format(SETTINGS_User_KEY, CreatedUser); object obj2 = HttpCache.Get(key); if ((obj2 != null)) { return((T_CMS_Master_EmploymentTypeCollection)obj2); } using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue)) { HttpResponseMessage response = client.GetAsync(string.Format(Resource + "/GetbyUser?usr={0}", CreatedUser)).GetAwaiter().GetResult(); if (response.IsSuccessStatusCode) { items = response.Content.ReadAsAsync <T_CMS_Master_EmploymentTypeCollection>().GetAwaiter().GetResult(); } } HttpCache.Max(key, items); return(items); }
public ActionResult list() { T_CMS_Master_EmploymentTypeCollection collection = T_CMS_Master_EmploymentTypeManager.GetAll(); return(View(ViewFolder + "list.cshtml", collection)); }