public KichBanXa GetInfoByKichBanCode(int kichBanCode)
{
KichBanXa result = null;
try
{
result = new KichBanXa();
thiet_lap_kich_ban_tb tmpThietLapKichBan =
_database._databaseContext.thiet_lap_kich_ban_tb.FirstOrDefault(
x => x.deleted_status == 0 && x.thiet_lap_kich_ban_code == kichBanCode);
if (tmpThietLapKichBan != null)
{
result.KichBan = tmpThietLapKichBan;
List <thiet_lap_kich_ban_detail_tb> tmpLapKichBanDetail =
_database._databaseContext.thiet_lap_kich_ban_detail_tb.Where(
x =>
x.deleted_status == 0 &&
x.thiet_lap_kich_ban_ref == tmpThietLapKichBan.thiet_lap_kich_ban_code).ToList();
result.KichBanChiTiet = tmpLapKichBanDetail;
}
}
catch (Exception ex)
{
result = null;
}
return(result);
}
public ActionResult LuuKichBanXa(int kichbancode, int vitricode, double mucnuoc, double luuluong, DateTime time,
string jsondata)
{
List <thiet_lap_kich_ban_detail_tb> listKichBanChiTiet = serializer.Deserialize <List <thiet_lap_kich_ban_detail_tb> >(jsondata);
listKichBanChiTiet = listKichBanChiTiet.OrderBy(x => x.thoi_gian).ToList();
KichBanXa kichBanXa = new KichBanXa()
{
KichBan = new thiet_lap_kich_ban_tb
{
thiet_lap_kich_ban_code = kichbancode,
thoi_gian = time,
vi_tri_ref = vitricode,
muc_nuoc_ho = mucnuoc,
luu_luong_ve_ho = luuluong
},
KichBanChiTiet = listKichBanChiTiet
};
bool result = _thietlapxa.UpdateKichBan(kichBanXa);
if (result)
{
return(Json(new
{
listKichBan = _thietlapxa.GetListKichBanByUserTLVN(Convert.ToInt32(Security.CurrentUserId)),
codeKichBan = kichbancode
}));
}
return(Json(result));
}
public KichBanXa TinhToanXa(KichBanXa kichbanxa)
{
KichBanXa result = null;
if (kichbanxa != null & kichbanxa.KichBanChiTiet.Count > 0)
{
try
{
thiet_lap_kich_ban_tb kichBan = kichbanxa.KichBan;
var kichBanChiTiet = kichbanxa.KichBanChiTiet;
// Tính toán cho bản ghi đầu
double hHienTai = _common.TimDungTich(kichBan.vi_tri_ref, kichBan.muc_nuoc_ho);
TimeSpan tmpTimeSpan = kichBanChiTiet[0].thoi_gian.Value - kichBan.thoi_gian.Value;
double totalSecond = tmpTimeSpan.TotalSeconds;
double totalQden = kichBanChiTiet[0].luu_luong_du_bao;
double totalQXa = kichBanChiTiet[0].tong_tran + kichBanChiTiet[0].luu_luong_phat_dien +
kichBanChiTiet[0].luu_luong_xa;
double?tmpDungTich = TinhDungTichDuBao(hHienTai, totalQden, totalQXa, totalSecond);
//kichBanChiTiet[0].dung_tich_ho = Math.Round(tmpDungTich == null ? 0 : tmpDungTich.Value,3);
kichBanChiTiet[0].dung_tich_ho = tmpDungTich == null ? 0 : Math.Round(tmpDungTich.Value, 3);
kichBanChiTiet[0].muc_nuoc_ho = Math.Round(_common.TimMucNuoc(kichBan.vi_tri_ref,
kichBanChiTiet[0].dung_tich_ho), 3);
// Tính cho các bản ghi tiếp theo
for (int i = 1; i < kichBanChiTiet.Count; i++)
{
thiet_lap_kich_ban_detail_tb kb1 = kichBanChiTiet[i - 1];
thiet_lap_kich_ban_detail_tb kb2 = kichBanChiTiet[i];
tmpTimeSpan = kb2.thoi_gian.Value - kb1.thoi_gian.Value;
totalSecond = tmpTimeSpan.TotalSeconds;
totalQden = kb2.luu_luong_du_bao;
totalQXa = kb2.tong_tran + kb2.luu_luong_phat_dien + kb2.luu_luong_xa;
tmpDungTich = TinhDungTichDuBao(hHienTai, totalQden, totalQXa, totalSecond);
//kb2.dung_tich_ho = Math.Round(tmpDungTich == null ? 0 : tmpDungTich.Value, 3);
kb2.dung_tich_ho = tmpDungTich == null ? 0 : Math.Round(tmpDungTich.Value, 3);
kb2.muc_nuoc_ho = Math.Round(_common.TimMucNuoc(kichBan.vi_tri_ref, kb2.dung_tich_ho), 3);
}
result = kichbanxa;
}
catch (Exception ex)
{
}
}
return(result);
}
// GET: ThietLapXa
public ActionResult Index()
{
KichBanXa kbx = new KichBanXa();
DateTime tmp = DateTime.Today;
tmp = tmp.AddHours(DateTime.Now.Hour + 1);
ViewBag.MucNuoc = _common.GetDataLakeEVN(1, 1);
ViewBag.LuuLuong = _common.GetDataLakeEVN(1, 5);
var tmpListThietLap = _thietlapxa.GetListKichBanByUserTLVN(Convert.ToInt32(Security.CurrentUserId));
tmpListThietLap.Insert(0, new thiet_lap_kich_ban_tb
{
thiet_lap_kich_ban_code = -1,
thiet_lap_kich_ban_name = "--Không chọn--"
});
ViewBag.ListThietLap = new SelectList(tmpListThietLap, "thiet_lap_kich_ban_code", "thiet_lap_kich_ban_name", -1);
kbx.KichBanChiTiet = new List <thiet_lap_kich_ban_detail_tb>()
{
new thiet_lap_kich_ban_detail_tb()
{
thoi_gian = tmp, luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100
},
new thiet_lap_kich_ban_detail_tb()
{
thoi_gian = tmp.AddHours(1), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100
},
new thiet_lap_kich_ban_detail_tb()
{
thoi_gian = tmp.AddHours(2), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100
},
new thiet_lap_kich_ban_detail_tb()
{
thoi_gian = tmp.AddHours(3), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100
},
new thiet_lap_kich_ban_detail_tb()
{
thoi_gian = tmp.AddHours(4), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100
}
};
return(View(kbx));
}
public ActionResult TaoKichBanXa(int vitricode, double mucnuoc, double luuluong, DateTime time, string jsondata)
{
List <thiet_lap_kich_ban_detail_tb> listKichBanChiTiet = serializer.Deserialize <List <thiet_lap_kich_ban_detail_tb> >(jsondata);
listKichBanChiTiet = listKichBanChiTiet.OrderBy(x => x.thoi_gian).ToList();
KichBanXa kichBanXa = new KichBanXa()
{
KichBan = new thiet_lap_kich_ban_tb
{
thoi_gian = time,
vi_tri_ref = vitricode,
muc_nuoc_ho = mucnuoc,
luu_luong_ve_ho = luuluong
},
KichBanChiTiet = listKichBanChiTiet
};
kichBanXa = _handl.TinhToanXa(kichBanXa);
return(Json(kichBanXa.KichBanChiTiet));
}
public bool UpdateKichBan(KichBanXa kichBanXa)
{
bool result = false;
if (kichBanXa != null & !String.IsNullOrEmpty(Security.CurrentUserGuid))
{
try
{
thiet_lap_kich_ban_tb tmpThietLapKichBan = kichBanXa.KichBan;
List <thiet_lap_kich_ban_detail_tb> tmpLapKichBanDetail = kichBanXa.KichBanChiTiet;
if (tmpThietLapKichBan.thiet_lap_kich_ban_code == -1)
{
#region Insert moi
var vitri = _database._databaseContext.vi_tri_tb.FirstOrDefault(x => x.vi_tri_code == tmpThietLapKichBan.vi_tri_ref);
// Them moi thiet_lap_kich_ban_tb
tmpThietLapKichBan.created_at = DateTime.Now;
tmpThietLapKichBan.last_modified_at = DateTime.Now;
tmpThietLapKichBan.created_by = Security.CurrentUserName;
tmpThietLapKichBan.last_modified_by = Security.CurrentUserName;
tmpThietLapKichBan.deleted_status = 0;
tmpThietLapKichBan.user_ref = Convert.ToInt32(Security.CurrentUserId);
if (vitri != null)
{
tmpThietLapKichBan.thiet_lap_kich_ban_name = String.Format("Hồ {0}: Kịch bản {1}", vitri.vi_tri_name, DateTime.Now.ToString("dd/MM/yyyy HH:mm"));
}
_database._databaseContext.thiet_lap_kich_ban_tb.Add(tmpThietLapKichBan);
_database._databaseContext.SaveChanges();
// Them moi thiet_lap_kich_ban_detail_tb
foreach (thiet_lap_kich_ban_detail_tb item in tmpLapKichBanDetail)
{
item.created_at = DateTime.Now;
item.last_modified_at = DateTime.Now;
item.created_by = Security.CurrentUserName;
item.last_modified_by = Security.CurrentUserName;
item.deleted_status = 0;
item.thiet_lap_kich_ban_ref = tmpThietLapKichBan.thiet_lap_kich_ban_code;
_database._databaseContext.thiet_lap_kich_ban_detail_tb.Add(item);
}
_database._databaseContext.SaveChanges();
result = true;
#endregion
}
else
{
#region update
// Cap nhat thiet_lap_kich_ban_tb
thiet_lap_kich_ban_tb tmpGoc = _database._databaseContext.thiet_lap_kich_ban_tb.FirstOrDefault(
x => x.thiet_lap_kich_ban_code == tmpThietLapKichBan.thiet_lap_kich_ban_code);
if (tmpGoc != null)
{
tmpGoc.muc_nuoc_ho = tmpThietLapKichBan.muc_nuoc_ho;
tmpGoc.luu_luong_ve_ho = tmpThietLapKichBan.luu_luong_ve_ho;
tmpGoc.last_modified_at = DateTime.Now;
tmpGoc.last_modified_by = Security.CurrentUserName;
tmpGoc.deleted_status = 0;
_database._databaseContext.thiet_lap_kich_ban_tb.Attach(tmpGoc);
_database._databaseContext.Entry(tmpGoc).State = EntityState.Modified;
_database._databaseContext.SaveChanges();
// Them moi thiet_lap_kich_ban_detail_tb
string sqlDelete = String.Format(@"update thiet_lap_kich_ban_detail_tb
set deleted_status = 1
where thiet_lap_kich_ban_ref = {0}", tmpGoc.thiet_lap_kich_ban_code);
_database._databaseContext.Database.ExecuteSqlCommand(sqlDelete);
foreach (thiet_lap_kich_ban_detail_tb item in tmpLapKichBanDetail)
{
item.created_at = DateTime.Now;
item.last_modified_at = DateTime.Now;
item.created_by = Security.CurrentUserName;
item.last_modified_by = Security.CurrentUserName;
item.deleted_status = 0;
item.thiet_lap_kich_ban_ref = tmpThietLapKichBan.thiet_lap_kich_ban_code;
_database._databaseContext.thiet_lap_kich_ban_detail_tb.Add(item);
}
_database._databaseContext.SaveChanges();
result = true;
}
#endregion
}
}
catch (Exception ex)
{
}
}
return(result);
}
public JsonResult GetInfoKichBan(int kichbancode)
{
KichBanXa tmp = _thietlapxa.GetInfoByKichBanCode(kichbancode);
return(Json(tmp));
}
