private void saveData(int sCheck)
{
string sCode = string.Empty;
string sName = string.Empty;
string sKhoa;
string sShortName = string.Empty;
DateTime sNgayKG = new DateTime();
DateTime sNgayKT = new DateTime();
DateTime sNgayQD = new DateTime();
int sCcId;
sCode = txtCode.Text;
sName = txtName.Text;
sKhoa = txtKhoa.Text;
sShortName = txtShortName.Text;
//object startDate = dateNgayKG.Text;
//object endDadate = dateNgayKT.Text;
//object sDate = dateNgayQD.Text;
//startDate = dateNgayKG.Text.Substring(3, 2) + "/" + dateNgayKG.Text.Substring(0, 2) + "/" + dateNgayKG.Text.Substring(6, 4);
//endDadate = dateNgayKT.Text.Substring(3, 2) + "/" + dateNgayKT.Text.Substring(0, 2) + "/" + dateNgayKT.Text.Substring(6, 4);
//sDate = dateNgayQD.Text.Substring(3, 2) + "/" + dateNgayQD.Text.Substring(0, 2) + "/" + dateNgayQD.Text.Substring(6, 4);
//sNgayKG = DateTime.ParseExact(dateNgayKG.Text, "mm/dd/yyyy", null);
//sNgayKT = DateTime.ParseExact(dateNgayKT.Text, "mm/dd/yyyy", null);
//sNgayQD = DateTime.ParseExact(dateNgayQD.Text, "mm/dd/yyyy", null);
sNgayKG = dateNgayKG.DateTime;
sNgayKT = dateNgayKT.DateTime;
sNgayQD = dateNgayQD.DateTime;
sCcId = mCcId;
if (sCheck == 1)
{
boLop.insert(sCode, sName, sKhoa, sShortName, sNgayKG, sNgayKT, sNgayQD, sCcId);
int sLastLopId = int.Parse(boLop.getLOP_LastId().Rows[0]["LastID"].ToString());
Dictionary <int, int> sDicIdMonHoc = new Dictionary <int, int>();
for (int i = 0; i < boLop.getCC_MONHOC_BY_CCID(mCcId).Rows.Count - 1; i++)
{
sDicIdMonHoc.Add(int.Parse(boLop.getCC_MONHOC_BY_CCID(mCcId).Rows[i]["CCM_MONID"].ToString()), i);
}
foreach (var item in sDicIdMonHoc)
{
mMonHocId = item.Key;
// get so tiet khi da co mon id
int sMonSotiet = int.Parse(boLop.SelectMONHOC_SoTiet_MonId(mMonHocId).Rows[0]["MON_SoTiet"].ToString());
boMonlop.insert(txtMonLopCode.Text, sLastLopId, mMonHocId, -1, sMonSotiet);
}
}
else
if (sCheck == 2)
{
boLop.update(iLop, sCode, sName, sKhoa, sShortName, sNgayKG, sNgayKT, sNgayQD, sCcId);
// CHECK UPDATE MON_LOP TABLE HERE
}
}
