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
}
}
private bool 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;
sNgayKG = dateNgayKG.DateTime;
sNgayKT = dateNgayKT.DateTime;
sNgayQD = dateNgayQD.DateTime;
sCcId = mCcId;
if (int.Parse(lookCcID.EditValue.ToString()) == 23)
{
if (lookLevel.ItemIndex < 0)
{
MessageBox.Show("Chưa chọn cấp độ cho lớp: " + txtName.Text + " " + txtKhoa.Text, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
try
{
if (sCheck == 1)
{
iLop = boLop.insert(sCode, sName, sKhoa, sShortName, sNgayKG, sNgayKT, sNgayQD, sCcId);
}
else if (sCheck == 2)
{
boLop.update(iLop, sCode, sName, sKhoa, sShortName, sNgayKG, sNgayKT, sNgayQD, sCcId);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
//if (saveLevel(LevelID, iLop, int.Parse(lookLevel.EditValue.ToString())))
// return true;
//else
// return false;
}