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