/*--------------------------
* 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);
}
