public bool InsertNewMember(Member memberObj)
{
bool result = false;
if(dbMember.InsertNewMember(memberObj) == 1)
{
result = true;
}
return result;
}
public int UpdateMember(Member memberObj)
{
throw new NotImplementedException();
}
public int InsertNewMember(Member memberObject)
{
int rowCount = 0;
string connString = ConfigurationManager.ConnectionStrings["CS1"].ConnectionString;
using (SqlConnection con = new SqlConnection(connString))
{
string selectCmd = "INSERT INTO Member VALUES (@firstname, @lastname, @address, @city, @phonenumber, @email, @facilityname, @instructorname, @dietistname, @membertype)";
SqlCommand cmd = new SqlCommand(selectCmd, con);
cmd.CommandType = CommandType.Text;
SqlParameter parameterFname = new SqlParameter
{
ParameterName = "@firstname",
Value = memberObject.Firstname
};
cmd.Parameters.Add(parameterFname);
SqlParameter parameterLastName = new SqlParameter
{
ParameterName = "@lastname",
Value = memberObject.Lastname
};
cmd.Parameters.Add(parameterLastName);
SqlParameter parameterAddr = new SqlParameter
{
ParameterName = "@address",
Value = memberObject.Address
};
cmd.Parameters.Add(parameterAddr);
SqlParameter parameterCity = new SqlParameter
{
ParameterName = "@city",
Value = memberObject.City
};
cmd.Parameters.Add(parameterCity);
SqlParameter parameterPhone = new SqlParameter
{
ParameterName = "@phone",
Value = memberObject.Phonenum
};
cmd.Parameters.Add(parameterPhone);
SqlParameter parameterEmail = new SqlParameter
{
ParameterName = "@email",
Value = memberObject.Email
};
cmd.Parameters.Add(parameterEmail);
SqlParameter parameterMembertype = new SqlParameter
{
ParameterName = "@membertype",
Value = memberObject.Type
};
cmd.Parameters.Add(parameterMembertype);
if (memberObject.GetType() == typeof(GoldMember))
{
SqlParameter parameterFacility = new SqlParameter
{
ParameterName = "@facilityname",
Value = ((GoldMember)memberObject).FacilityName
};
cmd.Parameters.Add(parameterFacility);
SqlParameter parameterDiaetist = new SqlParameter
{
ParameterName = "@dietistname",
Value = ((GoldMember)memberObject).DietistName
};
cmd.Parameters.Add(parameterDiaetist);
}
else
{
SqlParameter parameterInstructor = new SqlParameter
{
ParameterName = "@instructorname",
Value = ((SilverMember)memberObject).InstructorName
};
cmd.Parameters.Add(parameterInstructor);
}
con.Open();
if(cmd.ExecuteNonQuery() == 1)
{
rowCount += rowCount;
}
}
return rowCount;
}
