public ActionResult Create()
{
ViewBag.employee = dbcontext.Employee_Profile.ToList().Select(m => new { Code = "" + m.Code + "-----[" + m.Full_Name + ']', ID = m.ID }).ToList();
ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
var req = dbcontext.check_Request.ToList();
var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Basic).Structure_Code;
string number;
if (req.Count > 0)
{
number = stru + (req.LastOrDefault().ID + 1).ToString();
}
else
{
number = stru + 1;
}
var check_Request_model = new check_Request {
Request_number = number, check_number = 0.ToString(), Request_date = DateTime.Now.Date, Check_Due_date = DateTime.Now.Date, month = 1, year = 2020, amount = 0.00
};
var check_request_change_status = new check_request_change_status {
Date = DateTime.Now.Date, selected_directedto = 0, selected_signby = 0
};
var model = new Check_Request_VM {
check_Request = check_Request_model, check_request_change_status = check_request_change_status
};
return(View(model));
}
public ActionResult history(string id)
{
try
{
var ID = int.Parse(id);
var request = dbcontext.check_Request.FirstOrDefault(m => m.ID == ID);
var status_id = int.Parse(request.check_request_change_statusID);
var all_statues = dbcontext.check_request_change_status.FirstOrDefault(m => m.ID == status_id);
if (all_statues.selected_signby > 0)
{
all_statues.Sign_by = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == all_statues.selected_signby);
}
if (all_statues.selected_directedto > 0)
{
all_statues.Directed_to = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == all_statues.selected_directedto);
}
var model = new Check_Request_VM
{
check_Request = request,
check_request_change_status = all_statues
};
return(View(model));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Delete(string id)
{
try
{
ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
var ID = int.Parse(id);
var request = dbcontext.check_Request.FirstOrDefault(m => m.ID == ID);
var statue_ID = int.Parse(request.check_request_change_statusID);
var request_statue = dbcontext.check_request_change_status.FirstOrDefault(m => m.ID == statue_ID);
var model = new Check_Request_VM {
check_Request = request, check_request_change_status = request_statue
};
if (model != null)
{
return(View(model));
}
else
{
TempData["Message"] = HR.Resource.Basic.thereisnodata;
return(View());
}
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Deletemethod(string id)
{
try
{
ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
var ID = int.Parse(id);
var request = dbcontext.check_Request.FirstOrDefault(m => m.ID == ID);
var statue_ID = int.Parse(request.check_request_change_statusID);
var request_statue = dbcontext.check_request_change_status.FirstOrDefault(m => m.ID == statue_ID);
var model = new Check_Request_VM {
check_Request = request, check_request_change_status = request_statue
};
dbcontext.check_Request.Remove(request);
dbcontext.check_request_change_status.Remove(request_statue);
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("check request transaction", HR.Models.user.Action.delete, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult Edit(string id)
{
try
{
ViewBag.employee = dbcontext.Employee_Profile.ToList().Select(m => new { Code = "" + m.Code + "-----[" + m.Full_Name + ']', ID = m.ID }).ToList();
ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
var ID = int.Parse(id);
var request = dbcontext.check_Request.FirstOrDefault(m => m.ID == ID);
var statue_ID = int.Parse(request.check_request_change_statusID);
var request_statue = dbcontext.check_request_change_status.FirstOrDefault(m => m.ID == statue_ID);
var model = new Check_Request_VM {
check_Request = request, check_request_change_status = request_statue
};
return(View(model));
}
catch (Exception e)
{ return(View()); }
}
public ActionResult Create(Check_Request_VM model)
{
try
{
ViewBag.employee = dbcontext.Employee_Profile.ToList().Select(m => new { Code = "" + m.Code + "-----[" + m.Full_Name + ']', ID = m.ID }).ToList();
ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID });
if (model.check_Request.check_number == 0.ToString() || model.check_Request.check_number == null)
{
TempData["Message"] = HR.Resource.Basic.YouMustenterchecknumber;
return(View(model));
}
var check_request_change_status_record = new check_request_change_status();
if (model.check_request_change_status.selected_signby > 0)
{
check_request_change_status_record.selected_signby = model.check_request_change_status.selected_signby;
check_request_change_status_record.Sign_by = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == model.check_request_change_status.selected_signby);
}
else
{
check_request_change_status_record.Sign_by = null;
}
if (model.check_request_change_status.selected_directedto > 0)
{
check_request_change_status_record.selected_directedto = model.check_request_change_status.selected_directedto;
check_request_change_status_record.Directed_to = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == model.check_request_change_status.selected_directedto);
}
else
{
check_request_change_status_record.Directed_to = null;
}
check_request_change_status_record.Date = model.check_request_change_status.Date;
check_request_change_status_record.Comment = model.check_request_change_status.Comment;
check_request_change_status_record.check_request_statusID = model.check_request_change_status.check_request_statusID;
var ID = int.Parse(model.check_request_change_status.check_request_statusID);
check_request_change_status_record.check_Request = dbcontext.check_request_status.FirstOrDefault(m => m.ID == ID);
var check_request_change_status = dbcontext.check_request_change_status.Add(check_request_change_status_record);
dbcontext.SaveChanges();
if (check_request_change_status != null)
{
var check_request_record = new check_Request();
check_request_record.Request_date = model.check_Request.Request_date;
check_request_record.month = model.check_Request.month;
check_request_record.year = model.check_Request.year;
check_request_record.amount = model.check_Request.amount;
check_request_record.check_number = model.check_Request.check_number;
check_request_record.Check_Due_date = model.check_Request.Check_Due_date;
check_request_record.Description = model.check_Request.Description;
check_request_record.Comment = model.check_Request.Comment;
check_request_record.Request_number = model.check_Request.Request_number;
var ID_ = int.Parse(model.check_Request.ChecktypeID);
check_request_record.ChecktypeID = model.check_Request.ChecktypeID;
check_request_record.Checktype = dbcontext.Checktype.FirstOrDefault(m => m.ID == ID_);
check_request_record.check_request_change_statusID = check_request_change_status.ID.ToString();
check_request_record.check_request_change_status = check_request_change_status;
check_request_record.Sourcedocumentdescription = model.check_Request.Sourcedocumentdescription;
check_request_record.Sourcedocumentnotes = model.check_Request.Sourcedocumentnotes;
check_request_record.Sourcedocumentreference = model.check_Request.Sourcedocumentreference;
dbcontext.check_Request.Add(check_request_record);
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("check request transaction", HR.Models.user.Action.Create, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
else
{
TempData["Message"] = HR.Resource.Basic.YouMustentercheckrequeststatu;
return(View(model));
}
}
catch (Exception e)
{
return(View(model));
}
}
