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