public ActionResult AddProgress(emp_progresses emp_progresses)
{
try
{
if (ModelState.IsValid)
{
int flag = EmployeeControllerManager.saveProgress(emp_progresses);
if (flag == 1)
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.projectList = EmployeeControllerManager.getPorjectList();
return(View());
}
}
else
{
ViewBag.projectList = EmployeeControllerManager.getPorjectList();
return(View());
}
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
//insert
public int saveProgressDB(emp_progresses progress)
{
try
{
db.emp_progresses.Add(progress);
return(db.SaveChanges());
}
catch (Exception)
{
throw;
}
}
public int deleteProgress(int id, emp_progresses progress)
{
try
{
progress.emp_progress_status = 0;
return(EmployeeProgressesServices.deleteProgressDB(id, progress));
}
catch (Exception)
{
throw;
}
}
public int updateProgress(int id, emp_progresses emp_progresses)
{
try
{
emp_progresses.emp_progress_month_year = emp_progresses.emp_progress_month_year.Substring(0, 7);
return(EmployeeProgressesServices.updateProgressDB(id, emp_progresses));
}
catch (Exception)
{
throw;
}
}
public int saveProgress(emp_progresses progress)
{
try
{
progress.emp_progress_status = 1;
progress.emp_progress_month_year = progress.emp_progress_month_year.Substring(0, 7);
return(EmployeeProgressesServices.saveProgressDB(progress));
}
catch (Exception)
{
throw;
}
}
public emp_progresses getProgressWithEmpIdDB(int id)
{
try
{
emp_progresses emp_progresses = new emp_progresses();
emp_progresses.emp_id = id;
emp_progresses.emp_progress_status = 1;
return(emp_progresses);
}
catch (Exception)
{
throw;
}
}
public int saveProgressDB(emp_progresses emp_progresses)
{
int flag = 0;
try
{
db.emp_progresses.Add(emp_progresses);
db.SaveChanges();
flag = 1;
}
catch (Exception)
{
throw;
}
return(flag);
}
public ActionResult Delete(int id, emp_progresses emp_progresses)
{
try
{
if (ModelState.IsValid)
{
int flag = EmployeeProgressesControllerManager.deleteProgress(id, emp_progresses);
if (flag == 1)
{
return(RedirectToAction("Index"));
}
}
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Edit(int id, emp_progresses emp_progresses)
{
try
{
if (ModelState.IsValid)
{
int flag = EmployeeProgressesControllerManager.updateProgress(id, emp_progresses);
if (flag == 1)
{
return(RedirectToAction("Index"));
}
}
ViewBag.month = EmployeeProgressesControllerManager.getMonth();
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home"));
}
}
//delete
public int deleteProgressDB(int id, emp_progresses progress)
{
int flag = 0;
try
{
var result = db.emp_progresses.Where(p => p.emp_progress_id == id && p.emp_progress_status == 1);
if (result != null)
{
db.Entry(result).State = EntityState.Detached;
db.Entry(progress).State = EntityState.Modified;
db.SaveChanges();
flag = 1;
}
}
catch (Exception)
{
throw;
}
return(flag);
}
