public bool Update(VanPhongPhamInfo vpp)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Update VANPHONGPHAM set MaVPP = @MaVPP, TenVPP = @TenVPP, Gia = @Gia, SoLuong = @SoLuong, MaDVT = @MaDVT, MaNCC = @MaNCC, TenNSX = @TenNSX, DaXoa = @DaXoa where MaVPP = @MaVPP";
cmd.Parameters.Add("@MaVPP", SqlDbType.Char, 10);
cmd.Parameters.Add("@TenVPP", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@Gia", SqlDbType.Money);
cmd.Parameters.Add("@SoLuong", SqlDbType.Int);
cmd.Parameters.Add("@MaDVT", SqlDbType.Int);
cmd.Parameters.Add("@MaNCC", SqlDbType.Int);
cmd.Parameters.Add("@TenNSX", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DaXoa", SqlDbType.Int);
cmd.Parameters["@MaVPP"].Value = vpp.MaVPP;
cmd.Parameters["@TenVPP"].Value = vpp.TenVPP;
cmd.Parameters["@Gia"].Value = vpp.Gia;
cmd.Parameters["@Soluong"].Value = vpp.SoLuong;
cmd.Parameters["@MaDVT"].Value = vpp.MaDVT;
cmd.Parameters["@MaNCC"].Value = vpp.MaNCC;
cmd.Parameters["@TenNSX"].Value = vpp.TenNSX;
cmd.Parameters["@DaXoa"].Value = vpp.DaXoa;
return(Update(cmd));
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
public bool Insert(VanPhongPhamInfo vpp)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Insert Into VANPHONGPHAM values(@MaVPP, @TenVPP, @Gia, @SoLuong, @MaDVT, @MaNCC, @TenNSX, @DaXoa)";
cmd.Parameters.Add("@MaVPP", SqlDbType.Int);
cmd.Parameters.Add("@TenVPP", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@Gia", SqlDbType.Money);
cmd.Parameters.Add("@SoLuong", SqlDbType.Int);
cmd.Parameters.Add("@MaDVT", SqlDbType.Int);
cmd.Parameters.Add("@MaNCC", SqlDbType.Int);
cmd.Parameters.Add("@TenNSX", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DaXoa", SqlDbType.Int);
cmd.Parameters["@MaVPP"].Value = vpp.MaVPP;
cmd.Parameters["@TenVPP"].Value = vpp.TenVPP;
cmd.Parameters["@Gia"].Value = vpp.Gia;
cmd.Parameters["@Soluong"].Value = vpp.SoLuong;
cmd.Parameters["@MaDVT"].Value = vpp.MaDVT;
cmd.Parameters["@MaNCC"].Value = vpp.MaNCC;
cmd.Parameters["@TenNSX"].Value = vpp.TenNSX;
cmd.Parameters["@DaXoa"].Value = vpp.DaXoa;
return(Insert(cmd));
}
catch (SqlException e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
public VanPhongPhamInfo[] SelectAll()
{
int i = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select * from VANPHONGPHAM";
DataTable dt = GetTable(cmd, "VANPHONGPHAM");
VanPhongPhamInfo[] vpp = new VanPhongPhamInfo[dt.Rows.Count];
foreach (DataRow row in dt.Rows)
{
vpp[i] = new VanPhongPhamInfo();
vpp[i].MaVPP = row["MaVPP"].ToString();
vpp[i].TenVPP = row["TenVPP"].ToString();
vpp[i].Gia = double.Parse(row["Gia"].ToString());
vpp[i].SoLuong = int.Parse(row["SoLuong"].ToString());
vpp[i].MaNCC = int.Parse(row["MaNCC"].ToString());
vpp[i].DaXoa = int.Parse(row["DaXoa"].ToString());
if (row["MaDVT"].ToString() != "")
{
vpp[i].MaDVT = int.Parse(row["MaDVT"].ToString());
}
vpp[i].TenNSX = row["TenNSX"].ToString();
//Thêm một số thuộc tính
i++;
}
return(vpp);
}
catch (Exception e)
{
return(null);
}
}
public VanPhongPhamInfo GetOne(string mavpp)
{
DataTable dt;
try
{
SqlCommand cmd = new SqlCommand();
//cmd.CommandText = @"Select * from VANPHONGPHAM where MaVPP = " + mavpp;
cmd.CommandText = @"Select * from VANPHONGPHAM where MaVPP = '" + mavpp + "'";
dt = GetTable(cmd, "VANPHONGPHAM");
VanPhongPhamInfo vpp = new VanPhongPhamInfo();
vpp.MaVPP = dt.Rows[0]["MaVPP"].ToString();
vpp.TenVPP = dt.Rows[0]["TenVPP"].ToString();
vpp.Gia = double.Parse(dt.Rows[0]["Gia"].ToString());
vpp.SoLuong = int.Parse(dt.Rows[0]["SoLuong"].ToString());
vpp.MaNCC = int.Parse(dt.Rows[0]["MaNCC"].ToString());
vpp.DaXoa = int.Parse(dt.Rows[0]["DaXoa"].ToString());
if (dt.Rows[0]["MaDVT"].ToString() != "")
{
vpp.MaDVT = int.Parse(dt.Rows[0]["MaDVT"].ToString());
}
vpp.TenNSX = dt.Rows[0]["TenNSX"].ToString();
return(vpp);
}
catch (SqlException e)
{
return(null);
}
}
public VanPhongPhamInfo[] TimMaVPP(string madon)
{
DataTable dt;
int i = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select * from VANPHONGPHAM where MaVPP = " + madon;
dt = GetTable(cmd, "VANPHONGPHAM");
VanPhongPhamInfo[] vpp = new VanPhongPhamInfo[dt.Rows.Count];
foreach (DataRow row in dt.Rows)
{
vpp[i] = new VanPhongPhamInfo();
vpp[i].MaVPP = row["MaVPP"].ToString();
vpp[i].TenVPP = row["TenVPP"].ToString();
vpp[i].Gia = double.Parse(row["Gia"].ToString());
vpp[i].SoLuong = int.Parse(row["SoLuong"].ToString());
vpp[i].MaNCC = int.Parse(row["MaNCC"].ToString());
vpp[i].DaXoa = int.Parse(row["DaXoa"].ToString());
vpp[i].MaDVT = int.Parse(row["MaDVT"].ToString());
vpp[i].TenNSX = row["TenNSX"].ToString();
i++;
}
return(vpp);
}
catch (SqlException e)
{
return(null);
}
}
