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 PostReportRemarks SaveConcern(PostConcern concern)
{
var objReturn = new PostReportRemarks();
try
{
var ticket_no = "T" + RandomizeHelper.GenerateRandomString(7);
var concern_no = "C" + RandomizeHelper.GenerateRandomString(7);
string img1 = string.Empty, img2 = string.Empty, img3 = string.Empty;
if (concern.image1 != null)
{
img1 = "../imageReport/" + concern.report_no + "/" + concern_no + "_img1.png";
}
if (concern.image2 != null)
{
img2 = "../imageReport/" + concern.report_no + "/" + concern_no + "_img2.png";
}
if (concern.image3 != null)
{
img3 = "../imageReport/" + concern.report_no + "/" + concern_no + "_img3.png";
}
using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection()))
{
try
{
con.Open();
var cmd = new MySqlCommand("INSERT INTO reportit_concern (report_no, ticket_no, concern_no, description, floor, segment, specific_location, comment, image1, image2, image3, imagesLocation, status) VALUES(@report_no, @ticket_no, @concern_no, @description, @floor, @segment, @specific_location, @comment, @image1, @image2, @image3, @imagesLocation, @status)", con);
cmd.Parameters.AddWithValue("@report_no", concern.report_no);
cmd.Parameters.AddWithValue("@ticket_no", ticket_no);
cmd.Parameters.AddWithValue("@concern_no", concern_no);
cmd.Parameters.AddWithValue("@description", concern.description);
cmd.Parameters.AddWithValue("@floor", concern.floor);
cmd.Parameters.AddWithValue("@segment", concern.segment);
cmd.Parameters.AddWithValue("@specific_location", concern.specific_location);
cmd.Parameters.AddWithValue("@comment", concern.comment);
cmd.Parameters.AddWithValue("@image1", img1);
cmd.Parameters.AddWithValue("@image2", img2);
cmd.Parameters.AddWithValue("@image3", img3);
cmd.Parameters.AddWithValue("@imagesLocation", "imageReport/" + concern.report_no);
cmd.Parameters.AddWithValue("@date_created", DateTime.Now);
cmd.Parameters.AddWithValue("@status", "Draft");
if (cmd.ExecuteNonQuery() > 0)
{
var path = @"C:\xampp\htdocs\reportit\imageReport\" + concern.report_no;
//var path = AppDomain.CurrentDomain.BaseDirectory + concern.report_no;
bool exists = Directory.Exists(path);
if (!exists)
{
System.IO.Directory.CreateDirectory(path);
}
if (concern.image1 != null)
{
using (var ms = new MemoryStream(concern.image1))
{
var img = Image.FromStream(ms);
var bm = new Bitmap(500, 500);
var g = Graphics.FromImage(bm);
g.InterpolationMode = InterpolationMode.HighQualityBicubic;
g.DrawImage(img, 0, 0, 500, 500);
g.Dispose();
img = bm;
var i2 = new Bitmap(img);
i2.Save(path + @"\" + concern_no + "_img1.png", System.Drawing.Imaging.ImageFormat.Png);
}
}
if (concern.image2 != null)
{
using (var ms = new MemoryStream(concern.image2))
{
var img = Image.FromStream(ms);
var bm = new Bitmap(500, 500);
var g = Graphics.FromImage(bm);
g.InterpolationMode = InterpolationMode.HighQualityBicubic;
g.DrawImage(img, 0, 0, 500, 500);
g.Dispose();
img = bm;
img.Save(path + @"\" + concern_no + "_img2.png", System.Drawing.Imaging.ImageFormat.Png);
}
}
if (concern.image3 != null)
{
using (var ms = new MemoryStream(concern.image3))
{
var img = Image.FromStream(ms);
var bm = new Bitmap(500, 500);
var g = Graphics.FromImage(bm);
g.InterpolationMode = InterpolationMode.HighQualityBicubic;
g.DrawImage(img, 0, 0, 500, 500);
g.Dispose();
img = bm;
img.Save(path + @"\" + concern_no + "_img3.png", System.Drawing.Imaging.ImageFormat.Png);
}
}
objReturn = new PostReportRemarks
{
remarks = "Successfully added new concern!",
subject = "Concern"
};
}
else
{
objReturn = new PostReportRemarks
{
remarks = "Error on adding of new concern!",
subject = "Error"
};
}
}
catch (Exception e)
{
objReturn = new PostReportRemarks
{
remarks = e.InnerException.ToString(),
subject = "Error"
};
}
}
}
catch (Exception ex)
{
objReturn = new PostReportRemarks
{
remarks = ex.InnerException.ToString(),
subject = "Error"
};
}
return(objReturn);
}
