public override bool ExitsTranlate_T_Photo_Even(int id, int langId)
{
string _sql = "[ExitsTranlate_T_Photo_Event]";
SqlService _sqlservice = new SqlService();
DataSet _ds;
try
{
_sqlservice.AddParameter("@Photo_ID", SqlDbType.Int, id, true);
_sqlservice.AddParameter("@Languages_ID", SqlDbType.Int, langId, true);
_ds = _sqlservice.ExecuteSPDataSet(_sql);
if (_ds.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.Disconnect();
}
}
public override bool Check_Nhanban_T_Categorys_Chuyende(int id)
{
string _sql = "Check_Nhanban_T_Category_ChuyenDe";
SqlService _sqlservice = new SqlService();
DataSet _ds;
try
{
_sqlservice.AddParameter("@ID", SqlDbType.Int, id, true);
_ds = _sqlservice.ExecuteSPDataSet(_sql);
if (_ds.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.Disconnect();
}
}
public override DataSet ExecStoreDataSet(string StoreName)
{
SqlService _sqlservice = new SqlService(connectionString);
try
{
return(_sqlservice.ExecuteSPDataSet(StoreName));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.Disconnect();
}
}
public override DataSet GetDataSet(string TableName, string ColumnList, string Where)
{
string _sql = "Sp_GetColumnValues";
SqlService _sqlservice = new SqlService(connectionString);
_sqlservice.AddParameter("@TableName", SqlDbType.NVarChar, TableName);
_sqlservice.AddParameter("@ColumnList", SqlDbType.NVarChar, ColumnList);
_sqlservice.AddParameter("@Where", SqlDbType.NVarChar, Where);
try
{
return(_sqlservice.ExecuteSPDataSet(_sql));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.Disconnect();
}
}
public override DataSet GetStoreDataSet(string StoreName, string[] param1, object[] value)
{
string _sql = StoreName;
SqlService _sqlservice = new SqlService(connectionString);
for (int i = 0; i < param1.Length; i++)
{
_sqlservice.AddParameter(new SqlParameter(param1[i], value[i]));
}
try
{
return(_sqlservice.ExecuteSPDataSet(_sql));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sqlservice.Disconnect();
}
}
