public ExecuteModels DelReport3(Report3 val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
try
{
string _SQL = "delete from report3 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);
}
public List <Report3> GetReport3All()
{
HomeController hc = new HomeController();
List <Report3> ul = new List <Report3>();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
string _SQL = "SELECT * from report3";
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)
{
Report3 rv = new Report3();
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();
ul.Add(rv);
}
}
con.Close();
}
return(ul);
}
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 ExecuteModels UpdateReport3(Report3 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" };
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 };
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 report3 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);
}
public ExecuteModels InsertReport3(Report3 val)
{
ExecuteModels ecm = new ExecuteModels();
HomeController hc = new HomeController();
using (SqlConnection con = hc.ConnectDatabaseTT1995())
{
try
{
string _SQL = "insert into report3 (txt1, txt2, txt3, txt4, txt5, txt6, txt7, txt8, txt9, txt10, txt11, txt12, txt13, txt14, txt15, txt16, txt17, txt18, txt19,txt20, txt21, txt22, txt23, txt24, 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 + "', 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);
}
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);
}
}
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);
}
}
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;
}
}
}
