public bool AddPatientBill(PatientBill patientBill)
{
return du.AddRow(@"insert into PatientBill(BillNo,PatientID ,BillDate, UserID ,AddDate ,ModifiyDate,IsDeleted, Remarks)
values(" + patientBill.BillNo + ",'" + patientBill.PatientID + "', '" + patientBill.BillDate + "', " + patientBill.UserID + ", '" + patientBill.AddDate
+ "', '" + patientBill.ModifiyDate + "', " + patientBill.IsDeleted + ", '" + patientBill.Remarks
+ "')");
}
public bool DeletePatientBill(PatientBill patientBill)
{
return du.DeleteRow(@"update PatientBill set DeleteFlag = 1 where BillNo ='" + patientBill.BillNo + "')");
}
public bool UpdatePatientBill(PatientBill patientBill)
{
return du.AddRow(@"update PatientBill set PatientID = " + patientBill.PatientID + ",BillDate = " + patientBill.BillDate + ",UserID = " + patientBill.UserID + ",ModifiyDate = " + patientBill.ModifiyDate + ",Remarks = " + patientBill.Remarks + ")");
}