protected void btnSubmitIssue_Click(object sender, EventArgs e)
{
//Create a new Issue object and assign necessary values
Issue issue = new Issue();
issue.SubmittedBy = ddlNewName.SelectedItem.Text;
issue.Title = txtBoxNewTitle.Text;
issue.Type = ddlNewType.SelectedItem.Text;
issue.Description = txtBoxNewDescription.Text;
issue.DateCreated = DateTime.Now;
issue.Status = "Pending Review";
//save issue
string message = Issue.saveIssue(issue);
if (message == "Issue created successfully")
{
gvCurretIssues.DataBind();
ddlNewName.Text = "Please Select";
txtBoxNewTitle.Text = "";
ddlNewType.Text = "Please Select";
txtBoxNewDescription.Text = "";
panelSubmitNew.Visible = false;
btnCreateNewIssue.Visible = true;
}
else
{
lblSaveIssueMessage.Text = message;
lblSaveIssueMessage.Visible = true;
}
}
public static Issue getIssue(int issueID)
{
SqlConnection dbConn;
SqlCommand dbCmd;
SqlDataReader dbReader;
string sConnection;
string sql;
sConnection = GlobalVars.ConnectionString;
dbConn = new SqlConnection(sConnection);
dbConn.Open();
sql = "SELECT datecreated, description, status, dateclosed, submittedby, type, reply,title FROM Issues "+
"WHERE id = @id";
dbCmd = new SqlCommand();
dbCmd.CommandText = sql;
dbCmd.Parameters.AddWithValue("@id", issueID);
dbCmd.Connection = dbConn;
dbReader = dbCmd.ExecuteReader();
Issue issue = new Issue();
while (dbReader.Read())
{
issue.DateCreated = Convert.ToDateTime(dbReader["datecreated"]);
issue.Description = dbReader["description"].ToString();
issue.Status = dbReader["status"].ToString();
if (dbReader["dateclosed"] == DBNull.Value)
{
issue.DateClosed = null;
}
else
{
issue.DateClosed = Convert.ToDateTime(dbReader["dateclosed"]);
}
issue.SubmittedBy = dbReader["submittedby"].ToString();
issue.Type = dbReader["dateclosed"].ToString();
issue.Reply = dbReader["reply"].ToString();
issue.Title = dbReader["title"].ToString();
}
dbReader.Close();
dbCmd.Parameters.Clear();
return issue;
}
public static string saveIssue(Issue issue)
{
SqlConnection dbConn;
string sConnection;
SqlCommand dbCmd;
SqlTransaction transaction;
StringBuilder message = new StringBuilder();
sConnection = GlobalVars.ConnectionString;
dbConn = new SqlConnection(sConnection);
dbConn.Open();
dbCmd = dbConn.CreateCommand();
transaction = dbConn.BeginTransaction("Transaction");
dbCmd.Transaction = transaction;
try
{
//Insert into Issues table
string sqlCommand = "INSERT INTO Issues (datecreated, description, status, submittedby, type, title) " +
"VALUES (@datecreated, @description, @status, @submittedby, @type, @title)";
dbCmd.CommandText = sqlCommand;
dbCmd.Parameters.AddWithValue("datecreated", issue.DateCreated);
dbCmd.Parameters.AddWithValue("description", issue.Description);
dbCmd.Parameters.AddWithValue("status", issue.Status);
dbCmd.Parameters.AddWithValue("submittedby", issue.SubmittedBy);
dbCmd.Parameters.AddWithValue("type", issue.Type);
dbCmd.Parameters.AddWithValue("title", issue.Title);
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
transaction.Commit();
dbConn.Close();
message.Append("Issue created successfully");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
message.Append(ex.ToString());
transaction.Rollback();
}
return message.ToString();
}
protected void btnUpdateIssue_Click(object sender, EventArgs e)
{
//get values from popup
Issue issue = new Issue();
issue.Title = txtBoxTitle.Text;
issue.Type = ddlType.Text;
issue.SubmittedBy = ddlSubmittedBy.Text;
issue.Status = ddlStatus.Text;
issue.DateCreated = Convert.ToDateTime(txtBoxDateCreated.Text);
if (txtBoxDateClosed.Text == "")
{
issue.DateClosed = null;
}
else
{
issue.DateClosed = Convert.ToDateTime(txtBoxDateClosed.Text);
}
issue.Description = txtBoxDescription.Text;
issue.Reply = txtBoxReply.Text;
issue.ID = Convert.ToInt32(hfID.Value);
//update issue
Issue.updateIssue(issue);
//refresh both gridviews
gvCurretIssues.DataBind();
gvPastIssues.DataBind();
//clear out any old data in modal popup
txtBoxTitle.Text = "";
txtBoxDateCreated.Text = "";
txtBoxDateClosed.Text = "";
txtBoxDescription.Text = "";
txtBoxReply.Text = "";
}
protected void lnkBtnSelect_Click1(object sender, EventArgs e)
{
//clear out any old data in modal popup
txtBoxTitle.Text = "";
txtBoxDateCreated.Text = "";
txtBoxDateClosed.Text = "";
txtBoxDescription.Text = "";
txtBoxReply.Text = "";
//get primary key from datagrid to get issue from DB
LinkButton lnkButton = (LinkButton)sender;
gvPastIssues.SelectedIndex = Convert.ToInt32(lnkButton.CommandArgument);
int issueID = Convert.ToInt32(gvPastIssues.SelectedDataKey.Value);
Issue issue = new Issue();
issue = Issue.getIssue(issueID);
//populate modial popup
txtBoxTitle.Text = issue.Title;
ddlType.Text = issue.Type;
ddlSubmittedBy.Text = issue.SubmittedBy;
ddlStatus.Text = issue.Status;
txtBoxDateCreated.Text = issue.DateCreated.ToShortDateString();
if (issue.DateClosed != null)
{
txtBoxDateClosed.Text = Convert.ToDateTime(issue.DateClosed).ToShortDateString();
}
txtBoxDescription.Text = issue.Description;
txtBoxReply.Text = issue.Reply;
hfID.Value = issueID.ToString();
btnPopUp_ModalPopUpExtender.Show();
}
public static Issue updateIssue(Issue issue)
{
SqlConnection dbConn;
SqlCommand dbCmd;
string sConnection;
string sql;
try
{
sConnection = GlobalVars.ConnectionString;
dbConn = new SqlConnection(sConnection);
dbConn.Open();
sql = "UPDATE Issues SET datecreated = @datecreated, description = @description, status = @status, dateclosed = @dateclosed, submittedby = @submittedby" +
", type = @type, reply = @reply, title = @title WHERE id = @id";
dbCmd = new SqlCommand();
dbCmd.CommandText = sql;
dbCmd.Parameters.AddWithValue("id", issue.ID);
dbCmd.Parameters.AddWithValue("datecreated", issue.DateCreated);
dbCmd.Parameters.AddWithValue("description", issue.Description);
dbCmd.Parameters.AddWithValue("status", issue.Status);
if (issue.DateClosed == null)
{
dbCmd.Parameters.AddWithValue("dateclosed", DBNull.Value);
}
else
{
dbCmd.Parameters.AddWithValue("dateclosed", issue.DateClosed);
}
dbCmd.Parameters.AddWithValue("submittedby", issue.SubmittedBy);
dbCmd.Parameters.AddWithValue("type", issue.Type);
dbCmd.Parameters.AddWithValue("reply", issue.Reply);
dbCmd.Parameters.AddWithValue("title", issue.Title);
dbCmd.Connection = dbConn;
dbCmd.ExecuteNonQuery();
dbCmd.Parameters.Clear();
dbConn.Close();
return issue;
}
catch (Exception ex)
{
ex.ToString();
return null;
}
}
public static Issue updateIssue(Issue issue)
{
return IssueDA.updateIssue(issue);
}
public static string saveIssue(Issue issue)
{
return IssueDA.saveIssue(issue);
}