public JsonResult notifi21()
{
if (Session["departID"] == null)
{
return(null);
}
string depart = Session["departID"].ToString();
int month = DateTime.Now.Month;
int year = DateTime.Now.Year;
var check = db.Notifications.Where(x => x.description == "21" && x.department_id == depart && x.date.Month == month && x.date.Year == year).FirstOrDefault();
if (check == null)
{
var qd = db.MonthlyPlans.Where(x => x.status == 1 && x.date.Month == month && x.date.Year == year && x.department_id == depart).ToList();
if (qd.Count == 0)
{
Notification no = new Notification
{
id_problem = 21,
date = DateTime.Now.Date,
description = "21",
department_id = depart,
isread = false
};
db.Notifications.Add(no);
db.SaveChanges();
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult Add(string supply_id, string supply_name, string unit)
{
Supply s = db.Supplies.Find(supply_id);
if (supply_id.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Mã vật tư" }, JsonRequestBehavior.AllowGet));
}
else if (supply_name.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Tên vật tư" }, JsonRequestBehavior.AllowGet));
}
else if (unit.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Đơn vị" }, JsonRequestBehavior.AllowGet));
}
else if (s != null)
{
return(Json(new { success = false, message = "Vật tư đã tồn tại" }, JsonRequestBehavior.AllowGet));
}
else
{
s = new Supply
{
supply_id = supply_id,
supply_name = supply_name,
unit = unit
};
db.Supplies.Add(s);
db.SaveChanges();
return(Json(new { success = true, message = "Tạo loại vật tư thành công" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(string edit, int id)
{
if (edit != "")
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
JArray list = JArray.Parse(edit);
foreach (JValue item in list)
{
if (item.Value.ToString() == "")
{
continue;
}
CameraRepairDetail temp = db.CameraRepairDetails.Where(x => x.documentary_id == id && x.room_id == item.Value.ToString()).FirstOrDefault();
if (temp.documentary_camera_repair_status == 0)
{
temp.documentary_camera_repair_status = 1;
Acceptance a = new Acceptance
{
acceptance_date = null,
documentary_id = id,
room_id = item.Value.ToString(),
acceptance_camera_quantity = temp.broken_camera_quantity
};
db.Acceptances.Add(a);
}
}
if ((from docu in db.Documentaries
join details in db.CameraRepairDetails on docu.documentary_id equals details.documentary_id
where docu.documentary_type == 8 && details.documentary_id == id && details.documentary_camera_repair_status == 0
select details).Count() == 0)
{
Documentary docu = db.Documentaries.Find(id);
docu.documentary_status = 2;
}
db.SaveChanges();
transaction.Commit();
return(Json(new { success = true, message = "Lưu thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
e.Message.ToString();
transaction.Rollback();
return(Json(new { success = false, message = "Có lỗi xảy ra" }, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { success = true, message = "Lưu thành công" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddCategory(Category ec, string[] id, string[] name, string[] unit)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
Category category = db.Categories.Find(ec.equipment_category_id);
if (category != null)
{
return(Json(new { success = false, message = "Mã loại thiết bị đã tồn tại" }));
}
using (DbContextTransaction dbc = db.Database.BeginTransaction())
{
try
{
db.Categories.Add(ec);
db.SaveChanges();
if (id != null)
{
for (int i = 0; i < id.Count(); i++)
{
if (!id[i].Equals(""))
{
CategoryAttribute ea = db.CategoryAttributes.Find(id[i]);
if (ea != null)
{
continue;
}
ea = new CategoryAttribute
{
equipment_category_id = ec.equipment_category_id,
equipment_category_attribute_id = id[i],
unit = unit[i],
equipment_category_attribute_name = name[i]
};
db.CategoryAttributes.Add(ea);
}
}
}
db.SaveChanges();
dbc.Commit();
return(Search("", "", "", "", "", "", "", "", ""));
}
catch (Exception e)
{
e.Message.ToString();
dbc.Rollback();
return(Json(new { success = false, message = "Có lỗi xảy ra" }));
}
}
}
public ActionResult delete()
{
try
{
int work_group_type_id = Convert.ToInt32(Request["work_group_type_id"]);
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
WorkGroupType workGroupType = db.WorkGroupTypes.Find(work_group_type_id);
if (workGroupType == null)
{
return(Json(new { error = true, title = "Có lỗi", message = "Không tìm thấy loại công việc tương ứng." }));
}
else
{
try
{
db.WorkGroupTypes.Remove(workGroupType);
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Xóa thành công." }));
} catch (Exception e)
{
return(Json(new { error = true, title = "Có lỗi", message = "Dữ liệu về loại công việc đã được sử dụng nên không thể xóa." }));
}
}
}
}
catch (Exception e)
{
return(Json(new { error = true, title = "Có lỗi", message = "Có lỗi xảy ra." }));
}
}
public ActionResult update()
{
try
{
int work_group_type_id = Convert.ToInt32(Request["work_group_type_id"]);
string work_group_type_name = Request["work_group_type_name"];
if (work_group_type_name == null || work_group_type_name == "")
{
return(Json(new { error = true, title = "Có lỗi", message = "Tên diện công việc không thể để trống." }));
}
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
WorkGroupType workGroupType = db.WorkGroupTypes.Find(work_group_type_id);
if (workGroupType == null)
{
return(Json(new { error = true, title = "Có lỗi", message = "Có lỗi xảy ra." }));
}
else
{
workGroupType.name = work_group_type_name;
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Cập nhật thành công." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, title = "Có lỗi", message = "Có lỗi xảy ra." }));
}
}
public ActionResult delete()
{
try
{
string work_work_group_id_param = Request["work_work_group_id"];
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
int work_work_group_id = Convert.ToInt32(work_work_group_id_param);
try
{
WorkWorkGroup workWorkGroup = db.WorkWorkGroups.Find(work_work_group_id);
db.WorkWorkGroups.Remove(workWorkGroup);
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Xóa công việc - nhóm công việc thành công." }));
} catch (Exception e)
{
return(Json(new { success = false, title = "Có lỗi", message = "Dữ liệu công việc - nhóm công việc đang được sử dụng." }));
}
}
}
catch (Exception e)
{
return(Json(new { error = true, title = "Có lỗi", message = "Có lỗi xảy ra." }));
}
}
public ActionResult add()
{
try
{
var add_work_group_type_name = Request["add_work_group_type_name"];
if (add_work_group_type_name == null || add_work_group_type_name == "")
{
return(Json(new { error = true, title = "Có lỗi", message = "Tên diện công việc không thể để trống." }));
}
else
{
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
WorkGroupType workGroupType = db.WorkGroupTypes.Where(x => x.name.Equals(add_work_group_type_name)).FirstOrDefault();
if (workGroupType == null)
{
workGroupType = new WorkGroupType();
workGroupType.name = add_work_group_type_name;
db.WorkGroupTypes.Add(workGroupType);
db.SaveChanges();
return(Json(new { success = true, title = "Thành công", message = "Thêm loại công việc mới thành công." }));
}
else
{
return(Json(new { error = true, title = "Có lỗi", message = "Đã có tên diện công việc." }));
}
}
}
}
catch (Exception e)
{
return(Json(new { error = true, title = "Có lỗi", message = "Có lỗi xảy ra." }));
}
}
public ActionResult addDK(string id, string nameSup, int quan, string dvt)
{
QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities();
using (DbContextTransaction dbc = DBContext.Database.BeginTransaction())
{
try
{
if (nameSup != null && quan != 0)
{
Equipment s = DBContext.Equipments.Where(x => x.equipment_name == nameSup).FirstOrDefault();
string sql_sup = "Equipment.Profile_Add_Update_DK 'add', {0}, {1}, {2}";
DBContext.Database.ExecuteSqlCommand(sql_sup, s.equipment_id, id, quan);
}
DBContext.SaveChanges();
dbc.Commit();
var sup = DBContext.Database.SqlQuery <ProfileGetListDK_Result>("Equipment.Profile_Get_List 'DK', {0}", id).ToList();
return(Json(new { success = true, data = sup }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
e.Message.ToString();
dbc.Rollback();
return(Json(new { success = false, message = e.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Add(string supply_id, string supply_name, string unit)
{
QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities();
Supply s = DBContext.Supplies.Find(supply_id);
if (supply_id.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Mã vật tư" }, JsonRequestBehavior.AllowGet));
}
else
if (supply_name.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Tên vật tư" }, JsonRequestBehavior.AllowGet));
}
else
if (unit.Trim() == "")
{
return(Json(new { success = false, message = "Không được để trống trường Đơn vị" }, JsonRequestBehavior.AllowGet));
}
else
if (s != null)
{
return(Json(new { success = false, message = "Vật tư đã tồn tại" }, JsonRequestBehavior.AllowGet));
}
else
{
s = new Supply();
s.supply_id = supply_id;
s.supply_name = supply_name;
s.unit = unit;
DBContext.Supplies.Add(s);
DBContext.SaveChanges();
return(Json(new { success = true, message = "Tạo loại vật tư thành công" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddNewDepartment(string departmentJson)
{
dynamic dataJson = JObject.Parse(departmentJson);
string mpb = dataJson.mpb;
string tpb = dataJson.tpb;
string lpb = dataJson.lpb;
bool isInside = Convert.ToBoolean(dataJson.isInside);
Department department = new Department {
department_id = mpb, department_name = tpb, department_type = lpb, isInside = isInside
};
try
{
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
var pb = db.Departments.Add(department);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int incident_id, string department, string reason, int quan, int yearStart, int monthStart, int dayStart, int hourStart, int minuteStart, int yearEnd, int monthEnd, int dayEnd, int hourEnd, int minuteEnd)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Incident i = db.Incidents.Find(incident_id);
Room d = db.Rooms.Where(x => x.room_name.Equals(department)).FirstOrDefault();
DateTime start = new DateTime(yearStart, monthStart, dayStart, hourStart, minuteStart, 0);
DateTime end = new DateTime(yearEnd, monthEnd, dayEnd, hourEnd, minuteEnd, 0);
if (DateTime.Compare(start, end) >= 0)
{
return(Json(new { success = false, message = "Bạn đã nhập ngày bắt đầu lớn hơn ngày kết thúc" }, JsonRequestBehavior.AllowGet));
}
i.room_id = d.room_id;
i.reason = reason;
i.start_time = start;
i.end_time = end;
i.incident_camera_quantity = quan;
db.SaveChanges();
transaction.Commit();
return(Json(new { success = true, message = "Chỉnh sửa thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Rollback();
return(Json(new { success = false, message = "Có lỗi xảy ra, xin vui lòng thử lại" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SetPhoto()
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Room r = db.Rooms.Find(Request["room_id"]);
string path = "/images/camera/";
Image sourceimage = Image.FromStream(Request.Files["img"].InputStream, true, true);
r.image_link = r.room_id + ".jfif";
db.SaveChanges();
if (!Directory.Exists(HostingEnvironment.MapPath(path)))
{
Directory.CreateDirectory(HostingEnvironment.MapPath(path));
}
if (sourceimage.Size != null)
{
sourceimage.Save(HostingEnvironment.MapPath(path + r.image_link));
}
transaction.Commit();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Rollback();
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult DeleteDepartment(string department_id)
{
try
{
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
var department = db.Departments.Find(department_id);
db.Departments.Remove(department);
try
{
db.SaveChanges();
}
catch (Exception e)
{
return(Json(new { success = false, message = "Dữ liệu bạn xóa đang tồn tại ở những màn hình khác. Do vậy để xóa phân xưởng này bạn phải xóa dữ liệu tại các màn hình có liên quan tới dữ liệu trên." }));
}
return(Json(new { success = true, message = "Xóa phân xưởng thành công." }));
}
}
catch (Exception e)
{
return(Json(new { success = false, message = "Có lỗi xảy ra." }));
}
}
public ActionResult Edit()
{
try
{
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
Room r = db.Rooms.Find(Request["room_id"]);
r.capacity = Request["capacity"];
r.disk_status = Request["status"];
r.series = Request["serial"];
r.note = Request["note"];
r.room_name = Request["location"];
r.department_id = Request["department"];
r.camera_quantity = int.Parse(Request["quantity"].ToString());
r.camera_available = int.Parse(Request["quantity"].ToString());
r.signal_loss_reason = "";
r.login_information = Request["login"];
db.SaveChanges();
return(Json(new { success = true, message = "Chỉnh sửa thành công" }));
}
}
catch (Exception)
{
return(Json(new { success = false, message = "Có lỗi xảy ra" }));
}
}
public ActionResult Delete()
{
try
{
int documentary_id = int.Parse(Request["documentary_id"]);
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
Documentary doc = db.Documentaries.Find(documentary_id);
if (doc == null)
{
return(Json(new { success = false, message = "Mã quyết định không tồn tại" }));
}
if (doc.documentary_code != null)
{
return(Json(new { success = false, message = "Bạn không được xóa quyết định này" }));
}
db.Documentaries.Remove(doc);
db.SaveChanges();
return(Json(new { success = true, message = "Xóa thành công" }));
}
}
catch (Exception)
{
return(Json(new { success = false, message = "Có lỗi xảy ra" }));
}
}
public JsonResult NotYetDelete(string id)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
db.Configuration.LazyLoadingEnabled = false;
using (DbContextTransaction dbct = db.Database.BeginTransaction())
{
try
{
List <Termination> list = db.Terminations.Where(x => x.decision_id + "" == id).ToList();
string listMaNV = "";
foreach (var MaNV in list)
{
listMaNV += "'" + MaNV.employee_id + "'" + ",";
}
listMaNV = listMaNV.Substring(0, listMaNV.Length - 1);
string query = @"update HumanResources.Employee set
current_status_id = 1 where employee_id in(" + listMaNV + ") " +
"delete from HumanResources.Termination where decision_id = @id " +
"delete from HumanResources.Decision where decision_id = @id";
db.Database.ExecuteSqlCommand(query, new SqlParameter("id", id));
db.SaveChanges();
dbct.Commit();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
dbct.Rollback();
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Update(int incident_id, string reason, int year, int month, int day, int hour, int minute)
{
using (QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities())
{
try
{
Incident1 i = DBContext.Incident1.Find(incident_id);
DateTime end = new DateTime(year, month, day, hour, minute, 0);
if (DateTime.Compare(i.start_time, end) >= 0)
{
return(Json(new { success = false, message = "Thời gian bắt đầu phải nhỏ hơn thời gian kết thúc" }));
}
if (i == null)
{
return(Json(new { success = false, message = "Mã sự cố sai" }));
}
else
{
i.reason = reason;
i.end_time = new DateTime(year, month, day, hour, minute, 0);
i.Equipment.current_status = 1;
DBContext.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công" }));
}
}
catch (Exception)
{
return(Json(new { success = false, message = "Có lỗi xảy ra, xin vui lòng thử lại" }));
}
}
}
public ActionResult addTT(string idTT, string nameTT, int quan, string dvt, string eid)
{
QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities();
using (DbContextTransaction dbc = DBContext.Database.BeginTransaction())
{
try
{
if (nameTT != null && quan != 0)
{
string sql_sup = "Equipment.Profile_Add_TT {0}, {1}, {2}, {3}, {4}";
DBContext.Database.ExecuteSqlCommand(sql_sup, idTT, nameTT, quan, dvt, eid);
}
DBContext.SaveChanges();
dbc.Commit();
var sup = DBContext.Database.SqlQuery <QUANGHANH2.Models.Attribute>("Equipment.Profile_Get_List 'TT', {0}", eid).ToList();
return(Json(new { success = true, data = sup }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
e.Message.ToString();
dbc.Rollback();
return(Json(new { success = false, message = e.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult EditFuel(int consumption_value, string fuel_type, string date1, String equipmentId, int fuelid)
{
QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = DBContext.Database.BeginTransaction())
{
try
{
// only taken by each department.
string department_id = Session["departID"].ToString();
//update
Equipment i = DBContext.Equipments.Find(equipmentId);
//check vehicle eq exist in department
FuelDB check = DBContext.Database.SqlQuery <FuelDB>(@"select equipment_id , equipment_name from
(select distinct e.equipment_id, e.equipment_name ,e.department_id from Equipment.Equipment e inner join Equipment.CategoryAttribute ea
on ea.Equipment_category_id = e.Equipment_category_id where
ea.Equipment_category_attribute_name = N'Số khung' or ea.Equipment_category_attribute_name = N'Số máy') as t
where department_id = @department_id
AND equipment_id = @equipmentId "
, new SqlParameter("department_id", department_id)
, new SqlParameter("equipmentId", equipmentId)
).First();
Supply s = DBContext.Database.SqlQuery <Supply>("select * from Supply.Supply where supply_id=@supply_id", new SqlParameter("supply_id", fuel_type)).First();
FuelDB f = DBContext.Database.SqlQuery <FuelDB>("select * from Equipment.FuelActivitiesConsumption where fuel_id=" + fuelid + "").First();
string date = DateTime.ParseExact(date1, "dd/MM/yyyy", null).ToString("MM-dd-yyyy");
DBContext.Database.ExecuteSqlCommand("UPDATE Equipment.FuelActivitiesConsumption set fuel_type =@fuel_type, [date] =@date1, consumption_value = @consumption_value, equipment_id = @equipmentId where fuel_id= @fuelid",
new SqlParameter("fuel_type", fuel_type), new SqlParameter("date1", date), new SqlParameter("consumption_value", consumption_value), new SqlParameter("equipmentId", equipmentId), new SqlParameter("fuelId", fuelid));
EditSupply_duphong(fuel_type, consumption_value);
//get old and new.
DBContext.SaveChanges();
transaction.Commit();
return(new HttpStatusCodeResult(201));
}
catch (Exception ex)
{
transaction.Rollback();
string output = "";
if (DBContext.Database.SqlQuery <Equipment>("SELECT * FROM Equipment.Equipment WHERE equipment_id = N'" + equipmentId + "'").Count() == 0)
{
output += "Mã thiết bị không tồn tại\n";
}
if (DBContext.Supplies.Where(x => (x.supply_id == fuel_type)).Count() == 0)
{
output += "Mã Nhiên Liệu không tồn tại\n";
}
if (output == "")
{
output += "Có lỗi xảy ra, xin vui lòng nhập lại";
}
Response.Write(output);
return(new HttpStatusCodeResult(400));
}
}
}
public ActionResult Add()
{
try
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
Room r = new Room
{
room_id = Request["id"],
capacity = Request["capacity"],
disk_status = Request["status"],
series = Request["serial"],
note = Request["note"],
room_name = Request["location"],
department_id = Request["department"],
camera_quantity = int.Parse(Request["quantity"].ToString()),
camera_available = int.Parse(Request["quantity"].ToString()),
signal_loss_reason = "",
disk_saveable = bool.Parse(Request["saveable"].ToString()),
login_information = Request["login"]
};
db.Rooms.Add(r);
db.SaveChanges();
if (Request.Files["img"] != null)
{
Image sourceimage = Image.FromStream(Request.Files["img"].InputStream, true, true);
r.image_link = r.room_id + ".jfif";
db.SaveChanges();
string path = "/images/camera/";
if (!Directory.Exists(HostingEnvironment.MapPath(path)))
{
Directory.CreateDirectory(HostingEnvironment.MapPath(path));
}
if (sourceimage.Size != null)
{
sourceimage.Save(HostingEnvironment.MapPath(path + r.image_link));
}
}
return(Json(new { success = true, message = "Thêm thành công" }));
}
catch (Exception)
{
return(Json(new { success = false, message = "Có lỗi xảy ra" }));
}
}
public ActionResult Index(string type, string date, string month, string quarter, string year)
{
Wherecondition(type, date, month, quarter, year);
List <content> content = new List <content>();
int tangbag = 0; int giambag = 0;
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
var nhom = db.Database.SqlQuery <CaName>("select ec.Equipment_category_name as MaNhom from Equipment e,Equipment_category ec where e.Equipment_category_id=ec.Equipment_category_id group by ec.Equipment_category_name").ToList();
foreach (var item in nhom)
{
if (ViewBag.ContentReportTang.Count > 0 || ViewBag.ContentReportGiam.Count > 0)
{
string find = item.MaNhom;
int tang = 0, giam = 0, Thang = 0, Nam = 0;
string MaNhom = ""; string MaHieu = ""; DateTime usedDay = DateTime.Now;
foreach (var item1 in ViewBag.ContentReportTang)
{
if (find.Equals(item1.MaNhom))
{
tang++;
tangbag++;
MaNhom = item1.MaNhom; MaHieu = item1.MaHieu; usedDay = item1.usedDay; Thang = item1.Thang; Nam = item1.Nam;
}
}
foreach (var item1 in ViewBag.ContentReportGiam)
{
if (find.Equals(item1.MaNhom))
{
giam++;
giambag++;
MaNhom = item1.MaNhom; MaHieu = item1.MaHieu; usedDay = item1.usedDay; Thang = item1.Thang; Nam = item1.Nam;
}
}
if (!String.IsNullOrEmpty(MaNhom))
{
content.Add(new content
{
Thang = Thang,
Nam = Nam,
MaNhom = MaNhom,
MaHieu = MaHieu,
usedDay = usedDay.Date,
Tang = tang,
Giam = giam
});
}
}
}
db.SaveChanges();
}
ViewBag.Tang = tangbag;
ViewBag.Giam = giambag;
ViewBag.content = content;
return(View("/Views/CDVT/Report/TangGiam.cshtml"));
}
public ActionResult Edit(string room_id, int documentary_id)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Acceptance acceptance = db.Acceptances.Where(x => x.documentary_id == documentary_id && x.room_id == room_id).FirstOrDefault();
if (acceptance != null && acceptance.acceptance_date != null)
{
return(Json(new { success = false, message = "Thiết bị đã được nghiệm thu" }));
}
acceptance.acceptance_date = DateTime.Now;
db.SaveChanges();
int acceptance_left = db.Acceptances.Where(x => x.documentary_id == documentary_id && x.acceptance_date != null).Count();
if (acceptance_left == 0)
{
Documentary documentary = db.Documentaries.Find(documentary_id);
documentary.documentary_status = 3;
}
Room r = db.Rooms.Find(room_id);
CameraRepairDetail detail = db.CameraRepairDetails.Where(x => x.documentary_id == documentary_id && x.room_id == room_id).FirstOrDefault();
r.camera_available += detail.broken_camera_quantity;
db.SaveChanges();
transaction.Commit();
return(Json(new { success = true, message = "Nghiệm thu thành công" }));
}
catch (Exception e)
{
e.Message.ToString();
transaction.Rollback();
return(Json(new { success = false, message = "Nghiệm thu thất bại" }));
}
}
}
public void EditSupply_duphong(String supplyid, int quantity)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
RepairRegularly1 duphong = db.RepairRegularly1.Where(x => x.supply_id == supplyid).FirstOrDefault();
if (duphong != null)
{
duphong.quantity -= quantity;
db.Entry(duphong).State = EntityState.Modified;
}
db.SaveChanges();
}
public ActionResult EditFuel(int consumption_value, string fuel_type, string date1, String equipmentId, int fuelid)
{
QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = DBContext.Database.BeginTransaction())
{
try
{
// only taken by each department.
string department_id = Session["departID"].ToString();
Equipment i = DBContext.Equipments.Where(x => (x.department_id == department_id && x.equipment_id == equipmentId)).First();
Supply s = DBContext.Database.SqlQuery <Supply>("select * from Supply.Supply where supply_id=@supply_id", new SqlParameter("supply_id", fuel_type)).First();
fuelDB f = DBContext.Database.SqlQuery <fuelDB>("select * from Equipment.FuelActivitiesConsumption where fuel_id=@fuelid", new SqlParameter("fuelid", fuelid)).First();
string date = DateTime.ParseExact(date1, "dd/MM/yyyy", null).ToString("MM-dd-yyyy");
DBContext.Database.ExecuteSqlCommand("UPDATE Equipment.FuelActivitiesConsumption set fuel_type =@fuel_type, [date] =@date1, consumption_value = @consumption_value, equipment_id = @equipmentId where fuel_id= @fuelid",
new SqlParameter("fuel_type", fuel_type), new SqlParameter("date1", DateTime.ParseExact(date1, "dd/MM/yyyy", null)), new SqlParameter("consumption_value", consumption_value), new SqlParameter("equipmentId", equipmentId), new SqlParameter("fuelId", fuelid));
//edit supply du phong.
int oldQuantity = f.consumption_value;
string oldEquipmentId = f.equipment_id;
string oldSupplyId = f.fuel_type;
EditSupply_duphong(oldEquipmentId, oldSupplyId, oldQuantity, equipmentId, fuel_type, consumption_value);
DBContext.SaveChanges();
transaction.Commit();
return(new HttpStatusCodeResult(201));
}
catch (Exception ex)
{
transaction.Rollback();
string output = "";
if (DBContext.Database.SqlQuery <Equipment>("SELECT * FROM Equipment.Equipment WHERE equipment_id = N'" + equipmentId + "'").Count() == 0)
{
output += "Mã thiết bị không tồn tại\n";
}
if (DBContext.Supplies.Where(x => (x.supply_id == fuel_type)).Count() == 0)
{
output += "Mã Nhiên Liệu không tồn tại\n";
}
if (output == "")
{
output += "Có lỗi xảy ra, xin vui lòng nhập lại";
}
Response.Write(output);
return(new HttpStatusCodeResult(400));
}
}
}
private void EditSupply_duphong(string oldEquipmentId, string oldSupplyid, int oldQuantity, string newEquipmentId, string newSupplyid, int newQuantity)
{
//find old supplies by device.
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
//if equipmentId and supplyId doesn't change after editing.
if (oldEquipmentId == newEquipmentId && oldSupplyid == newSupplyid)
{
RepairRegularly1 duphong = db.RepairRegularly1.Where(x => (x.supply_id == newSupplyid && x.equipment_id == newEquipmentId)).FirstOrDefault();
if (duphong != null)
{
duphong.quantity += oldQuantity;
duphong.quantity -= newQuantity;
db.Entry(duphong).State = EntityState.Modified;
}
}
else
{
//update quantity of old and new supplies remaining by each eqID.
RepairRegularly1 oldRecord = db.RepairRegularly1.Where(x => (x.supply_id == oldSupplyid && x.equipment_id == oldEquipmentId)).FirstOrDefault();
RepairRegularly1 newRecord = db.RepairRegularly1.Where(x => (x.supply_id == newSupplyid && x.equipment_id == newEquipmentId)).FirstOrDefault();
oldRecord.quantity += oldQuantity;
// if new doesn't exist => create new with quantity = -newQuantity
if (newRecord == null)
{
RepairRegularly1 sp = new RepairRegularly1()
{
supply_id = newSupplyid,
equipment_id = newEquipmentId,
quantity = -newQuantity
};
db.RepairRegularly1.Add(sp);
}
else
{
newRecord.quantity -= newQuantity;
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
}
public JsonResult UpdateSoQD(string id, string SoQD)
{
QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities();
using (DbContextTransaction dbct = db.Database.BeginTransaction())
{
try
{
if (!SoQD.Equals(""))
{
string query = @"select * from HumanResources.Decision where number = @SoQD";
List <Decision> qdList = db.Database.SqlQuery <Decision>(query, new SqlParameter("SoQD", SoQD)).ToList();
if (qdList.Count > 0)
{
return(Json(new { success = false, message = "Số quyết định trùng" }, JsonRequestBehavior.AllowGet));
}
else
{
int MaQD = Convert.ToInt32(id);
Decision qd = db.Decisions.Where(x => x.decision_id == MaQD).FirstOrDefault();
qd.number = SoQD;
qd.date = DateTime.Now.AddDays(2);
db.Entry(qd).State = EntityState.Modified;
List <string> maNV = db.Terminations.Where(x => x.decision_id == qd.decision_id).
Select(x => x.employee_id).ToList();
foreach (var item in maNV)
{
var Nv = db.Employees.Where(nv => nv.employee_id == item).FirstOrDefault();
Nv.current_status_id = 2;
db.Entry(Nv).State = EntityState.Modified;
}
db.SaveChanges();
dbct.Commit();
}
}
else
{
return(Json(new { success = false, message = "Chưa nhập số quyết định" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = true, message = "Thêm thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
dbct.Rollback();
return(Json(new { success = false, message = "Có lỗi khi thêm" }, JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult ResetPassword(string oldPass, string newPass, string rePass)
{
try
{
int id = Convert.ToInt32(Session["account_id"]);
string passXc = new XCryptEngine(XCryptEngine.AlgorithmType.MD5).Encrypt(oldPass, "pl");
string rePasss = new XCryptEngine(XCryptEngine.AlgorithmType.MD5).Encrypt(rePass, "pl");
var user = db.Accounts.Where(x => x.ID == id).FirstOrDefault();
if (string.IsNullOrEmpty(oldPass) || string.IsNullOrEmpty(newPass) || string.IsNullOrEmpty(rePass))
{
return(Json(new Result()
{
CodeError = 1,
Data = "Mật khẩu không được để trống"
}, JsonRequestBehavior.AllowGet));
}
if (!newPass.Equals(rePass))
{
return(Json(new Result()
{
CodeError = 1,
Data = "2 mật khẩu không trùng khớp"
}, JsonRequestBehavior.AllowGet));
}
if (!user.Password.Equals(passXc))
{
return(Json(new Result()
{
CodeError = 1,
Data = "Mật khẩu cũ không đúng"
}, JsonRequestBehavior.AllowGet));
}
user.Password = rePasss;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(Json(new Result()
{
CodeError = 2,
Data = "Thay đổi mật khẩu thành công"
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new Result()
{
CodeError = 1,
Data = "Có lỗi xảy ra. Vui lòng thử lại!"
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddQDQT(int documentory_id)
{
QuangHanhManufacturingEntities dbContext = new QuangHanhManufacturingEntities();
string username = Session["Username"].ToString();
Account account = dbContext.Accounts.Where(x => x.Username.Equals(username)).FirstOrDefault <Account>();
Important_Documentary checkDoc = dbContext.Important_Documentary.Where(x => x.documentary_id == documentory_id && x.AccountID == account.ID).FirstOrDefault();
if (checkDoc == null)
{
Important_Documentary important_Documentary = new Important_Documentary
{
documentary_id = documentory_id,
AccountID = account.ID
};
dbContext.Important_Documentary.Add(important_Documentary);
dbContext.SaveChanges();
}
else
{
dbContext.Important_Documentary.Remove(checkDoc);
dbContext.SaveChanges();
}
return(Json(new { message = "Success" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(string room_id)
{
using (QuangHanhManufacturingEntities db = new QuangHanhManufacturingEntities())
{
try
{
db.Configuration.LazyLoadingEnabled = false;
db.Rooms.Remove(db.Rooms.Find(room_id));
db.SaveChanges();
return(Json(new { success = true, message = "Xóa thành công" }));
}
catch (Exception)
{
Room r = db.Rooms.Find(Request["room_id"]);
if (r != null)
{
r.camera_quantity = 0;
r.camera_available = 0;
db.SaveChanges();
}
return(Json(new { success = true, message = "Xóa thành công" }));
}
}
}