public bool AddServicesBillDetailToDatabase(ServicesBillDetail servicesBillDetail)
{
try
{
OpenConnection();
string queryString = "Insert Into CHITIETPDV Values(@MaCTPDV, @MaPDV, @MaDV, @SoLuong, @DonGiaDuocTinh, @TinhTrang)";
SqlCommand command = new SqlCommand(queryString, conn);
command.Parameters.AddWithValue("@MaCTPDV", servicesBillDetail.MaCTPDV1);
command.Parameters.AddWithValue("@MaPDV", servicesBillDetail.MaPDV1);
command.Parameters.AddWithValue("@MaDV", servicesBillDetail.MaDV1);
command.Parameters.AddWithValue("@SoLuong", servicesBillDetail.SoLuong1);
command.Parameters.AddWithValue("@DonGiaDuocTinh", servicesBillDetail.DonGiaDuocTinh1);
command.Parameters.AddWithValue("@TinhTrang", servicesBillDetail.TinhTrang1);
int rs = command.ExecuteNonQuery();
if (rs != 1)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception e)
{
MessageBox.Show("Thêm thất bại!" + e, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
finally
{
CloseConnection();
}
}
public List <ServicesBillDetail> GetServicesBillDetailLById(int idServicesBillDetail)
{
List <ServicesBillDetail> servicesBillDetails = new List <ServicesBillDetail>();
try
{
OpenConnection();
string query = String.Format("Select * From CHITIETPDV Where MaPDV = '{0}'", idServicesBillDetail);
SqlCommand command = new SqlCommand(query, conn);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
ServicesBillDetail servicesBillDetail = new ServicesBillDetail(
int.Parse(dataTable.Rows[i].ItemArray[0].ToString()),
int.Parse(dataTable.Rows[i].ItemArray[1].ToString()),
int.Parse(dataTable.Rows[i].ItemArray[2].ToString()),
int.Parse(dataTable.Rows[i].ItemArray[3].ToString()),
long.Parse(dataTable.Rows[i].ItemArray[4].ToString()),
int.Parse(dataTable.Rows[i].ItemArray[5].ToString())
);
servicesBillDetails.Add(servicesBillDetail);
}
return(servicesBillDetails);
}
catch
{
return(new List <ServicesBillDetail>());
}
finally
{
CloseConnection();
}
}
