public void ChangeUserStatus(string UserID)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("ChangeUserStatus", new SqlParameter[] { new SqlParameter("@UserID", UserID) });
DB.Dispose();
}
public void DeleteExcelFile(string FileName)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("DeleteExcelFile", new SqlParameter[] { new SqlParameter("@FileName", FileName) });
DB.Dispose();
}
public void updateExcelExportedInventory(int InvId, int Flag)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("updateExcelExportedInventory", new SqlParameter[] { new SqlParameter("@InvId", InvId), new SqlParameter("@Flag", Flag) });
DB.Dispose();
}
public void UpdateExcelFileStatusUnlock(string FID)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("UpdateExcelFileStatusUnlock", new SqlParameter[] { new SqlParameter("@FID", FID) });
DB.Dispose();
}
public void DeleteUser(string UserID)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("DeleteUser", new SqlParameter[] { new SqlParameter("@UserID", UserID) });
DB.Dispose();
}
public void ChangeGroomerAppointmentStatus(string AppointmentId)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("ChangeGroomerAppointmentStatus", new SqlParameter[] { new SqlParameter("@AppointmentId", @AppointmentId) });
DB.Dispose();
}
public void updateExcelExportedEndingMileage(int DailyLogId, int Flag)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("updateExcelExportedEndingMileage", new SqlParameter[] { new SqlParameter("@DailyLogId", DailyLogId), new SqlParameter("@Flag", Flag) });
DB.Dispose();
}
public void ModifyExportFlag(string DailylogId, int ExcelRowId)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("sp_UpdateExportToExcelFlag", new SqlParameter[] { new SqlParameter("@DailylogId", @DailylogId), new SqlParameter("@ExcelRowId", ExcelRowId) });
DB.Dispose();
}
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 GetUnlockExcelFileName()
{
NewDBConnection DB = new NewDBConnection();
DataSet ds = new DataSet();
ds = DB.ExecuteDataSet("GetUnlockExcelFileName", new SqlParameter[] { });
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 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 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 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 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 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 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 GetUnExportedgroomerInventorydata()
{
NewDBConnection DB = new NewDBConnection();
DataSet ds = new DataSet();
ds = DB.ExecuteDataSet("GetUnExportedgroomerInventorydata", 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 GetUuExportedgroomerlogdataEndingM()
{
NewDBConnection DB = new NewDBConnection();
DataSet ds = new DataSet();
ds = DB.ExecuteDataSet("GetUuExportedgroomerlogdataEndingM", new SqlParameter[] { });
DB.Dispose();
return(ds);
}
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 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 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 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 BindGroomers()
{
NewDBConnection DB = new NewDBConnection();
DataSet ds = new DataSet();
ds = DB.ExecuteDataSet("BindGroomers", new SqlParameter[] { });
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 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);
}
}
public int AddAdminUser(string FirstName, string LastName, string Username, string Password, string Email, string Mobile, string Add1, string Add2, int UserType)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("AddAdminUser", new SqlParameter[] { new SqlParameter("@FirstName", FirstName), new SqlParameter("@LastName", LastName),
new SqlParameter("@Username", Username),
new SqlParameter("@Password", Password),
new SqlParameter("@Email", Email),
new SqlParameter("@Phone", Mobile),
new SqlParameter("@Add1", Add1),
new SqlParameter("@Add2", Add2),
new SqlParameter("@UserType", UserType),
new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.ReturnValue, true, 0, 0, "UserID", DataRowVersion.Default, 0) });
DB.Dispose();
int Count = int.Parse(((SqlParameter)DB.LastCommand.Parameters["@UserID"]).Value.ToString());
return(Count);
}
public int AddGroomerAppointment(int GID, string AppointmentDate, string StartTime, string EndTime, string ExpectedTotalRevenue, string Others, string DateTimeFormat, int SequenceNo, decimal ExpPetTime)
{
NewDBConnection DB = new NewDBConnection();
DB.ExecuteNonQuery("AddGroomerAppointment", new SqlParameter[] { new SqlParameter("@GID", GID), new SqlParameter("@AppointmentDate", AppointmentDate),
new SqlParameter("@StartTime", StartTime),
new SqlParameter("@EndTime", EndTime),
new SqlParameter("@ExpectedTotalRevenue", ExpectedTotalRevenue),
new SqlParameter("@Others", Others),
new SqlParameter("@DateTimeFormat", DateTimeFormat),
new SqlParameter("@SequenceNo", SequenceNo),
new SqlParameter("@ExpPetTime", ExpPetTime),
new SqlParameter("@AppointmentID", SqlDbType.Int, 4, ParameterDirection.ReturnValue, true, 0, 0, "AppointmentID", DataRowVersion.Default, 0) });
DB.Dispose();
int Count = int.Parse(((SqlParameter)DB.LastCommand.Parameters["@AppointmentID"]).Value.ToString());
return(Count);
}