/// <summary> /// Returns the localization id for the Flowchart that contains this command. /// </summary> public virtual string GetFlowchartLocalizationId() { // If no localization id has been set then use the Flowchart name IFlowchart flowchart = GetFlowchart(); if (flowchart == null) { return(""); } string localizationId = GetFlowchart().LocalizationId; if (localizationId.Length == 0) { localizationId = flowchart.GetName(); } return(localizationId); }
internal void Delete(IFlowchart flowchart) { string dt = DateTime.Now.ToString("u"); string query = @"DELETE FROM data WHERE owner = '" + login + "' AND reviewer = '" + reviewer + "' AND flowchart_name = '" + flowchart.GetName() + "'"; MySqlConnection connection = initializeDatabaseConnection("localhost", "flowchart", "root", ""); MySqlCommand com = new MySqlCommand(query, connection); try { connection.Open(); MySqlDataReader dr = com.ExecuteReader(); connection.Close(); } catch (Exception e) { connection.Close(); } }
internal void ReviewerAddToDB(IFlowchart flowchart, string comment) { string dt = DateTime.Now.ToString("u"); string querySelect = @"SELECT flowchart_name FROM data WHERE flowchart_name = '" + flowchart.GetName() + "' AND owner = '" + this.owner + "' AND reviewer = ''"; MySqlConnection connection = initializeDatabaseConnection("localhost", "flowchart", "root", ""); MySqlCommand com = new MySqlCommand(querySelect, connection); try { connection.Open(); MySqlDataReader dr = com.ExecuteReader(); string query = ""; if (dr.HasRows) { query = @"INSERT INTO data (owner, flowchart_name, flowchart_data, date, reviewer, comment) VALUES ('" + this.owner + "', '" + flowchart.GetName() + "', '" + flowchart.GetCodeLikeStringList() + "','" + dt + "', '" + this.reviewer + "', '" + comment + "')"; connection.Close(); } com = new MySqlCommand(query, connection); connection.Open(); dr = com.ExecuteReader(); connection.Close(); } catch (Exception e) { connection.Close(); } }
internal void MasterApply(IFlowchart flowchart) { string dt = DateTime.Now.ToString("u"); string query = @"UPDATE data SET flowchart_data = '" + flowchart.GetCodeLikeStringList() + "', date = '" + dt + "', comment = '' WHERE owner = '" + login + "' AND flowchart_name = '" + flowchart.GetName() + "' AND reviewer = ''"; MySqlConnection connection = initializeDatabaseConnection("localhost", "flowchart", "root", ""); MySqlCommand com = new MySqlCommand(query, connection); try { connection.Open(); MySqlDataReader dr = com.ExecuteReader(); connection.Close(); } catch (Exception e) { connection.Close(); } }