public static void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
AspxServiceProvider.SaveServiceProvider(aspxCommonObj, providerSaveInfo);
}
catch (Exception e)
{
throw e;
}
}
public bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >();
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));
Parameter.Add(new KeyValuePair <string, object>("@StoreBranchID", providerUniqueInfo.StoreBranchID));
Parameter.Add(new KeyValuePair <string, object>("@EmployeeID", providerUniqueInfo.EmployeeID));
Parameter.Add(new KeyValuePair <string, object>("@EmployeeName", providerUniqueInfo.EmployeeName));
return(sqlH.ExecuteNonQueryAsBool("[usp_Aspx_ServiceProviderUniqunessCheck]", Parameter, "@IsUnique"));
}
catch (Exception ex)
{
throw ex;
}
}
public static void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("StoreBranchID", providerSaveInfo.StoreBranchID));
parameter.Add(new KeyValuePair <string, object>("EmployeeID", providerSaveInfo.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("EmployeeName", providerSaveInfo.EmployeeName));
parameter.Add(new KeyValuePair <string, object>("EmployeeNickName", providerSaveInfo.EmployeeNickName));
parameter.Add(new KeyValuePair <string, object>("EmployeeImage", providerSaveInfo.EmployeeImage));
OracleHandler sqlh = new OracleHandler();
sqlh.ExecuteNonQuery("usp_Aspx_AddUpdateServiceProvider", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
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));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("@StoreBranchID", providerSaveInfo.StoreBranchID));
parameter.Add(new KeyValuePair <string, object>("@EmployeeID", providerSaveInfo.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("@EmployeeName", providerSaveInfo.EmployeeName));
parameter.Add(new KeyValuePair <string, object>("@EmployeeNickName", providerSaveInfo.EmployeeNickName));
parameter.Add(new KeyValuePair <string, object>("@EmployeeImage", providerSaveInfo.EmployeeImage));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("[dbo].[usp_Aspx_AddUpdateServiceProvider]", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
bool isSPUnique = AspxServiceProvider.CheckServiceProviderUniqueness(aspxCommonObj, providerUniqueInfo);
return(isSPUnique);
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
bool isSPUnique = AspxServiceProvider.CheckServiceProviderUniqueness(aspxCommonObj,providerUniqueInfo);
return isSPUnique;
}
catch (Exception e)
{
throw e;
}
}
public static void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
AspxServiceProvider.SaveServiceProvider(aspxCommonObj, providerSaveInfo);
}
catch (Exception e)
{
throw e;
}
}
public bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>();
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));
Parameter.Add(new KeyValuePair<string, object>("@StoreBranchID", providerUniqueInfo.StoreBranchID));
Parameter.Add(new KeyValuePair<string, object>("@EmployeeID", providerUniqueInfo.EmployeeID));
Parameter.Add(new KeyValuePair<string, object>("@EmployeeName", providerUniqueInfo.EmployeeName));
return sqlH.ExecuteNonQueryAsBool("[usp_Aspx_ServiceProviderUniqunessCheck]", Parameter, "@IsUnique");
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
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));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@StoreBranchID", providerSaveInfo.StoreBranchID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeID", providerSaveInfo.EmployeeID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeName", providerSaveInfo.EmployeeName));
parameter.Add(new KeyValuePair<string, object>("@EmployeeNickName", providerSaveInfo.EmployeeNickName));
parameter.Add(new KeyValuePair<string, object>("@EmployeeImage", providerSaveInfo.EmployeeImage));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("[dbo].[usp_Aspx_AddUpdateServiceProvider]", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
Parameter.Add(new KeyValuePair <string, object>("StoreBranchID", providerUniqueInfo.StoreBranchID));
Parameter.Add(new KeyValuePair <string, object>("EmployeeID", providerUniqueInfo.EmployeeID));
Parameter.Add(new KeyValuePair <string, object>("EmployeeName", providerUniqueInfo.EmployeeName));
bool isSPUnique = sqlH.ExecuteNonQueryAsBool("usp_Aspx_ServiceProviderUniqunessCheck", Parameter, "IsUnique");
return(isSPUnique);
}
catch (Exception e)
{
throw e;
}
}
public static bool CheckServiceProviderUniqueness(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerUniqueInfo)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
Parameter.Add(new KeyValuePair<string, object>("@StoreBranchID", providerUniqueInfo.StoreBranchID));
Parameter.Add(new KeyValuePair<string, object>("@EmployeeID", providerUniqueInfo.EmployeeID));
Parameter.Add(new KeyValuePair<string, object>("@EmployeeName", providerUniqueInfo.EmployeeName));
bool isSPUnique= sqlH.ExecuteNonQueryAsBool("[usp_Aspx_ServiceProviderUniqunessCheck]", Parameter, "@IsUnique");
return isSPUnique;
}
catch (Exception e)
{
throw e;
}
}
public static void SaveServiceProvider(AspxCommonInfo aspxCommonObj, ServiceProviderInfo providerSaveInfo)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@StoreBranchID", providerSaveInfo.StoreBranchID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeID", providerSaveInfo.EmployeeID));
parameter.Add(new KeyValuePair<string, object>("@EmployeeName", providerSaveInfo.EmployeeName));
parameter.Add(new KeyValuePair<string, object>("@EmployeeNickName", providerSaveInfo.EmployeeNickName));
parameter.Add(new KeyValuePair<string, object>("@EmployeeImage", providerSaveInfo.EmployeeImage));
SQLHandler sqlh = new SQLHandler();
sqlh.ExecuteNonQuery("[dbo].[usp_Aspx_AddUpdateServiceProvider]", parameter);
}
catch (Exception e)
{
throw e;
}
}
