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));
}
