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)); } } }
public ActionResult getFuelID(int fuelid) { try { QuangHanhManufacturingEntities DBContext = new QuangHanhManufacturingEntities(); fuelDB activity = DBContext.Database.SqlQuery <fuelDB>( @"select f.fuel_id, f.[date], f.equipment_id, f.fuel_type, e.equipment_name , s.supply_name , f.consumption_value , s.unit ,sd.quantity from Equipment.FuelActivitiesConsumption f, Equipment.Equipment e , Supply.Supply s , Supply.RepairRegularly sd where e.equipment_id = f.equipment_id and s.supply_id = f.fuel_type and sd.supply_id = s.supply_id and sd.equipment_id = e.equipment_id and f.fuel_id = @fuelid order by f.[date] desc ", new SqlParameter("fuelid", fuelid)).First(); activity.stringDate = activity.date.ToString("dd/MM/yyyy"); return(Json(activity)); } catch (Exception) { Response.Write("Có lỗi xảy ra, xin vui lòng nhập lại"); return(new HttpStatusCodeResult(400)); } }