public DataSet callScheduleDay(ref ErrorLog elog, BCscheduleProperties obj)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(dbm.InParam("@schedule_day", SqlDbType.VarChar, 50, obj.daysch));
return(dbm.GetDS(ref elog, param, "sp_scheduleday"));
}
public int schedulePatients(ref ErrorLog elog, BCscheduleProperties obj)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(dbm.InParam("@schedule_Day", SqlDbType.VarChar, 50, obj.schDay));
param.Add(dbm.InParam("@schedule_Starting_Time", SqlDbType.DateTime, 8, obj.schStartingTime));
param.Add(dbm.InParam("@schedule_CLosing_Time", SqlDbType.DateTime, 8, obj.schClosingTime));
param.Add(dbm.InParam("@schedule_Effective_Date", SqlDbType.DateTime, 8, obj.schEffectiveDate));
param.Add(dbm.InParam("@schedule_Expiry_Date ", SqlDbType.DateTime, 8, obj.schExpiryDate));
param.Add(dbm.InParam("@schedule_approved_Bit", SqlDbType.Bit, 1, obj.schApprovedBit));
param.Add(dbm.InParam("@schedule_Disable_Bit", SqlDbType.Bit, 1, obj.schDisableBit));
param.Add(dbm.InParam("@schedule_Create_User", SqlDbType.Int, 4, obj.schCreateUser));
param.Add(dbm.InParam("@schedule_Create_Date", SqlDbType.DateTime, 8, obj.schCreateDate));
//param.Add(dbm.InParam("@schedule_Update_User", SqlDbType.Int, 4, obj.schUpdateUser));
//param.Add(dbm.InParam("@schedule_Update_Date", SqlDbType.Bit, 1, obj.schUpdateDate));
return dbm.Manage(ref elog, param, "sp_schedulePatients");
}
public int schedulePatients(ref ErrorLog elog, BCscheduleProperties obj)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(dbm.InParam("@schedule_Day", SqlDbType.VarChar, 50, obj.schDay));
param.Add(dbm.InParam("@schedule_Starting_Time", SqlDbType.DateTime, 8, obj.schStartingTime));
param.Add(dbm.InParam("@schedule_CLosing_Time", SqlDbType.DateTime, 8, obj.schClosingTime));
param.Add(dbm.InParam("@schedule_Effective_Date", SqlDbType.DateTime, 8, obj.schEffectiveDate));
param.Add(dbm.InParam("@schedule_Expiry_Date ", SqlDbType.DateTime, 8, obj.schExpiryDate));
param.Add(dbm.InParam("@schedule_approved_Bit", SqlDbType.Bit, 1, obj.schApprovedBit));
param.Add(dbm.InParam("@schedule_Disable_Bit", SqlDbType.Bit, 1, obj.schDisableBit));
param.Add(dbm.InParam("@schedule_Create_User", SqlDbType.Int, 4, obj.schCreateUser));
param.Add(dbm.InParam("@schedule_Create_Date", SqlDbType.DateTime, 8, obj.schCreateDate));
//param.Add(dbm.InParam("@schedule_Update_User", SqlDbType.Int, 4, obj.schUpdateUser));
//param.Add(dbm.InParam("@schedule_Update_Date", SqlDbType.Bit, 1, obj.schUpdateDate));
return(dbm.Manage(ref elog, param, "sp_schedulePatients"));
}
public DataSet callScheduleDay(ref ErrorLog elog, BCscheduleProperties obj)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(dbm.InParam("@schedule_day", SqlDbType.VarChar, 50, obj.daysch));
return dbm.GetDS(ref elog,param,"sp_scheduleday");
}
public int SchedulePatientServices(ref ErrorLog elog, BCscheduleProperties objP)
{
BCschedule objpp = new BCschedule();
return objpp.schedulePatients(ref elog, objP);
}
