// GET: /Users/
public ActionResult Index(int isdelete = 0, int restoreid = 0)
{
var list = (dynamic)null;
TempData["restore"] = "";
if (isdelete == 0)
{
if (restoreid > 0)
{
if (db.tblArea.Any(a => a.AreaID == restoreid && a.IsDelete == true))
{
tblArea tblArea = db.tblArea.Find(restoreid);
tblArea.IsDelete = false;
db.Entry(tblArea).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Record Restore Successfully";
// return View("Index","Area");
}
}
list = db.tblArea.Where(a => a.IsDelete != true).OrderByDescending(a => a.AreaID).ToList();
}
else
{
TempData["restore"] = "restore";
list = db.tblArea.Where(a => a.IsDelete == true).OrderByDescending(a => a.AreaID).ToList();
}
return(View(list));
}
// GET: AreaApp/Delete/5
public ActionResult Delete(tblArea detailsToEdit)
{
var d = obj.tblAreas.Where(x => x.id == detailsToEdit.id).FirstOrDefault();
obj.tblAreas.Remove(d);
obj.SaveChanges();
return(RedirectToAction("AreaDetails"));
}
public ActionResult DeleteConfirmed(int id)
{
tblArea tblArea = db.tblArea.Find(id);
db.tblArea.Remove(tblArea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Exclude = "Id")] tblArea data)
{
if (!ModelState.IsValid)
{
return(View());
}
obj.tblAreas.Add(data);
obj.SaveChanges();
return(RedirectToAction("AreaDetails"));
}
//public tblAnio RetrieveByAnioTexto(int anio)
//{
// tblAnio Result = null;
// using (var r = new Repository<tblAnio>())
// {
// Result = r.Retrieve(p => p.anio == anio);
// }
// return Result;
//}
public tblArea RetrieveAreaByID(int id)
{
tblArea Result = null;
using (var r = new Repository <tblArea>())
{
Result = r.Retrieve(p => p.idArea == id);
}
return(Result);
}
public ActionResult Create([Bind(Include = "AreaID,AreaName,CreatedBy,UpdatedBy,CreateDate,UpdateDate,IsLogin,IsDelete,IsActive,CountryID,ProvinceID,CityID,DeleteBy,DeleteDate")] tblArea tblArea)
{
if (ModelState.IsValid)
{
db.tblArea.Add(tblArea);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblArea));
}
public ActionResult Edit([Bind(Include = "AreaID,AreaName,CreatedBy,UpdatedBy,CreateDate,UpdateDate,IsLogin,IsDelete,IsActive,CountryID,ProvinceID,CityID,DeleteBy,DeleteDate")] tblArea tblArea)
{
if (ModelState.IsValid)
{
db.Entry(tblArea).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Record Update Successfully";
return(RedirectToAction("Index"));
}
return(View(tblArea));
}
public ActionResult Delete(int?id)
{
tblArea A = db.tblAreas.SingleOrDefault(x => x.intAreaId == id);
AreaModel N = new AreaModel()
{
AreaId = A.intAreaId,
AreaName = A.strAreaName,
CityId = (int)A.intCityId,
PinCode = (int)A.intPinCode,
};
return(View(N));
}
public ActionResult Edit(tblArea detailsToEdit)
{
var orignalRecord = (from m in obj.tblAreas where m.id == detailsToEdit.id select m).First();
if (!ModelState.IsValid)
{
return(View(orignalRecord));
}
obj.Entry(orignalRecord).CurrentValues.SetValues(detailsToEdit);
obj.SaveChanges();
return(RedirectToAction("AreaDetails"));
}
// GET: /Area/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblArea tblArea = db.tblArea.Find(id);
if (tblArea == null)
{
return(HttpNotFound());
}
return(View(tblArea));
}
public ActionResult Create(AreaModel A)
{
tblArea ar = new tblArea();
ar.intAreaId = A.AreaId;
ar.strAreaName = A.AreaName;
ar.intCityId = A.CityId;
ar.intPinCode = A.PinCode;
db.tblAreas.Add(ar);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(AreaModel ar)
{
tblArea a = db.tblAreas.SingleOrDefault(x => x.intAreaId == ar.AreaId);
if (a != null)
{
a.intAreaId = ar.AreaId;
a.strAreaName = ar.AreaName;
a.intCityId = ar.CityId;
a.intPinCode = ar.PinCode;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: /Area/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblArea tblArea = db.tblArea.Find(id);
ViewBag.CountryID = new SelectList(db.tblCountry, "CountryID", "CountryName", tblArea.CountryID);
ViewBag.ProvinceID = new SelectList(db.tblProvince, "ProvinceID", "ProvinceName", tblArea.ProvinceID);
ViewBag.CityID = new SelectList(db.tblCity, "CityID", "CityName", tblArea.CityID);
if (tblArea == null)
{
return(HttpNotFound());
}
return(View(tblArea));
}
// GET: Area/Edit/5
public ActionResult Edit(int id)
{
var areaBLL = new AreasBLL();
tblArea objArea = areaBLL.RetrieveAreaByID(id);
var aulaBLL = new AulaBLL();
List <tblAula> listaAulas = aulaBLL.RetrieveAll();
ViewBag.idAula = new SelectList(listaAulas, "idAula", "nombreAula", objArea.idAula);
var colaboradorBLL = new ColaboradorBLL();
List <tblColaboradore> listacolaborador = colaboradorBLL.RetrieveAll();
ViewBag.idColaborador = new SelectList(listacolaborador, "idcolaborador", "nombreColaborador", objArea.idColaborador);
return(View(objArea));
}
public ActionResult Create(tblArea area)
{
var areaBLL = new AreasBLL();
ActionResult Result = null;
try
{
if (ModelState.IsValid)
{
areaBLL.Create(area);
Result = RedirectToAction("Index");
}
}
catch
{
return(View());
}
return(Result);
}
public bool Delete(int id)
{
bool Result = false;
tblArea obj = RetrieveAreaByID(id);
if (obj != null)
{
using (var r = new Repository <tblArea>())
{
Result = r.Delete(obj);
}
}
else
{
throw (new Exception("El area seleccionada no se pudo eliminar."));
}
return(Result);
}
protected void Button1_Click(object sender, EventArgs e)
{
try {
var dc = new DataClassesDataContext();
tblArea objArea = new tblArea();
objArea.AreaName = txtArea.Text;
objArea.PinCode = Convert.ToInt32(txtPinCode.Text);
dc.tblAreas.InsertOnSubmit(objArea);
dc.SubmitChanges();
Binddata();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public JsonResult DeleteArea(int id)
{
var aerBLL = new AreasBLL();
wmJsonResult objJson = new wmJsonResult();
try
{
tblArea area = aerBLL.RetrieveAreaByID(id);
if (area != null)
{
bool banderita = aerBLL.Delete(id);
if (banderita == true)
{
objJson.bandera = true;
objJson.mensaje = "El Area se eliminó correctamente";
}
else
{
objJson.bandera = false;
objJson.mensaje = "El Area NO se eliminó correctamente";
}
}
else
{
objJson.bandera = false;
objJson.mensaje = "El Area no se encontró";
}
}
catch
{
objJson.bandera = false;
objJson.mensaje = "Ocurrio una excepcion al eliminar el registro";
}
return(Json(objJson, JsonRequestBehavior.AllowGet));
}
public bool Update(tblArea t)
{
bool Result = false;
using (var r = new Repository <tblArea>())
{
tblArea ba = r.Retrieve(p => p.nombreArea == t.nombreArea &&
p.horaInicio == t.horaInicio &&
p.horaFinal == t.horaFinal &&
p.idColaborador == t.idColaborador &&
p.idAula == t.idAula && p.idArea != t.idArea);
if (ba == null)
{
Result = r.Update(t);
}
else
{
throw (new Exception("No se pudo actualizar el area seleccionada."));
}
}
return(Result);
}
public tblArea Create(tblArea t)
{
tblArea Result = null;
using (var r = new Repository <tblArea>())
{
tblArea ba = r.Retrieve(p => p.nombreArea == t.nombreArea &&
p.horaInicio == t.horaInicio &&
p.horaFinal == t.horaFinal &&
p.idColaborador == t.idColaborador &&
p.idAula == t.idAula &&
p.idArea != t.idArea);
if (ba == null)
{
Result = r.Create(t);
}
else
{
throw (new Exception("El area ya existe."));
}
}
return(Result);
}
/// <summary>
/// Create a new tblArea object.
/// </summary>
/// <param name="areaID">Initial value of AreaID.</param>
public static tblArea CreatetblArea(short areaID)
{
tblArea tblArea = new tblArea();
tblArea.AreaID = areaID;
return tblArea;
}
public ActionResult Edit(ServiceRequestsModels ServiceRequest)
{
if (ModelState.IsValid)
{
var RequestId = Convert.ToInt32(ServiceRequest.RequestType);
var requesttype = db.tblServiceTypes.Where(x => x.Id == RequestId).FirstOrDefault()?.ServiceDescription;
if (!string.IsNullOrEmpty(ServiceRequest.Area))
{
var TblArea = new tblArea
{
FacilityId = ServiceRequest.FacilityId,
BuildingId = ServiceRequest.BuildingId,
FloorId = ServiceRequest.FloorId,
AreaName = ServiceRequest.Area
};
//TblArea.Id = db.tblAreas.Max(p => p.Id) + 1;
db.tblAreas.Add(TblArea);
db.SaveChanges();
ServiceRequest.AreaId = TblArea.Id;
}
if (!string.IsNullOrEmpty(ServiceRequest.Room))
{
var TblRoom = new tblRoom
{
FacilityId = ServiceRequest.FacilityId,
BuildingId = ServiceRequest.BuildingId,
FloorId = ServiceRequest.FloorId,
AreaId = ServiceRequest.AreaId,
RoomName = ServiceRequest.Room
};
//TblRoom.Id = db.tblRooms.Max(p => p.Id) + 1;
db.tblRooms.Add(TblRoom);
db.SaveChanges();
ServiceRequest.RoomId = TblRoom.Id;
}
var TblServiceRequest = db.tblServiceRequests.Where(x => x.ServiceRequestNumber == ServiceRequest.ServiceRequestNumber).FirstOrDefault();
tblServiceRequestStatu TBLStatus = new tblServiceRequestStatu();
TBLStatus.dtTimeStamp = DateTime.Now;
TBLStatus.iServiceRequestId = ServiceRequest.Id;
TBLStatus.iStatusId = db.TblServiceStates.Where(x => x.ServiceState == "Open").FirstOrDefault().id;
db.tblServiceRequestStatus.Add(TBLStatus);
TblServiceRequest.OccupantName = ServiceRequest.OccupantName;
TblServiceRequest.ContactName = ServiceRequest.ContactName;
TblServiceRequest.ContactNumber = ServiceRequest.ContactNumber;
TblServiceRequest.ContactEmail = ServiceRequest.ContactEmail;
TblServiceRequest.FacilityId = ServiceRequest.FacilityId;
TblServiceRequest.BuildingId = ServiceRequest.BuildingId;
TblServiceRequest.FloorId = ServiceRequest.FloorId;
TblServiceRequest.AreaId = ServiceRequest.AreaId;
TblServiceRequest.RoomId = ServiceRequest.RoomId;
TblServiceRequest.RequestType = Convert.ToString(ServiceRequest.RequestType);
TblServiceRequest.CategoryIdParentId = Convert.ToInt32(db.tblServiceTypes.Where(x => x.Id == ServiceRequest.RequestType).FirstOrDefault()?.ServiceType);
TblServiceRequest.AssetGroupId = ServiceRequest.AssetGroupId;
TblServiceRequest.CategoryId = ServiceRequest.CategoryId;
TblServiceRequest.AssetTypeId = ServiceRequest.CategoryId;
TblServiceRequest.RequestDescription = ServiceRequest.RequestDescription;
TblServiceRequest.ISeniorTechId = ServiceRequest.ISeniorTechId ?? TblServiceRequest.ISeniorTechId;
TblServiceRequest.Severity = ServiceRequest.Severity ?? (TblServiceRequest.Severity ?? 3);
db.SaveChanges();
List <int> ResourcesList = new List <int>();
var WorkOrder = db.tblWorkOrders.Where(x => x.ServiceRequestId == TblServiceRequest.Id).FirstOrDefault();
WorkOrder.CategoryTypeId = ServiceRequest.CategoryId;
WorkOrder.CategoryIdParentId = Convert.ToInt32(db.tblServiceTypes.Where(x => x.Id == ServiceRequest.RequestType).FirstOrDefault()?.ServiceType);
var ExistingResources = db.tblWorkOrderResources.Where(x => x.WorkOrderId == WorkOrder.Id).Select(y => y.WorkforceId)?.ToList();
//Adding moddified reosurces in tblWorkOrderResource
if (ServiceRequest.ResourceID != null)
{
var NewResources = ServiceRequest.ResourceID.ToList();
if (NewResources.Any())
{
foreach (var resource in NewResources)
{
if (!ExistingResources.Contains(resource))
{
var Tblworkorderresources = new tblWorkOrderResource
{
WorkforceId = resource,
WorkOrderId = WorkOrder.Id
};
var TblServiceRequestResources = new tblServiceRequestResource
{
ServiceRequestId = TblServiceRequest.Id,
workforceId = resource
};
ResourcesList.Add(resource);
db.tblServiceRequestResources.Add(TblServiceRequestResources);
db.tblWorkOrderResources.Add(Tblworkorderresources);
}
}
foreach (var resource in ExistingResources)
{
if (!NewResources.Contains(Convert.ToInt32(resource)))
{
var Tblworkorderresources = db.tblWorkOrderResources.Where(x => x.WorkforceId == resource && x.WorkOrderId == WorkOrder.Id).FirstOrDefault();
var TblServiceRequestResources = db.tblServiceRequestResources.Where(x => x.workforceId == resource && x.ServiceRequestId == TblServiceRequest.Id).FirstOrDefault();
db.tblWorkOrderResources.Remove(Tblworkorderresources);
db.tblServiceRequestResources.Remove(TblServiceRequestResources);
}
}
db.SaveChanges();
}
}
foreach (var resource in ResourcesList)
{
if (resource != 0)
{
tblNotificationQueue notification = new tblNotificationQueue();
notification.ContactNumber = db.tblWorkForces.Where(x => x.Id == resource).FirstOrDefault().ContactNumber;
notification.MessageBody = WorkOrder.WorkOrderRefNo + " " +
ServiceRequest.RequestDescription + " " + ServiceRequest.ContactName + " " +
ServiceRequest.ContactNumber + Convert.ToString(ServiceRequest.Severity ?? 3) + " " +
db.tblBuildings.Where(x => x.Id == ServiceRequest.BuildingId).FirstOrDefault()?.BuildingName + "/" +
db.tblFloors.Where(x => x.Id == ServiceRequest.FloorId).FirstOrDefault()?.FloorName + "/" +
db.tblAreas.Where(x => x.Id == ServiceRequest.AreaId).FirstOrDefault()?.AreaName + "/" +
db.tblRooms.Where(x => x.Id == ServiceRequest.RoomId).FirstOrDefault()?.RoomName;
notification.IsSMSSent = false;
notification.SMSSentDateTime = null;
notification.FormRequestType = "WorkOrderUpdate";
notification.QueuedDate = DateTime.Now;
db.tblNotificationQueues.Add(notification);
}
}
db.SaveChanges();
//Adding files to table
if (ServiceRequest.Files != null && ServiceRequest.Files.Any())
{
foreach (var file in ServiceRequest.Files)
{
if (file != null && file.ContentLength > 0)
{
string newfilename = Path.GetFileNameWithoutExtension(file.FileName) + "_" + Guid.NewGuid() + "SREQ" + Path.GetExtension(file.FileName);
string path = Path.Combine("C:\\Program Files (x86)\\Johnson Controls\\EFIRM\\ImagesHelpDesk\\ServiceRequest",
newfilename);
file.SaveAs(path);
var TblServiceRequestImages = new tblServiceRequestImage
{
sImageName = newfilename,
nServiceRequestId = TblServiceRequest.Id
};
db.tblServiceRequestImages.Add(TblServiceRequestImages);
}
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.Occupants = new SelectList(db.tblOccupants, "Id", "OccupantName");
ViewBag.Facilities = new SelectList(db.tblFacilities, "Id", "FacilityName");
ViewBag.Groups = new SelectList(db.tblAssetGroups, "Id", "AssetGroup");
ViewBag.RequestTypes = new SelectList(db.tblServiceTypes, "Id", "ServiceDescription");
ViewBag.Severities = new SelectList(db.tblSeverities, "Id", "SeverityLevel");
ViewBag.LeadResources = new SelectList(db.tblWorkForces, "Id", "PersonName");
return(View(ServiceRequest));
}
public ActionResult Create(ServiceRequestsModels ServiceRequest)
{
if (ModelState.IsValid)
{
var RequestId = Convert.ToInt32(ServiceRequest.RequestType);
var requesttype = db.tblServiceTypes.Where(x => x.Id == RequestId).FirstOrDefault()?.ServiceDescription;
if (!string.IsNullOrEmpty(ServiceRequest.Area))
{
var TblArea = new tblArea
{
FacilityId = ServiceRequest.FacilityId,
BuildingId = ServiceRequest.BuildingId,
FloorId = ServiceRequest.FloorId,
AreaName = ServiceRequest.Area
};
//TblArea.Id = db.tblAreas.Max(p => p.Id) + 1;
db.tblAreas.Add(TblArea);
db.SaveChanges();
ServiceRequest.AreaId = TblArea.Id;
}
if (!string.IsNullOrEmpty(ServiceRequest.Room))
{
var TblRoom = new tblRoom
{
FacilityId = ServiceRequest.FacilityId,
BuildingId = ServiceRequest.BuildingId,
FloorId = ServiceRequest.FloorId,
AreaId = ServiceRequest.AreaId,
RoomName = ServiceRequest.Room
};
//TblRoom.Id = db.tblRooms.Max(p => p.Id) + 1;
db.tblRooms.Add(TblRoom);
db.SaveChanges();
ServiceRequest.RoomId = TblRoom.Id;
}
var TblServiceRequest = new tblServiceRequest
{
OccupantName = ServiceRequest.OccupantName,
ContactName = ServiceRequest.ContactName,
ContactNumber = ServiceRequest.ContactNumber,
ContactEmail = ServiceRequest.ContactEmail,
FacilityId = ServiceRequest.FacilityId,
BuildingId = ServiceRequest.BuildingId,
FloorId = ServiceRequest.FloorId,
AreaId = ServiceRequest.AreaId,
RoomId = ServiceRequest.RoomId,
RequestType = Convert.ToString(ServiceRequest.RequestType),
AssetGroupId = ServiceRequest.AssetGroupId,
CategoryId = ServiceRequest.CategoryId,
AssetTypeId = ServiceRequest.CategoryId,
RequestDescription = ServiceRequest.RequestDescription,
ISeniorTechId = ServiceRequest.ISeniorTechId,
Severity = ServiceRequest.Severity ?? 3,
WhoLogged = System.Web.HttpContext.Current.User.Identity.Name,
Status = "Open",
RequestDate = System.DateTime.Now,
IsThroughService = false,
CategoryIdParentId = Convert.ToInt32(db.tblServiceTypes.Where(x => x.Id == ServiceRequest.RequestType).FirstOrDefault()?.ServiceType)
};
string ServiceRequestNumber = string.Empty;
var LastServiceRequestNumber = (db.tblServiceRequests.Where(y => y.ServiceRequestNumber.Contains(requesttype)).OrderByDescending(x => x.Id).FirstOrDefault()?.ServiceRequestNumber).Split('/');;
DateTime LastServiceRequestNumberDate = DateTime.ParseExact(LastServiceRequestNumber[2], "yyMMdd", CultureInfo.InvariantCulture);
if (LastServiceRequestNumberDate.Year == DateTime.Today.Year &&
LastServiceRequestNumberDate.Month == DateTime.Today.Month)
{
ServiceRequestNumber = "SR/" + requesttype + "/" +
DateTime.Today.ToString("yy") + DateTime.Now.Month.ToString("d2") +
DateTime.Now.Day.ToString("d2")
+ "/" + (Convert.ToInt32(LastServiceRequestNumber[3]) + 1);
}
else
{
ServiceRequestNumber = "SR/" + requesttype + "/" +
DateTime.Today.ToString("yy") + DateTime.Now.Month.ToString("d2") +
DateTime.Now.Day.ToString("d2")
+ "/" + 1;
}
TblServiceRequest.ServiceRequestNumber = ServiceRequestNumber;
db.tblServiceRequests.Add(TblServiceRequest);
db.SaveChanges();
string WorkOrderRefNumber = string.Empty;
var LastWorkOrderRefNumber = (db.tblWorkOrders.Where(y => y.WorkOrderRefNo.Contains(requesttype)).OrderByDescending(x => x.Id).FirstOrDefault()?.WorkOrderRefNo).Split('/');;
DateTime LastWorkOrderRefNumberDate = DateTime.ParseExact(LastWorkOrderRefNumber[2], "yyMMdd", CultureInfo.InvariantCulture);
var WorkOrderId = Convert.ToInt32(ServiceRequest.RequestType);
if (LastWorkOrderRefNumberDate.Year == DateTime.Today.Year &&
LastWorkOrderRefNumberDate.Month == DateTime.Today.Month)
{
WorkOrderRefNumber = "WO/" + requesttype + "/" +
DateTime.Today.ToString("yy") + DateTime.Now.Month.ToString("d2") +
DateTime.Now.Day.ToString("d2")
+ "/" + (Convert.ToInt32(LastWorkOrderRefNumber[3]) + 1);
}
else
{
WorkOrderRefNumber = "WO/" + requesttype + "/" +
DateTime.Today.ToString("yy") + DateTime.Now.Month.ToString("d2") +
DateTime.Now.Day.ToString("d2")
+ "/" + 1;
}
var TblWorkOrders = new tblWorkOrder
{
WorkOrderRefNo = WorkOrderRefNumber,
ServiceRequestId = TblServiceRequest.Id,
WorkOrderDate = DateTime.Now,
Status = "Open",
RequesterId = Convert.ToInt32(Session["UserID"]),
CategoryTypeId = ServiceRequest.CategoryId,
IsThroughService = false,
CategoryIdParentId = Convert.ToInt32(db.tblServiceTypes.Where(x => x.Id == ServiceRequest.RequestType).FirstOrDefault()?.ServiceType)
};
db.tblWorkOrders.Add(TblWorkOrders);
db.SaveChanges();
var NewServiceRequest = tblServiceRequest.Where(x => x.ServiceRequestNumber == ServiceRequestNumber)?.FirstOrDefault();
List <int> ResourcesList = new List <int>();
//Adding reosurces in tblWorkOrderResource
if (ServiceRequest.ResourceID != null && ServiceRequest.ResourceID.Any())
{
foreach (var resource in ServiceRequest.ResourceID)
{
ResourcesList.Add(resource);
var Tblworkorderresources = new tblWorkOrderResource
{
WorkforceId = resource,
WorkOrderId = TblWorkOrders.Id
};
var TblServiceRequestResources = new tblServiceRequestResource
{
ServiceRequestId = NewServiceRequest.Id,
workforceId = resource
};
db.tblWorkOrderResources.Add(Tblworkorderresources);
db.tblServiceRequestResources.Add(TblServiceRequestResources);
}
db.SaveChanges();
}
else
{
//Service Request is not created from Admin mode so we need to so auto assign of resource
var TblShifts = db.tblShifts?.ToArray();
var TblShiftRostering = db.tblShiftRosterings;
var TblShiftException = db.tblShiftExceptions;
var TimeNow = TimeSpan.Parse(DateTime.Now.ToString("HH:mm"));
var ShiftNow = (TimeNow.Hours > 17 || TimeNow.Hours < 7) ? TblShifts[1] : TblShifts[0];
var ResouceonLeaveInCurrentShiftToday = TblShiftException.Where(x => x.ShiftId == ShiftNow.Id && x.FromDate <= DateTime.Now && x.ToDate >= DateTime.Now).Select(x => x.WorkForceId);
foreach (var resource in ResouceonLeaveInCurrentShiftToday)
{
var res = db.tblShiftRosterings.FirstOrDefault(x => x.WorkForceId == resource);
TblShiftRostering.Remove(res);
}
var dummy = TblShifts.ToList();
var LeastUsedResourceInCurrentShift = TblShiftRostering.Where(x => x.ShiftId == ShiftNow.Id).OrderBy(x => x.LastUsedDateTime).FirstOrDefault();
ResourcesList.Add(Convert.ToInt32(LeastUsedResourceInCurrentShift?.WorkForceId));
var Tblworkorderresources = new tblWorkOrderResource
{
WorkforceId = LeastUsedResourceInCurrentShift?.WorkForceId,
WorkOrderId = TblWorkOrders.Id
};
var TblServiceRequestResources = new tblServiceRequestResource
{
ServiceRequestId = NewServiceRequest.Id,
workforceId = LeastUsedResourceInCurrentShift?.WorkForceId,
};
db.tblServiceRequestResources.Add(TblServiceRequestResources);
db.tblWorkOrderResources.Add(Tblworkorderresources);
NewServiceRequest.ISeniorTechId = LeastUsedResourceInCurrentShift?.WorkForceId;
LeastUsedResourceInCurrentShift.LastUsedDateTime = DateTime.Now;
db.SaveChanges();
}
foreach (var resource in ResourcesList)
{
if (resource != 0)
{
tblNotificationQueue notification = new tblNotificationQueue();
notification.ContactNumber = db.tblWorkForces.Where(x => x.Id == resource).FirstOrDefault().ContactNumber;
notification.MessageBody = TblWorkOrders.WorkOrderRefNo + " " +
ServiceRequest.RequestDescription + " " + ServiceRequest.ContactName + " " +
ServiceRequest.ContactNumber + Convert.ToString(ServiceRequest.Severity ?? 3) + " " +
db.tblBuildings.Where(x => x.Id == ServiceRequest.BuildingId).FirstOrDefault()?.BuildingName + "/" +
db.tblFloors.Where(x => x.Id == ServiceRequest.FloorId).FirstOrDefault()?.FloorName + "/" +
db.tblAreas.Where(x => x.Id == ServiceRequest.AreaId).FirstOrDefault()?.AreaName + "/" +
db.tblRooms.Where(x => x.Id == ServiceRequest.RoomId).FirstOrDefault()?.RoomName;
notification.IsSMSSent = false;
notification.SMSSentDateTime = null;
notification.QueuedDate = DateTime.Now;
notification.FormRequestType = "WorkOrderAdd";
db.tblNotificationQueues.Add(notification);
}
}
db.SaveChanges();
//Adding files to table
if (ServiceRequest.Files != null && ServiceRequest.Files.Any())
{
foreach (var file in ServiceRequest.Files)
{
if (file != null && file.ContentLength > 0)
{
string newfilename = Path.GetFileNameWithoutExtension(file.FileName) + "_" + Guid.NewGuid() + "SREQ" + Path.GetExtension(file.FileName);
string path = Path.Combine("C:\\Program Files (x86)\\Johnson Controls\\EFIRM\\ImagesHelpDesk\\ServiceRequest",
newfilename);
file.SaveAs(path);
var TblServiceRequestImages = new tblServiceRequestImage
{
sImageName = newfilename,
nServiceRequestId = TblServiceRequest.Id
};
db.tblServiceRequestImages.Add(TblServiceRequestImages);
}
}
db.SaveChanges();
}
tblServiceRequestStatu TBLStatus = new tblServiceRequestStatu();
TBLStatus.dtTimeStamp = DateTime.Now;
TBLStatus.iServiceRequestId = NewServiceRequest.Id;
TBLStatus.iStatusId = db.TblServiceStates.Where(x => x.ServiceState == "Open").FirstOrDefault().id;
db.tblServiceRequestStatus.Add(TBLStatus);
return(RedirectToAction("Index", new { ServiceRequestCreated = true }));
}
ViewBag.Occupants = new SelectList(db.tblOccupants, "Id", "OccupantName");
ViewBag.Facilities = new SelectList(db.tblFacilities, "Id", "FacilityName");
ViewBag.Groups = new SelectList(db.tblAssetGroups, "Id", "AssetGroup");
ViewBag.RequestTypes = new SelectList(db.tblServiceTypes, "Id", "ServiceDescription");
ViewBag.Severities = new SelectList(db.tblSeverities, "Id", "SeverityLevel");
ViewBag.LeadResources = new SelectList(db.tblWorkForces, "Id", "PersonName");
return(View(ServiceRequest));
}
/// <summary>
/// There are no comments for tblArea in the schema.
/// </summary>
public void AddTotblArea(tblArea tblArea)
{
base.AddObject("tblArea", tblArea);
}
