public static int InsertServiceBillDetail(ServiceBillDetail newSBD)
{
String sqlInsert = @"INSERT INTO SERVICEBILLDETAIL(BILLID, SERVICEID, QUANTITY, PRICE)
VALUES (@BILLID,@SERVICEID,@QUANTITY,@PRICE)";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", newSBD.BillID),
new SqlParameter("@SERVICEID", newSBD.ServiceID),
new SqlParameter("@QUANTITY", newSBD.Quantity),
new SqlParameter("@PRICE",newSBD.Price)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int InsertServiceBillDetail(ServiceBillDetail newSBD)
{
String sqlInsert = @"INSERT INTO SERVICEBILLDETAIL(BILLID, SERVICEID, QUANTITY, PRICE)
VALUES (@BILLID,@SERVICEID,@QUANTITY,@PRICE)";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", newSBD.BillID),
new SqlParameter("@SERVICEID", newSBD.ServiceID),
new SqlParameter("@QUANTITY", newSBD.Quantity),
new SqlParameter("@PRICE", newSBD.Price) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
// Insert bill detail after insert bill
private void insertBillDetail()
{
switch (BillDetail.BillTypeID)
{
case Bill.MEDICINEBILL:
MedicineBillDetail newMedicineBillDetail = new MedicineBillDetail();
foreach (DataRow record in ((DataTable)dataViewBillDetail.DataSource).Rows)
{
newMedicineBillDetail.BillID = BillDetail.BillID;
newMedicineBillDetail.MedicineID = Convert.ToInt32(record["MEDICINEID"]);
newMedicineBillDetail.Quantity = Convert.ToInt32(record["Số lượng"]);
newMedicineBillDetail.Price = Convert.ToDecimal(record["Giá"]);
MedicineBillDetail.InsertMedicineBillDetail(newMedicineBillDetail);
}
break;
case Bill.SERVICEBILL:
ServiceBillDetail newServiceBillDetail = new ServiceBillDetail();
foreach (DataRow record in ((DataTable)dataViewBillDetail.DataSource).Rows)
{
newServiceBillDetail.BillID = BillDetail.BillID;
newServiceBillDetail.ServiceID = Convert.ToInt32(record["SERVICEID"]);
newServiceBillDetail.Quantity = Convert.ToInt32(record["Số lượng"]);
newServiceBillDetail.Price = Convert.ToDecimal(record["Giá"]);
ServiceBillDetail.InsertServiceBillDetail(newServiceBillDetail);
}
break;
case Bill.MATERIALBILL:
RentMaterialBillDetail newRentMaterialBillDetail = new RentMaterialBillDetail();
foreach (DataRow record in ((DataTable)dataViewBillDetail.DataSource).Rows)
{
newRentMaterialBillDetail.BillID = BillDetail.BillID;
newRentMaterialBillDetail.MaterialID = Convert.ToInt32(record["MATERIALID"]);
newRentMaterialBillDetail.Quantity = Convert.ToInt32(record["Số lượng"]);
newRentMaterialBillDetail.Price = Convert.ToDecimal(record["Giá"]);
RentMaterialBillDetail.InsertRentMaterialBillDetail(newRentMaterialBillDetail);
}
break;
}
}