public List <ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { AspxServiceProvider objService = new AspxServiceProvider(); List <ServiceCoreAvailableTime> lstServTime = objService.GetServiceAvailableTime(getServiceTimeObj, aspxCommonObj); return(lstServTime); } catch (Exception e) { throw e; } }
public List <ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime 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)); OracleHandler sqlh = new OracleHandler(); List <ServiceCoreAvailableTime> lstServTime = sqlh.ExecuteAsList <ServiceCoreAvailableTime>("usp_Aspx_GetServiceTime", parameter); return(lstServTime); } catch (Exception e) { throw e; } }
public List<ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj) { try { AspxServiceProvider objService = new AspxServiceProvider(); List<ServiceCoreAvailableTime> lstServTime = objService.GetServiceAvailableTime(getServiceTimeObj, aspxCommonObj); return lstServTime; } catch (Exception e) { throw e; } }
public List<ServiceCoreAvailableTime> GetServiceAvailableTime(GetServiceCoreAvailableTime 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<ServiceCoreAvailableTime> lstServTime = sqlh.ExecuteAsList<ServiceCoreAvailableTime>("[dbo].[usp_Aspx_GetServiceTime]", parameter); return lstServTime; } catch (Exception e) { throw e; } }