public bool SaveBoat(Boat newBoat)
{
UserDAL usrDAL = new UserDAL();
List<User> userlist = usrDAL.GetUsers();
if (userlist.Exists(x => x.PersonalNumber == newBoat.Personalnumber))
{
usrDAL.AddBoat(newBoat);
return true;
}
else
{
return false;
}
}
public Boat AddNewBoat(Boat boat)
{
bool test;
do
{
Console.Write("State boat type: ");
boat.BoatType = Console.ReadLine();
if (boat.BoatType.Length == 0)
{
Console.Clear();
Console.WriteLine("You must state boat type");
}
} while (boat.BoatType.Length == 0);
do
{
int n;
Console.Write("State boat lenght: ");
string s = Console.ReadLine();
test = int.TryParse(s, out n);
if (test)
{
boat.BoatLenght = n;
}
else
{
Console.Clear();
Console.WriteLine("Try to state a number again");
}
} while (test == false);
do
{
int n;
Console.Write("State personal number: ");
string s = Console.ReadLine();
test = int.TryParse(s, out n);
if (test)
{
boat.Personalnumber = n;
}
else
{
Console.Clear();
Console.WriteLine("Try to state a number again");
}
} while (test == false);
return boat;
}
public void AddBoat(Boat newBoat)
{
try
{
using (SqlConnection conn = CreateConnection())
{
SqlCommand sqlCmd = new SqlCommand("applicationSchema.usp_AddBoat", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@Personalnumber", SqlDbType.Int, 4).Value = newBoat.Personalnumber;
sqlCmd.Parameters.Add("@BoatType", SqlDbType.VarChar, 50).Value = newBoat.BoatType;
sqlCmd.Parameters.Add("@BoatLenght", SqlDbType.Float, 4).Value = newBoat.BoatLenght;
conn.Open();
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception)
{
throw new Exception("Error when the data was going to be saved");
}
}
public void UpdateBoat(Boat boat)
{
UserDAL usrDAL = new UserDAL();
usrDAL.UpdateBoat(boat);
}
public Boat UpdateBoat(Boat boat)
{
Console.WriteLine("Change boat info");
do
{
Console.Write("State boatID:");
string boatID = Console.ReadLine();
int parsedNumber;
int.TryParse(boatID, out parsedNumber);
if (parsedNumber == 0 )
{
Console.Clear();
Console.WriteLine("Try state a number again");
}
else
{
boat.BoatID = parsedNumber;
}
} while (boat.BoatID == 0 );
do
{
Console.Write("State boat personalnumber:");
string personalNumber = Console.ReadLine();
int parsedNumber;
int.TryParse(personalNumber, out parsedNumber);
if (parsedNumber == 0)
{
Console.Clear();
Console.WriteLine("Try state a number again");
}
else
{
boat.Personalnumber = parsedNumber;
}
} while (boat.BoatID == 0);
do
{
Console.Write("State boat type:");
boat.BoatType = Console.ReadLine();
if (boat.BoatType == "" || boat.BoatType == null)
{
Console.Clear();
Console.WriteLine("Try state a boat type again");
}
} while (boat.BoatType == "" || boat.BoatType == null);
do
{
Console.Write("State boat lenght:");
string boatID = Console.ReadLine();
int parsedNumber;
int.TryParse(boatID, out parsedNumber);
if (parsedNumber == 0)
{
Console.Clear();
Console.WriteLine("Try state a number again");
}
else
{
boat.BoatLenght = parsedNumber;
}
} while (boat.BoatID == 0);
return boat;
}