public bool UpdateIndoorPatient(IndoorPatient indoorPatients)
{
return du.AddRow(@"update IndoorPatient set CheckINDate = " + indoorPatients.CheckINDate + ",CheckOutDate = " + indoorPatients.CheckOutDate + ",UserID = " + indoorPatients.UserID + ",ModifiyDate = " + indoorPatients.ModifiyDate + ",IsDischarged = " + indoorPatients.IsDischarged + ")");
}
public bool DeleteIndoorPatient(IndoorPatient indoorPatients)
{
return du.DeleteRow(@"update IndoorPatient set DeleteFlag = 1 where IPDID ='" + indoorPatients.IPDID + "')");
}
public bool AddIndoorPatient(IndoorPatient indoorPatient)
{
return du.AddRow(@"insert into IndoorPatient(IPDID,PatientID ,CheckINDate, CheckOutDate,UserID ,AddDate ,ModifiyDate, IsDeleted,IsDischarged )
values(" + indoorPatient.IPDID + ",'" + indoorPatient.PatientID + "', '" + indoorPatient.CheckINDate + "', " + indoorPatient.CheckOutDate + ", '" + indoorPatient.UserID + "', '" + indoorPatient.AddDate + "', " + indoorPatient.ModifiyDate + ", '" + indoorPatient.IsDeleted + "', '" + indoorPatient.IsDischarged
+ "')");
}