public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         ServiceItemProvider         objService  = new ServiceItemProvider();
         List <ServiceAvailableTime> lstServTime = objService.GetServiceAvailableTime(getServiceTimeObj, aspxCommonObj);
         return(lstServTime);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
        {
            List <ServiceAvailableTime> serviceAvailableTime;

            try
            {
                serviceAvailableTime = (new ServiceItemProvider()).GetServiceAvailableTime(getServiceTimeObj, aspxCommonObj);
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(serviceAvailableTime);
        }
 public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("@CategoryID", getServiceTimeObj.CategoryID));
         parameter.Add(new KeyValuePair <string, object>("@BranchID", getServiceTimeObj.BranchID));
         parameter.Add(new KeyValuePair <string, object>("@EmployeeID", getServiceTimeObj.EmployeeID));
         parameter.Add(new KeyValuePair <string, object>("@ServiceDateID", getServiceTimeObj.ServiceDateID));
         parameter.Add(new KeyValuePair <string, object>("@ServiceDate", getServiceTimeObj.ServiceDate));
         parameter.Add(new KeyValuePair <string, object>("@ItemID", getServiceTimeObj.ItemID));
         SQLHandler sqlh = new SQLHandler();
         List <ServiceAvailableTime> lstServTime = sqlh.ExecuteAsList <ServiceAvailableTime>("[dbo].[usp_Aspx_GetServiceTime]", parameter);
         return(lstServTime);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
        {
            List <ServiceAvailableTime> serviceAvailableTimes;

            try
            {
                List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                parameter.Add(new KeyValuePair <string, object>("CategoryID", (object)getServiceTimeObj.CategoryID));
                parameter.Add(new KeyValuePair <string, object>("BranchID", (object)getServiceTimeObj.BranchID));
                parameter.Add(new KeyValuePair <string, object>("EmployeeID", (object)getServiceTimeObj.EmployeeID));
                parameter.Add(new KeyValuePair <string, object>("ServiceDateID", getServiceTimeObj.ServiceDateID));
                parameter.Add(new KeyValuePair <string, object>("ServiceDate", getServiceTimeObj.ServiceDate));
                parameter.Add(new KeyValuePair <string, object>("ItemID", (object)getServiceTimeObj.ItemID));
                serviceAvailableTimes = (new OracleHandler()).ExecuteAsList <ServiceAvailableTime>("usp_Aspx_GetServiceTime", parameter);
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(serviceAvailableTimes);
        }
    public List<ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
    {
        try
        {
            ServiceItemController objService = new ServiceItemController();
            List<ServiceAvailableTime> lstServTime = objService.GetServiceAvailableTime(getServiceTimeObj, aspxCommonObj);
            return lstServTime;
        }
        catch (Exception e)
        {

            throw e;
        }

    }
        public List<ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                parameter.Add(new KeyValuePair<string, object>("@CategoryID", getServiceTimeObj.CategoryID));
                parameter.Add(new KeyValuePair<string, object>("@BranchID", getServiceTimeObj.BranchID));
                parameter.Add(new KeyValuePair<string, object>("@EmployeeID", getServiceTimeObj.EmployeeID));
                parameter.Add(new KeyValuePair<string, object>("@ServiceDateID", getServiceTimeObj.ServiceDateID));
                parameter.Add(new KeyValuePair<string, object>("@ServiceDate", getServiceTimeObj.ServiceDate));
                parameter.Add(new KeyValuePair<string, object>("@ItemID", getServiceTimeObj.ItemID));
                SQLHandler sqlh = new SQLHandler();
                List<ServiceAvailableTime> lstServTime = sqlh.ExecuteAsList<ServiceAvailableTime>("[dbo].[usp_Aspx_GetServiceTime]", parameter);
                return lstServTime;
            }
            catch (Exception e)
            {

                throw e;
            }

        }