public void Remove(int id)
{
UserShift userShift = db.UserShift.Find(id);
db.UserShift.Remove(userShift);
db.SaveChanges();
}
public Result FinishUserShift(UserShift _userShift)
{
Result result = new Result();
if (getCurrentUser() == null)
{
result.Message = "Session Expired !! Please reload Page ";
}
else
{
UserShift userShift = iuserShift.GetUserShift(_userShift.us_id);
if (userShift != null)
{
if (_userShift.us_end_date >= userShift.us_start_date)
{
userShift.us_end_date = _userShift.us_end_date;
iuserShift.Update(userShift);
result.Message = "Success";
}
else
{
result.Message = "End Date Should be greater than Start date ";
}
}
else
{
result.Message = "Data Not Found!!!";
}
}
return(result);
}
public async Task <IActionResult> UpdateUserShift([FromBody] UpdateUserDto updatedUser)
{
var newUser = new User
{
UserId = updatedUser.UserId,
AccountId = updatedUser.AccountId,
FirstName = updatedUser.FirstName,
LastName = updatedUser.LastName,
Gender = updatedUser.Gender,
DepartmentId = updatedUser.DepartmentId,
PositionId = updatedUser.PositionId
};
await _userShiftRepo.DeleteAsync(d => d.UserId == updatedUser.UserId);
await _userRepo.UpdateAsync(newUser);
if (updatedUser.UserShifts.Count > 0)
{
foreach (var userShift in updatedUser.UserShifts)
{
var newUserShift = new UserShift
{
ShiftId = userShift.ShiftId,
UserId = userShift.UserId,
Day = userShift.Day
};
await _userShiftRepo.CreateAsync(newUserShift);
}
}
return(Ok(await GetUserList()));
}
public NDbResult <List <UserShift> > GetUnCloseUserShifts()
{
NDbResult <List <UserShift> > result;
result = UserShift.GetUnCloseUserShifts();
return(result);
}
public ActionResult Edit(int id, UserShift userShift)
{
if (getCurrentUser() == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
if (userShift.us_end_date >= userShift.us_start_date)
{
UserShift _userShift = iuserShift.GetUserShift(id);
_userShift.us_end_date = userShift.us_end_date;
_userShift.us_start_date = userShift.us_start_date;
_userShift.us_u_id = userShift.us_u_id;
iuserShift.Update(_userShift);
return(RedirectToAction(nameof(Index)));
}
else
{
ViewBag.Message = "End Date Should be greater than start date !!";
return(View());
}
}
catch (Exception ex)
{
ViewBag.Message = ex.Message + " " + ex.InnerException;
return(View());
}
}
}
private void cmdOK_Click(object sender, RoutedEventArgs e)
{
if (cbShift.SelectedIndex == -1)
{
cbShift.Focus();
return;
}
Shift shift = cbShift.SelectedItem as Shift;
if (null != shift)
{
UserShift inst = ops.UserShifts.Create(shift, _user).Value();
if (null != inst)
{
shift.AssignTo(inst);
}
var success = ops.UserShifts.BeginUserShift(inst).Ok;
if (!success)
{
DMT.Windows.MessageBoxWindow msg = new DMT.Windows.MessageBoxWindow();
msg.Owner = Application.Current.MainWindow;
msg.Setup("ไม่สามารถเปิดกะใหม่ได้ เนื่องจาก ยังมีกะที่ยังไม่ป้อนรายได้", "DMT - Tour of Duty");
if (msg.ShowDialog() == true)
{
}
}
}
DialogResult = true;
}
public NRestResult <List <LaneAttendance> > GetAllAttendancesByUserShift(
UserShift value)
{
NRestResult <List <LaneAttendance> > ret;
NRestClient client = NRestClient.CreateLocalClient();
if (null == client)
{
ret = new NRestResult <List <LaneAttendance> >();
ret.RestInvalidConfig();
return(ret);
}
if (null != value)
{
ret = client.Execute <List <LaneAttendance> >(
RouteConsts.Lane.GetAllAttendancesByUserShift.Url, value);
}
else
{
ret = new NRestResult <List <LaneAttendance> >();
ret.ParameterIsNull();
}
return(ret);
}
public UserShift Create([FromBody] UserShiftCreate value)
{
if (null == value)
{
return(null);
}
return(UserShift.Create(value.Shift, value.User));
}
public UserShift GetCurrent([FromBody] User value)
{
if (null == value)
{
return(null);
}
return(UserShift.GetCurrent(value.UserId));
}
public bool BeginJob([FromBody] UserShift shift)
{
if (null == shift)
{
return(false);
}
return(UserShift.BeginJob(shift));
}
public void EndJob([FromBody] UserShift shift)
{
if (null == shift)
{
return;
}
UserShift.EndJob(shift);
}
public List <UserShift> GetUserShifts([FromBody] User value)
{
if (null == value)
{
return(new List <UserShift>());
}
return(UserShift.GetUserShifts(value.UserId));
}
public bool BeginJob(UserShift shift)
{
if (null == shift)
{
return(false);
}
return(NRestClient.Create(port: 9000).Execute <bool>(
RouteConsts.Job.BeginJob.Url, shift));
}
public void EndJob(UserShift shift)
{
if (null == shift)
{
return;
}
NRestClient.Create(port: 9000).Execute(
RouteConsts.Job.EndJob.Url, shift);
}
private void RefreshLane(UserShift userShift)
{
lstLaneJobs.ItemsSource = null;
if (null == userShift)
{
return;
}
var lanes = ops.Lanes.GetAllAttendancesByUserShift(userShift).Value();
lstLaneJobs.ItemsSource = lanes;
}
public DbResult Add(UserShift userShift)
{
var us_u_id = new SqlParameter("us_u_id", userShift.us_u_id + "");
var us_start_time = new SqlParameter("us_start_time", userShift.us_start_time + "");
var us_end_time = new SqlParameter("us_end_time", userShift.us_end_time + "");
var us_start_date = new SqlParameter("us_start_date", userShift.us_start_date + "");
var us_cre_by = new SqlParameter("us_cre_by", userShift.us_cre_by + "");
var result = db.DbResult.FromSqlRaw <DbResult>
("EXECUTE dbo.createUserShift @us_u_id,@us_start_time,@us_end_time,@us_start_date,@us_cre_by",
us_u_id, us_start_time, us_end_time, us_start_date, us_cre_by).ToList().FirstOrDefault();
return(result);
}
public NDbResult <UserShift> Create([FromBody] UserShiftCreate value)
{
NDbResult <UserShift> result;
if (null == value)
{
result = new NDbResult <UserShift>();
result.ParameterIsNull();
}
else
{
result = UserShift.Create(value.Shift, value.User);
}
return(result);
}
public NDbResult <UserShift> GetCurrent([FromBody] User value)
{
NDbResult <UserShift> result;
if (null == value)
{
result = new NDbResult <UserShift>();
result.ParameterIsNull();
}
else
{
result = UserShift.GetUserShift(value.UserId);
}
return(result);
}
public NDbResult SaveUserShift([FromBody] UserShift value)
{
NDbResult result;
if (null == value)
{
result = new NDbResult <Shift>();
result.ParameterIsNull();
}
else
{
result = UserShift.Save(value);
}
return(result);
}
public NDbResult <List <LaneAttendance> > GetAllAttendancesByUserShift([FromBody] UserShift value)
{
NDbResult <List <LaneAttendance> > result;
if (null == value)
{
result = new NDbResult <List <LaneAttendance> >();
result.ParameterIsNull();
}
else
{
result = LaneAttendance.Search(value);
}
return(result);
}
public DbResult Create(UserShift userShift)
{
DbResult result = new DbResult();
User user = getCurrentUser();
if (user != null)
{
result = iuserShift.Add(userShift);
}
else
{
result.Message = "Session Expired ! Please Reload !!!";
}
return(result);
}
public void Setup(User user, UserShift userShift, PlazaGroup plazaGroup,
UserShiftRevenue plazaRevenue,
List <LaneAttendance> laneActivities,
DateTime entryDate, DateTime revDate,
Models.RevenueEntry revenueEntry)
{
_user = user;
_userShift = userShift;
_plazaGroup = plazaGroup;
_plazaRevenue = plazaRevenue;
_laneActivities = laneActivities;
_entryDate = entryDate;
_revDate = revDate;
_revenueEntry = revenueEntry;
if (null != _revenueEntry)
{
if (_revenueEntry.RevenueId == string.Empty ||
_revenueEntry.EntryDate == DateTime.MinValue ||
_revenueEntry.RevenueDate == DateTime.MinValue)
{
InitNewReport();
}
}
var model = GetReportModel();
if (null == model ||
null == model.DataSources || model.DataSources.Count <= 0 ||
null == model.DataSources[0] || null == model.DataSources[0].Items)
{
DMT.Windows.MessageBoxWindow msg = new DMT.Windows.MessageBoxWindow();
msg.Owner = Application.Current.MainWindow;
msg.Setup("No result found.", "DMT - Tour of Duty");
if (msg.ShowDialog() == true)
{
this.rptViewer.ClearReport();
}
}
else
{
this.rptViewer.LoadReport(model);
}
}
public NRestResult SaveUserShift(UserShift value)
{
NRestResult ret;
NRestClient client = NRestClient.CreateLocalClient();
if (null == client)
{
ret = new NRestResult();
ret.RestInvalidConfig();
return(ret);
}
if (null != value)
{
ret = client.Execute(RouteConsts.UserShift.SaveUserShift.Url, value);
}
else
{
ret = new NRestResult();
ret.ParameterIsNull();
}
return(ret);
}
public void Update(UserShift userShift)
{
db.UserShift.Update(userShift);
db.SaveChanges();
}
public UserShift GetUserShift(int id)
{
UserShift userShift = db.UserShift.Find(id);
return(userShift);
}
