public DataSet GetUuExportedgroomerlogdataEndingM() { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetUuExportedgroomerlogdataEndingM", new SqlParameter[] { }); DB.Dispose(); return(ds); }
public DataSet GetUnExportedgroomerInventorydata() { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetUnExportedgroomerInventorydata", new SqlParameter[] { }); DB.Dispose(); return(ds); }
public DataSet GetGroomer(int GID) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomer", new SqlParameter[] { new SqlParameter("@GID", GID) }); DB.Dispose(); return(ds); }
public DataSet DeleteOldGroomerAppointment(DateTime AppointmentDate, DateTime Enddate) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("DeleteOldGroomerAppointment", new SqlParameter[] { new SqlParameter("@AppointmentDate", AppointmentDate), new SqlParameter("@Enddate", Enddate) }); DB.Dispose(); return(ds); }
public DataSet GetUnlockExcelFileName() { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetUnlockExcelFileName", new SqlParameter[] { }); DB.Dispose(); return(ds); }
public DataSet GroomerOperationToExport(string Gid) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("sp_GroomerOperationToExport", new SqlParameter[] { new SqlParameter("@Gid", @Gid) }); DB.Dispose(); return(ds); }
public DataSet GetGroomerMonthlyLogData(int GID, string StartDate, string EndDate) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomerMonthlyLogData", new SqlParameter[] { new SqlParameter("@GID", GID), new SqlParameter("@StartDate", StartDate), new SqlParameter("@EndDate", EndDate) }); DB.Dispose(); return(ds); }
public DataSet getExcelData() { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("sp_getExcelData", new SqlParameter[] { new SqlParameter("@logid", "") }); DB.Dispose(); return(ds); }
public DataSet getDailyOperatrionLog(string @GID, string @DailyLogID) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("sp_getDailyOperatrionLog", new SqlParameter[] { new SqlParameter("@Gid", @GID), new SqlParameter("@DailyLogID", @DailyLogID) }); DB.Dispose(); return(ds); }
public DataSet GetMaxSequencenoOfGroomer(int GId, string AppointmentDate) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetMaxSequencenoOfGroomer", new SqlParameter[] { new SqlParameter("@GId", GId), new SqlParameter("@AppointmentDate", AppointmentDate) }); DB.Dispose(); return(ds); }
public DataSet GetGroomerNextsequenceForupdate(int GId, string AppointmentDate, int Sequence) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomerNextsequenceForupdate", new SqlParameter[] { new SqlParameter("@GId", GId), new SqlParameter("@AppointmentDate", AppointmentDate), new SqlParameter("@Sequence", Sequence) }); DB.Dispose(); return(ds); }
public DataSet UpdateGroomerSequence(int GID, string AppointmentDate, int SequenceNo, int AppointmentId) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("UpdateGroomerSequence", new SqlParameter[] { new SqlParameter("@GID", GID), new SqlParameter("@AppointmentDate", AppointmentDate), new SqlParameter("@SequenceNo", SequenceNo), new SqlParameter("@AppointmentId", AppointmentId) }); DB.Dispose(); return(ds); }
public DataSet DeleteGroomerAppointment(int AppointmentId) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("DeleteGroomerAppointment", new SqlParameter[] { new SqlParameter("@AppointmentId", @AppointmentId) }); DB.Dispose(); return(ds); }
public DataSet BindGroomers() { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("BindGroomers", new SqlParameter[] { }); DB.Dispose(); return(ds); }
public DataSet GetGroomersAppointment(DateTime AppointmentDate) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomersAppointment", new SqlParameter[] { new SqlParameter("@AppointmentDate", AppointmentDate) }); DB.Dispose(); return(ds); }
public DataSet GetGroomerAppointmentDetails(int DailyLogID) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomerAppointmentDetails", new SqlParameter[] { new SqlParameter("@DailyLogID", DailyLogID) }); DB.Dispose(); return(ds); }
public DataSet GetUserDetail(int UserID) { NewDBConnection DB = new NewDBConnection(); DataSet DT = new DataSet(); DT = DB.ExecuteDataSet("GetUserDetail", new SqlParameter[] { new SqlParameter("@UserID", UserID) }); DB.Dispose(); return(DT); }
public DataSet GetAllUser(string SearchFor, string SearchText) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetAllUser", new SqlParameter[] { new SqlParameter("@SearchFor", SearchFor), new SqlParameter("@SearchText", SearchText) }); DB.Dispose(); return(ds); }
public DataSet GetGroomerDailyLogData(int GID, string Date) { NewDBConnection DB = new NewDBConnection(); DataSet ds = new DataSet(); ds = DB.ExecuteDataSet("GetGroomerDailyLogData", new SqlParameter[] { new SqlParameter("@GID", GID), new SqlParameter("@Date", Date) }); DB.Dispose(); return(ds); }
public DataSet GetUser(string LoginID, string Password) { try { NewDBConnection DB = new NewDBConnection(); DataSet DT = new DataSet(); DT = DB.ExecuteDataSet("GetUserLogin", new SqlParameter[] { new SqlParameter("@Username", LoginID), new SqlParameter("@PassWord", Password) }); DB.Dispose(); return(DT); } catch (SqlException ex) { string Error = ex.Message; return(null); } }