private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) // redo
{
if (Program.indexLogGVDK < Program.logGVDK.Count - 1)
{
Program.indexLogGVDK++;
DataLogGVDK logGvdk = Program.logGVDK[Program.indexLogGVDK];
if (logGvdk.Action.Equals("I"))
{
SqlCommand sqlcmd = new SqlCommand("SP_THEM_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAGV", logGvdk.Sau.MaGV);
sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop);
sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Sau.TrinhDo);
sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Sau.NgayThi);
sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan);
sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Sau.SoCauThi);
sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Sau.ThoiGian);
MessageBox.Show(logGvdk.Action + logGvdk.Sau.MaMH + " " + logGvdk.Sau.MaLop + " " + logGvdk.Sau.Lan + "" + logGvdk.Sau.TrinhDo + logGvdk.Sau.NgayThi + logGvdk.Sau.SoCauThi + logGvdk.Sau.ThoiGian);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
}
}
if (logGvdk.Action.Equals("D"))
{
SqlCommand sqlcmd = new SqlCommand("SP_XOA_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop);
sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
}
}
if (logGvdk.Action.Equals("U"))
{
SqlCommand sqlcmd = new SqlCommand("SP_SUA_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAGV", logGvdk.Sau.MaGV);
sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop);
sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Sau.TrinhDo);
sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Sau.NgayThi);
sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan);
sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Sau.SoCauThi);
sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Sau.ThoiGian);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
}
}
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
/*
* Neu Insert thi delete
* Nêu Update thi Update
* Nếu Xóa Thì Insert
*
*/
if (Program.indexLogGVDK >= 0)
{
DataLogGVDK logGvdk = Program.logGVDK[Program.indexLogGVDK];
if (logGvdk.Action.Equals("I"))
{
SqlCommand sqlcmd = new SqlCommand("SP_XOA_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAMH", logGvdk.Sau.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Sau.MaLop);
sqlcmd.Parameters.Add("@LAN", logGvdk.Sau.Lan);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
Program.indexLogGVDK--;
}
}
if (logGvdk.Action.Equals("D"))
{
SqlCommand sqlcmd = new SqlCommand("SP_THEM_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAGV", logGvdk.Truoc.MaGV);
sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop);
sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Truoc.TrinhDo);
sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Truoc.NgayThi);
sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan);
sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Truoc.SoCauThi);
sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Truoc.ThoiGian);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
Program.indexLogGVDK--;
}
}
if (logGvdk.Action.Equals("U"))
{
SqlCommand sqlcmd = new SqlCommand("SP_SUA_GVDK", Program.conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@MAGV", logGvdk.Truoc.MaGV);
sqlcmd.Parameters.Add("@MAMH", logGvdk.Truoc.MaMH);
sqlcmd.Parameters.Add("@MALOP", logGvdk.Truoc.MaLop);
sqlcmd.Parameters.Add("@TRINHDO", logGvdk.Truoc.TrinhDo);
sqlcmd.Parameters.Add("@NGAYTHI", logGvdk.Truoc.NgayThi);
sqlcmd.Parameters.Add("@LAN", logGvdk.Truoc.Lan);
sqlcmd.Parameters.Add("@SOCAUTHI", logGvdk.Truoc.SoCauThi);
sqlcmd.Parameters.Add("@THOIGIAN", logGvdk.Truoc.ThoiGian);
int check = Program.execStoreProcedureWithReturnValue(sqlcmd);
if (check == 1)
{
MessageBox.Show("Lỗi Khôi phục Insert");
}
else
{
barButtonItem1.PerformClick();
Program.indexLogGVDK--;
}
}
}
}
