public bool AddPatient(Patient patient)
{
return du.AddRow(@"insert into PatientRegstration( ID , PatientID , Name , AttendentName , Sex ,
ContactNumber1 , ContactNumber2 , Email , Address , RefDrID , Type , IsFeeFree , ConsultantName , DepartmentID ,
ConsultantFee , RegDate , RegTime , UserID , AddDate , ModifiyDate , IsDeleted , Fyear ,
CompanyCode , Remarks , IsPaymentPaid )
values(" + patient.ID + ",'" + patient.PatientID + "', '" + patient.Name + "', '" + patient.AttendentName + "', '" + patient.Sex
+ "', '" + patient.ContactNumber1 + "', '" + patient.ContactNumber2 + "', '" + patient.Email + "', '" + patient.Address + "', " + patient.RefDrID
+ ", '" + patient.Type + "', " + patient.IsFeeFree + ", '" + patient.ConsultantName + "', " + patient.DepartmentID
+ ", " + patient.ConsultantFee + ", '" + patient.RegDate + "', '" + patient.RegTime + "', " + patient.UserID + ", '" + patient.AddDate
+ "', '" + patient.ModifiyDate + "', " + patient.IsDeleted + ", " + patient.Fyear + ", '" + patient.CompanyCode + "', '" + patient.Remarks
+ "', " + patient.IsPaymentPaid + ")");
}
public bool DeletePatient(Patient patient)
{
return du.DeleteRow(@"update PatientRegstration set DeleteFlag = 1 where PatientID ='" + patient.PatientID + "')");
}
public bool UpdatePatient(Patient patient)
{
return du.AddRow(@"update PatientRegstration set Name= '" + patient.Name + "' where PatientID = '" +patient.PatientID + "')");
}