public bool addNewBrother(Brother newBrother)
{
using (SqlConnection conn = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = c:\users\grant folgate\documents\visual studio 2015\Projects\DeltaSigServiceCenter_DEV\DeltaSigServiceCenter_DEV\App_Data\DeltaSigServiceData.mdf; Integrated Security = True"))
{
SqlCommand cmd = new SqlCommand("AddNewBrother", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@FullName", System.Data.SqlDbType.NVarChar);
cmd.Parameters.Add("@Class", System.Data.SqlDbType.NVarChar);
cmd.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar);
cmd.Parameters.Add("@PhoneNum", System.Data.SqlDbType.NVarChar);
cmd.Parameters["@FullName"].Value = newBrother.FullName;
cmd.Parameters["@Class"].Value = newBrother.ClassStanding;
cmd.Parameters["@Email"].Value = newBrother.Email;
cmd.Parameters["@PhoneNum"].Value = newBrother.PhoneNum;
conn.Open();
try
{
//attempt to insert into DB
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
//close the connection ASAP
conn.Close();
//non-query exception error, can't insert
e.GetBaseException();
return(false);
}
}
}
public bool requestBrotherAddition(Brother pendingBrother)
{
broDataRetreiver = new BrothersInfo_DAL();
try
{
if (broDataRetreiver.checkForExistingBro(pendingBrother) == true)
{
return(true);
}
else
{
return(false);
}
} catch (Exception e)
{
LogException(e);
//Error happened so the new brother could not be added
return(false);
}
}
public bool checkForExistingBro(Brother potentialBrother)
{
string emailAddressCheck = potentialBrother.Email;
string emailHolder = "";
using (SqlConnection conn = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = c:\users\grant folgate\documents\visual studio 2015\Projects\DeltaSigServiceCenter_DEV\DeltaSigServiceCenter_DEV\App_Data\DeltaSigServiceData.mdf; Integrated Security = True"))
{
SqlCommand qry = new SqlCommand("CheckForExistingBrother", conn);
qry.CommandType = System.Data.CommandType.StoredProcedure;
qry.Parameters.Add("@Email", System.Data.SqlDbType.NVarChar);
qry.Parameters["@Email"].Value = emailAddressCheck;
conn.Open();
dataReader = qry.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
//should return one item of information (Brother's name)
emailHolder = dataReader[0].ToString();
}
}
}
if (emailHolder == emailAddressCheck)
{
return(false);
}
else
{
if (addNewBrother(potentialBrother) == true)
{
return(true);
}
else
{
return(false);
}
}
}
