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