internal void DeleteReport(Report report)
{
int result = 0;
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlCommand cmd = new MySqlCommand("usp_DeleteReport", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iReportID", MySqlDbType.Int32, report.ReportID);
connection.Open();
result = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
}
internal Report GetReportByFileName(string fileName)
{
Report report = new Report();
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlDataReader dr = null;
MySqlCommand cmd = new MySqlCommand("usp_GetReportByFileName", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iFileName", MySqlDbType.VarChar, 8000, Path.GetFileName(fileName));
connection.Open();
dr = cmd.ExecuteReader();
cmd.Dispose();
if (dr.HasRows)
{
while (dr.Read())
{
report.ReportID = (int)dr["ReportID"];
report.FileName = dr["FileName"].ToString();
report.IsActive = Convert.ToBoolean(dr["IsActive"]);
report.IsClone = Convert.ToBoolean(dr["IsClone"]);
report.IsCustom = Convert.ToBoolean(dr["IsCustom"]);
report.Override = Convert.ToBoolean(dr["Override"]);
report.ClonedReportID = (int)dr["ClonedReportID"];
break;
}
}
else
{
Report newReport = new Report();
newReport.FileName = fileName;
newReport.IsActive = true;
newReport.ReportID = InsertReport(newReport);
report = GetReportByFileName(fileName);
}
}
return report;
}
internal Report UpdateReport(Report report)
{
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlCommand cmd = new MySqlCommand("usp_UpdateReport", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iReportID", MySqlDbType.Int32, report.ReportID);
AddSqlParameter(cmd, "iFileName", MySqlDbType.VarChar, 4000, report.FileName);
AddSqlParameter(cmd, "iIsActive", MySqlDbType.Bit, report.IsActive);
AddSqlParameter(cmd, "iIsClone", MySqlDbType.Bit, report.IsClone);
AddSqlParameter(cmd, "iIsCustom", MySqlDbType.Bit, report.IsCustom);
AddSqlParameter(cmd, "iOverride", MySqlDbType.Bit, report.Override);
AddSqlParameter(cmd, "iClonedReportID", MySqlDbType.Int32, report.ClonedReportID);
connection.Open();
cmd.ExecuteScalar();
cmd.Dispose();
}
return report;
}
public void CloneReport(string newReportName)
{
FileInfo sourceFileInfo = new FileInfo(SelectedReportPath);
FileInfo destFileInfo = new FileInfo(Path.Combine(sourceFileInfo.DirectoryName, newReportName));
File.Copy(sourceFileInfo.FullName, destFileInfo.FullName);
Report report = new Report();
report.FileName = destFileInfo.Name;
report.IsClone = true;
report.ClonedReportID = (SelectedReport.ClonedReportID == 0 ? SelectedReport.ReportID : SelectedReport.ClonedReportID);
report.ReportID = _reporterDA.InsertReport(report);
}