public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Clients_Id,WorkshiftCategories_Id,DayOfWeek,Start,DurationMinutes,Notes,Active")] WorkshiftTemplateModels workshiftTemplateModels)
{
int check = (from wt in db.WsTemplate
where wt.Name == workshiftTemplateModels.Name &&
wt.Clients_Id == workshiftTemplateModels.Clients_Id &&
wt.WorkshiftCategories_Id == workshiftTemplateModels.WorkshiftCategories_Id &&
wt.DayOfWeek == workshiftTemplateModels.DayOfWeek &&
wt.Start == workshiftTemplateModels.Start &&
wt.DurationMinutes == workshiftTemplateModels.DurationMinutes
select wt).Count();
if (check > 0)
{
ModelState.AddModelError("Duplicate", "Data Workshift Templates already exist!");
}
if (ModelState.IsValid)
{
db.Entry(workshiftTemplateModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName");
ViewBag.listCategory = new SelectList(db.WsCategory.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name");
var dow = from Common.Master.DayOfWeek d in Enum.GetValues(typeof(Common.Master.DayOfWeek))
select new { Id = (byte)d, Name = d.ToString() };
ViewBag.listDOW = new SelectList(dow, "Id", "Name");
return(View(workshiftTemplateModels));
}
public ActionResult Edit([Bind(Include = "Id,Name,StartDate,EndDate,Status")] Training training)
{
if (ModelState.IsValid)
{
db.Entry(training).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(training));
}
public ActionResult Edit([Bind(Include = "Id,Name,Description")] Position position)
{
if (ModelState.IsValid)
{
db.Entry(position).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(position));
}
public ActionResult Edit([Bind(Include = "EmployeeId,FirstName,LastName,DateBirthday,INN")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public IActionResult Edit(Employee employee)
{
if (ModelState.IsValid)
{
_context.Entry(employee).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Notes,Active")] WorkshiftCategoryModels workshiftCategoryModels)
{
if (ModelState.IsValid)
{
db.Entry(workshiftCategoryModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(workshiftCategoryModels));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,CompanyName,Address,BillingAddress,ContactPersonName,Phone1,Phone2,Notes,NPWP,NPWPAddress,Active")] ClientModels clientModels)
{
if (ModelState.IsValid)
{
db.Entry(clientModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(clientModels));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,UserAccounts_Id,TimestampIn,TimestampOut,Notes,Flag1,Flag2,Approved,Workshifts_DayOfWeek,Workshifts_Start,Workshifts_DurationMinutes,EffectiveTimestampIn,EffectiveTimestampOut,Clients_Id,Rejected,PayrollItems_Id,AttendanceStatuses_Id,Workshifts_Id,AttendancePayRates_Id,AttendancePayRates_Amount")] AttendanceModels attendanceModels)
{
if (ModelState.IsValid)
{
attendanceModels.Workshifts_Start = attendanceModels.EffectiveTimestampIn;
attendanceModels.Workshifts_DurationMinutes = (int)attendanceModels.EffectiveTimestampOut.Subtract(attendanceModels.EffectiveTimestampIn).TotalMinutes;
db.Entry(attendanceModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName");
ViewBag.listEmployee = new SelectList(db.User.OrderBy(x => x.FullName).ToList(), "Id", "FullName");
ViewBag.listAttStatus = new SelectList(db.AttStatus.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name");
ViewBag.listWorkshift = new SelectList(db.Workshift.Where(x => x.UserAccounts_Id == attendanceModels.UserAccounts_Id && x.Clients_Id == attendanceModels.Clients_Id).OrderBy(x => x.Name).ToList(), "Id", "Name");
return(View(attendanceModels));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,RefId,AttendanceStatuses_Id,Amount,Notes,Active")] AttendancePayRateModels attendancePayRateModels)
{
if (ModelState.IsValid)
{
db.Entry(attendancePayRateModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName");
ViewBag.idClient = (from pr in db.AttPayRate
join wt in db.WsTemplate on pr.RefId equals wt.Id
join c in db.Clients on wt.Clients_Id equals c.Id
where pr.Id == attendancePayRateModels.Id
select c.Id).Single();
ViewBag.listWsTemplate = new SelectList(db.WsTemplate.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name");
ViewBag.listAttStatus = new SelectList(db.AttStatus.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name");
return(View(attendancePayRateModels));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Owner_Id,Owner_RefId,BankName,AccountNumber,Notes,Active,Internal")] BankAccountModels bankAccountModels)
{
if (ModelState.IsValid)
{
db.Entry(bankAccountModels).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
if (bankAccountModels.Owner_Id == 1)
{
ViewBag.listOwner = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName");
}
else
{
ViewBag.listOwner = new SelectList(db.User.OrderBy(x => x.FullName).ToList(), "Id", "FullName");
}
return(View(bankAccountModels));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,FullName,UserName,Email,RoleId,Identification,DOB,Height,Weight,Phone1,Phone2,Address1,Address2,Notes")] UserViewModel userModels)
{
if (ModelState.IsValid)
{
var user = new UserModels()
{
Id = userModels.Id,
FullName = userModels.FullName,
Email = userModels.Email,
Identification = userModels.Identification,
DOB = userModels.DOB,
Height = userModels.Height,
Weight = userModels.Weight,
Phone1 = userModels.Phone1,
Phone2 = userModels.Phone2,
Address1 = userModels.Address1,
Address2 = userModels.Address2,
Notes = userModels.Notes
};
var userRole = new UserRoleModels()
{
UserId = userModels.Id, RoleId = userModels.RoleId
};
using (var database = new HrContext())
{
database.User.Attach(user);
database.Entry(user).Property(x => x.FullName).IsModified = true;
database.Entry(user).Property(x => x.Email).IsModified = true;
database.Entry(user).Property(x => x.Identification).IsModified = true;
database.Entry(user).Property(x => x.DOB).IsModified = true;
database.Entry(user).Property(x => x.Height).IsModified = true;
database.Entry(user).Property(x => x.Weight).IsModified = true;
database.Entry(user).Property(x => x.Phone1).IsModified = true;
database.Entry(user).Property(x => x.Phone2).IsModified = true;
database.Entry(user).Property(x => x.Address1).IsModified = true;
database.Entry(user).Property(x => x.Address2).IsModified = true;
database.Entry(user).Property(x => x.Notes).IsModified = true;
database.UserRole.Attach(userRole);
database.Entry(userRole).Property(x => x.RoleId).IsModified = true;
await database.SaveChangesAsync();
}
return(RedirectToAction("Index"));
}
ViewBag.listRole = new SelectList(db.Role.OrderBy(x => x.Name).ToList(), "Id", "Name");
return(View(userModels));
}
