/// <summary>
/// use for setting up default value
/// </summary>
/// <returns></returns>
public ActionResult Update(int Id, string TargetID = "T_LMS_Trans_LeaveStorylist")
{
T_LMS_Trans_LeaveStory objItem = T_LMS_Trans_LeaveStoryManager.GetById(Id);
objItem.TargetDisplayID = TargetID;
return(View(ViewFolder + "Create.cshtml", objItem));
}
public ContentResult Save(string objdata, string value)
{
JsonObject js = new JsonObject();
js.StatusCode = 200;
js.Message = "Upload Success";
try
{
T_LMS_Trans_LeaveStory obj = JsonConvert.DeserializeObject <T_LMS_Trans_LeaveStory>(objdata);
obj = T_LMS_Trans_LeaveStoryManager.Update(obj);
if (obj.Id == 0)
{
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"));
}
public ActionResult T_LMS_Trans_LeaveStoryEvt(int[] Id, string Action)
{
// You have your books IDs on the deleteInputs array
switch (Action.ToLower())
{
case "delete":
if (Id != null && Id.Length > 0)
{
int length = Id.Length;
T_LMS_Trans_LeaveStory objItem;
for (int i = 0; i <= length - 1; i++)
{
objItem = T_LMS_Trans_LeaveStoryManager.GetById(Id[i]);
if (objItem != null)
{
T_LMS_Trans_LeaveStoryManager.Delete(objItem);
}
}
return(View(ViewFolder + "list.cshtml", T_LMS_Trans_LeaveStoryManager.GetAll()));
}
break;
}
return(View("PostFrm"));
}
public ActionResult Create(T_LMS_Trans_LeaveStory model)
{
try
{
if (ModelState.IsValid)
{
// model.CreatedUser = CurrentUser.UserName;
if (model.Id != 0)
{
//get default value
// T_LMS_Trans_LeaveStory b = T_LMS_Trans_LeaveStoryManager.GetById(model.Id);
T_LMS_Trans_LeaveStoryManager.Update(model);
}
else
{
// TODO: Add insert logic here
// model.CreatedDate = SystemConfig.CurrentDate;
T_LMS_Trans_LeaveStoryManager.Add(model);
}
return(View(ViewFolder + "list.cshtml", T_LMS_Trans_LeaveStoryManager.GetAll()));
}
}
catch
{
return(View(model));
}
return(View(model));
}
public ContentResult Lms(string EmployeeNo, string WD)
{
LeaveWFCollection collection = T_LMS_Trans_LeaveStoryManager.GetEmployeeLeaveReason(10001, EmployeeNo, WD);
return(Content(JsonConvert.SerializeObject(collection), "application/json"));
//return View(ViewFolder + "EmpTms.cshtml");
}
public string ExportExMonthTMS(int UserID, string MonthID, string FilterBy, string FilterValue)
{
External_TimesCollection collection = T_LMS_Trans_LeaveStoryManager.GetExMonthlyReport(UserID, MonthID, FilterBy, FilterValue);
DataSet ds = new DataSet();
DataTable dt = collection.ToDataTable <External_Times>();
string fileName = UserID + "_Monthly_TimeSheet_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy");
string[] sheetName = { "Daily_TMS" };
string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate", "ErrorMesssage" };
for (int i = 0; i < RemoveColumn.Length; i++)
{
if (dt.Columns.Contains(RemoveColumn[i]))
{
dt.Columns.Remove(RemoveColumn[i]);
}
}
ds.Tables.Add(dt);
//set Column Date Format
//int[] DateColumn = { 5, 6 };
//ExcelPara mypara = new ExcelPara()
//{
// ds = ds,
// sheetName = sheetName,
// fileName = fileName,
// DateColumns = DateColumn,
// DateFormat = "h:mm:ss tt"
//};
//FileInputHelper.ExportMultiSheetExcelExtend(mypara);
FileInputHelper.ExportExcel(dt, fileName, "Monthly_TimeSheet", false);
return(fileName);
}
public ContentResult Search(SearchFilter SearchKey)
{
SearchKey.OrderBy = string.IsNullOrEmpty(SearchKey.OrderBy) ? "Id" : SearchKey.OrderBy;
T_LMS_Trans_LeaveStoryCollection collection = T_LMS_Trans_LeaveStoryManager.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_LMS_Trans_LeaveStoryCollection objItem = T_LMS_Trans_LeaveStoryManager.Search(SearchKey);
return(Content(JsonConvert.SerializeObject(objItem), "application/json"));
}
public LeaveWFCollection Get(int EntityID, int EmployeeCode, DateTime WorkDate)
{
LeaveWFPara Filter = new LeaveWFPara()
{
EntityID = EntityID,
EmployeeCode = EmployeeCode,
WorkDate = WorkDate
};
return(T_LMS_Trans_LeaveStoryManager.GetLeaveReason(Filter));
}
public JsonResult GetGata([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
SearchFilter SearchKey = SearchFilter.SearchData(1, requestModel, "Id", "Id");
T_LMS_Trans_LeaveStoryCollection collection = T_LMS_Trans_LeaveStoryManager.Search(SearchKey);
int TotalRecord = 0;
if (collection.Count > 0)
{
TotalRecord = collection[0].TotalRecord;
}
return(Json(new DataTablesResponse(requestModel.Draw, collection, TotalRecord, TotalRecord), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// ExportExcel File
/// </summary>
/// <returns></returns>
public string ExportExcel()
{
T_LMS_Trans_LeaveStoryCollection collection = T_LMS_Trans_LeaveStoryManager.GetAll();
DataTable dt = collection.ToDataTable <T_LMS_Trans_LeaveStory>();
string fileName = "T_LMS_Trans_LeaveStory_" + 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_LMS_Trans_LeaveStory List", false);
return(fileName);
}
public ActionResult Update(T_LMS_Trans_LeaveStory model)
{
try
{
if (ModelState.IsValid)
{
// TODO: Add insert logic here
T_LMS_Trans_LeaveStoryManager.Update(model);
//return RedirectToAction("Index");
}
return(View(model));
}
catch
{
return(View(model));
}
}
/// <summary>
///
/// </summary>
/// <param name="UserID">Manager/DirectManagerID</param>
/// <param name="FD">FromDate</param>
/// <param name="TD">ToDate</param>
/// <param name="AID">Associate ID</param>
/// <returns></returns>
public string ExportExDailyTMS(int UserID, string FD, string TD, int AID)
{
DataSet ds = new DataSet();
ExternalDailyCollection collection = T_LMS_Trans_LeaveStoryManager.ExportExDailyTMS(UserID, FD, TD, AID);
DataTable dt = collection.ToDataTable <ExternalDaily>();
string fileName = AID + "_Monthly_TimeSheet_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy");
string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate", "ErrorMesssage" };
for (int i = 0; i < RemoveColumn.Length; i++)
{
if (dt.Columns.Contains(RemoveColumn[i]))
{
dt.Columns.Remove(RemoveColumn[i]);
}
}
if (collection.Count > 0)
{
ds.Tables.Add(dt);
int[] DateColumn = { 6, 7 };
string[] sheetName = { "Daily_TMS" };
ExcelPara mypara = new ExcelPara()
{
ds = ds,
sheetName = sheetName,
fileName = fileName,
DateColumns = DateColumn,
DateFormat = "h:mm:ss"
};
FileInputHelper.ExportMultiSheetExcelExtend(mypara);
}
else
{
FileInputHelper.ExportExcel(dt, fileName, "Monthly_TimeSheet", false);
}
//set Column Date Format
//
return(fileName);
}
public T_LMS_Trans_LeaveStoryCollection GetbyUser(string usr)
{
return(T_LMS_Trans_LeaveStoryManager.GetbyUser(usr));
}
// GET api/<controller>/5
/// <summary>
/// Gets the specified COM group identifier.
/// </summary>
/// <param name="T_LMS_Trans_LeaveStoryId">The COM group identifier.</param>
/// <returns></returns>
public T_LMS_Trans_LeaveStory Get(int Id)
{
return(T_LMS_Trans_LeaveStoryManager.GetItemByID(Id));
}
// POST api/<controller>
/// <summary>
/// Posts the specified value.
/// </summary>
/// <param name="value">The value.</param>
/// <returns></returns>
public T_LMS_Trans_LeaveStory Post([FromBody] T_LMS_Trans_LeaveStory value)
{
return(T_LMS_Trans_LeaveStoryManager.AddItem(value));
}
// PUT api/<controller>/5
/// <summary>
/// Puts the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="value">The value.</param>
/// <returns></returns>
/// <exception cref="HttpResponseException"></exception>
public T_LMS_Trans_LeaveStory Put(string id, [FromBody] T_LMS_Trans_LeaveStory value)
{
return(T_LMS_Trans_LeaveStoryManager.UpdateItem(value));
}
// GET api/<controller>
/// <summary>
/// Gets this instance.
/// </summary>
/// <returns></returns>
public T_LMS_Trans_LeaveStoryCollection Post(string method, [FromBody] SearchFilter value)
{
return(T_LMS_Trans_LeaveStoryManager.Search(value));
}
// DELETE api/<controller>/5
/// <summary>
/// Deletes the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
public void Delete(int id)
{
T_LMS_Trans_LeaveStoryManager.DeleteItem(id);
}
public LeaveWFCollection Get(LeaveWFPara Filter)
{
return(T_LMS_Trans_LeaveStoryManager.GetLeaveReason(Filter));
}
public ActionResult Get(int Id, string action)
{
T_LMS_Trans_LeaveStory objItem = T_LMS_Trans_LeaveStoryManager.GetById(Id);
return(Content(JsonConvert.SerializeObject(objItem), "application/json"));
}
public ActionResult Get(int Id)
{
T_LMS_Trans_LeaveStory objItem = T_LMS_Trans_LeaveStoryManager.GetById(Id);
return(View(objItem));
}
// GET api/<controller>
/// <summary>
/// Gets this instance.
/// </summary>
/// <returns></returns>
public T_LMS_Trans_LeaveStoryCollection Get()
{
return(T_LMS_Trans_LeaveStoryManager.GetAllItem());
}
