public PostReportRemarks CreateReport(PostReport report) { var objReturn = new PostReportRemarks(); var reportNo = "R" + RandomizeHelper.GenerateRandomString(7); var draft = GetDraftReport(report.reported_by_email); if (draft.report_no != null) { reportNo = draft.report_no; objReturn = new PostReportRemarks { report_no = reportNo, remarks = "You have a pending report!", subject = "Report" }; } else { using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection())) { con.Open(); var cmd = new MySqlCommand("INSERT INTO reportit_report (report_no, user, ip, reported_by, reported_by_email, reported_by_phone, reported_on, status) VALUES(@report_no, @user, @ip, @reported_by, @reported_by_email, @reported_by_phone, @reported_on, @status)", con); cmd.Parameters.AddWithValue("@report_no", reportNo); cmd.Parameters.AddWithValue("@user", report.reported_by_email); cmd.Parameters.AddWithValue("@ip", "EEC Mobility"); cmd.Parameters.AddWithValue("@reported_by", report.reported_by); cmd.Parameters.AddWithValue("@reported_by_email", report.reported_by_email); cmd.Parameters.AddWithValue("@reported_by_phone", report.reported_by_phone); cmd.Parameters.AddWithValue("@reported_on", DateTime.Now); cmd.Parameters.AddWithValue("@status", "Draft"); if (cmd.ExecuteNonQuery() > 0) { objReturn = new PostReportRemarks { report_no = reportNo, remarks = "Successfully created new report!", subject = "Report" }; } else { objReturn = new PostReportRemarks { remarks = "Error on creation of new report!", subject = "Error" }; } } } return(objReturn); }
public PostReport GetDraftReport(string user) { var objReturn = new PostReport(); using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection())) { con.Open(); var cmd = new MySqlCommand("SELECT report_no FROM reportit_report WHERE (user=@user OR reported_by_email=@user) AND status='Draft' LIMIT 1", con); cmd.Parameters.AddWithValue("@user", user); var dr = cmd.ExecuteReader(); while (dr.Read()) { objReturn = new PostReport { report_no = dr["report_no"].ToString(), }; } } return(objReturn); }