public bool Update(UserJoinToEventDto dto) { con.Open(); SqlCommand cmd = new SqlCommand("Update tblUserJoinToEvent set userID=@userID, eventID=@eventID where id=@id;", con); cmd.Parameters.Add("@id", SqlDbType.Int).Value = dto.Id; cmd.Parameters.Add("@userID", SqlDbType.VarChar).Value = dto.UserID; cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = dto.EventID; int count = cmd.ExecuteNonQuery(); con.Close(); return(count == 1); }
public bool Create(UserJoinToEventDto dto) { con.Open(); SqlCommand cmd = new SqlCommand("Insert Into tblUserJoinToEvent(id,userID,eventID) VALUES(@id,@userID,@eventID);", con); cmd.Parameters.Add("@id", SqlDbType.Int).Value = dto.Id; cmd.Parameters.Add("@userID", SqlDbType.VarChar).Value = dto.UserID; cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = dto.EventID; int count = cmd.ExecuteNonQuery(); con.Close(); return(count == 1); }