public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int month, int year, string filter = "")
{
var db = new Timekeeping_TimeSSNDal();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = pageIndex,
PageSize = pageSize,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetTimeKeepingMachine(baseListParam, month, year, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public ActionResult SaveListWorkingday(List <HR_WorkingDaySupplementSaveListType> Data)
{
SystemMessage result = new SystemMessage();
var db = new Timekeeping_TimeSSNDal();
foreach (var item in Data)
{
item.HourOff = item.FullHourOff;
item.CreatedBy = item.StaffID;
item.CreatedDate = DateTime.Now;
if (item.StaffID == 0)
{
item.StaffID = Global.CurrentUser.UserID;
}
if (item.Type != 5 && item.Type != 4)
{
item.PercentPayrollID = null;
}
if (((item.HourOff == null || item.TimeOfActual == null) && item.Type == 1) || ((item.FromTime == null || item.ToTime == null) && item.Type != 1))
{
result.Message = "4";
result.IsSuccess = false;
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
}
int OutPut = 0;
result = db.SaveListWorkingday(Data, out OutPut);
if (OutPut == 5)
{
result.Message = "2";
}
else if (OutPut == 2 && Data[0].ReasonType == 1214)
{
result.Message = "1";
}
else if (OutPut == 0)
{
result.Message = "0";
}
else if (OutPut == 3)
{
result.Message = "3";
}
else if (OutPut == 6)
{
result.Message = "6";
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult HR_CheckMissDayApproval()
{
var db = new Timekeeping_TimeSSNDal();
int ShowTabApproval = db.HR_CheckMissDayApproval(Global.CurrentUser.LoginUserId);
return(Content(JsonConvert.SerializeObject(new
{
ShowTabApproval = ShowTabApproval
})));
}
public ActionResult HR_WorkingDay_GetHour(int userid)
{
var db = new Timekeeping_TimeSSNDal();
var result = db.HR_WorkingDay_GetHour(userid);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult GetCustomerContacts(int customerid)
{
var db = new Timekeeping_TimeSSNDal();
int roleid = Global.CurrentUser.RoleId;
var result = db.GetCustomerContacts(customerid, roleid);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult SaveBoSungCong(HR_WorkingDaySupplement entity)
{
var db = new Timekeeping_TimeSSNDal();
DateTime now = DateTime.Now;
//entity.StaffID = Global.CurrentUser.UserID;
entity.CreatedBy = entity.StaffID;
entity.CreatedDate = now;
int checkduyetbosung = 0;
var result = new SystemMessage();
checkduyetbosung = db.HR_WorkingDaySupplement_CheckExists(entity);
if (checkduyetbosung == 1)
{
if (((entity.HourOff == null || entity.TimeOfActual == null) && entity.Type == 1) || ((entity.FromTime == null || entity.ToTime == null) && entity.Type != 1))
{
result.Message = "4";
}
else
{
if (entity.Type != 5 && entity.Type != 4)
{
entity.PercentPayrollID = null;
}
result = db.SaveBoSungCong(entity);
if (result.IsSuccess == true)
{
result.Message = AppRes.MS_Update_success;
}
}
}
else if (checkduyetbosung == 0)
{
result.Message = "0";
}
else if (checkduyetbosung == 2)
{
result.Message = "2";
}
else if (checkduyetbosung == 3)
{
result.Message = "3";
}
else if (checkduyetbosung == 6)
{
result.Message = "6";
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult GetDateApproval(int userid)
{
var db = new Timekeeping_TimeSSNDal();
if (userid == 0)
{
userid = Global.CurrentUser.LoginUserId;
}
var result = db.GetDateApproval(userid);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult HR_WorkingDay_GetHour(int userid)
{
var db = new Timekeeping_TimeSSNDal();
if (userid == 0)
{
userid = Global.CurrentUser.LoginUserId;
}
var result = db.HR_WorkingDay_GetHour(userid);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult Merge(int WorkingDayMachineIDOld, int WorkingDayMachineIDNew, string ListUserId, DateTime FromDate)
{
var db = new Timekeeping_TimeSSNDal();
SystemMessage result = new SystemMessage();
result = db.Merge(WorkingDayMachineIDOld, WorkingDayMachineIDNew, ListUserId, FromDate);
if (result.IsSuccess == true)
{
result.Message = AppRes.MergeSuccess;
}
else
{
result.Message = AppRes.MS_Update_error;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult HR_WorkingDaySupplement_Send(int user)
{
var db = new Timekeeping_TimeSSNDal();
int userid = user;
if (userid == 0)
{
userid = Global.CurrentUser.LoginUserId;
}
var result = db.HR_WorkingDaySupplement_Send(userid);
if (result.IsSuccess == true)
{
result.Message = AppRes.MS_Update_success;
}
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
