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