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
{
}
}
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();
}
}
public void updateReportAbuseIssue(issuesBO issuesBO)
{
try
{
ob.updateReportAbuseIssue(issuesBO);
}
catch
{
}
finally
{
}
}
