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" }));
}
}
}
