// GET: IncidentRequest/Create
public ActionResult Create()
{
IncidentRequestViewModel model = new IncidentRequestViewModel();
using (TehnicalDepartmentDb db = new TehnicalDepartmentDb())
{
List <Department> departments = db.Departments.ToList();
foreach (var d in departments)
{
model.departmentsList.Add(new SelectListItem {
Text = d.name, Value = d.name.ToString()
});
}
return(View(model));
}
}
public async Task <ActionResult> Create(IncidentRequestViewModel model)
{
if (ModelState.IsValid)
{
using (TehnicalDepartmentDb db = new TehnicalDepartmentDb())
{
string CreatedByName = User.Identity.Name;
int CreatedById = db.Users.FirstOrDefault(u => u.username == CreatedByName).userId;
Request request = new Request
{
createdBy = CreatedById,
title = model.title,
description = model.description,
type = model.type == "0" ? false : true,
departmentAssigned = model.departmentAssigned,
employeeAssigned = null,
priority = model.priority
};
db.Requests.Add(request);
await db.SaveChangesAsync();
List <Request> newRequestList = db.Requests.Where(u => u.createdBy == CreatedById).ToList();
List <Request> newRequestListDescendingOrder = newRequestList.OrderByDescending(u => u.requestId).ToList();
int newRequestId = newRequestListDescendingOrder.First().requestId;
RequestHistory requestHistory = new RequestHistory
{
requestId = newRequestId,
from = CreatedByName,
to = model.departmentAssigned,
data = DateTime.Now,
status = "Pending"
};
db.RequestHistories.Add(requestHistory);
await db.SaveChangesAsync();
return(RedirectToAction("Support"));
}
}
// ViewBag.createdBy = new SelectList(db.Users, "userId", "company", request.createdBy);
return(View(model));
}
public async Task <ActionResult> Create(IncidentRequestViewModel model)
{
if (ModelState.IsValid)
{
using (TehnicalDepartmentDb db = new TehnicalDepartmentDb())
{
string CreatedByName = User.Identity.Name;
int CreatedById = db.Users.FirstOrDefault(u => u.username == CreatedByName).userId;
int? fileval = null;
DatabaseConnection.File fileDb = null;
if (model.file != null && model.file.ContentLength > 0)
{
try
{
string path = Path.Combine(Server.MapPath("~/Files"),
Path.GetFileName(model.file.FileName));
model.file.SaveAs(path);
fileDb = new DatabaseConnection.File
{
fileName = model.file.FileName,
fileType = model.file.ContentType
};
db.Files.Add(fileDb);
await db.SaveChangesAsync();
fileval = fileDb.fileId;
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
else
{
ViewBag.Message = "You have not specified a file.";
fileval = null;
}
Request request = new Request
{
createdBy = CreatedById,
title = model.title,
description = model.description,
type = model.type == "0" ? false : true,
departmentAssigned = model.departmentAssigned,
fileId = fileval,
employeeAssigned = null,
priority = model.priority,
};
db.Requests.Add(request);
await db.SaveChangesAsync();
List <Request> newRequestList = db.Requests.Where(u => u.createdBy == CreatedById).ToList();
List <Request> newRequestListDescendingOrder = newRequestList.OrderByDescending(u => u.requestId).ToList();
int newRequestId = newRequestListDescendingOrder.First().requestId;
RequestHistory requestHistory = new RequestHistory
{
requestId = newRequestId,
from = CreatedByName,
to = model.departmentAssigned,
data = DateTime.Now,
status = "Pending"
};
db.RequestHistories.Add(requestHistory);
await db.SaveChangesAsync();
return(RedirectToAction("Support"));
}
}
// ViewBag.createdBy = new SelectList(db.Users, "userId", "company", request.createdBy);
return(View(model));
}
