private void btnDelete_Click(object sender, EventArgs e)
{
idx = 3;
for (int i = 0; i < lvLichTruc.Items.Count; i++)
{
if (lvLichTruc.Items[i].Selected)
{
if (lvLichTruc.SelectedIndices.Count == 0)
{
return;
}
LichTruc lt = new LichTruc();
ListViewItem liv = lvLichTruc.SelectedItems[0];
lt.MaLT = liv.SubItems[0].Text;
lt.MaPM = liv.SubItems[1].Text;
lt.MaNV = liv.SubItems[2].Text;
lt.NgayTruc = Convert.ToDateTime(liv.SubItems[3].Text);
lt.CaTruc = liv.SubItems[4].Text;
string tangca = liv.SubItems[5].Text;
if (tangca == "X")
{
lt.TangCa = 1;
}
if (tangca == "O")
{
lt.TangCa = 0;
}
lstXoa.Add(lt);
lvLichTruc.Items[i].Remove();
i--;
}
}
}
public static List <LichTruc> ShowLichTruc()
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "LoadLichTruc";
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
List <LichTruc> dsLT = new List <LichTruc>();
while (reader.Read()) // điều kiện đọc
{
string malt = reader.GetString(0);
string mapm = reader.GetString(1);
string manv = reader.GetString(2);
DateTime ngaytruc = reader.GetDateTime(3);
string catruc = reader.GetString(4);
int tangca = reader.GetInt32(5);
LichTruc lt = new LichTruc(malt, mapm, manv, ngaytruc, catruc, tangca);
dsLT.Add(lt);
}
reader.Close();
return(dsLT);
}
public static void UpDate(LichTruc lt)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SuaLT";
cmd.Connection = conn;
OpenConnection();
cmd.Parameters.Add("@MaLT", SqlDbType.NVarChar).Value = lt.MaLT;
cmd.Parameters.Add("@MaPM", SqlDbType.NVarChar).Value = lt.MaPM;
cmd.Parameters.Add("@MaNV", SqlDbType.NVarChar).Value = lt.MaNV;
cmd.Parameters.Add("@NgayTruc", SqlDbType.Date).Value = lt.NgayTruc;
cmd.Parameters.Add("@CaTruc", SqlDbType.NVarChar).Value = lt.CaTruc;
cmd.Parameters.Add("@TangCa", SqlDbType.Float).Value = lt.TangCa;
cmd.ExecuteNonQuery();
CloseConnection();
}
private void btnundo_Click(object sender, EventArgs e)
{
LichTruc nv = new LichTruc();
int a = lstXoa.Count;
for (int i = a - 1; i >= 0; i--)
{
ListViewItem liv = new ListViewItem(lstXoa[i].MaLT);
liv.SubItems.Add(lstXoa[i].MaPM);
liv.SubItems.Add(lstXoa[i].MaNV);
liv.SubItems.Add(lstXoa[i].NgayTruc.ToString("dd-MM-yyyy"));
liv.SubItems.Add(lstXoa[i].CaTruc);
liv.SubItems.Add(lstXoa[i].TangCa.ToString());
lvLichTruc.Items.Add(liv);
break;
}
if (a > 0)
{
lstXoa.RemoveAt(a - 1);
}
}
public LichTruc GETLICHTRUC()
{
string malt = txtmalt.Text;
string mapm = arrAll[0];
string manv = txtMaNV.Text;
DateTime hbh = dtngaytruc.Value;
string catruc = "";
if (rdchieu.Checked)
{
catruc = "Chiều";
}
if (rdsang.Checked)
{
catruc = "Sáng";
}
if (rdtoi.Checked)
{
catruc = "Tối";
}
//tăng ca
int tangca = 0;
if (ckbtangca.Checked)
{
tangca = 1;
}
if (!ckbtangca.Checked)
{
tangca = 0;
}
LichTruc lt = new LichTruc(malt, mapm, manv, hbh, catruc, tangca);
return(lt);
}
public static void SuaLT(LichTruc lt)
{
LichTrucAccess.UpDate(lt);
}
public static void ThemLT(LichTruc lt)
{
LichTrucAccess.Insert(lt);
}
