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);
}
}
