public void ChangeUserStatus(string UserID)
        {
            NewDBConnection DB = new NewDBConnection();

            DB.ExecuteNonQuery("ChangeUserStatus", new SqlParameter[] { new SqlParameter("@UserID", UserID) });
            DB.Dispose();
        }
Example #2
0
        public void DeleteExcelFile(string FileName)
        {
            NewDBConnection DB = new NewDBConnection();

            DB.ExecuteNonQuery("DeleteExcelFile", new SqlParameter[] { new SqlParameter("@FileName", FileName) });
            DB.Dispose();
        }
Example #3
0
        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();
        }
Example #4
0
        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();
        }
Example #6
0
        public void ChangeGroomerAppointmentStatus(string AppointmentId)
        {
            NewDBConnection DB = new NewDBConnection();

            DB.ExecuteNonQuery("ChangeGroomerAppointmentStatus", new SqlParameter[] { new SqlParameter("@AppointmentId", @AppointmentId) });
            DB.Dispose();
        }
Example #7
0
        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();
        }
Example #8
0
        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();
        }
Example #9
0
        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);
        }
Example #10
0
        public DataSet GetUnlockExcelFileName()
        {
            NewDBConnection DB = new NewDBConnection();
            DataSet         ds = new DataSet();

            ds = DB.ExecuteDataSet("GetUnlockExcelFileName", new SqlParameter[] { });
            DB.Dispose();
            return(ds);
        }
Example #11
0
        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);
        }
Example #12
0
        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);
        }
Example #13
0
        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);
        }
Example #14
0
        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);
        }
Example #15
0
        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);
        }
Example #16
0
        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);
        }
Example #17
0
        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);
        }
Example #18
0
        public DataSet GetUnExportedgroomerInventorydata()
        {
            NewDBConnection DB = new NewDBConnection();
            DataSet         ds = new DataSet();

            ds = DB.ExecuteDataSet("GetUnExportedgroomerInventorydata", new SqlParameter[] { });
            DB.Dispose();
            return(ds);
        }
Example #19
0
        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);
        }
Example #20
0
        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);
        }
Example #22
0
        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);
        }
Example #23
0
        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);
        }
Example #24
0
        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);
        }
Example #25
0
        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);
        }
Example #27
0
        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);
        }
Example #30
0
        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);
        }