public static void DeleteNameFilter(int Id)
{
INameFilter dal = Factory <INameFilter> .Create("NameFilter");
NameFilterInfo namefilter = dal.GetById(Id);
dal.Delete(namefilter);
}
public static void UpdateNameFilter(int Id, string name)
{
INameFilter dal = Factory <INameFilter> .Create("NameFilter");
NameFilterInfo namefilter = dal.GetById(Id);
namefilter.Name = name;
dal.Update(namefilter);
}
public static int AddNameFilter(string name)
{
NameFilterInfo namefilter = new NameFilterInfo();
namefilter.Name = name;
INameFilter dal = Factory <INameFilter> .Create("NameFilter");
return(dal.Add(namefilter));
}
public void Delete(NameFilterInfo filter)
{
string strSql = "DELETE FROM " + Config.FilterTablePrefix + "NAMEFILTER WHERE N_ID=@Id";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, new SqlParameter("@Id", SqlDbType.VarChar)
{
Value = filter.Id
});
}
public int Add(NameFilterInfo filter)
{
string strSql = "INSERT INTO " + Config.FilterTablePrefix + "NAMEFILTER (N_NAME) VALUES (@Name); SELECT SCOPE_IDENTITY();";
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql, new SqlParameter("@Name", SqlDbType.VarChar)
{
Value = filter.Name
})));
}
public int Add(NameFilterInfo filter)
{
string strSql = "INSERT INTO " + Config.FilterTablePrefix + "NAMEFILTER (N_NAME) VALUES (@Name)";
return(Convert.ToInt32(SqlHelper.ExecuteInsertQuery(SqlHelper.ConnString, CommandType.Text, strSql, new OleDbParameter("@Name", OleDbType.VarChar)
{
Value = filter.Name
})));
}
public void Update(NameFilterInfo filter)
{
string strSql = "UPDATE " + Config.FilterTablePrefix + "NAMEFILTER SET M_NAME=@Name WHERE N_ID=@Id";
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter("@Id", SqlDbType.Int)
{
Value = filter.Id
},
new SqlParameter("@NAme", SqlDbType.VarChar)
{
Value = filter.Name
}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray());
}
public NameFilterInfo GetById(int id)
{
string strSql = "SELECT N_ID,N_NAME FROM " + Config.FilterTablePrefix + "NAMEFILTER WHERE N_ID=@Id";
NameFilterInfo filter = null;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSql, new SqlParameter("@Id", SqlDbType.Int)
{
Value = id
}))
{
while (rdr.Read())
{
filter = new NameFilterInfo
{
Id = rdr.GetInt32(0),
Name = rdr.SafeGetString(1)
};
}
}
return(filter);
}
