protected void BTNissuePost_Click(object sender, EventArgs e) { issuesBO issuebo = new issuesBO(); String fileName; try { if (TXTissue.Text != "") { if (FileUploadIssue.HasFile) { fileName = Server.MapPath("~/image/") + FileUploadIssue.FileName; FileUploadIssue.SaveAs(fileName); } issuebo.guid = int.Parse(Session["guid"].ToString()); /** from session **/ issuebo.mpId = mpidval; issuebo.issueText = TXTissue.Text; TXTissue.Text = ""; issuesbal.postIssue(issuebo); //loadlist(50,1,mpidval); } } catch { throw; } finally { } }
protected void BTNissuePost_Click(object sender, EventArgs e) { issuesBO issuebo = new issuesBO(); String fileName; try { if (TXTissue.Text != "") { if (FileUploadIssue.HasFile) { fileName = Server.MapPath("~/image/") + FileUploadIssue.FileName; FileUploadIssue.SaveAs(fileName); } issuebo.guid = int.Parse(Session["guid"].ToString()); /** from session **/ issuebo.mpId = mpidval; issuebo.issueText = TXTissue.Text; issuebo.issuetype = Convert.ToInt64(dropDownIssueFilter.SelectedValue); TXTissue.Text = ""; issuesbal.postIssue(issuebo); loadlist(); } } catch { throw; } finally { } }
public void postIssues(issuesBO issuesbo) { try { query = "ISSUES_INSERTED"; if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new SqlCommand(query,con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mpId",issuesbo.mpId); cmd.Parameters.AddWithValue("@guId",issuesbo.guid); cmd.Parameters.AddWithValue("@issueText",issuesbo.issueText); cmd.Parameters.AddWithValue("@PostedOn",DateTime.Now); cmd.ExecuteNonQuery(); } catch { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); } }
public DataTable getGuidIssues(issuesBO IssuesBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "getGuidIssues"; dap = new SqlDataAdapter(query, con); dap.SelectCommand.Parameters.AddWithValue("@issueId", IssuesBO.issueId); dap.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); dap.Fill(ds, "getGuidIssues"); dap.Dispose(); return ds.Tables["getGuidIssues"]; } catch { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); } }
public void updateReportAbuseIssue(issuesBO issuesBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "updateIssueReportedAsAbuse"; cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@guid", issuesBO.guid); cmd.Parameters.AddWithValue("@issueId", issuesBO.issueId); cmd.Parameters.AddWithValue("@enable", issuesBO.enable); cmd.Parameters.AddWithValue("@reportabuse", issuesBO.reportAbuseIssue); cmd.ExecuteNonQuery(); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public DataTable getGuidIssues(issuesBO IssuesBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "getGuidIssues"; dap = new SqlDataAdapter(query, con); dap.SelectCommand.Parameters.AddWithValue("@issueId", IssuesBO.issueId); dap.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); dap.Fill(ds, "getGuidIssues"); dap.Dispose(); return(ds.Tables["getGuidIssues"]); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public void postIssues(issuesBO issuesbo) { try { query = "ISSUES_INSERTED"; if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mpId", issuesbo.mpId); cmd.Parameters.AddWithValue("@guId", issuesbo.guid); cmd.Parameters.AddWithValue("@issueText", issuesbo.issueText); cmd.Parameters.AddWithValue("@PostedOn", DateTime.Now); cmd.Parameters.AddWithValue("@issuetype", issuesbo.issuetype); cmd.ExecuteNonQuery(); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public void updateReportAbuseIssue(issuesBO issuesBO) { try { ob.updateReportAbuseIssue(issuesBO); } catch { } finally { } }
private string postIssue(Int64 mpId, Int64 guId, string issue) { if (issue != " ") { issuesBO issuebo = new issuesBO(); issuebo.mpId = mpId; issuebo.guid = guId; issuebo.issueText = issue; issuesbal.postIssue(issuebo); return("issue posted"); } return("eRRoR"); }
public void postIssue(issuesBO issuesbo) { try { ob.postIssues(issuesbo); } catch { throw; } finally { } }
private string postIssue(Int64 mpId ,Int64 guId , string issue) { if (issue != " ") { issuesBO issuebo = new issuesBO(); issuebo.mpId = mpId; issuebo.guid = guId; issuebo.issueText = issue; issuesbal.postIssue(issuebo); return "issue posted"; } return "eRRoR"; }
public void updateReportAbuseIssue(issuesBO issuesBO) { try { if (con.State == ConnectionState.Closed) { con.Open(); } query = "updateIssueReportedAsAbuse"; cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@guid", issuesBO.guid); cmd.Parameters.AddWithValue("@issueId", issuesBO.issueId); cmd.Parameters.AddWithValue("@enable", issuesBO.enable); cmd.Parameters.AddWithValue("@reportabuse", issuesBO.reportAbuseIssue); cmd.ExecuteNonQuery(); } catch { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); } }