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