public void CreateMember(bandmembersDAO memberToCreate) { try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_CreateBandMembers", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@Name", memberToCreate.MemberName); _command.Parameters.AddWithValue("@Bio", memberToCreate.MemberBio); _command.Parameters.AddWithValue("@DateOfBirth", memberToCreate.DateOfBirth); _command.Parameters.AddWithValue("@BirthLocation", memberToCreate.BirthLocation); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); _connection.Dispose(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } }
public bool DeleteMember(bandmembersDAO memberToDelete) { bool yes = false; try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_DeleteBandMember", _connection)) { _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@BandMembers_ID", memberToDelete.BandMembers_ID); _connection.Open(); _command.ExecuteNonQuery(); yes = true; _connection.Close(); } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } if (yes == true) { } return(yes); }
public List <bandmembersDAO> GetAllMembers() { List <bandmembersDAO> _MemberList = new List <bandmembersDAO>(); try { using (SqlConnection _connection = new SqlConnection(connectionstring)) { using (SqlCommand _command = new SqlCommand("Sp_ViewBandMembers", _connection)) { _command.CommandType = CommandType.StoredProcedure; _connection.Open(); using (SqlDataReader _reader = _command.ExecuteReader()) { while (_reader.Read()) { bandmembersDAO _memberToList = new bandmembersDAO(); _memberToList.BandMembers_ID = _reader.GetInt32(0); _memberToList.MemberName = _reader.GetString(1); _memberToList.MemberBio = _reader.GetString(2); _memberToList.DateOfBirth = _reader.GetDateTime(3); _memberToList.BirthLocation = _reader.GetString(4); _MemberList.Add(_memberToList); } } } } } catch (Exception _Error) { Error_Logger Log = new Error_Logger(); Log.Errorlogger(_Error); } return(_MemberList); }
public ActionResult UpdateMember(BandMembers _MemberInfo) { if ((int)Session["Role_ID"] == 3 || (int)Session["Role_ID"] == 2) { bandmembersDAO _recievedMember = _mapper.SingleMember(_MemberInfo); _BandMemberDataAccess.UpdateMember(_recievedMember); } return(RedirectToAction("BandMemberView")); }
public ActionResult CreateMember(BandMembers newMember) { if ((int)Session["Role_ID"] == 3 || (int)Session["Role_ID"] == 2) { bandmembersDAO MemberToCreate = _mapper.SingleMember(newMember); _BandMemberDataAccess.CreateMember(MemberToCreate); } return(RedirectToAction("BandMemberView")); }
public ActionResult DeleteMember(int Delete_Member) { if ((int)Session["Role_ID"] == 3) { bandmembersDAO _DeleteMember = new bandmembersDAO(); _DeleteMember.BandMembers_ID = Delete_Member; _BandMemberDataAccess.DeleteMember(_DeleteMember); } return(RedirectToAction("BandMemberView")); }
public BandMembers SelectMember(bandmembersDAO _SelectMemberToMap) { BandMembers MemberToReturn = new BandMembers(); { BandMembers _memberToView = new BandMembers(); _memberToView.BandMembers_ID = _SelectMemberToMap.BandMembers_ID; _memberToView.MemberName = _SelectMemberToMap.MemberName; _memberToView.MemberBio = _SelectMemberToMap.MemberBio; _memberToView.DateOfBirth = _SelectMemberToMap.DateOfBirth; _memberToView.BirthLocation = _SelectMemberToMap.BirthLocation; MemberToReturn = _memberToView; } return(MemberToReturn); }
public bandmembersDAO SingleMember(BandMembers _SingleMemberToMap) { bandmembersDAO MemberToReturn = new bandmembersDAO(); { bandmembersDAO _memberToView = new bandmembersDAO(); _memberToView.BandMembers_ID = _SingleMemberToMap.BandMembers_ID; _memberToView.MemberName = _SingleMemberToMap.MemberName; _memberToView.MemberBio = _SingleMemberToMap.MemberBio; _memberToView.DateOfBirth = _SingleMemberToMap.DateOfBirth; _memberToView.BirthLocation = _SingleMemberToMap.BirthLocation; MemberToReturn = _memberToView; } return(MemberToReturn); }