public async Task <IActionResult> Edit(int id, [Bind("Id,AdultId,FirstName,LastName,MidInit,Suffix,Birthdate,InActive,InActiveDate")] JuvenileMember juvenileMember)
{
if (id != juvenileMember.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(juvenileMember);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!JuvenileMemberExists(juvenileMember.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AdultId"] = new SelectList(_context.AdultMember, "Id", "FirstName", juvenileMember.AdultId);
return(View(juvenileMember));
}
private void ConvertToAdult(Member myMember)
{
string myErr;
if (myMember is JuvenileMember)
{
JuvenileMember myJuv = (JuvenileMember)myMember;
if ((DateTime)myJuv.BirthDate.AddYears(+18) <= DateTime.Today)
{
try
{
myDb.ConvertJuvenile(myJuv.MemberID);
myErr = string.Format("Member ID: {0} Converted to Adult.", txtMemberID.Text);
myMember = (Member)myDb.GetMember(Convert.ToInt16(txtMemberID.Text));
LoadGenericFields(myMember);
FormatAdultWindow();
Label lbl = (Label)Page.Master.FindControl("lblStatus");
lbl.Text = myErr;
lbl.ForeColor = Color.Blue;
txtExpDte.BackColor = Color.White;
btnRenewMember.Visible = false;
}
catch (LibraryException)
{
myErr = string.Format("Member ID: {0} could not be converted from Juvenile to Adult.", txtMemberID.Text);
Label lbl = (Label)Page.Master.FindControl("lblStatus");
lbl.Text = myErr;
}
}
}
}
public IActionResult Update(long id, [FromBody] JuvenileMember member)
{
if (member == null || member.Id != id)
{
return(BadRequest());
}
var uMember = _context.JuvenileMember.FirstOrDefault(t => t.Id == id);
if (uMember == null)
{
return(NotFound());
}
uMember.AdultId = member.AdultId;
uMember.FirstName = member.FirstName;
uMember.MidInit = member.MidInit;
uMember.LastName = member.LastName;
uMember.Suffix = member.Suffix;
uMember.Birthdate = member.Birthdate;
uMember.InActive = member.InActive;
uMember.InActiveDate = member.InActiveDate;
_context.JuvenileMember.Update(uMember);
_context.SaveChanges();
return(new NoContentResult());
}
/// <summary>
/// Add a Juvenile member to the DB.
/// </summary>
/// <param name="member"></param>
public void AddMember(JuvenileMember member)
{
try
{
myAccess.AddMember(member);
}
catch (LibraryException)
{
throw new LibraryException(ErrorCode.AddJuvenileFailed);
}
}
public async Task <IActionResult> Create([Bind("Id,AdultId,FirstName,LastName,MidInit,Suffix,Birthdate,InActive,InActiveDate")] JuvenileMember juvenileMember)
{
if (ModelState.IsValid)
{
_context.Add(juvenileMember);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AdultId"] = new SelectList(_context.AdultMember, "Id", "FirstName", juvenileMember.AdultId);
return(View(juvenileMember));
}
public IActionResult Create([FromBody] JuvenileMember member)
{
if (member == null)
{
return(BadRequest());
}
_context.JuvenileMember.Add(member);
_context.SaveChanges();
return(CreatedAtRoute("GetJuvenileMember", new { id = member.Id }, member));
}
public void AddJuvenileMember(ref JuvenileMember member)
{
try
{
DBInteraction db = new DBInteraction();
db.AddMember(member);
}
catch (LibraryException ex)
{
throw new SoapException(ex.Message, ExceptionCodes.AddJuvenileFailed);
}
}
//loads the fields that are common to Juvenile members.
private void LoadJuvenileFields(Member myMember)
{
juve = (JuvenileMember)myMember;
//set the fields visibles
lblBirth.Visible = true;
lblAdultID.Visible = true;
txtBirthDate.Visible = true;
txtAdultMemberID.Visible = true;
//move the myMemberfields into the txt fields.
txtAdultMemberID.Text = juve.AdultMemberID.ToString();
txtBirthDate.Text = juve.BirthDate.ToString("MM/dd/yyyy");
}
/// <summary>
/// Adds a juvenile member
/// </summary>
/// <param name="member">Member object</param>
public void AddMember(JuvenileMember member)
{
try
{
//create Connection object
using (SqlConnection cn = DBConnect())
{
//create command object
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_AddJuvenileMember";
//add all the fields as parameters to pass into our AddAdultMember
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 15).Value = member.LastName;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 15).Value = member.FirstName;
if (member.MiddleInitial != null)
{
cmd.Parameters.Add("@MiddleInitial", SqlDbType.Char, 1).Value = member.MiddleInitial;
}
else
{
cmd.Parameters.Add("@MiddleInitial", SqlDbType.Char, 1).Value = DBNull.Value;
}
cmd.Parameters.Add("@AdultMemberID", SqlDbType.SmallInt).Value = member.AdultMemberID;
cmd.Parameters.Add("@BirthDate", SqlDbType.DateTime).Value = member.BirthDate;
cmd.Parameters.Add("@memberID", SqlDbType.SmallInt).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@errorCode", SqlDbType.Int).Direction = ParameterDirection.Output;
//open connection
cn.Open();
//Execute command
cmd.ExecuteNonQuery();
//get the memberID of the newly added member
member.MemberID = (Int16)cmd.Parameters["@memberID"].Value;
int errorCode = (int)cmd.Parameters["@errorCode"].Value;
if (errorCode != 0)
{
throw new LibraryException(ErrorCode.AddAdultFailed, "Error: Add Juvenile Failed.");
}
}
}
}
catch (SqlException ex)
{
throw new LibraryException(ErrorCode.GenericException, "Error: Contact Technical Support.", ex);
}
}
/// <summary>
/// Retrieves a member
/// </summary>
/// <param name="isbn">ISBN</param>
/// <param name="copyNum">Copy Number</param>
/// <returns>Member object</returns>
public Member GetMember(Int32 isbn, Int16 copyNum)
{
try
{
//create Connection object
using (SqlConnection cn = DBConnect())
{
//create command object
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetMemberByIsbnCopyNum";
//load the parameter list
cmd.Parameters.Add("@ISBN", SqlDbType.Int).Value = isbn;
cmd.Parameters.Add("@CopyNum", SqlDbType.SmallInt).Value = copyNum;
//open connection
cn.Open();
//execute command
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
//check the birth_date field, if its null, then we have an adult.
if (reader.IsDBNull(10))
{
AdultMember member = new AdultMember();
member.MemberID = (Int16)reader["member_no"];
member.LastName = (string)reader["lastname"];
member.FirstName = (string)reader["firstname"];
if (!reader.IsDBNull(3))
{
member.MiddleInitial = (string)reader["middleinitial"];
}
member.Street = (string)reader["street"];
member.City = (string)reader["city"];
member.State = (string)reader["state"];
member.ZipCode = (string)reader["zip"];
if (!reader.IsDBNull(8))
{
member.PhoneNumber = (string)reader["phone_no"];
}
member.ExpirationDate = (DateTime)reader["expr_date"];
return(member);
}
else
{
JuvenileMember member = new JuvenileMember();
member.MemberID = (Int16)reader["member_no"];
member.LastName = (string)reader["lastname"];
member.FirstName = (string)reader["firstname"];
if (!reader.IsDBNull(3))
{
member.MiddleInitial = (string)reader["middleinitial"];
}
member.Street = (string)reader["street"];
member.City = (string)reader["city"];
member.State = (string)reader["state"];
member.ZipCode = (string)reader["zip"];
if (!reader.IsDBNull(8))
{
member.PhoneNumber = (string)reader["phone_no"];
}
member.ExpirationDate = (DateTime)reader["expr_date"];
member.BirthDate = (DateTime)reader["birth_date"];
member.AdultMemberID = (Int16)reader["adult_member_no"];
return(member);
}
}
else
{
throw new LibraryException(ErrorCode.NoSuchMember, "Member not found");
}
}
}
}
catch (SqlException ex)
{
throw new LibraryException(ErrorCode.GenericException, "Error: Contact Technical Support.", ex);
}
}
