public bool Xoa(QLKTX.BusinessObject.KTXInfo ktx)
{
SqlCommand com = new SqlCommand();
com.CommandText = "Delete KTX where KTX=@ma";
com.Parameters.Add("@ma", SqlDbType.VarChar, 7).Value = ktx.MaKTX;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public bool Sua(QLKTX.BusinessObject.KTXInfo ktx)
{
SqlCommand com = new SqlCommand();
com.CommandText = "Update KTX Set TenKTX =@ten, SOLUONGDAY=@soday where KTX=@ma";
com.Parameters.Add("@ma", SqlDbType.VarChar, 7).Value = ktx.MaKTX;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = ktx.TenKTX;
com.Parameters.Add("@soday", SqlDbType.Int).Value = ktx.SoDay;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
/// <summary>
/// Lưu KTX Xuống CSDL
/// </summary>
/// <param name="ktx">KTX cần thêm</param>
/// <returns>
/// true --> Thành công
/// false --> Thất bại
/// </returns>
public bool Them(QLKTX.BusinessObject.KTXInfo ktx)
{
SqlCommand com = new SqlCommand();
com.CommandText = "Insert Into KTX(KTX,TENKTX,SOLUONGDAY) values(@ma,@ten,@soday)";
com.Parameters.Add("@ma", SqlDbType.VarChar, 4).Value = ktx.MaKTX;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 30).Value = ktx.TenKTX;
com.Parameters.Add("@soday", SqlDbType.Int).Value = ktx.SoDay;
try
{
ser.Load(com);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
/// <summary>
/// Sửa Thông tin KTX ra khỏi CSDL
/// </summary>
/// <param name="ktx">KTX cần Sửa</param>
public void Sua(QLKTX.BusinessObject.KTXInfo ktx)
{
data.Sua(ktx);
}
/// <summary>
/// Thêm KTX vào CSDL
/// </summary>
/// <param name="ktx">KTX cần thêm</param>
public void Them(QLKTX.BusinessObject.KTXInfo ktx)
{
data.Them(ktx);
}