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 + ")");
 }