//Update bảng DVT
public bool Update(DVTInfo dvt)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Update DVT set MaDVT = @MaDVT, TenDVT = @TenDVT, MaVPPChan = @MaVPPChan, SoLuongDoi = @SoLuongDoi, DaXoa = @DaXoa where MaDVT = @MaDVT";
cmd.Parameters.Add("@MaDVT", SqlDbType.Char, 10);
cmd.Parameters.Add("@TenDVT", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@MaVPPChan", SqlDbType.Char, 10);
cmd.Parameters.Add("@SoLuongDoi", SqlDbType.Int);
cmd.Parameters.Add("@DaXoa", SqlDbType.Int);
cmd.Parameters["@MaDVT"].Value = dvt.MaDVT;
cmd.Parameters["@TenDVT"].Value = dvt.TenDVT;
cmd.Parameters["@MaVPPChan"].Value = dvt.MaVPPChan;
cmd.Parameters["@SoLuongDoi"].Value = dvt.SoLuongDoi;
cmd.Parameters["@DaXoa"].Value = dvt.DaXoa;
return(Update(cmd));
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
//Thêm dữ liệu vào bảng DVT
public bool Insert(DVTInfo dvt)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Insert Into DVT values(@MaDVT, @TenDVT, @MaVPPChan, @SoLuongDoi, @DaXoa)";
cmd.Parameters.Add("@MaDVT", SqlDbType.Char, 10);
cmd.Parameters.Add("@TenDVT", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@MaVPPChan", SqlDbType.Char, 10);
cmd.Parameters.Add("@SoLuongDoi", SqlDbType.Int);
cmd.Parameters.Add("@DaXoa", SqlDbType.Int);
cmd.Parameters["@MaDVT"].Value = dvt.MaDVT;
cmd.Parameters["@TenDVT"].Value = dvt.TenDVT;
cmd.Parameters["@MaVPPChan"].Value = dvt.MaVPPChan;
cmd.Parameters["@SoLuongDoi"].Value = dvt.SoLuongDoi;
cmd.Parameters["@DaXoa"].Value = dvt.DaXoa;
return(Insert(cmd));
}
catch (SqlException e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
//Lấy hết bảng DVT
public DVTInfo[] SelectAll()
{
DataTable dt;
int i = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select * from DVT";
dt = GetTable(cmd, "DVT");
DVTInfo[] dvt = new DVTInfo[dt.Rows.Count];
foreach (DataRow row in dt.Rows)
{
dvt[i] = new DVTInfo();
dvt[i].MaDVT = int.Parse(row["MaDVT"].ToString());
dvt[i].TenDVT = row["TenDVT"].ToString();
dvt[i].MaVPPChan = row["MaVPPChan"].ToString();
dvt[i].SoLuongDoi = Int32.Parse(row["SoLuongDoi"].ToString());
dvt[i].DaXoa = int.Parse(row["DaXoa"].ToString());
i++;
}
return(dvt);
}
catch (SqlException e)
{
return(null);
}
}
//Lấy 1 DVT dựa trên mã của nó
public DVTInfo GetOne(int madvt)
{
DataTable dt;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select * from DVT where MaDVT = " + madvt.ToString();
dt = GetTable(cmd, "DVT");
DVTInfo dvt = new DVTInfo();
dvt.MaDVT = int.Parse(dt.Rows[0]["MaDVT"].ToString());
dvt.TenDVT = dt.Rows[0]["TenDVT"].ToString();
dvt.MaVPPChan = dt.Rows[0]["MaVPPChan"].ToString();
dvt.SoLuongDoi = Int32.Parse(dt.Rows[0]["SoLuongDoi"].ToString());
dvt.DaXoa = int.Parse(dt.Rows[0]["DaXoa"].ToString());
return(dvt);
}
catch (SqlException e)
{
return(null);
}
}
