private bool SaveQuytrinh(string txtConfigValue, string sConfigName)
{
try
{
var query = (from c in DBContext.THAMSOes.Where(c => c.NAME == sConfigName)
select c);
int nCount = query.Count();
if (nCount == 0)
{
THAMSO q = new THAMSO();
q.NAME = sConfigName;
q.VALUE = txtConfigValue;
DBContext.THAMSOes.AddObject(q);
DBContext.SaveChanges();
}
else
{
foreach (THAMSO q in query)
{
q.VALUE = txtConfigValue;
}
DBContext.SaveChanges();
}
}
catch (SystemException ex)
{
ex.Message.ToString();
return(false);
}
return(true);
}
public static THAMSO LoadThamSo()
{
//ThamSoDAO thamSoDAO = new ThamSoDAO();
THAMSO thamso = ThamSoDAO.LoadThamSo();
return(thamso);
}
public ActionResult DeleteConfirmed(int id)
{
THAMSO tHAMSO = db.THAMSOes.Find(id);
db.THAMSOes.Remove(tHAMSO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool Inseart()
{
var hd = new THAMSO()
{
Name = view.Name,
Value = view.Value
};
return(model.Insert(hd));
}
public bool Update()
{
var ct = new THAMSO()
{
Name = view.Name,
Value = view.Value
};
return(model.Update(ct));
}
public ActionResult Edit([Bind(Include = "MaTS,TuoiTT,TuoiTD,SoCauThuTT,SoCauThuTD,SoCauThuNgoaiTD,ThoiDiemTT,ThoiDiemTD,DiemThang,DiemHoa,DiemThua")] THAMSO tHAMSO)
{
if (ModelState.IsValid)
{
db.Entry(tHAMSO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tHAMSO));
}
public void Delete(string tenthamso, string giatri)
{
THAMSO ts = datacontext.THAMSOs.Where(p => p.TEN == tenthamso).FirstOrDefault();
if (ts != null)
{
datacontext.THAMSOs.DeleteOnSubmit(ts);
datacontext.SubmitChanges();
}
}
public ActionResult Edit([Bind(Include = "PhanTramTraTruoc")] THAMSO tHAMSO)
{
if (ModelState.IsValid)
{
db.Entry(tHAMSO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tHAMSO));
}
public ActionResult Create([Bind(Include = "PhanTramTraTruoc")] THAMSO tHAMSO)
{
if (ModelState.IsValid)
{
db.THAMSOes.Add(tHAMSO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tHAMSO));
}
public ActionResult Create([Bind(Include = "MaTS,TuoiTT,TuoiTD,SoCauThuTT,SoCauThuTD,SoCauThuNgoaiTD,ThoiDiemTT,ThoiDiemTD,DiemThang,DiemHoa,DiemThua")] THAMSO tHAMSO)
{
if (ModelState.IsValid)
{
db.THAMSOes.Add(tHAMSO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tHAMSO));
}
public void Insert(string tenthamso, string kieu, string giatri)
{
THAMSO ts = new THAMSO()
{
TEN = tenthamso,
KIEU = kieu,
GIATRI = giatri
};
datacontext.THAMSOs.InsertOnSubmit(ts);
datacontext.SubmitChanges();
}
// Lấy tham số
public static double LayThamSo(string tenThamSo)
{
THAMSO ts = THAMSO_DAL.LayThamSo(tenThamSo);
if (ts != null)
{
return(ts.GIATRI.Value);
}
else
{
return(0);
}
}
public void LoadThamSo()
{
//ThamSoBUS tsBUS = new ThamSoBUS();
THAMSO thamso = ThamSoBUS.LoadThamSo();
txtTuoiToiThieu.Text = thamso.TuoiToiThieu.ToString();
txtTuoiToiDa.Text = thamso.TuoiToiDa.ToString();
txtThoiHanGiaTriThe.Text = thamso.ThoiHanGiaTriThe.ToString();
txtKhoangCachNamXuatBan.Text = thamso.KhoangCachNamXuatBanToiDa.ToString();
txtSoLuongSachMuon.Text = thamso.SoLuongSachMuonToiDa.ToString();
txtSoNgayMuon.Text = thamso.SoNgayMuonToiDa.ToString();
txtTienPhat.Text = thamso.TienPhat.ToString();
}
public string Get(string tenthamso)
{
THAMSO ts = datacontext.THAMSOs.Where(p => p.TEN == tenthamso).FirstOrDefault();
if (ts != null)
{
return(ts.GIATRI);
}
else
{
return("");
}
}
// GET: Manager/ThamSo/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
THAMSO tHAMSO = db.THAMSOes.Find(id);
if (tHAMSO == null)
{
return(HttpNotFound());
}
return(View(tHAMSO));
}
public int Set(string tenthamso, string giatri)
{
THAMSO ts = datacontext.THAMSOs.Where(p => p.TEN == tenthamso).FirstOrDefault();
if (ts != null)
{
ts.GIATRI = giatri;
datacontext.SubmitChanges();
return(0); // tìm thấy
}
else
{
return(1); // k tìm thấy tham số
}
}
public void TestCheckDuplicatedData_EditThamSo(string tenTS, string selectedTenTS, string giaTri,
decimal selectedGiaTri, bool isChecked, bool flag, bool expectedRes)
{
viewModel.TenThamSo = tenTS;
viewModel.GiaTri = giaTri;
viewModel.IsCheckedToggle = isChecked;
THAMSO selected = new THAMSO();
selected.TenThamSo = selectedTenTS;
selected.GiaTri = selectedGiaTri;
viewModel.SelectedItemThamSo = selected;
viewModel.CheckDuplicatedData_EditThamSo(ref flag);
Assert.AreEqual(expectedRes, flag);
}
private void btThem_Click(object sender, RoutedEventArgs e)
{
if (CheckNull() == true)
{
return;
}
else
{
using (var db = new QLTV_DBContext())
{
var qd = new THAMSO(txtNoiDungQD_ID.Text, int.Parse(txtGiaTri.Text), txtGhichu.Text);
db.THAMSOs.Add(qd);
db.SaveChanges();
QuyDinhList.ItemsSource = db.THAMSOs.ToList();
QuyDinhList.Items.Refresh();
}
}
}
public bool UpdateTS(string mats, int tigia, int muaMax, int tonMax, int tonMin, int banMax)
{
try
{
THAMSO ts = qllk.THAMSOs.Where(t => t.MaTS == mats).FirstOrDefault();
ts.MaTS = mats;
ts.TiLeGiaBan = tigia;
ts.SLMuaToiDa = muaMax;
ts.SLTonToiDa = tonMax;
ts.SLTonToiThieu = tonMin;
ts.SLBanToiDa = banMax;
qllk.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//update
public bool Update(int id, int soDLToiDa, int soMatHang, int soDVT)
{
using (QLDLDataContext db = new QLDLDataContext())
{
THAMSO update = db.THAMSOs.Where(p => p.ID == id).FirstOrDefault();
update.SoDaiLyToiDaQuan = soDLToiDa;
update.SoMatHang = soMatHang;
update.SoDonViTinh = soDVT;
db.SubmitChanges();
try
{
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
