public int CatalogPriceRuleRoleAdd(CatalogPriceRuleRole catalogPriceRuleRole, Int32 storeID, Int32 portalID, string userName, string culture) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleRole.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@RoleID", catalogPriceRuleRole.RoleID)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", storeID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", portalID)); sqlCommand.Parameters.Add(new SqlParameter("@Username", userName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", culture)); sqlCommand.CommandText = "usp_Aspx_CatalogPriceRuleRoleAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return(Convert.ToInt16(val)); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public static int CatalogPriceRuleRoleAdd(CatalogPriceRuleRole catalogPriceRuleRole, AspxCommonInfo aspxCommonObj) { OracleCommand sqlCommand = new OracleCommand(); sqlCommand.Parameters.Add(new OracleParameter("CatalogPriceRuleID", catalogPriceRuleRole.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new OracleParameter("RoleID", catalogPriceRuleRole.RoleID)); sqlCommand.Parameters.Add(new OracleParameter("IsActive", true)); sqlCommand.Parameters.Add(new OracleParameter("StoreID", aspxCommonObj.StoreID)); sqlCommand.Parameters.Add(new OracleParameter("PortalID", aspxCommonObj.PortalID)); sqlCommand.Parameters.Add(new OracleParameter("UserName", aspxCommonObj.UserName)); sqlCommand.Parameters.Add(new OracleParameter("CultureName", aspxCommonObj.CultureName)); sqlCommand.CommandText = "usp_Aspx_CatalogPriceRuleRoleAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; OracleConnection sqlConnection = new OracleConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return(Convert.ToInt16(val)); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public static int CatalogPriceRuleRoleAdd(CatalogPriceRuleRole catalogPriceRuleRole, AspxCommonInfo aspxCommonObj) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleRole.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@RoleID", catalogPriceRuleRole.RoleID)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", aspxCommonObj.StoreID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", aspxCommonObj.PortalID)); sqlCommand.Parameters.Add(new SqlParameter("@UserName", aspxCommonObj.UserName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", aspxCommonObj.CultureName)); sqlCommand.CommandText = "usp_Aspx_CatalogPriceRuleRoleAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return Convert.ToInt16(val); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }