public bool XoaTieuChi(TieuChi tc)
{
try
{
var kq = TimTieuChi(tc.MaTC);
if (kq == default(TieuChi))
{
return(false);
}
//kiem tra rang buoc:
if (tc.TieuChiTheoBieuMaus.Count > 0)
{
throw new Exception();
}
if (tc.CapDoTheoTieuChis.Count > 0)
{
throw new Exception();
}
dc.TieuChis.DeleteOnSubmit(tc);
return(true);
}
catch
{
return(false);
}
}
public bool ThemTieuChi(TieuChi tc)
{
try
{
//var kq = TimTieuChi(tc.MaTC);
//if (kq != default(TieuChi)) return false;
dc.TieuChis.InsertOnSubmit(tc);
return(true);
}
catch
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
var paramId = MyUtility.LayQueryString("id");
if (paramId != null)
{
int maTC = int.Parse(paramId);
TieuChi tieuChi = kho.TimTieuChi(maTC);
hdfmaTC.Value = maTC.ToString();
txtTenTC.Text = tieuChi.TenTC;
txtTrongSo.Text = tieuChi.TrongSo.ToString();
txtMoTa.Text = tieuChi.MoTa;
ddlNTC.SelectedValue = tieuChi.MaNTC.ToString();
this.loadCapDo2LV(maTC);
ILEN.View.Load2LV(kho.TimCapDoTheoTC(maTC), lvDSCDTheoTC);
}
ILEN.View.Load2DDL(kho.TimNhomTieuChiTheoMaDV(1), ddlNTC, true);
}
}
public bool SuaTieuChi(TieuChi tc)
{
try
{
var kq = TimTieuChi(tc.MaTC);
if (kq == default(TieuChi))
{
return(false);
}
kq.MaNTC = tc.MaNTC;
kq.TenTC = tc.TenTC;
kq.TrongSo = tc.TrongSo;
kq.MoTa = tc.MoTa;
kq.MaTCCha = tc.MaTCCha;
kq.TenTCEN = tc.TenTCEN;
return(true);
}
catch
{
return(false);
}
}
protected void btnLuuTC_Click(object sender, EventArgs e)
{
string tenVN = string.Empty;
string tenEN = string.Empty;
if (!MyUtility.TextBoxHopLe(txtTenTC, out tenVN))
{
lblKQ.Text = "Tên không được bỏ trống!";
return;
}
double ts = 0;
double.TryParse(txtTrongSo.Text, out ts);
if (ts <= 0)
{
lblKQ.Text = "Trọng số không hợp lệ!";
return;
}
var maNTC = int.Parse(ddlNTC.SelectedValue);
if (maNTC == 0)
{
lblKQ.Text = "Nhóm tiêu chí không hợp lệ!";
return;
}
var maTC = int.Parse(hdfmaTC.Value);
if (maTC == 0)
{
TieuChi tc = new TieuChi()
{
MaNTC = maNTC,
TenTC = tenVN,
TenTCEN = tenEN,
TrongSo = ts,
MoTa = txtMoTa.Text
};
if (!kho.ThemTieuChi(tc))
{
lblKQ.Text = "Lỗi lưu dữ liệu11!";
return;
}
}
else
{
TieuChi tc = new TieuChi()
{
MaTC = maTC,
MaNTC = maNTC,
TenTC = tenVN,
TenTCEN = tenEN,
TrongSo = ts,
MoTa = txtMoTa.Text
};
if (!kho.SuaTieuChi(tc))
{
lblKQ.Text = "Lỗi lưu dữ liệu22!";
return;
}
}
if (!kho.Luu())
{
lblKQ.Text = "Lỗi lưu dữ liệu!";
return;
}
//reload:
Response.Redirect("~/Admin/QLTieuChi.aspx");
}
public ActionResult Create()
{
var ma_tchuan = System.Web.HttpContext.Current.Request.Params["ma_tieuchuan"];
var ten_tieuchi = System.Web.HttpContext.Current.Request.Params["ten_tieuchi"];
var diem = System.Web.HttpContext.Current.Request.Params["diem"];
var khoa = Boolean.Parse(System.Web.HttpContext.Current.Request.Params["khoa"]);
var truong = Boolean.Parse(System.Web.HttpContext.Current.Request.Params["truong"]);
var thanh = Boolean.Parse(System.Web.HttpContext.Current.Request.Params["thanh"]);
var trunguong = Boolean.Parse(System.Web.HttpContext.Current.Request.Params["trunguong"]);
var batbuoc = Boolean.Parse(System.Web.HttpContext.Current.Request.Params["batbuoc"]);
var ma_phancap = System.Web.HttpContext.Current.Request.Params["ma_phancap"];
if (diem == null)
{
diem = "0";
}
List <TieuChi> tc_list = new List <TieuChi>();
TieuChi tc = new TieuChi();
if (ma_phancap == "LHTT")
{
var tieuchi = db.TieuChis.Where(a => a.MaPhanCap == "LHTT").OrderByDescending(a => a.Ma_NDTieuChi).FirstOrDefault().Ma_NDTieuChi;
char[] tam = tieuchi.ToCharArray();
int stt = int.Parse(tam[tam.Count() - 1].ToString()) + 1;
tc.MaPhanCap = "LHTT";
tc.Diem = float.Parse(diem);
tc.MaTieuChi = ma_tchuan;
tc.Ma_NDTieuChi = ma_tchuan + stt;
tc.TenNDTieuChi = ten_tieuchi;
tc.MaTieuChi = ma_tchuan;
tc_list.Add(tc);
db.TieuChis.InsertAllOnSubmit(tc_list);
db.SubmitChanges();
return(Json(new { success = true, mess = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet));
}
else if (ma_phancap == "SV5T")
{
var tam = db.PhanCap_TieuChis.Where(a => (a.Khoa == khoa) && (a.Truong == truong) && (a.Thanh == thanh) && (a.TrungUong == trunguong)).Select(a => a.MaPhanCap).FirstOrDefault();
if (tam.Count() == 0)
{
khoa = true;
}
tc.MaPhanCap = db.PhanCap_TieuChis.Where(a => (a.Khoa == khoa) && (a.Truong == truong) && (a.Thanh == thanh) && (a.TrungUong == trunguong)).Select(a => a.MaPhanCap).FirstOrDefault();
tc.Diem = float.Parse(diem);
tc.MaTieuChi = ma_tchuan;
var tieuchi = db.TieuChis.Where(a => a.MaTieuChi == ma_tchuan).OrderByDescending(a => a.Ma_NDTieuChi).FirstOrDefault().Ma_NDTieuChi;
char[] abc = tieuchi.ToCharArray();
int stt = int.Parse(abc[abc.Count() - 1].ToString()) + 1;
tc.Ma_NDTieuChi = "SV" + ma_tchuan + stt;
tc.TenNDTieuChi = ten_tieuchi;
tc_list.Add(tc);
db.TieuChis.InsertAllOnSubmit(tc_list);
db.SubmitChanges();
return(Json(new { success = true, mess = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false, mess = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet));
}
