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);
}
