public bool DeleteSessions(SessionMember sessionMember)
{
return(_sessionRepository.DeleteSession(new SessionMemberDAO
{
SessionId = sessionMember.SessionId
}));
}
public bool InsertSessions(SessionMember sessionMember)
{
return(_sessionRepository.InsertSession(new SessionMemberDAO
{
FilmId = sessionMember.FilmId,
Date = sessionMember.Date,
Time = sessionMember.Time,
HallId = sessionMember.HallId
}));
}
public ValidationResultString UpdateSessions(SessionMember sessionMember)
{
if (sqlConnect.GetConnect)
{
sqlConnect.OpenConn();
}
ValidationResultString result = new ValidationResultString()
{
IsValid = true
};
try
{
string commPart = " UPDATE maindb.\"Session\" " +
" SET \"FilmId\" = @1, \"Date\" = @2, \"Time\" = @3::time without time zone, \"HallId\" = @4 " +
" WHERE \"SessionId\" = @5;";
NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn);
command.Parameters.AddWithValue("@1", Convert.ToInt32(sessionMember.FilmId));
command.Parameters.AddWithValue("@2", Convert.ToDateTime(sessionMember.Date));
command.Parameters.AddWithValue("@3", sessionMember.Time);
command.Parameters.AddWithValue("@4", Convert.ToInt32(sessionMember.HallId));
command.Parameters.AddWithValue("@5", Convert.ToInt32(sessionMember.SessionId));
NpgsqlDataReader readerTable = command.ExecuteReader();
readerTable.Close();
}
catch (Npgsql.PostgresException exp)
{
return(new ValidationResultString
{
Errors = new List <string> {
exp.SqlState
}
});
}
finally
{
if (!sqlConnect.GetConnect)
{
sqlConnect.CloseConn();
}
}
return(result);
}
public ValidationResultString DeleteSessions(SessionMember sessionMember)
{
if (sqlConnect.GetConnect)
{
sqlConnect.OpenConn();
}
ValidationResultString result = new ValidationResultString()
{
IsValid = true
};
try
{
string commPart = "DELETE FROM maindb.\"Session\" WHERE \"SessionId\"=@1";
NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn);
command.Parameters.AddWithValue("@1", Convert.ToInt32(sessionMember.SessionId));
NpgsqlDataReader readerTable = command.ExecuteReader();
readerTable.Close();
}
catch (Npgsql.PostgresException exp)
{
return(new ValidationResultString
{
Errors = new List <string> {
exp.SqlState
}
});
}
finally
{
if (!sqlConnect.GetConnect)
{
sqlConnect.CloseConn();
}
}
return(result);
}
public bool InsertSession(SessionMember sessionMember)
{
var res = InsertSessions(sessionMember);
return(res.IsValid);
}
public bool UpdateSession(SessionMember sessionMember)
{
var res = UpdateSessions(sessionMember);
return(res.IsValid);
}
public bool DeleteSession(SessionMember sessionMember)
{
var res = DeleteSessions(sessionMember);
return(res.IsValid);
}
