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