//End variables
//Constructor
public frmShowController(MetroForm form, MetroGrid grid)
{
this.form = form;
this.grid = grid;
//Instantiate database.
database = new Database(form);
}
//Validates the column of a certain grid with a field size of 30.
//Checks to see if it is empty
//Checks its length
public bool validateEdit30(MetroGrid grid, int column)
{
string value;
bool validateValue = false;
//Loop through each row in the list.
for (int i = 0; i < grid.Rows.Count; i++)
{
value = Convert.ToString(grid.Rows[i].Cells[column].Value);//Get value of cell[i, column]
//Value cannot be empty.
if (value != "")
{
//Value cannot exceed over 30.
if (value.Length > 30)
{
//Value's length is greater than 30.
return false;
}
//Value is less than 30.
else
{
validateValue = true;
}
}
//Value is empty
else
{
return false;
}
}
return validateValue;
}
private void TreeView1_AfterSelect_1(object sender, TreeViewEventArgs e)
{
Padding pading = new Padding();
pading.Top = 30;
// MetroFramework.Controls.MetroTabControl a
string filename = filenameTxt.Text;
NodeName.Text = e.Node.Text;
tabGridview = new MetroFramework.Controls.MetroGrid();
tabGridview.Name = "tabGridView";
tabGridview.Dock = DockStyle.Fill;
tabGridview.GridColor = Color.BurlyWood;
GrdtabPage = new MetroTabPage();
GrdtabPage.Text = e.Node.Text;
GrdtabPage.Padding = pading;
GrdtabPage.Controls.Add(tabGridview);
metroTabControl2.Style = MetroColorStyle.Blue;
metroTabControl2.SelectedTab = GrdtabPage;
metroTabControl2.Controls.Add(GrdtabPage);
System.Data.DataTable GrdData = Reader.GetGridData(e.Node.Text);
tabGridview.DataSource = GrdData;
tabGridview.EditMode = DataGridViewEditMode.EditProgrammatically;
}
public frmShowController(MetroForm form, MetroGrid grid, int reservationID)
{
this.form = form;
this.grid = grid;
this.reservationID = reservationID;
database = new Database(form); //Instantiate database.
}
//Changes the font size of grids.
public void changeFont(MetroGrid grid)
{
//Changes grid's column's header's font size to 10.
grid.ColumnHeadersDefaultCellStyle.Font = new Font("", 10.0f);
//Changes grid's data's font size to 8.
grid.Font = new Font("", 8.0f);
}
//End variables
//Constructor
public frmReservationController(MetroGrid grid, MetroForm form)
{
this.grid = grid;
this.form = form;
//Instantiate database
database = new Database(form);
}
//End variables
//Constructor
public frmEmployeeController(MetroForm form, MetroGrid grid)
{
this.form = form;
this.grid = grid;
//Start instantiation
database = new Database(this.form);
encryptionController = new frmEncryptionController();
//End instantiation
}
public static void temizle(MetroGrid grid)
{
foreach (DataGridViewCell oneCell in grid.SelectedCells)
{
if (oneCell.Selected)
{
grid.Rows.RemoveAt(oneCell.RowIndex);
}
}
}
public frmTicketController(MetroForm form, MetroGrid grid, int reservationID)
{
this.form = form;
this.grid = grid;
//Start instantiation
ticket = new Ticket();
database = new Database(form);
//End instantiation
ticket.getSetReservationID = reservationID;
}
//End variables
//Constructor
public frmTicketController(MetroForm form, List<int> seatID, int showID, int customerID, MetroGrid grid)
{
this.showID = showID;
this.seatID = seatID;
this.form = form;
this.grid = grid;
this.customerID = customerID;
//Start instantiations
reservationController = new frmReservationController(form, customerID, seatID, showID);
reservation = new Reservation(customerID, DateTime.Now.Date);
database = new Database(form);
ticket = new Ticket();
//End instantiations
}
private void CmdNew_Click(object sender, EventArgs e)
{
if (filenameTxt.Text != "")
{
filenameTxt.Text = "";
NodeName.Text = "";
tabGridview = new MetroGrid();
tabGridview.Name = "tabGridView";
tabGridview.Dock = DockStyle.Fill;
treeView1.Nodes.Clear();
treeView2.Nodes.Clear();
GrdtabPage.Text = "";
GrdtabPage.Controls.Clear();
metroTabControl2.Controls.Clear();
tabGridview.DataSource = null;
}
}
//Validates the column of a certain grid with a field size of 11.
//Checks to see if it is empty
//Checks its length - it has to be 11.
//Checks if it is a number
public bool validateEdit11(MetroGrid grid, int column)
{
string value;
bool validateValue = false;
//Loop through each row in the grid.
for (int i = 0; i < grid.Rows.Count; i++)
{
value = Convert.ToString(grid.Rows[i].Cells[column].Value); //Get value of cell[i, column]
//Value cannot be empty.
if (value != "")
{
//Value needs to be 11
if (value.Length != 11)
{
//Value's length is not 11.
return false;
}
//Value's length is 11
else
{
//Checks to see if it is a number
try
{
Int64.Parse(value);
validateValue = true;
}
//Value is not a number
catch
{
return false;
}
}
}
//Value is empty.
else
{
return false;
}
}
return validateValue;
}
/// <summary>
/// saves the changes of a grid to database
/// </summary>
/// <param name="grid"></param>
public void SaveGridChangesToDatabase(ref MetroFramework.Controls.MetroGrid grid)
{
CustomSqlConnection con = new CustomSqlConnection();
if (con.ConnectError())
{
return;
}
DataTable changes = table.GetChanges();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand($"SELECT * FROM t_s_faecher", con.Con);
SqlCommand insertCmd = new SqlCommand($"INSERT INTO t_s_faecher (f_kurzform, f_langform) VALUES (@subjectNameShort, @subjectNameLong)", con.Con);
insertCmd.Parameters.Add("@subjectNameShort", SqlDbType.NVarChar, 64, "Kürzel");
insertCmd.Parameters.Add("@subjectNameLong", SqlDbType.NVarChar, 256, "Langbezeichnung");
adapter.InsertCommand = insertCmd;
SqlCommand deleteCmd = new SqlCommand($"DELETE FROM t_s_faecher WHERE f_kurzform = @subjectNameShort", con.Con);
deleteCmd.Parameters.Add("@subjectNameShort", SqlDbType.NVarChar, 64, "Kürzel");
adapter.DeleteCommand = deleteCmd;
SqlCommand updateCmd = new SqlCommand($"UPDATE t_s_faecher SET f_kurzform = @subjectNameShort, f_langform = @subjectNameLong WHERE f_id = @subjectId", con.Con);
updateCmd.Parameters.Add("@subjectNameShort", SqlDbType.NVarChar, 64, "Kürzel");
updateCmd.Parameters.Add("@subjectNameLong", SqlDbType.NVarChar, 256, "Langbezeichnung");
updateCmd.Parameters.Add("@subjectId", SqlDbType.Int, 32, "ID");
adapter.UpdateCommand = updateCmd;
if (changes != null)
{
changes = noDuplicates(changes);
adapter.Update(changes);
}
}
//Fills the grid with data using the SQL statement.
public void updateGrid(string DDL, MetroGrid grid)
{
//Start instantiation
OleDbDataAdapter DA = new OleDbDataAdapter(DDL, getSetCon());
DataTable DT = new DataTable();
//End instantiation
try
{
getSetCon().Open(); //Opens connection
DA.Fill(DT);
}
catch (Exception ex)
{
MetroMessageBox.Show(form, "Unsuccessful \n" + ex.Message);
}
grid.DataSource = DT; //Sets the data source.
DA.Update(DT); //Updates the data adpapter.
con.Close(); //Closes con.
}
public void EnableSorting(MetroGrid grid)
{
foreach (DataGridViewColumn column in grid.Columns)
{
column.SortMode = DataGridViewColumnSortMode.Automatic;
}
}
public void UpdateLastRow2Grid(MetroGrid grid,int index=-1)
{
if(index == -1)
index = grid.Rows.Add();
if(commands[commands.Count - 1].GetType() == typeof(Command_WD))
{
Command_WD c = (Command_WD)commands[commands.Count - 1];
grid.Rows[index].Cells[0].ToolTipText = c.id.ToString();
grid.Rows[index].Cells[1].Value = c.TextCommand;
grid.Rows[index].Cells[2].Value = c.target_command_list[c.selectedTargetIndex].Target;
grid.Rows[index].Cells[3].Value = c.Value;
}
else if (commands[commands.Count - 1].GetType() == typeof(Command_SK))
{
Command_SK c = (Command_SK)commands[commands.Count - 1];
grid.Rows[index].Cells[0].ToolTipText = c.id;
grid.Rows[index].Cells[1].Value = c.TextCommand;
grid.Rows[index].Cells[4].Value = c.pattern.img;
}
}
//Checks to see if they are entering a duplicate username
public bool distinctUsername(MetroGrid grid)
{
List<string> usernames = new List<string>(); //Create new list
//Loop through each row in the grid.
for (int i = 0; i < grid.Rows.Count; i++)
{
//Adds all usernames to the list
usernames.Add(Convert.ToString(grid.Rows[i].Cells[3].Value)); //Both customer and employee the usernames are in column "3"
}
//Creates a copy of the list with only distinct values
if (usernames.Count != usernames.Distinct().Count()) //Checks to see if they both have the same amount of items.
{
return false;
}
//Unique username
else
{
return true;
}
}
//End variable
//Constructor
public frmDatePickerController(MetroGrid grid)
{
this.grid = grid;
}
public void SaveAsCSV(MetroGrid grid, string filelocation)
{
if (grid.RowCount != 0)
{
string value = "";
DataGridViewRow dr = new DataGridViewRow();
using (StreamWriter sw = new StreamWriter(File.Open(filelocation, FileMode.OpenOrCreate)))
{
for (var i = 0; i < grid.Columns.Count; i++)
{
if (i > 0)
{
sw.Write(",");
}
sw.Write(grid.Columns[i].HeaderText);
}
sw.WriteLine();
for (var r = 0; r < grid.RowCount - 1; r++)
{
if (r > 0)
{
sw.WriteLine();
}
dr = grid.Rows[r];
for (var p = 0; p < grid.Columns.Count; p++)
{
value = dr.Cells[p].Value.ToString();
value = value + ",";
sw.Write(value);
}
}
sw.Close();
}
}
}
//Validates the column of a certain grid with a field size of 40.
//Checks to see if it is empty
//Checks its length
//Checks to see if it has "@"
public bool validateEdit40(MetroGrid grid, int column)
{
string value;
bool validateValue = false;
//Loop through each row in the grid.
for (int i = 0; i < grid.Rows.Count; i++)
{
value = Convert.ToString(grid.Rows[i].Cells[column].Value);//Get value of cell[i, column]
//Value cannot be empty.
if (value != "")
{
//Value cannot exceed over 40.
if (value.Length > 40)
{
//Value is greater than 40.
return false;
}
//Value does no exceed 40 characters.
else
{
try
{
//Checks to see if the value has correct email format.
var address = new MailAddress(value).Address;
validateValue = true;
}
//address is invalid
catch (FormatException)
{
return false;
}
}
}
//Value is empty
else
{
return false;
}
}
return validateValue;
}
//End variables
//Constructor
public frmMovieController(MetroForm form, MetroGrid grid)
{
this.form = form;
this.grid = grid;
database = new Database(this.form); //Instantiate database
}
//Display show details.
public void displayShowDetails(MetroGrid grid)
{
//Get all show details.
string DDL = "Select * from show where show_ID = " + getShowID(Convert.ToDateTime(comboBox.SelectedItem));
OleDbCommand command = new OleDbCommand(DDL, database.getSetCon());
database.updateGrid(DDL, grid); //Display information in the grid.
}
/// <summary>
/// fills a datagridview with the subject data
/// </summary>
/// <param name="grid">the refering gridview</param>
/// <param name="value"></param>
public void FillGrid(ref MetroFramework.Controls.MetroGrid grid, object value = null)
{
table = FillObject();
grid.DataSource = table;
grid.Columns["ID"].Visible = false;
}
//Display show information in the grid.
public void displayShow(MetroGrid grid)
{
//SQL Statement getting all values from show using show ID.
string DDL = "select * from show where show_id = " + showID;
database.updateGrid(DDL, grid); //Displays show information in the grid.
}
//Displays reservation details.
public void displayReservation(MetroGrid grid)
{
//Gets all information from the reservation table depending on the reservation ID.
string DDL = "Select * from reservation where reservation_id = " + reservationID;
database.updateGrid(DDL, grid); //Adds information in the grid.
}
