public bool UpdateIndoorPatientDetails(IndoorPatientDetails indoorPatientDetails)
{
return du.AddRow(@"update IndoorPatientDetails set Roomnumber = " + indoorPatientDetails.Roomnumber + ",Bedno = " + indoorPatientDetails.Bedno + ",UserID = " + indoorPatientDetails.UserID + ",FromDate = " + indoorPatientDetails.FromDate + ",ToDate = " + indoorPatientDetails.ToDate + ",InTime = " + indoorPatientDetails.InTime + ",OutTime = " + indoorPatientDetails.OutTime + ")");
}
public bool DeleteIndoorPatientDetails(IndoorPatientDetails indoorPatientDetails)
{
return du.DeleteRow(@"update IndoorPatientDetails set DeleteFlag = 1 where SRNO ='" + indoorPatientDetails.SRNO + "')");
}
public bool AddIndoorPatientDetails(IndoorPatientDetails indoorPatientDetail)
{
return du.AddRow(@"insert into IndoorPatientDetails(IPDID,SRNO ,Roomnumber, Bedno,UserID ,FromDate ,ToDate, InTime,OutTime )
values(" + indoorPatientDetail.IPDID + ",'" + indoorPatientDetail.SRNO + "', '" + indoorPatientDetail.Roomnumber + "', " + indoorPatientDetail.Bedno + ", '" + indoorPatientDetail.UserID + "', '" + indoorPatientDetail.FromDate + "', " + indoorPatientDetail.ToDate + ", '" + indoorPatientDetail.InTime + "', '" + indoorPatientDetail.OutTime
+ "')");
}