public static int InsertMedicineBillDetail(MedicineBillDetail newMBD)
{
String sqlInsert = @"INSERT INTO
MEDICINEBILLDETAIL(BILLID, MEDICINEID, QUANTITY, PRICE)
VALUES
(@BILLID,@MEDICINEID,@QUANTITY,@PRICE)";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", newMBD.BillID),
new SqlParameter("@MEDICINEID", newMBD.MedicineID),
new SqlParameter("@QUANTITY", newMBD.Quantity),
new SqlParameter("@PRICE", newMBD.Price) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
public static int InsertMedicineBillDetail(MedicineBillDetail newMBD)
{
String sqlInsert = @"INSERT INTO
MEDICINEBILLDETAIL(BILLID, MEDICINEID, QUANTITY, PRICE)
VALUES
(@BILLID,@MEDICINEID,@QUANTITY,@PRICE)";
SqlParameter[] sqlParameters = { new SqlParameter("@BILLID", newMBD.BillID),
new SqlParameter("@MEDICINEID", newMBD.MedicineID),
new SqlParameter("@QUANTITY", newMBD.Quantity),
new SqlParameter("@PRICE",newMBD.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;
}
}
