public static void UpdateIssue(IConfigurationRoot configuration, IssueRuleType Issue, MySqlConnection myConnection, DateTime UpdateTime) { try { ConnectionState State = myConnection.State; if (State == ConnectionState.Closed) { myConnection.Open(); } string query = "UPDATE issue SET Resolved=@Resolved, UpdateDate=@UpdateDate WHERE IssueID = @IssueID and Type=@Type "; MySqlCommand myCommand = new MySqlCommand(query, myConnection); myCommand.Parameters.AddWithValue("@Resolved", "True"); myCommand.Parameters.AddWithValue("@UpdateDate", UpdateTime); myCommand.Parameters.AddWithValue("@IssueID", Issue.IssueRule); myCommand.Parameters.AddWithValue("@Type", Issue.IssueType); object result = myCommand.ExecuteScalar(); } catch (Exception e) { string error = "Exception Occre while updating table:" + e.Message + "\t" + e.GetType(); } }
public static List <IssueRuleType> GetServiceIssues(IConfigurationRoot configuration, int ServiceID, MySqlConnection myConnection) { try { List <IssueRuleType> Issues = new List <IssueRuleType>(); DbDataReader myReader; ConnectionState State = myConnection.State; if (State == ConnectionState.Closed) { myConnection.Open(); } string query = "SELECT IssueID, Type from issue WHERE ServiceID =@ServiceID"; MySqlCommand myCommand = new MySqlCommand(query, myConnection); myCommand.Parameters.AddWithValue("@ServiceID", ServiceID); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { IssueRuleType IssueRuleType = new IssueRuleType(); IssueRuleType.IssueRule = myReader.GetString(0); IssueRuleType.IssueType = myReader.GetString(1); Issues.Add(IssueRuleType); } myReader.Dispose(); return(Issues); } catch (Exception e) { string error = "Exception Occre while selecting from table:" + e.Message + "\t" + e.GetType(); List <IssueRuleType> vide = new List <IssueRuleType>(); return(vide); } }