public static List <ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <ServiceBookedTime> lstSBTime = AspxServiceProvider.GetServiceBookedTime(bookedTimeObj, aspxCommonObj);
return(lstSBTime);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxServiceProvider objService = new AspxServiceProvider();
List <ServiceBookedTime> lstSBTime = objService.GetServiceBookedTime(bookedTimeObj, aspxCommonObj);
return(lstSBTime);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("ServiceCategoryID", bookedTimeObj.ServiceCategoryID));
parameter.Add(new KeyValuePair <string, object>("BranchID", bookedTimeObj.BranchID));
parameter.Add(new KeyValuePair <string, object>("EmployeeID", bookedTimeObj.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("ServiceDateID", bookedTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair <string, object>("ServiceDate", bookedTimeObj.ServiceDate));
parameter.Add(new KeyValuePair <string, object>("ServiceTimeID", bookedTimeObj.ServiceTimeID));
parameter.Add(new KeyValuePair <string, object>("ItemID", bookedTimeObj.ItemID));
OracleHandler sqlh = new OracleHandler();
List <ServiceBookedTime> lstSBTime = sqlh.ExecuteAsList <ServiceBookedTime>("usp_Aspx_GetServiceBookedTime", parameter);
return(lstSBTime);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@ServiceCategoryID", bookedTimeObj.ServiceCategoryID));
parameter.Add(new KeyValuePair <string, object>("@BranchID", bookedTimeObj.BranchID));
parameter.Add(new KeyValuePair <string, object>("@EmployeeID", bookedTimeObj.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("@ServiceDateID", bookedTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair <string, object>("@ServiceDate", bookedTimeObj.ServiceDate));
parameter.Add(new KeyValuePair <string, object>("@ServiceTimeID", bookedTimeObj.ServiceTimeID));
parameter.Add(new KeyValuePair <string, object>("@ItemID", bookedTimeObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlh = new SQLHandler();
return(sqlh.ExecuteAsList <ServiceBookedTime>("[dbo].[usp_Aspx_GetServiceBookedTime]", parameter));
}
catch (Exception ex)
{
throw ex;
}
}
public List<ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo getServiceBookedTimeObj, AspxCommonInfo aspxCommonObj)
{
ServiceItemController objService = new ServiceItemController();
List<ServiceBookedTime> lstSBTime = objService.GetServiceBookedTime(getServiceBookedTimeObj, aspxCommonObj);
return lstSBTime;
}
public List<ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
AspxServiceProvider objService = new AspxServiceProvider();
List<ServiceBookedTime> lstSBTime = objService.GetServiceBookedTime(bookedTimeObj, aspxCommonObj);
return lstSBTime;
}
catch (Exception e)
{
throw e;
}
}
public List<ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@ServiceCategoryID", bookedTimeObj.ServiceCategoryID));
parameter.Add(new KeyValuePair<string, object>("@BranchID", bookedTimeObj.BranchID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeID", bookedTimeObj.EmployeeID));
parameter.Add(new KeyValuePair<string, object>("@ServiceDateID", bookedTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair<string, object>("@ServiceDate", bookedTimeObj.ServiceDate));
parameter.Add(new KeyValuePair<string, object>("@ServiceTimeID", bookedTimeObj.ServiceTimeID));
parameter.Add(new KeyValuePair<string, object>("@ItemID", bookedTimeObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
SQLHandler sqlh = new SQLHandler();
return sqlh.ExecuteAsList<ServiceBookedTime>("[dbo].[usp_Aspx_GetServiceBookedTime]", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public List<ServiceBookedTime> GetServiceBookedTime(GetServiceBookedTimeInfo bookedTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ServiceCategoryID", bookedTimeObj.ServiceCategoryID));
parameter.Add(new KeyValuePair<string, object>("@BranchID", bookedTimeObj.BranchID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeID", bookedTimeObj.EmployeeID));
parameter.Add(new KeyValuePair<string, object>("@ServiceDateID", bookedTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair<string, object>("@ServiceDate", bookedTimeObj.ServiceDate));
parameter.Add(new KeyValuePair<string, object>("@ServiceTimeID", bookedTimeObj.ServiceTimeID));
parameter.Add(new KeyValuePair<string, object>("@ItemID", bookedTimeObj.ItemID));
SQLHandler sqlh = new SQLHandler();
List<ServiceBookedTime> lstSBTime = sqlh.ExecuteAsList<ServiceBookedTime>("[dbo].[usp_Aspx_GetServiceBookedTime]", parameter);
return lstSBTime;
}
catch (Exception e)
{
throw e;
}
}
