public void InsertFriend(FriendDetails friendDetais)//הפעולה מאפשרת להוסיף מידע לתוך טבלת חברים { OleDbCommand myCmd = new OleDbCommand("InsertIntoFriends", myConnection); myCmd.CommandType = CommandType.StoredProcedure; //INSERT INTO Friends ( PhoneIDAsking, PhoneIDAccepting, DateOfFriendship, Status ) //VALUES(@PhoneIDAsking, @PhoneIDAccepting, @DateOfFriendship, @Status); OleDbParameter objParam; objParam = myCmd.Parameters.Add("@PhoneIDAsking", OleDbType.BSTR); objParam.Direction = ParameterDirection.Input; objParam.Value = friendDetais.phoneIDAsking; objParam = myCmd.Parameters.Add("@PhoneIDAccepting", OleDbType.BSTR); objParam.Direction = ParameterDirection.Input; objParam.Value = friendDetais.phoneIDAccepting; objParam = myCmd.Parameters.Add("@DateOfFriendship", OleDbType.Date); objParam.Direction = ParameterDirection.Input; objParam.Value = friendDetais.dateOfFriendship; objParam = myCmd.Parameters.Add("@Status", OleDbType.Boolean); objParam.Direction = ParameterDirection.Input; objParam.Value = friendDetais.status; try { myConnection.Open(); myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { myConnection.Close(); } }
public string ToText() { return(FriendDetails.ToText()); }
public void InsertFriend(FriendDetails friendDetais)//הפעולה מאפשרת להוסיף מידע לתוך טבלת חברים { UserService service = new UserService(); service.InsertFriend(friendDetais); }
public void InsertFriend1()//הפעולה מאפשרת להוסיף מידע לתוך טבלת חברים { FriendDetails friendDetais = new FriendDetails(); friendDetais.phoneIDAccepting = "0547645029"; friendDetais.phoneIDAsking = "3"; friendDetais.dateOfFriendship = DateTime.Now; friendDetais.status = false; UserService service = new UserService(); service.InsertFriend(friendDetais); }