public bool Insert(DTO_Group _Group) { Connet(); string sql = "insert into Group ( ID, Group_Name, AccountID, Phone) values (@ID, @Group_Name, @AccountID, @Phone)"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID; _cmd.Parameters.Add("@Group_Name", SqlDbType.VarChar).Value = _Group.Group_Name; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Group.AccountID; _cmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = _Group.Phone; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Update(DTO_Group _Group) { Connet(); string sql = "update Group set Group_Name=@Group_Name,AccountID=@AccountID,Phone=@APhone Where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID; _cmd.Parameters.Add("@Group_Name", SqlDbType.VarChar).Value = _Group.Group_Name; _cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Group.AccountID; _cmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = _Group.Phone; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public DTO_Group GetNhomByID(string strMaNhom) { if (strMaNhom == null) { return(null); } DTO_Group res = null; using (var context = new SQLServerDBContext()) { res = context.Group.Where(g => g.MaNhom == strMaNhom).FirstOrDefault(); } return(res); }
public bool Delete(DTO_Group _Group) { Connet(); string sql = "delete from Group where ID=@ID"; try { _cmd = new SqlCommand(sql, _conn); _cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID; _cmd.ExecuteNonQuery(); _cmd.Dispose(); Disconnet(); } catch (Exception ex) { Disconnet(); return(false); throw ex; } return(true); }
public bool Update(DTO_Group _group) { return(_Group.Update(_group)); }
public bool Delete(DTO_Group _group) { return(_Group.Delete(_group)); }
public bool Insert(DTO_Group _group) { return(_Group.Insert(_group)); }