public int Add(Practice p) { SqlParameter[] parameter = { new SqlParameter("@Username", p.Username), new SqlParameter("@Fullname", p.Fullname), new SqlParameter("@Password", p.Password), new SqlParameter("@CountryID", p.CountryID), new SqlParameter("@Gender", p.Gender), new SqlParameter("@Interests", p.Interests) }; string query = "Insert into tblInfo values(@Fullname,@Username,@Password,@CountryID,@Gender,@Interests)"; var args = new DynamicParameters(new { }); parameter.ToList().ForEach(t => args.Add(t.ParameterName, t.Value)); var add = this._db.Execute(query, args); return(add); }
public int Update(Practice p) { SqlParameter[] parameter = { new SqlParameter("@Username", p.Username), new SqlParameter("@Fullname", p.Fullname), new SqlParameter("@Password", p.Password), new SqlParameter("@Gender", p.Gender), new SqlParameter("@CountryID", p.CountryID), new SqlParameter("@Interests", p.Interests), new SqlParameter("@ID", p.ID) }; string query = ("Update tblInfo set Username=@Username,Fullname=@Fullname,Password=@Password,Gender=@Gender,CountryID=@CountryID,Interests=@Interests Where ID=@ID"); var args = new DynamicParameters(new { }); parameter.ToList().ForEach(t => args.Add(t.ParameterName, t.Value)); var update = this._db.Execute(query, args); return(update); }