public async Task <IActionResult> Edit(int id, [Bind("id,name,desc")] Report1 report1)
{
if (id != report1.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(report1);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Report1Exists(report1.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(report1));
}
public ExecuteModels DelReport2(Report1 val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
try
{
string _SQL = "delete from report2 where id = " + val.id;
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
if (Int32.Parse(cmd.ExecuteNonQuery().ToString()) == 1)
{
ecm.result = 0;
ecm.code = "OK";
}
else
{
ecm.result = 1;
ecm.code = _SQL;
}
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
con.Close();
}
return(ecm);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.RouteData.Values["Id"].ToSafeString() != "")
{
Report report = new Report1();
// Assigning the ObjectDataSource component to the DataSource property of the report.
report.DataSource = new OrderRepository().GetOrderForPrint(Page.RouteData.Values["Id"].ToSafeInt());
// Use the InstanceReportSource to pass the report to the viewer for displaying
InstanceReportSource reportSource = new InstanceReportSource();
reportSource.ReportDocument = report;
//Assigning the report to the report viewer.
ReportViewer1.ReportSource = reportSource;
//Calling the RefreshReport method (only in WinForms applications).
ReportViewer1.RefreshReport();
//Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource();
//// Specifying an URL or a file path
//uriReportSource.Uri = "~/Reports/ord.trdx";
//// Adding the initial parameter values
//uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("Id", "1"));
//ReportViewer1.ReportSource = uriReportSource;
//ReportViewer1.RefreshReport();
}
}
//public void invoiceReport(int issuingId, int invoiceId)
//{
// DateTime value = new DateTime(2020, 3, 18);
// var data = new DataBase();
// Client klient = new Client();
// try
// {
// Report1.Reset();
// var db = new DataBase();
// var ds = db.SelectClient(issuingId);
// var di = db.SelectInvoice(invoiceId);
// var dp = db.SelectInvoicePos(invoiceId);
// var vatTable = db.ReportVatTableInvoicePos(invoiceId);
// klient.CheckWl("6972171117", "2020-03-30");
// var clientReportDataSource = new ReportDataSource("Client", ds);
// var invoiceReportDataSource = new ReportDataSource("Invoice", di);
// var invoicePosReportDataSource = new ReportDataSource("Invoice_pos", dp);
// var vatTableReportDataSource = new ReportDataSource("Vat_Table", vatTable);
// Report1.LocalReport.ReportEmbeddedResource = "Invoice.PL_VAT_Invoice.rdlc";
// Report1.LocalReport.DataSources.Add(clientReportDataSource);
// Report1.LocalReport.DataSources.Add(invoiceReportDataSource);
// Report1.LocalReport.DataSources.Add(invoicePosReportDataSource);
// Report1.LocalReport.DataSources.Add(vatTableReportDataSource);
// Report1.RefreshReport();
// var dataBase = new DataBase();
// }
// catch (Exception e)
// {
// MessageBox.Show(e.ToString());
// }
//}
//Generates invoice_report_std
public void InvoiceReportStd(int issuingClientId, int invoiceId)
{
var data = new DataBase();
Client klient = new Client();
try
{
Report1.Reset();
var db = new DataBase();
var ds = db.SelectClient(issuingClientId);
var di = db.SelectInvoice(invoiceId);
var dp = db.SelectInvoicePos(invoiceId);
var vatTable = db.ReportVatTableInvoicePos(invoiceId);
// klient.CheckWl("6972171117", "2020-03-30");
var clientReportDataSource = new ReportDataSource("Client", ds);
var invoiceReportDataSource = new ReportDataSource("Invoice", di);
var invoicePosReportDataSource = new ReportDataSource("Invoice_pos", dp);
var vatTableReportDataSource = new ReportDataSource("Vat_Table", vatTable);
Report1.LocalReport.ReportPath = Directory.GetCurrentDirectory() + @"\PrintReports\Invoice\PL_VAT_Invoice_std.rdlc";
Report1.LocalReport.DataSources.Add(clientReportDataSource);
Report1.LocalReport.DataSources.Add(invoiceReportDataSource);
Report1.LocalReport.DataSources.Add(invoicePosReportDataSource);
Report1.LocalReport.DataSources.Add(vatTableReportDataSource);
Report1.RefreshReport();
var dataBase = new DataBase();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
// Bind the data source to the server controls.
DataBind();
// Create a new report instance.
Report1 report = new Report1();
// Link the required controls with the
// Printable Component Containers of a report.
report.gridContainer.PrintableComponent = ASPxGridViewExporter1;
report.chartContainer.PrintableComponent =
new PrintableComponentLinkBase()
{
Component = ((IChartContainer)WebChartControl1).Chart
};
// Assemble the report document and publish it
// (e.g., save it to a memory stream in a third-party format).
using (MemoryStream stream = new MemoryStream()) {
report.CreateDocument();
report.PrintingSystem.ExportToPdf(stream);
Response.ClearContent();
Response.ContentType = "application/pdf";
byte[] buffer = stream.ToArray();
Response.OutputStream.Write(buffer, 0, (int)stream.Length);
Response.Flush();
}
}
public List <Report1> GetReport1All()
{
HomeController hc = new HomeController();
List <Report1> ul = new List <Report1>();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
string _SQL = "SELECT * from report1";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
DataTable _Dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
foreach (DataRow _Item in _Dt.Rows)
{
Report1 rv = new Report1();
rv.id = _Item["id"].ToString();
rv.txt1 = _Item["txt1"].ToString();
rv.txt2 = _Item["txt2"].ToString();
rv.txt3 = _Item["txt3"].ToString();
rv.txt4 = _Item["txt4"].ToString();
rv.txt5 = _Item["txt5"].ToString();
rv.txt6 = _Item["txt6"].ToString();
rv.txt7 = _Item["txt7"].ToString();
rv.txt8 = _Item["txt8"].ToString();
rv.txt9 = _Item["txt9"].ToString();
rv.txt10 = _Item["txt10"].ToString();
rv.txt11 = _Item["txt11"].ToString();
rv.txt12 = _Item["txt12"].ToString();
rv.txt13 = _Item["txt13"].ToString();
rv.txt14 = _Item["txt14"].ToString();
rv.txt15 = _Item["txt15"].ToString();
rv.txt16 = _Item["txt16"].ToString();
rv.txt17 = _Item["txt17"].ToString();
rv.txt18 = _Item["txt18"].ToString();
rv.txt19 = _Item["txt19"].ToString();
rv.txt20 = _Item["txt20"].ToString();
rv.txt21 = _Item["txt21"].ToString();
rv.txt22 = _Item["txt22"].ToString();
rv.txt23 = _Item["txt23"].ToString();
rv.txt24 = _Item["txt24"].ToString();
rv.txt25 = _Item["txt25"].ToString();
rv.txt26 = _Item["txt26"].ToString();
rv.txt27 = _Item["txt27"].ToString();
rv.txt28 = _Item["txt28"].ToString();
rv.txt29 = _Item["txt29"].ToString();
rv.txt30 = _Item["txt30"].ToString();
rv.txt31 = _Item["txt31"].ToString();
rv.txt32 = _Item["txt32"].ToString();
rv.txt33 = _Item["txt33"].ToString();
rv.txt34 = _Item["txt34"].ToString();
rv.txt35 = _Item["txt35"].ToString();
ul.Add(rv);
}
}
con.Close();
}
return(ul);
}
public async Task <IActionResult> Create([Bind("id,name,desc")] Report1 report1)
{
if (ModelState.IsValid)
{
_context.Add(report1);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(report1));
}
public Stream GetReport(string reportId, string asofdate, string sessionId)
{
WebOperationContext.Current.OutgoingResponse.ContentType = "text/xml";
Console.WriteLine("At {0}: {1}", DateTime.Now, WebOperationContext.Current.IncomingRequest.UriTemplateMatch.RequestUri);
if (!File.Exists(GetAuthTokenFilePath(sessionId)))
{
Console.WriteLine("Not authenticated: " + (sessionId ?? "[Empty]"));
var ms = new MemoryStream();
var errs = new Errors {
ErrorsArray = new[] { new Error {
Type = "InvalidSessionFault"
} }
};
XmlSerializer errorsXmlSerializer = new XmlSerializer(typeof(Errors));
errorsXmlSerializer.Serialize(ms, errs);
ms.Position = 0;
return(ms);
}
Tree reportData;
switch (reportId.ToUpperInvariant())
{
case "REPORT1":
reportData = Report1.Create(asofdate);
break;
case "REPORT2":
reportData = Report2.Create(asofdate);
break;
case "REPORT3":
reportData = Report3.Create(asofdate);
break;
default:
Console.WriteLine("Unknown report requested.");
reportData = null;
break;
}
var ms2 = new MemoryStream();
XmlSerializer reportDataXmlSerializer = new XmlSerializer(typeof(Tree));
reportDataXmlSerializer.Serialize(ms2, reportData);
ms2.Position = 0;
return(ms2);
}
public ReportSource Resolve(string reportName)
{
var objectDataSource = new ObjectDataSource();
objectDataSource.DataSource = GetData();
var report = new Report1();
report.DataSource = objectDataSource;// you can use also GetData() directly since it is a List
var reportSource = new InstanceReportSource();
reportSource.ReportDocument = report;
return(reportSource);
}
public void CreateReport()
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-GI4R9EJ;Initial Catalog=QUANLYCF1;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from HOADONBANHANG where MONTH(THOIGIAN) = Month(GETDATE()) and day(THOIGIAN) = day(GETDATE()) and year(THOIGIAN) = year(GETDATE())", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
Report1 report = new Report1();
report.DataSouce = dt;
report.ShowPreview();
}
public ReportSource GetReportDocument()
{
Report reportObj;
var rManager = new ReportManager();
var irs = new Telerik.Reporting.InstanceReportSource();
reportObj = new Report1();
reportObj.DataSource = rManager.GetAdmissionApplicant();
irs.ReportDocument = reportObj;
SaveReportProgramatically(reportObj, "C:\\MyReport.pdf");
return(irs);
}
public ExecuteModels UpdateReport1(Report1 val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
string _SQL = string.Empty;
try
{
string _SQL_Set = string.Empty;
string[] Col_Arr = { "txt1", "txt2", "txt3", "txt4", "txt5", "txt6", "txt7", "txt8", "txt9", "txt10", "txt11", "txt12", "txt13", "txt14", "txt15", "txt16", "txt17", "txt18", "txt19", "txt20", "txt21", "txt22", "txt23", "txt24", "txt25", "txt26", "txt27", "txt28", "txt29", "txt30", "txt31", "txt32", "txt33", "txt34", "txt35" };
string[] Val_Arr = { val.txt1, val.txt2, val.txt3, val.txt4, val.txt5, val.txt6, val.txt7, val.txt8, val.txt9, val.txt10, val.txt11, val.txt12, val.txt13, val.txt14, val.txt15, val.txt16, val.txt17, val.txt18, val.txt19, val.txt20, val.txt21, val.txt22, val.txt23, val.txt24, val.txt25, val.txt26, val.txt27, val.txt28, val.txt29, val.txt30, val.txt31, val.txt32, val.txt33, val.txt34, val.txt35 };
for (int n = 0; n <= Val_Arr.Length - 1; n++)
{
if (Val_Arr[n] != null)
{
_SQL_Set += Col_Arr[n] + " = N'" + Val_Arr[n] + "', ";
}
}
_SQL = "update report1 set " + _SQL_Set + " create_by_user_id = 1 where id = " + val.id;
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
if (Int32.Parse(cmd.ExecuteNonQuery().ToString()) == 1)
{
ecm.result = 0;
ecm.code = "OK";
}
else
{
ecm.result = 1;
ecm.code = _SQL;
}
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message + " sql => " + _SQL;
}
con.Close();
}
return(ecm);
}
private void barButtonItem13_ItemClick(object sender, ItemClickEventArgs e)
{
if (tabPane1.SelectedPageIndex == 3)
{
if (clientBindingSource1.Current is Client buffer)
{
buffer.Accountings = Gateway.Call(new GetAccountingByOwnerId()
{
Id = buffer.Id
}).Result;
var report = new Report1();
report.objectDataSource1.DataSource = buffer;
report.ShowPreview();
}
}
else
{
XtraMessageBox.Show("Выберете клиента для вывода в отчёт.");
}
}
private async void R1TimerOnTick(object sender, object o)
{
try
{
byte[] data;
bool haveReportA = false;
bool haveReportB = false;
Report1 report = new Report1();
do
{
var inputReport = await EventHandlerForDevice.Current.Device.GetInputReportAsync(1);
data = inputReport.Data.ToArray();
var reportType = (data[3] & 0x0f);
if (reportType == 1)
{
haveReportA = true;
}
else if (reportType == 8)
{
haveReportB = true;
}
else
{
continue; // bad report ID
}
AcuRite.AcuriteParser.ParseReport1(data, ref report);
} while (!haveReportA || !haveReportB);
if (report != null)
{
var messageString = JsonConvert.SerializeObject(report);
var message = new Message(Encoding.ASCII.GetBytes(messageString));
await _deviceClient.SendEventAsync(message);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
public ActionResult Index(Report1 report1)
{
if (ModelState.IsValid)
{
pubsEntities2 db = new pubsEntities2();
string query;
IEnumerable <authors> results;
SqlParameter number_of_sales = new SqlParameter("number_of_sales", report1.X);
SqlParameter first_date = new SqlParameter("first_date", report1.From_time);
SqlParameter second_date = new SqlParameter("second_date", report1.To_time);
if (!report1.X.HasValue)
{
query = "SELECT authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract " +
"FROM authors INNER JOIN titleauthor ON authors.au_id=titleauthor.au_id INNER JOIN sales ON titleauthor.title_id=sales.title_id " +
"WHERE sales.ord_date >= CONVERT(datetime,@first_date,110) AND sales.ord_date <= CONVERT(datetime,@second_date,110) GROUP BY authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract ORDER BY sum(sales.qty) DESC;";
results = db.Database.SqlQuery <authors>(query, parameters: new[] { first_date, second_date });
}
else if (!report1.From_time.HasValue)
{
query = "SELECT TOP (@number_of_sales) authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract " +
"FROM authors INNER JOIN titleauthor ON authors.au_id=titleauthor.au_id INNER JOIN sales ON titleauthor.title_id=sales.title_id " +
"WHERE sales.ord_date <= CONVERT(datetime,@second_date,110) GROUP BY authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract ORDER BY sum(sales.qty) DESC;";
results = db.Database.SqlQuery <authors>(query, parameters: new[] { number_of_sales, second_date });
}
else
{
query = "SELECT TOP (@number_of_sales) authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract " +
"FROM authors INNER JOIN titleauthor ON authors.au_id=titleauthor.au_id INNER JOIN sales ON titleauthor.title_id=sales.title_id " +
"WHERE sales.ord_date >= CONVERT(datetime,@first_date,110) GROUP BY authors.au_id,authors.au_fname,authors.au_lname,authors.phone,authors.address,authors.city,authors.state,authors.zip,authors.contract ORDER BY sum(sales.qty) DESC;";
results = db.Database.SqlQuery <authors>(query, parameters: new[] { number_of_sales, first_date });
}
ViewBag.results = results;
return(View("Results"));
}
else
{
return(View());
}
}
private async void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
string p1 = "", p2 = "";
if (Date1.SelectedDate.HasValue)
{
p1 = _reportVm.Parameter1 = DateTime.Parse(Date1.SelectedDate.ToString()).Date.ToString("yyyy-MM-dd");
}
if (Date2.SelectedDate.HasValue)
{
p2 = _reportVm.Parameter2 = DateTime.Parse(Date2.SelectedDate.ToString()).Date.ToString("yyyy-MM-dd");
}
var table = await _reportVm.GetTableTemp();
Report1 report1 = new Report1();
if (_reportVm.Parameter1 == null)
{
p1 = "--------";
}
if (_reportVm.Parameter2 == null)
{
p2 = "--------";
}
string trainNo = _reportVm.TrainId.ToString(), type = "By Train", name = ((Train)cmbTrain.SelectedItem).Name;
if (_reportVm.TrainId == 1)
{
name = trainNo = "*****";
type = "All Trains";
}
report1.Database.Tables["Report1"].SetDataSource(table);
report1.SetParameterValue("fromDate", p1);
report1.SetParameterValue("toDate", p2);
report1.SetParameterValue("trainNo", trainNo);
report1.SetParameterValue("type", type);
report1.SetParameterValue("trainName", name);
report1.SetParameterValue("noOfRecordes", table.Rows.Count);
ReportsViewer.ViewerCore.ReportSource = report1;
}
public ExecuteModels InsertReport1(Report1 val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
try
{
string _SQL = "insert into report1 (txt1, txt2, txt3, txt4, txt5, txt6, txt7, txt8, txt9, txt10, txt11, txt12, txt13, txt14, txt15, txt16, txt17, txt18, txt19,txt20, txt21, txt22, txt23, txt24, txt25, txt26, txt27, txt28, txt29, txt30, txt31, txt32, txt33, txt34, txt35, create_by_user_id) output inserted.id values (N'" + val.txt1 + "', N'" + val.txt2 + "', N'" + val.txt3 + "', N'" + val.txt4 + "', N'" + val.txt5 + "', N'" + val.txt6 + "', N'" + val.txt7 + "', N'" + val.txt8 + "', N'" + val.txt9 + "', N'" + val.txt10 + "', N'" + val.txt11 + "', N'" + val.txt12 + "', N'" + val.txt13 + "', N'" + val.txt14 + "', N'" + val.txt15 + "', N'" + val.txt16 + "', N'" + val.txt17 + "', N'" + val.txt18 + "', N'" + val.txt19 + "', N'" + val.txt20 + "', N'" + val.txt21 + "', N'" + val.txt22 + "', N'" + val.txt23 + "', N'" + val.txt24 + "', N'" + val.txt25 + "', N'" + val.txt26 + "', N'" + val.txt27 + "', N'" + val.txt28 + "', N'" + val.txt29 + "', N'" + val.txt30 + "', N'" + val.txt31 + "', N'" + val.txt32 + "', N'" + val.txt33 + "', N'" + val.txt34 + "', N'" + val.txt35 + "', 1)";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
var id_return = Int32.Parse(cmd.ExecuteScalar().ToString());
if (id_return >= 1)
{
ecm.result = 0;
ecm.code = "OK";
ecm.id_return = id_return.ToString();
}
else
{
ecm.result = 1;
ecm.code = "NOK";
}
}
}
catch (Exception ex)
{
ecm.result = 1;
ecm.code = ex.Message;
}
con.Close();
}
return(ecm);
}
public void ExecuteTest()
{
var accountStorage = new MemoryAccountStorage(new RegularAccountFactory());
var categoryStorage = new MemoryCategoryStorage(new RegularCategoryFactory());
var transactionStorage = new MemoryTransactionStorage(new RegularTransactionFactory());
var category1 = categoryStorage.CreateCategory("Category 1", "", 0, null);
var category2 = categoryStorage.CreateCategory("Category 2", "", 0, category1);
var category3 = categoryStorage.CreateCategory("Category 3", "", 0, category2);
var category31 = categoryStorage.CreateCategory("Category 3-1", "", 0, category3);
var category32 = categoryStorage.CreateCategory("Category 3-2", "", 0, category3);
var category4 = categoryStorage.CreateCategory("Category 4", "", 0, category1);
var category5 = categoryStorage.CreateCategory("Category 5", "", 0, category1);
var account = accountStorage.CreateAccount("Main account", "", "UAH");
var account2 = accountStorage.CreateAccount("Reserve account", "", "TUR");
var transaction1 = CreateTransaction(transactionStorage, account, category31);
CreateTransaction(transactionStorage, account, category31);
CreateTransaction(transactionStorage, account, category32);
CreateTransaction(transactionStorage, account, category31);
CreateTransaction(transactionStorage, account, category5);
CreateTransaction(transactionStorage, account, category31);
CreateTransaction(transactionStorage, account, category32);
CreateTransaction(transactionStorage, account, category32);
CreateTransaction(transactionStorage, account2, category32);
CreateTransaction(transactionStorage, account2, category31);
CreateTransaction(transactionStorage, account2, category4);
var report1 = new Report1(transactionStorage, categoryStorage);
var list = report1.Execute(new AllTransactionFilteredSource()).GroupBy(x => x.Key.Account);
}
static void Main(string[] args)
{
try
{
var p1 = ConfigReader.Path1;
var p2 = ConfigReader.Path2;
var p3 = ConfigReader.Path3;
var exceptionReportPath = ConfigReader.ExceptionReportPath;
var report1 = new Report1().GetReport(p1);
var report2 = new Report2().GetReport(p2);
var report3 = new Report3().GetReport(p3);
new ExceptionReport().GenExceptionReport(report1, report2, report3, exceptionReportPath);
new Report1().ExportToDB(p1);
new Report2().ExportToDB(p2);
new Report3().ExportToDB(p3);
}
catch (Exception ex)
{
logger.Error(ex, ex.Message);
}
}
public void mm()
{
Report1 ls = new Report1();
pdfReportService.ExportToPDF(ls);
}
private void createReport(object sender, RoutedEventArgs e)
{
if (listViewProjects.SelectedItem == null)
{
myMessageQueue.Enqueue(rm.GetString("selectRowToTakeAction"), rm.GetString("ok"), () => HandleOKMethod());
return;
}
int counter2 = countCheckBoxForReport2();
VarsProjectsAll varsProjectsAll = (VarsProjectsAll)listViewProjects.SelectedItem;
if (localDbConnectionUnity.State == ConnectionState.Closed)
{
localDbConnectionUnity.Open();
}
try
{
SqlCommand reportCommand = new SqlCommand("INSERT INTO Reports VALUES (@date)", localDbConnectionUnity);
reportCommand.Parameters.AddWithValue("@date", Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")));
reportCommand.ExecuteNonQuery();
SqlCommand commandProjectReport = new SqlCommand("SELECT dbo.countReports()", localDbConnectionUnity);
reportDone.Content = (int)commandProjectReport.ExecuteScalar();
}
catch { }
localDbConnectionUnity.Close();
if (localDbConnection.State == ConnectionState.Closed)
{
localDbConnection.Open();
}
SqlCommand command = new SqlCommand("SELECT dbo.getProjectDeviceType(@id)", localDbConnection);
command.Parameters.AddWithValue("@id", varsProjectsAll.id);
int type = int.Parse(command.ExecuteScalar().ToString());
localDbConnection.Close();
if (type == 1)
{
switch (countCheckBoxForReport1())
{
case 0:
myMessageQueue.Enqueue(rm.GetString("selectDataToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 1:
Report1 report1_1 = new Report1(varsProjectsAll.id, idList);
report1_1.Show();
break;
case 2:
Report2 report1_2 = new Report2(varsProjectsAll.id, idList);
report1_2.Show();
break;
case 3:
Report3 report1_3 = new Report3(varsProjectsAll.id, idList);
report1_3.Show();
break;
case 4:
Report4 report1_4 = new Report4(varsProjectsAll.id, idList);
report1_4.Show();
break;
case 5:
Report5 report1_5 = new Report5(varsProjectsAll.id, idList);
report1_5.Show();
break;
case 6:
Report6 report1_6 = new Report6(varsProjectsAll.id, idList);
report1_6.Show();
break;
case 7:
Report7 report1_7 = new Report7(varsProjectsAll.id, idList);
report1_7.Show();
break;
case 8:
Report8 report1_8 = new Report8(varsProjectsAll.id, idList);
report1_8.Show();
break;
case 9:
Report9 report1_9 = new Report9(varsProjectsAll.id, idList);
report1_9.Show();
break;
case 10:
Report10 report1_10 = new Report10(varsProjectsAll.id, idList);
report1_10.Show();
break;
case 11:
Report11 report1_11 = new Report11(varsProjectsAll.id, idList);
report1_11.Show();
break;
}
}
else
{
switch (countCheckBoxForReport2())
{
case 0:
myMessageQueue.Enqueue(rm.GetString("selectDataToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 1:
Report1 report1_1 = new Report1(varsProjectsAll.id, idList);
report1_1.Show();
break;
case 2:
Report2 report1_2 = new Report2(varsProjectsAll.id, idList);
report1_2.Show();
break;
case 3:
Report3 report1_3 = new Report3(varsProjectsAll.id, idList);
report1_3.Show();
break;
case 4:
Report4 report1_4 = new Report4(varsProjectsAll.id, idList);
report1_4.Show();
break;
case 5:
Report5 report1_5 = new Report5(varsProjectsAll.id, idList);
report1_5.Show();
break;
case 6:
Report6 report1_6 = new Report6(varsProjectsAll.id, idList);
report1_6.Show();
break;
case 7:
Report7 report1_7 = new Report7(varsProjectsAll.id, idList);
report1_7.Show();
break;
case 8:
Report8 report1_8 = new Report8(varsProjectsAll.id, idList);
report1_8.Show();
break;
case 9:
Report9 report1_9 = new Report9(varsProjectsAll.id, idList);
report1_9.Show();
break;
case 10:
Report10 report1_10 = new Report10(varsProjectsAll.id, idList);
report1_10.Show();
break;
case 11:
Report11 report1_11 = new Report11(varsProjectsAll.id, idList);
report1_11.Show();
break;
case 12:
myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 13:
myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 14:
myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 15:
myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
case 16:
myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod());
break;
}
}
}
static void Main(string[] args)
{
Report1 report = new Report1(TestData.GetSampleOrder());
report.CreateReport();
}
private void AltToggle(object sender, RoutedEventArgs e)
{
// Mimicing radio buttons so you cant toggle a button off
if (AltOption.IsChecked == false)
{
AltOption.IsChecked = true;
return;
}
SimpleOption.IsChecked = false;
OrbOption.IsChecked = false;
Properties.Settings.Default.Simple = SimpleOption.IsChecked;
Properties.Settings.Default.Orb = OrbOption.IsChecked;
Properties.Settings.Default.Alt = AltOption.IsChecked;
if (AltOption.IsChecked)
{
Report1.SetResourceReference(ContentProperty, "AnsemReportOld1");
Report2.SetResourceReference(ContentProperty, "AnsemReportOld2");
Report3.SetResourceReference(ContentProperty, "AnsemReportOld3");
Report4.SetResourceReference(ContentProperty, "AnsemReportOld4");
Report5.SetResourceReference(ContentProperty, "AnsemReportOld5");
Report6.SetResourceReference(ContentProperty, "AnsemReportOld6");
Report7.SetResourceReference(ContentProperty, "AnsemReportOld7");
Report8.SetResourceReference(ContentProperty, "AnsemReportOld8");
Report9.SetResourceReference(ContentProperty, "AnsemReportOld9");
Report10.SetResourceReference(ContentProperty, "AnsemReportOld10");
Report11.SetResourceReference(ContentProperty, "AnsemReportOld11");
Report12.SetResourceReference(ContentProperty, "AnsemReportOld12");
Report13.SetResourceReference(ContentProperty, "AnsemReportOld13");
Fire1.SetResourceReference(ContentProperty, "FireOld");
Fire2.SetResourceReference(ContentProperty, "FireOld");
Fire3.SetResourceReference(ContentProperty, "FireOld");
Blizzard1.SetResourceReference(ContentProperty, "BlizzardOld");
Blizzard2.SetResourceReference(ContentProperty, "BlizzardOld");
Blizzard3.SetResourceReference(ContentProperty, "BlizzardOld");
Thunder1.SetResourceReference(ContentProperty, "ThunderOld");
Thunder2.SetResourceReference(ContentProperty, "ThunderOld");
Thunder3.SetResourceReference(ContentProperty, "ThunderOld");
Cure1.SetResourceReference(ContentProperty, "CureOld");
Cure2.SetResourceReference(ContentProperty, "CureOld");
Cure3.SetResourceReference(ContentProperty, "CureOld");
Reflect1.SetResourceReference(ContentProperty, "ReflectOld");
Reflect2.SetResourceReference(ContentProperty, "ReflectOld");
Reflect3.SetResourceReference(ContentProperty, "ReflectOld");
Magnet1.SetResourceReference(ContentProperty, "MagnetOld");
Magnet2.SetResourceReference(ContentProperty, "MagnetOld");
Magnet3.SetResourceReference(ContentProperty, "MagnetOld");
Valor.SetResourceReference(ContentProperty, "ValorOld");
Wisdom.SetResourceReference(ContentProperty, "WisdomOld");
Limit.SetResourceReference(ContentProperty, "LimitOld");
Master.SetResourceReference(ContentProperty, "MasterOld");
Final.SetResourceReference(ContentProperty, "FinalOld");
TornPage1.SetResourceReference(ContentProperty, "TornPageOld");
TornPage2.SetResourceReference(ContentProperty, "TornPageOld");
TornPage3.SetResourceReference(ContentProperty, "TornPageOld");
TornPage4.SetResourceReference(ContentProperty, "TornPageOld");
TornPage5.SetResourceReference(ContentProperty, "TornPageOld");
Lamp.SetResourceReference(ContentProperty, "GenieOld");
Ukulele.SetResourceReference(ContentProperty, "StitchOld");
Baseball.SetResourceReference(ContentProperty, "ChickenLittleOld");
Feather.SetResourceReference(ContentProperty, "PeterPanOld");
Nonexistence.SetResourceReference(ContentProperty, "ProofOfNonexistenceOld");
Connection.SetResourceReference(ContentProperty, "ProofOfConnectionOld");
Peace.SetResourceReference(ContentProperty, "ProofOfPeaceOld");
PromiseCharm.SetResourceReference(ContentProperty, "PromiseCharmOld");
broadcast.Report.SetResourceReference(ContentProperty, "AnsemReportOld");
broadcast.Peace.SetResourceReference(ContentProperty, "ProofOfPeaceOld");
broadcast.Nonexistence.SetResourceReference(ContentProperty, "ProofOfNonexistenceOld");
broadcast.Connection.SetResourceReference(ContentProperty, "ProofOfConnectionOld");
broadcast.PromiseCharm.SetResourceReference(ContentProperty, "PromiseCharmOld");
broadcast.Fire.SetResourceReference(ContentProperty, "FireAlt");
broadcast.Blizzard.SetResourceReference(ContentProperty, "BlizzardAlt");
broadcast.Thunder.SetResourceReference(ContentProperty, "ThunderAlt");
broadcast.Cure.SetResourceReference(ContentProperty, "CureAlt");
broadcast.Reflect.SetResourceReference(ContentProperty, "ReflectAlt");
broadcast.Magnet.SetResourceReference(ContentProperty, "MagnetAlt");
broadcast.Valor.SetResourceReference(ContentProperty, "ValorAlt");
broadcast.Wisdom.SetResourceReference(ContentProperty, "WisdomAlt");
broadcast.Limit.SetResourceReference(ContentProperty, "LimitAlt");
broadcast.Master.SetResourceReference(ContentProperty, "MasterAlt");
broadcast.Final.SetResourceReference(ContentProperty, "FinalAlt");
broadcast.Baseball.SetResourceReference(ContentProperty, "ChickenLittleAlt");
broadcast.Lamp.SetResourceReference(ContentProperty, "GenieAlt");
broadcast.Ukulele.SetResourceReference(ContentProperty, "StitchAlt");
broadcast.Feather.SetResourceReference(ContentProperty, "PeterPanAlt");
((Grid)((Grid)broadcast.Fire.Parent).Parent).RowDefinitions[0].Height = new GridLength(0, GridUnitType.Star);
((Grid)((Grid)broadcast.Fire.Parent).Parent).RowDefinitions[2].Height = new GridLength(0, GridUnitType.Star);
((Grid)broadcast.Valor.Parent).RowDefinitions[1].Height = new GridLength(5, GridUnitType.Star);
((Grid)broadcast.Valor.Parent).RowDefinitions[2].Height = new GridLength(5, GridUnitType.Star);
((Grid)broadcast.Lamp.Parent).RowDefinitions[1].Height = new GridLength(8, GridUnitType.Star);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Report1 rpt = new Report1();
rpt.PrintToPrinter(1,true,0,0);
}
public static byte[] DataTableToExcel(Report1 myReport)
{
try
{
int delta = 0;
// Opening the Excel template...
FileStream fs =
new FileStream(myReport.Template, FileMode.Open, FileAccess.Read);
// Getting the complete workbook...
HSSFWorkbook templateWorkbook = new HSSFWorkbook(fs, true);
// Getting the worksheet by its name...
HSSFSheet sheet = templateWorkbook.GetSheetAt(0);
//Xử lý Parameters
for (int t = 0; t < myReport.lsParameter.Count; t++)
{
Parameters myParam = myReport.lsParameter[t];
HSSFCellStyle cs = sheet.GetRow(myParam.PrRow - 1).GetCell(myParam.PrColl - 1).CellStyle;
HSSFCell myCell = sheet.GetRow(myParam.PrRow - 1).CreateCell(myParam.PrColl - 1);
myCell.SetCellValue(myParam.PrValue.ToString());
myCell.CellStyle = cs;
}
//Đoạn này thêm vào cho bên atcom xuất báo cáo có header
if (myReport.GenHeader)
{
CreateHeader(myReport.lsTable, sheet);
}
//kết thúc header
//Xử lý Tables
for (int t = 0; t < myReport.lsTable.Count; t++)
{
Tables myTable = myReport.lsTable[t];
HSSFCellStyle[] cs = new HSSFCellStyle[myTable.PrValue.Columns.Count];
if (myTable.PrValue != null && myTable.PrColl != null && myTable.PrRow != null && myTable != null)
{
//Get cell styles in the first row
for (int i = 0; i < myTable.PrValue.Columns.Count; i++)
{
cs[i] = sheet.GetRow(myTable.PrRow - 1 + delta).GetCell(myTable.PrColl - 1 + i).CellStyle;
}
//Shift rows to take place for the table's rows
if (myTable.PrValue.Rows.Count > 1)
{
sheet.ShiftRows(myTable.PrRow + delta, sheet.LastRowNum + 1 + delta, myTable.PrValue.Rows.Count - 1);
}
//Fill table data & style
for (int i = 0; i < myTable.PrValue.Rows.Count; i++)
{
HSSFRow row = sheet.CreateRow(myTable.PrRow - 1 + i + delta);
for (int j = 0; j < myTable.PrValue.Columns.Count; j++)
{
HSSFCell cell = row.CreateCell(myTable.PrColl - 1 + j);
//Trường hợp cell là kiểu DateTime --> chuyển value sang dạng dd/MM/yyyy
if (myTable.PrValue.Rows[i][j].GetType() == typeof(DateTime))
{
cell.SetCellValue(((DateTime)myTable.PrValue.Rows[i][j]).ToString("dd/MM/yyyy"));
}
else
{
cell.SetCellValue(myTable.PrValue.Rows[i][j].ToString());
}
cell.CellStyle = cs[j];
}
}
delta += myTable.PrValue.Rows.Count - 1;
}
}
sheet.ForceFormulaRecalculation = true;
MemoryStream ms = new MemoryStream();
// Writing the workbook content to the FileStream...
templateWorkbook.Write(ms);
// Sending the server processed data back to the user computer...
//return ms. .ToString();
return(ms.ToArray());
}
catch
{
return(null);
}
}
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://aka.ms/RazorPagesCRUD.
public async Task <IActionResult> OnPostAsync(int id)
{
Employee1 = await _context.Employee.FindAsync(id);
string sb = Employee1.Email;
var myMail = new MailMessage();
myMail.From = new MailAddress("Admin System<*****@*****.**>");
myMail.Subject = "My Subject";
myMail.To.Add(new MailAddress(sb.ToString()));
myMail.IsBodyHtml = true;
myMail.BodyEncoding = System.Text.Encoding.UTF8;
myMail.Body = "My Body & <b>Description</b>";
var credential = new NetworkCredential("*****@*****.**", "thanakrit2540bb!"); // User & Password
var smtpClient = new SmtpClient();
smtpClient.Port = 587;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = credential;
smtpClient.Host = "smtp.gmail.com"; // SMTP
smtpClient.EnableSsl = true;
Report1 = await _context.Report
.ToListAsync();
try
{
smtpClient.Send(myMail);
smtpClient.Dispose();
myMail.Dispose();
}
catch (Exception)
{
error = "Please check email security.";
}
DateTime date = DateTime.Now;
Report.Date = new DateTime(date.Year, date.Month, date.Day, date.Hour, date.Minute, date.Second);
StringBuilder a = new StringBuilder("RPT");
a.Append(Report1.Count().ToString());
string b = a.ToString();
Report.ReportName = b;
_context.Report.Add(Report);
await _context.SaveChangesAsync();
return(RedirectToPage("./../Includes/ShowJob"));
}
private void Cetak()
{
ReportViewer dummyDoc = new ReportViewer();
List <dataakhir> tempdata = null;
switch (kryptonComboBox1.SelectedIndex)
{
case 0:
tempdata = akhir.OrderBy(x => x.Index).ToList();
break;
case 1:
tempdata = akhir.OrderBy(x => x.minimum).ToList();
break;
case 2:
tempdata = akhir.OrderBy(x => x.maximum).ToList();
break;
case 3:
tempdata = akhir.OrderBy(x => x.average).ToList();
break;
case 4:
tempdata = akhir.OrderByDescending(x => x.minimum).ToList();
break;
case 5:
tempdata = akhir.OrderByDescending(x => x.maximum).ToList();
break;
case 6:
tempdata = akhir.OrderByDescending(x => x.average).ToList();
break;
}
Report1 datalaporan = new Report1(tempdata, laporanpopupasi);
datalaporan.addAlpha(inp_alpha.Text + " (" + FireflyVariabel.Alpha.Rounding(GlobalConfiguration.Digit) + ")");
datalaporan.addBeta(FireflyVariabel.Beta + "");
datalaporan.addDelta(FireflyVariabel.Delta + "");
datalaporan.addFungsi(inp_fungsi.Text + " [" + FunctionVariabel.Xmin + " " + FunctionVariabel.Xmax + ";" + FunctionVariabel.Ymin + " " + FunctionVariabel.Ymax + "]");
datalaporan.addGamma(FireflyVariabel.Gamma + "");
datalaporan.addJumlahPopulasi(pop_member.Value + "");
using (var stream = new MemoryStream())
{
var pngExporter = new PngExporter();
pngExporter.Export(plot2.Model, stream);
datalaporan.addPicture(Image.FromStream(stream));
}
dummyDoc.Report(datalaporan);
if (thismain.dockPanel1.DocumentStyle == DocumentStyle.SystemMdi)
{
dummyDoc.MdiParent = thismain;
dummyDoc.Show();
}
else
{
dummyDoc.Show(thismain.dockPanel1);
}
}
