public static OperationResult.opResult addUser(string name, string username, string password, User.userRole role)
{
string passwordEncod = getMd5Hash(password);
OperationResult.opResult result = UserDAL.addUser(name, username, passwordEncod, role);
return(result);
}
private void signInBtn_click(object sender, EventArgs e)
{
string username = this.username.Text;
string password = this.password.Text;
OperationResult.opResult result = UserBL.login(username, password);
switch (result)
{
case OperationResult.opResult.OperationLoginUser:
{
UserForm user = new UserForm();
this.Hide();
user.Show();
}
break;
case OperationResult.opResult.OperationLoginAdmin:
{
List <User> users = UserBL.getAllUsers();
AdminForm admin = new AdminForm(users);
this.Hide();
admin.Show();
}
break;
case OperationResult.opResult.OperationLoginFail:
default:
{
MessageBox.Show("Wrong username or/and password");
}
break;
}
}
public static OperationResult.opResult login(string username, string password)
{
OperationResult.opResult result = OperationResult.opResult.OperationLoginFail;
User user = UserDAL.getUser(username);
string passwordEncod = getMd5Hash(password);
if (user != null && user.Password.Equals(passwordEncod))
{
result = OperationResult.opResult.OperationLoginUser;
if (user.UserRole == User.userRole.Administrator)
{
result = OperationResult.opResult.OperationLoginAdmin;
}
}
return(result);
}
private void handleFinishEdit(object sender, System.Collections.Specialized.OrderedDictionary e)
{
if (sender.Equals(this.addTicket))
{
string code = e[Constants.codeField].ToString();
string spectacol = e[Constants.spectacolField].ToString();
int nrOfTickets = SpectacleBL.getNrOfTicketsForSpectacle(spectacol);
if (nrOfTickets == 0)
{
MessageBox.Show("Cannot add more tickets");
return;
}
else if (nrOfTickets == -1)
{
MessageBox.Show("Bad request,please check fields");
return;
}
int rand = int.Parse(e[Constants.randField].ToString());
int numar = int.Parse(e[Constants.numarField].ToString());
OperationResult.opResult result = TicketBL.addTicketForSpectacle(code, spectacol, rand, numar);
if (result == OperationResult.opResult.OperationInsertTicketDuplicate ||
result == OperationResult.opResult.OperationAddTicketFail)
{
MessageBox.Show("Cannot add ticket for this place");
return;
}
else
{
MessageBox.Show("Succes");
}
}
else if (sender.Equals(this.export))
{
ExporterType type = (ExporterType)int.Parse(e["Export Type"].ToString());
Exporter exporter = ExportFactory.getExporter(type);
string spectacol = e[Constants.spectacolField].ToString();
Array tickets = TicketBL.getAllTicketsForSpectacle(spectacol).ToArray();
string path = e["File Path"].ToString();
exporter.exportTickets(tickets.OfType <Ticket>().ToList(), path);
}
}
public static OperationResult.opResult deleteSpectacle(string spectacol)
{
string delSpectacle = "DELETE FROM Spectacles WHERE Titlu ='" + spectacol + "'";
OperationResult.opResult delTicketsResult = TicketDAL.deleteTicketsForSpectacle(spectacol);
using (SqlConnection con = new SqlConnection(Constants.connectionString))
{
try
{
con.Open();
SqlCommand com = new SqlCommand(delSpectacle, con);
com.ExecuteNonQuery();
}
catch (SqlException ex)
{
return(OperationResult.opResult.OperationDeleteSpectacleFail);
}
}
return(delTicketsResult);
}
public static OperationResult.opResult addTicketForSpectacle(string code, string spectacol, int rand, int numar)
{
OperationResult.opResult result = TicketDAL.addTicketForSpectacle(code, spectacol, rand, numar);
return(result);
}
// This method is callback method like, where the data received after editing is processed.
private void handleFinishEdit(object sender, System.Collections.Specialized.OrderedDictionary e)
{
if (sender.Equals(this.addNewEmployee))
{
string name = e[Constants.nameField].ToString();
string username = e[Constants.usernameField].ToString();
string password = e[Constants.passwordField].ToString();
User.userRole role;
try
{
role = (User.userRole) int.Parse(e[Constants.userRoleField].ToString());
}
catch (FormatException)
{
MessageBox.Show("Bad request,please check fields");
return;
}
if (name.Length == 0 || username.Length == 0 || password.Length == 0 || role > User.userRole.User)
{
MessageBox.Show("Bad request,please check fields");
return;
}
OperationResult.opResult result = UserBL.addUser(name, username, password, role);
if (result == OperationResult.opResult.OperationAddUserSucces)
{
MessageBox.Show("Succes");
}
else
{
MessageBox.Show("Cannot add user");
}
}
else if (sender.Equals(this.addNewSpectacle))
{
string titlu = e[Constants.titluField].ToString();
string regia = e[Constants.regiaField].ToString();
string distributia = e[Constants.distributiaField].ToString();
DateTime premiera;
int nrOfTickets;
try
{
premiera = DateTime.Parse(e[Constants.premieraField].ToString());
nrOfTickets = int.Parse(e[Constants.nrOfTicketsField].ToString());
}
catch (FormatException)
{
MessageBox.Show("Bad request,please check fields");
return;
}
if (titlu.Length == 0 || regia.Length == 0 || distributia.Length == 0)
{
MessageBox.Show("Bad request,please check fields");
return;
}
OperationResult.opResult result = SpectacleBL.addSpectacle(premiera, titlu, regia, distributia, nrOfTickets);
if (result == OperationResult.opResult.OperationAddSpectacleSucces)
{
MessageBox.Show("Succes");
}
else
{
MessageBox.Show("Cannot add spectacle");
}
}
else if (sender.Equals(this.deleteSpectacle))
{
string titlu = e[Constants.titluField].ToString();
if (titlu.Length == 0)
{
MessageBox.Show("Bad request,please check fields");
return;
}
OperationResult.opResult result = SpectacleBL.deleteSpectacle(titlu);
if (result == OperationResult.opResult.OperationDeleteSpectacleSucces)
{
MessageBox.Show("Succes");
}
else
{
MessageBox.Show("Cannot delete spectacle");
}
}
else if (sender.Equals(this.updateSpectacle))
{
string titlu = e[Constants.titluField].ToString();
string regia = e[Constants.regiaField].ToString();
string distributia = e[Constants.distributiaField].ToString();
DateTime premiera;
int nrOfTickets;
try
{
premiera = DateTime.Parse(e[Constants.premieraField].ToString());
nrOfTickets = int.Parse(e[Constants.nrOfTicketsField].ToString());
}
catch (FormatException)
{
MessageBox.Show("Bad request,please check fields");
return;
}
if (titlu.Length == 0 || regia.Length == 0 || distributia.Length == 0)
{
MessageBox.Show("Bad request,please check fields");
return;
}
OperationResult.opResult result = SpectacleBL.updateSpectacle(premiera, titlu, regia, distributia, nrOfTickets);
if (result == OperationResult.opResult.OperationUpdateSpectacleSucces)
{
MessageBox.Show("Succes");
}
else
{
MessageBox.Show("Cannot update data");
}
}
}
public static OperationResult.opResult deleteSpectacle(string spectacol)
{
OperationResult.opResult result = SpectacleDAL.deleteSpectacle(spectacol);
return(result);
}
public static OperationResult.opResult addSpectacle(DateTime premiera, string titlu, string regia, string distributia, int maxNrOfTickets)
{
OperationResult.opResult result = SpectacleDAL.addSpectacle(premiera, titlu, regia, distributia, maxNrOfTickets);
return(result);
}
