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