public void DeleteBy(string field, object value) { using (var cmd = new SqlCommand("DELETE FROM " + table + " WHERE " + field + "=@value", Conn.CreateConnection())) { cmd.Parameters.AddWithValue("@value", value); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public void Insert(T pro) { string parms = ""; string fielsds = ""; var mappings = mapper.CreateMap(); foreach (var map in mappings) { if (map.Key.ToLower() != "id") { fielsds += map.Value + ", "; parms += "@" + map.Key + ", "; } } fielsds = fielsds.Substring(0, fielsds.Length - 2); parms = parms.Substring(0, parms.Length - 2); using (var cmd = new SqlCommand("INSERT INTO " + table + " (" + fielsds + ") VALUES(" + parms + ")", Conn.CreateConnection())) { foreach (var prop in mappings) { if (prop.Key.ToLower() != "id") { cmd.Parameters.AddWithValue(prop.Key, pro.GetType().GetProperty(prop.Key).GetValue(pro, null)); } } cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public void Delete(int ID) { using (var cmd = new SqlCommand("DELETE FROM " + table + " WHERE ID=@ID", Conn.CreateConnection())) { cmd.Parameters.AddWithValue("ID", ID); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public List <T> GetBy(string field, object value) { using (var cmd = new SqlCommand("SELECT * FROM " + table + " WHERE " + field + "=@KID", Conn.CreateConnection())) { cmd.Parameters.AddWithValue("@KID", value); List <T> list = mapper.MapList(cmd.ExecuteReader()); cmd.Connection.Close(); return(list); } }
public T Get(int ID) { using (var cmd = new SqlCommand("SELECT * FROM " + table + " WHERE ID=@ID", Conn.CreateConnection())) { cmd.Parameters.AddWithValue("@ID", ID); var r = cmd.ExecuteReader(); T type = new T(); if (r.Read()) { type = mapper.Map(r); } r.Close(); cmd.Connection.Close(); return(type); } }
public void UpdateField(string field, object value, int ID) { using (var cmd = new SqlCommand("UPDATE " + table + " SET " + field + "=@value WHERE ID=@Id", Conn.CreateConnection())) { cmd.Parameters.AddWithValue("@ID", ID); cmd.Parameters.AddWithValue("@value", value); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public void Update(T pro) { string fAndP = ""; var mappings = mapper.CreateMap(); foreach (var map in mappings) { if (map.Key.ToLower() != "id") { fAndP += map.Value + "=@" + map.Key + ", "; } } fAndP = fAndP.Substring(0, fAndP.Length - 2); using (var cmd = new SqlCommand("UPDATE " + table + " SET " + fAndP + " WHERE ID=@Id", Conn.CreateConnection())) { foreach (var prop in mappings) { cmd.Parameters.AddWithValue(prop.Key, pro.GetType().GetProperty(prop.Key).GetValue(pro, null)); } cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }