private void dgv_DanhSach_AfterExitEditMode(object sender, EventArgs e)
{
try
{
var hs = new DapAn
{
IdKyThi = _idkythi,
MaMon = dgv_DanhSach.ActiveRow.Cells["MaMon"].Text,
MaDe = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text,
CauHoi = int.Parse(dgv_DanhSach.ActiveRow.Cells["CauHoi"].Text),
ThangDiem = !string.IsNullOrEmpty(dgv_DanhSach.ActiveRow.Cells["ThangDiem"].Text) ? double.Parse(dgv_DanhSach.ActiveRow.Cells["ThangDiem"].Text) : 0,
};
_listUpdate.Add(hs);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void Nhapdiem()
{
try
{
var frm = new FrmNhapDiem();
frm.ShowDialog();
if (string.IsNullOrEmpty(frm.txtNhapdiem.Text)) return;
_listUpdate.Clear();
foreach (var row in dgv_DanhSach.Rows)
{
row.Cells["ThangDiem"].Value = frm.txtNhapdiem.Text;
var hs = new DapAn
{
IdKyThi = _idkythi,
MaMon = row.Cells["MaMon"].Text,
MaDe = row.Cells["MaDe"].Text,
CauHoi = int.Parse(row.Cells["CauHoi"].Text),
ThangDiem = double.Parse(frm.txtNhapdiem.Text)
};
_listUpdate.Add(hs);
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
/// <summary>
/// Sửa lại đáp án đúng của 1 câu hỏi
/// </summary>
/// <returns>true</returns>
private static void UpdateThangDiem(DapAn item)
{
try
{
var thangdiem = item.ThangDiem.ToString().Replace(',', '.');
var str = "UPDATE DAPAN SET ThangDiem = " + thangdiem + " " +
"WHERE MaMon = '" + item.MaMon + "' and MaDe = '" + item.MaDe + "' " +
"and CauHoi =" + item.CauHoi + " and IdKyThi= " + item.IdKyThi + "";
Conn.ExcuteQuerySql(str);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
/// <summary>
/// Sửa lại đáp án đúng của câu hỏi
/// </summary>
/// <returns>true</returns>
private static void UpdateDapAn(DapAn item)
{
try
{
Conn.ExcuteQuerySql("UPDATE DAPAN SET Dapan = '" + item.Dapan + "' " +
"WHERE MaMon = '" + item.MaMon + "' and MaDe = '" + item.MaDe + "' " +
"and CauHoi = " + item.CauHoi + " and IdKyThi= " + item.IdKyThi + "");
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
/// <summary>
/// Lưu dữ liệu trên UltraGrid
/// </summary>
protected override void SaveDetail()
{
try
{
foreach (var row in dgv_DanhSach.Rows)
{
var hs = new DapAn
{
IdKyThi = _idKythi,
MaMon = row.Cells["MaMon"].Text,
MaDe = row.Cells["MaDe"].Text,
CauHoi = int.Parse(row.Cells["CauHoi"].Text),
Dapan = row.Cells["Dapan"].Text,
ThangDiem = 0
};
_listAdd.Add(hs);
}
if (_listAdd.Count <= 0) return;
InsertData.ThemDapAn(_listAdd);
MessageBox.Show(@"Đã lưu vào CSDL", FormResource.MsgCaption, MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.Contains(FormResource.msgLostConnect) ? FormResource.txtLoiDB : ex.Message);
Log2File.LogExceptionToFile(ex);
}
}
/// <summary>
/// Thêm 1 đáp án cho mã đề
/// </summary>
/// <returns></returns>
public static bool ThemDapAn(DapAn item)
{
try
{
Conn.ExcuteQuerySql("insert into DapAn(IdKyThi,MaMon,MaDe,CauHoi,Dapan,ThangDiem) values(" +
item.IdKyThi + ",'" + item.MaMon + "','" + item.MaDe + "'," +
item.CauHoi + ",'" + item.Dapan + "'," + item.ThangDiem + ")");
return true;
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return false;
}
}
private void dgv_DanhSach_AfterExitEditMode(object sender, EventArgs e)
{
try
{
var hs = new DapAn
{
IdKyThi = _idKyThi,
MaMon = dgv_DanhSach.ActiveRow.Cells["MaMon"].Text,
MaDe = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text,
CauHoi = int.Parse(dgv_DanhSach.ActiveRow.Cells["CauHoi"].Text),
Dapan = dgv_DanhSach.ActiveRow.Cells["Dapan"].Text,
};
_listUpdate.Add(hs);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
