public ActionResult SeachScheduleTest(FormCollection colection, RepairDetail RepairDetails) { ViewData["User"] = Ql.Users.ToList(); ViewData["ScheduleTests"] = Ql.ScheduleTests.ToList(); int?Users = colection["User"].Equals("0") ? (int?)null : Convert.ToInt32(colection["User"]); int?Status = colection["Status"].Equals("") ? (int?)null : Convert.ToInt32(colection["Status"]); var lstScheduleTest = Ql.SearchScheduleTest(Users, Status).ToList(); var ViewScheduleTest = lstScheduleTest; ViewBag.Users = Users; ViewBag.Status = Status; return(View("ScheduleTest", lstScheduleTest)); }
public ActionResult AddRepairDetails(FormCollection colection, RepairDetail RepairDetail) { int? DeviceId = colection["DeviceId"].Equals("") ? (int?)null : Convert.ToInt32(colection["DeviceId"]); DateTime?DateOfRepair = colection["DateOfRepair"].Equals("") ? (DateTime?)null : Convert.ToDateTime(colection["DateOfRepair"]); string AddressOfRepair = colection["AddressOfRepair"]; int? TimeOrder = colection["TimeOrder"].Equals("") ? (int?)null : Convert.ToInt32(colection["TimeOrder"]); int? TypeOfRepair = colection["TypeOfRepair"].Equals("0") ? (int?)null : Convert.ToInt32(colection["TypeOfRepair"]); int? UserId = colection["UserId"].Equals("") ? (int?)null : Convert.ToInt32(colection["UserId"]); string Notes = colection["Notes"]; DateTime?NextDateOfRepair = colection["NextDateOfRepair"].Equals("") ? (DateTime?)null : Convert.ToDateTime(colection["NextDateOfRepair"]); Ql.AddRepairDetails(DeviceId, DateOfRepair, NextDateOfRepair, TimeOrder, TypeOfRepair, AddressOfRepair, UserId, Notes); return(RedirectToAction("RepairDetails", "RepairDetails")); }
public ActionResult SeachRepairDetails(FormCollection colection, RepairDetail RepairDetails) { ViewData["User"] = Ql.Users.ToList(); ViewData["RepairTypes"] = Ql.RepairTypes.ToList(); int?RepairType1 = colection["RepairType1"].Equals("0") ? (int?)null : Convert.ToInt32(colection["RepairType1"]); int?Users = colection["User"].Equals("0") ? (int?)null : Convert.ToInt32(colection["User"]); int?Status = colection["Status"].Equals("-1") ? (int?)null : Convert.ToInt32(colection["Status"]); int?IdDevice = colection["IdDevice"].Equals("") ? (int?)null : Convert.ToInt32(colection["IdDevice"]); var lstRepairDetails = Ql.SearchRepairDetails(RepairType1, Users, IdDevice, Status).ToList(); var ViewRepairDetails = lstRepairDetails; ViewBag.RepairType1 = RepairType1; ViewBag.Users = Users; ViewBag.Status = Status; return(View("RepairDetails", ViewRepairDetails)); }
public ActionResult EditRepairDetails(FormCollection colection, RepairDetail RepairDetail) { int? Id = colection["Id"].Equals("0") ? (int?)null : Convert.ToInt32(colection["Id"]); int? DeviceId = colection["DeviceId"].Equals("") ? (int?)null : Convert.ToInt32(colection["DeviceId"]); DateTime?DateOfRepair = colection["DateOfRepair"].Equals("") ? (DateTime?)null : Convert.ToDateTime(colection["DateOfRepair"]); string AddressOfRepair = colection["AddressOfRepair"]; int? TimeOrder = colection["TimeOrder"].Equals("") ? (int?)null : Convert.ToInt32(colection["TimeOrder"]); int? TypeOfRepair = colection["TypeOfRepair"].Equals("") ? (int?)null : Convert.ToInt32(colection["TypeOfRepair"]); int? UserId = colection["UserId"].Equals("0") ? (int?)null : Convert.ToInt32(colection["UserId"]); string NoteRepair = colection["NoteRepair"]; DateTime?NextDateOfRepair = colection["NextDateOfRepair"].Equals("") ? (DateTime?)null : Convert.ToDateTime(colection["NextDateOfRepair"]); int? Status = colection["Status"].Equals("") ? (int?)null : Convert.ToInt32(colection["Status"]); double Price = colection["Prices"].Equals("") ? 0 : Convert.ToDouble(colection["Prices"]); Ql.EditRepairDetails(Id, DeviceId, DateOfRepair, NextDateOfRepair, TimeOrder, TypeOfRepair, AddressOfRepair, UserId, NoteRepair, Status, Price); return(RedirectToAction("EditRepairDetails", "RepairDetails")); }
public ActionResult Add(string out_in_come, string data, string department_id_to, string reason) { JArray json = JArray.Parse(data); QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities(); using (DbContextTransaction transaction = DBContext.Database.BeginTransaction()) { try { Documentary documentary = new Documentary { documentary_type = 1, department_id_to = department_id_to, date_created = DateTime.Now, person_created = Session["Name"] + "", reason = reason, out_income = out_in_come, documentary_status = 1 }; DBContext.Documentaries.Add(documentary); DBContext.SaveChanges(); // Vị trí của thiết bị con được lấy theo vị trí của thiết bị to List <string> list = new List <string>(); foreach (JObject item in json) { list.Add(item["attachTo"].Type == JTokenType.Null ? item["equipmentId"].ToString() : item["attachTo"].ToString()); } var dict = (from e in DBContext.Equipments join d in DBContext.Departments on e.department_id equals d.department_id where list.Contains(e.equipment_id) select new { e.equipment_id, d.department_id }) .Select(x => new { x.equipment_id, x.department_id }) .AsEnumerable() .ToDictionary(d => d.equipment_id, d => d.department_id); foreach (JObject item in json) { DateTime finish_date_plan = DateTime.ParseExact((string)item["date"], "dd/MM/yyyy", null); string equipmentId = item["equipmentId"].ToString(); string attach_to = item["attachTo"].Type == JTokenType.Null ? null : item["attachTo"].ToString(); RepairDetail drd = new RepairDetail { department_id_from = attach_to == null ? dict[equipmentId] : dict[attach_to], equipment_repair_status = 0, repair_type = item["type"].ToString(), repair_reason = item["reason"].ToString(), finish_date_plan = finish_date_plan, documentary_id = documentary.documentary_id, equipment_id = equipmentId, attach_to = attach_to, is_visible = true, quantity = int.Parse(item["quantity"].ToString()) }; DBContext.RepairDetails.Add(drd); DBContext.SaveChanges(); bool used = false; JObject vattu = (JObject)item["supply"]; if (vattu != null) { foreach (var jObject in vattu) { RepairEquipment sde = new RepairEquipment { documentary_repair_id = drd.documentary_repair_id, supply_id = jObject.Key, quantity_plan = int.Parse(jObject.Value.ToString()), }; used = true; DBContext.RepairEquipments.Add(sde); } DBContext.SaveChanges(); } JObject thietbi = (JObject)item["equipment"]; if (thietbi != null) { foreach (var jObject in thietbi) { RepairEquipment sde = new RepairEquipment { documentary_repair_id = drd.documentary_repair_id, equipment_id = jObject.Key, quantity_plan = int.Parse(jObject.Value.ToString()), }; used = true; DBContext.RepairEquipments.Add(sde); } DBContext.SaveChanges(); } if (!used) { transaction.Rollback(); string message = "Thiết bị " + (attach_to == null ? (equipmentId + " chưa được chọn thiết bị con hoặc vật tư") : (attach_to + $" ({equipmentId}) chưa được chọn vật tư")); return(Json(new { success = false, message = "Thiết bị chưa được chọn" })); } } transaction.Commit(); return(Json(new { success = true })); } catch (Exception) { transaction.Rollback(); return(Json(new { success = false, message = "Có lỗi xảy ra" })); } } }