public JsonResult GetGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { SearchFilter SearchKey = SearchFilter.SearchData(CurrentUser.CompanyID, requestModel, "ID", "ID"); T_COM_Master_EntityCollection EntityAllows = T_COM_Master_EntityManager.GetAllByEmployeeCode(CurrentUser.EmployeeCode); T_COM_Master_Entity entity; if (EntityAllows.Count > 0) { SearchKey.Condition += " (Entity_Id in ( "; for (int i = 0; i < EntityAllows.Count; i++) { entity = EntityAllows[i]; SearchKey.Condition += " '" + entity.EntityId + "' "; if (i != EntityAllows.Count - 1) { SearchKey.Condition += " , "; } } SearchKey.Condition += ") ) "; } T_CMS_Master_InternshipCollection collection = T_CMS_Master_InternshipManager.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_InternshipCollection Search(SearchFilter value) { T_CMS_Master_InternshipCollection items = new T_CMS_Master_InternshipCollection(); string key = string.Format(SETTINGS_Search_KEY, value.Keyword, value.Page, value.PageSize, value.OrderBy, value.OrderDirection, value.Condition); if (SystemConfig.AllowSearchCache) { object obj2 = HttpCache.Get(key); if ((obj2 != null)) { return((T_CMS_Master_InternshipCollection)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_InternshipCollection>().GetAwaiter().GetResult(); } } if (SystemConfig.AllowSearchCache && items.Count > 0) { HttpCache.Max(key, items); } return(items); }
/// <summary> /// Upload The Excel File /// </summary> /// <returns></returns> public ContentResult ImportExcelFile() { JsonObject obj = new JsonObject(); HttpPostedFileBase file = Request.Files[0] as HttpPostedFileBase; // string fileName = file.FileName; // string fileContentType = file.ContentType; // byte[] fileBytes = new byte[file.ContentLength]; // var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); //DataTable dt = ExcelHelper.getClassFromExcelPackage<T_CMS_Master_Internship>(file.InputStream, 2,1); obj.StatusCode = 200; obj.Message = "Upload Success"; try { DataTable dt = ExcelHelper.ToDataTable(file.InputStream); IEnumerable <T_CMS_Master_Internship> objItemList = ExcelHelper.ToDataTable(file.InputStream).ToList <T_CMS_Master_Internship>(); T_CMS_Master_InternshipCollection ErrorList = T_CMS_Master_InternshipManager.ImportData(objItemList, CurrentUser.EmployeeCode); obj.Data = ErrorList; if (ErrorList.Count > 0) { obj.StatusCode = 400; obj.Message = "Can't import into system :" + ErrorList.Count + "/" + objItemList.Count <T_CMS_Master_Internship>(); } //obj.Data = dt; } catch (Exception objEx) { obj.StatusCode = 400; obj.Message = objEx.Message; } return(Content(JsonConvert.SerializeObject(obj), "application/json")); }
public ContentResult Search(SearchFilter SearchKey) { SearchKey.OrderBy = string.IsNullOrEmpty(SearchKey.OrderBy) ? "ID" : SearchKey.OrderBy; T_CMS_Master_InternshipCollection collection = T_CMS_Master_InternshipManager.Search(SearchKey); return(Content(JsonConvert.SerializeObject(collection), "application/json")); }
/// <summary> /// use for scrolling page /// </summary> /// <returns></returns> public ContentResult GetPg(int page, int pagesize) { string condition = ""; SearchFilter SearchKey = SearchFilter.SearchPG(1, page, pagesize, "ID", "ID", "Desc", condition); T_CMS_Master_InternshipCollection objItem = T_CMS_Master_InternshipManager.Search(SearchKey); return(Content(JsonConvert.SerializeObject(objItem), "application/json")); }
public static T_CMS_Master_InternshipCollection GetbyUser(string CreatedUser) { T_CMS_Master_InternshipCollection collection = new T_CMS_Master_InternshipCollection(); T_CMS_Master_Internship obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Internship_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_InternshipCollection Search(SearchFilter SearchKey) { T_CMS_Master_InternshipCollection collection = new T_CMS_Master_InternshipCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Internship_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey))) { while (reader.Read()) { T_CMS_Master_Internship obj = new T_CMS_Master_Internship(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Master_InternshipCollection GetAllItem() { T_CMS_Master_InternshipCollection collection = new T_CMS_Master_InternshipCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_Internship_GetAll", null)) { while (reader.Read()) { T_CMS_Master_Internship obj = new T_CMS_Master_Internship(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
/// <summary> /// ExportExcel File /// </summary> /// <returns></returns> public string ExportExcel() { T_CMS_Master_InternshipCollection collection = T_CMS_Master_InternshipManager.GetAll(); DataTable dt = collection.ToDataTable <T_CMS_Master_Internship>(); string fileName = "T_CMS_Master_Internship_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy"); string[] RemoveColumn = { "CompanyID", "ID", "InternNo", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate", "EmployeeCode", "SalutationID", "ProbationsPeriodCD", "FullName", "StatusID", "ApproverLevel", "InternLevel", "IDCardNo", "PassportNo", "DeptID", "LocationID", "EmpTypeID", "EmpSubTypeID", "IsActive", "CreatedBy", "ModifiedBy", "ModifiedDate", "ErrorMesssage","Dept","WorkHours", "UniversityID" }; 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_Internship List", false); return(fileName); }
public static T_CMS_Master_InternshipCollection GetAll() { T_CMS_Master_InternshipCollection items = new T_CMS_Master_InternshipCollection(); string key = SETTINGS_ALL_KEY; object obj2 = HttpCache.Get(key); if ((obj2 != null)) { return((T_CMS_Master_InternshipCollection)obj2); } using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue)) { HttpResponseMessage response = client.GetAsync(Resource).GetAwaiter().GetResult(); if (response.IsSuccessStatusCode) { items = response.Content.ReadAsAsync <T_CMS_Master_InternshipCollection>().GetAwaiter().GetResult(); } } HttpCache.Max(key, items); return(items); }
public static T_CMS_Master_InternshipCollection ImportData(IEnumerable <T_CMS_Master_Internship> objItemList, int EmployeeCode) { T_COm_Master_Org objOrg; T_CMS_Master_WorkHours objWH; T_COM_Master_University objUni; T_CMS_Master_EmploymentType objEmpType; //T_CMS_Master_EmploymentTypeCollection objEmpTypes; T_CMS_Master_EmploymentSubType objEmpSubType; T_CMS_Master_InternshipCollection ErrorList = new T_CMS_Master_InternshipCollection(); int SaluationID = 1; bool isError = false; string strError = ""; string EntityList = ""; T_COM_Master_EntityCollection EntityAllows = T_COM_Master_EntityManager.GetAllByEmployeeCode(EmployeeCode); foreach (T_COM_Master_Entity entity in EntityAllows) { EntityList += entity.EntityId + ";"; } foreach (T_CMS_Master_Internship objitem in objItemList) { isError = false; strError = ""; try { objOrg = T_COm_Master_OrgManager.GetByOrgName(objitem.DepartCD); objWH = T_CMS_Master_WorkHoursManager.GetByWorkHours(objitem.WorkHoursCD); if (objWH.WorkHoursID == 0) { strError += "<div>Invalid Work Hours Name: <span class='impval'>" + objitem.WorkHoursCD + "</span></div>"; //ErrorList.Add(AddErrorMessage(objitem, "Invalid Work Hours Name:" + objitem.WorkHoursCD)); isError = true; } if (objOrg.OrgId == 0) { strError += "<div>Invalid Depart Name: <span class='impval'>" + objitem.DepartCD + "</span></div>"; //ErrorList.Add(AddErrorMessage(objitem, "Invalid Work Hours Name:" + objitem.WorkHoursCD)); isError = true; } if (!string.IsNullOrEmpty(objitem.UniversityCD)) { objUni = T_COM_Master_UniversityManager.GetByName(objitem.UniversityCD); if (objUni.UniversityID == 0) { strError += "<div>Invalid University Name: <span class='impval'>" + objitem.UniversityCD + "</span></div>"; //ErrorList.Add(AddErrorMessage(objitem, "Invalid Work Hours Name:" + objitem.WorkHoursCD)); isError = true; } else { objitem.UniversityID = objUni.UniversityID; } } if (EntityList.IndexOf(objOrg.Entity_Id.ToString()) == -1) { strError += "<div>You don't have Permission to Import to this Group: <span class='impval'>" + objitem.DepartCD + " </span></div>"; //ErrorList.Add(AddErrorMessage(objitem, "Invalid Grade Name:" + objitem.GradeName)); isError = true; } if (isError) { objitem.ErrorMesssage += "<div>" + strError + "</div>"; ErrorList.Add(objitem); continue; } if (objitem.SalutationCD.IndexOf("Ms") != -1) { objitem.StatusID = 2; } else if (objitem.SalutationCD.IndexOf("Mrs") != -1) { objitem.StatusID = 3; } else { objitem.StatusID = 1; } //get emp subtype by entity and internship objEmpType = T_CMS_Master_EmploymentTypeManager.GetAllByEntityID(objOrg.Entity_Id, "I"); if (objEmpType != null) { objitem.EmpTypeID = objEmpType.EmpTypeID; objEmpSubType = T_CMS_Master_EmploymentSubTypeManager.GetEmpTypeID(objEmpType.EmpTypeID, "Intern"); if (objEmpSubType != null) { objitem.EmpSubTypeID = objEmpSubType.EmpSubTypeID; } } DateTime enddate = objitem.Joiningdate.AddMonths(objitem.PeriodofInternship); enddate = enddate.AddDays(-1); objitem.Enddate = enddate; objitem.DeptID = objOrg.OrgId; objitem.WorkHours = objWH.WorkHoursID; objitem.CreatedBy = EmployeeCode; objitem.CreatedDate = SystemConfig.CurrentDate; Add(objitem); } catch (Exception ObjEx) { objitem.ErrorMesssage += "<div>" + ObjEx.Message + "</div>"; ErrorList.Add(objitem); } } return(ErrorList); }
public ActionResult list() { T_CMS_Master_InternshipCollection collection = T_CMS_Master_InternshipManager.GetAll(); return(View(ViewFolder + "list.cshtml", collection)); }