/*-------------------------- * PROCEDURE procSEL_Phrase *-------------------------- * @IdLanguage int * @IdResource int */ public Boolean SelectPhrase(int iIdResource, ref String strPhrase) { SQLParameters Parameters = new SQLParameters(); SQLFillParameter FillParameter = new SQLFillParameter(); SqlParameter Parameter = new SqlParameter("@IdLanguage", SqlDbType.Int); FillParameter.FillParameter(Parameter, Language.GetLanguage()); Parameters.Add(Parameter); Parameter = new SqlParameter("@IdResource", SqlDbType.Int); FillParameter.FillParameter(Parameter, iIdResource); Parameters.Add(Parameter); SqlCommand CommandSelectPhrase = new SqlCommand("procSEL_Phrase", Database.Connection); if (CommandSelectPhrase == null) { return(false); } try { CommandSelectPhrase.CommandType = CommandType.StoredProcedure; Parameters.FillParametersIn(CommandSelectPhrase); SqlDataReader AdapterSelectPhrase = CommandSelectPhrase.ExecuteReader(); if (!AdapterSelectPhrase.HasRows) { return(false); } AdapterSelectPhrase.Read(); strPhrase = AdapterSelectPhrase["Context"].ToString(); } catch (SqlException Ex) { throw new SQLException("Exception in 'SelectPhrase' function!", Ex); } catch (FormatException Ex) { throw new SQLException("Exception in 'SelectPhrase' function!", Ex); } return(true); }
/*------------------------------------- * PROCEDURE procSEL_StaticContext *-------------------------------------- * @IdStatic int * @IdLanguage int */ public Boolean SelectStaticContext(int iIdStatic, int iIdLanguage, out DataSet dsText) { SQLParameters Parameters = new SQLParameters(); SQLFillParameter FillParameter = new SQLFillParameter(); SqlParameter Parameter = new SqlParameter("@IdLanguage", SqlDbType.Int); FillParameter.FillParameter(Parameter, iIdLanguage); Parameters.Add(Parameter); Parameter = new SqlParameter("@IdStatic", SqlDbType.Int); FillParameter.FillParameter(Parameter, iIdStatic); Parameters.Add(Parameter); dsText = new DataSet(); SqlCommand CommandSelectText = new SqlCommand("procSEL_StaticContext", Database.Connection); if (CommandSelectText == null) { return(false); } try { CommandSelectText.CommandType = CommandType.StoredProcedure; Parameters.FillParametersIn(CommandSelectText); SqlDataAdapter AdapterSelectText = new SqlDataAdapter(); AdapterSelectText.SelectCommand = CommandSelectText; AdapterSelectText.Fill(dsText, "tblStaticText"); } catch (SqlException Ex) { throw new SQLException("Exception in 'SelectStaticText' function!", Ex); } catch (FormatException Ex) { throw new SQLException("Exception in 'SelectStaticText' function!", Ex); } return(true); }
/*------------------------------------------------- * PROCEDURE procSEL_ExcludedLanguagesByIdResource *-------------------------------------------------- * @IdResource int, * @IsStaticResource as bit */ public Boolean SelectExcludedLanguagesByIdRes(int nIdResource, Boolean IsStaticResource, out DataSet dsLanguage) { dsLanguage = new DataSet(); SqlCommand CommandSelectExcludedLanguages = new SqlCommand("procSEL_ExcludedLanguagesByIdResource", Database.Connection); if (CommandSelectExcludedLanguages == null) { return(false); } try { SQLParameters Parameters = new SQLParameters(); SQLFillParameter FillParameter = new SQLFillParameter(); SqlParameter Parameter = new SqlParameter("@IdResource", SqlDbType.Int); FillParameter.FillParameter(Parameter, nIdResource); Parameters.Add(Parameter); Parameter = new SqlParameter("@IsStaticResource", SqlDbType.Bit); FillParameter.FillParameter(Parameter, IsStaticResource); Parameters.Add(Parameter); CommandSelectExcludedLanguages.CommandType = CommandType.StoredProcedure; Parameters.FillParametersIn(CommandSelectExcludedLanguages); SqlDataAdapter AdapterSelectExcludedLanguages = new SqlDataAdapter(); AdapterSelectExcludedLanguages.SelectCommand = CommandSelectExcludedLanguages; AdapterSelectExcludedLanguages.Fill(dsLanguage, "tblExLanguages"); } catch (SqlException Ex) { throw new SQLException("Exception in 'SelectExcludedLanguagesByIdRes' function!", Ex); } catch (FormatException Ex) { throw new SQLException("Exception in 'SelectExcludedLanguagesByIdRes' function!", Ex); } return(true); }
/*--------------------------------------- * PROCEDURE procUPD_ResourceDescription *--------------------------------------- * @IdResource int * @Description nvarchar (100) */ public Boolean UpdateResourceDescription(int iIdResource, String strDescription, ref Int32 nReturnValue) { SqlCommand CommandUpdateResourceDescription = new SqlCommand("procUPD_ResourceDescription", Database.Connection); if (CommandUpdateResourceDescription == null) { return(false); } try { SQLParameters Parameters = new SQLParameters(); SQLFillParameter FillParameter = new SQLFillParameter(); SqlParameter Parameter = new SqlParameter("@Description", SqlDbType.NVarChar, 100); FillParameter.FillParameter(Parameter, strDescription); Parameters.Add(Parameter); Parameter = new SqlParameter("@IdResource", SqlDbType.Int); FillParameter.FillParameter(Parameter, iIdResource); Parameters.Add(Parameter); Parameter = new SqlParameter("@IdLanguage", SqlDbType.Int); FillParameter.FillParameter(Parameter, Language.GetLanguage()); Parameters.Add(Parameter); CommandUpdateResourceDescription.CommandType = CommandType.StoredProcedure; Parameters.FillParametersIn(CommandUpdateResourceDescription); CommandUpdateResourceDescription.ExecuteNonQuery(); nReturnValue = (Int32)Parameters.ReturnValue(); } catch (SqlException Ex) { nReturnValue = 0; throw new SQLException("Error in 'UpdateResourceDescription' function", Ex); } return(true); }
/*----------------------------------- * PROCEDURE procUPD_LanguageContext *----------------------------------- * @Context nvarchar (500) * @IdContext int * @UserName nvarchar(50) */ public Boolean UpdateLanguageContext(String strContext, int iIdContext, String UserName, ref Int32 nReturnValue) { SqlCommand CommandUpdateLanguageContext = new SqlCommand("procUPD_LanguageContext", Database.Connection); if (CommandUpdateLanguageContext == null) { return(false); } try { SQLParameters Parameters = new SQLParameters(); SQLFillParameter FillParameter = new SQLFillParameter(); SqlParameter Parameter = new SqlParameter("@IdContext", SqlDbType.Int); FillParameter.FillParameter(Parameter, iIdContext); Parameters.Add(Parameter); Parameter = new SqlParameter("@Context", SqlDbType.NVarChar, 500); FillParameter.FillParameter(Parameter, strContext); Parameters.Add(Parameter); Parameter = new SqlParameter("@UserName", SqlDbType.NVarChar, 50); FillParameter.FillParameter(Parameter, UserName); Parameters.Add(Parameter); CommandUpdateLanguageContext.CommandType = CommandType.StoredProcedure; Parameters.FillParametersIn(CommandUpdateLanguageContext); CommandUpdateLanguageContext.ExecuteNonQuery(); nReturnValue = (Int32)Parameters.ReturnValue(); } catch (SqlException Ex) { nReturnValue = 0; throw new SQLException("Error in 'UpdateLanguageContext' function", Ex); } return(true); }