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; }