private void updateAlarmPackageGrid()
{
var context = new db_sqlceEntities();
var cn = listView1.Items[3].SubItems[1].Text;
try
{
var query = from c in context.package_al
where (c.date_inc >= dateTimePicker1.Value && c.date_inc <= dateTimePicker2.Value) &&
(c.na.Equals(cn))
select new
{
da = c.date_inc,
sn = c.na,
wr = c.wr_txt
};
var results = query.ToList();
this.bindingWarningSource.DataSource = results;
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text != "")
{
using (var context = new db_sqlceEntities())
{
var q = context.counters.FirstOrDefault(c => c.serial_amspi == textBox2.Text);
if (q == null)
{
var cnt = new counters()
{
objects_place_id = _treeNodeId,
serial_amspi = textBox2.Text,
date_init_calibration_r1 = dateTimePicker1.Value.Date,
date_init_calibration_r2 = dateTimePicker2.Value.Date,
date_calibration_r1 = dateTimePicker3.Value.Date,
date_calibration_r2 = dateTimePicker4.Value.Date,
date_calibration_amspi = dateTimePicker5.Value.Date,
diameter_r1 = Convert.ToInt32(textBox5.Text),
diameter_r2 = Convert.ToInt32(textBox6.Text),
date_start = dateTimePicker6.Value.Date
};
context.counters.Add(cnt);
context.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("ППУ-РМ с таким серийным номером уже установлен!");
}
}
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (ownersDataGridView.SelectedCells.Count > 0)
{
DialogResult dialogResult = MessageBox.Show("Вы действительно хотите удалить выбранный пункт?",
"Подтвердите удаление!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int i = (int)ownersDataGridView.CurrentRow.Cells[0].Value;
using (var context = new db_sqlceEntities())
{
try
{
var obPlc = context.owners.FirstOrDefault(p => p.id == i);
if (obPlc != null)
{
context.owners.Remove(obPlc);
context.SaveChanges();
LoadData();
//loadTree();
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
}
public void loadTree()
{
doneNotes.Clear();
dtTable = new DataTable("TreeView");
dtTable.Columns.Add("PlaceID", typeof(string));
dtTable.Columns.Add("PlaceName", typeof(string));
DataColumn dc = new DataColumn("PlaceParentID", typeof(string))
{
AllowDBNull = true
};
dtTable.Columns.Add(dc);
using (var context = new db_sqlceEntities())
{
foreach (var db in context.objects_place.ToList())
{
dtTable.Rows.Add(db.id, db.name, db.objects_place_id);
}
}
CreateNodes();
/* byte[] myBytes = {0,0,0,0,0,88,112,64}; //assume you pad your array with enough zeros to make it 8 bytes.
* var myDouble = BitConverter.ToDouble(myBytes,0);
* byte[] byt = BitConverter.GetBytes(261.5);
* Console.WriteLine(byt.ToString());
* Console.WriteLine(myDouble.ToString("F", CultureInfo.InvariantCulture));*/
}
private void удалитьОбъектToolStripMenuItem_Click(object sender, EventArgs e)
{
using (var context = new db_sqlceEntities())
{
try
{
var ttt = context.objects_place.LongCount(p => p.objects_place_id == _treeNodeId);
if (ttt > 0)
{
MessageBox.Show("У объекта есть вложенные объекты!");
}
else
{
var obPlc = context.objects_place.FirstOrDefault(p => p.id == _treeNodeId);
if (obPlc != null)
{
context.objects_place.Remove(obPlc);
context.SaveChanges();
loadTree();
}
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void startHttpService()
{
int ip_port = 8080;
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt != null && opt.is_ip)
{
ip_port = (int)opt.ip_port;
httpServer = new MyHttpServer(ip_port);
thread = new Thread(new ThreadStart(httpServer.listen));
Debug.WriteLine("стартуем хттп");
thread.IsBackground = true;
thread.Start();
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void MailService()
{
MailService mailService = VodopriborUchet.MailService.GetInstance();
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt != null)
{
if (opt.is_mail == true)
{
mailService.StartMailService();
}
if (opt.is_mail == false)
{
mailService.StopMailService();
}
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text != "" && this.textBox2.Text != "" && this.textBox3.Text != "")
{
using (var context = new db_sqlceEntities())
{
try
{
var objct = new owners()
{
name = this.textBox1.Text,
surname = this.textBox2.Text,
patronymic = this.textBox3.Text,
tel = this.textBox4.Text,
category_pay_id = (int?)this.comboBox1.SelectedValue
};
context.owners.Add(objct);
context.SaveChanges();
mEditOwners.LoadData();
this.Close();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
private void AddOwner_Load(object sender, EventArgs e)
{
var context = new db_sqlceEntities();
try
{
var query = from c in context.category_pay_type
select new
{
c.id,
c.name //new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
};
var results = query.ToList();
this.comboBox1.DataSource = results;
this.comboBox1.DisplayMember = "name";
this.comboBox1.ValueMember = "id";
//this.objects_placeBindingSource.Columns[0].Visible = false;
// context.SaveChanges();
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text != "" && this.textBox2.Text != "")
{
if (ValidateInt())
{
using (var context = new db_sqlceEntities())
{
try
{
var objct = new impulse()
{
weight = Convert.ToInt32(this.textBox1.Text),
code = Convert.ToInt32(this.textBox2.Text)
};
context.impulse.Add(objct);
context.SaveChanges();
editImpulse.LoadData();
this.Close();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
}
private List <string> getMessagesUIDFromBase(int c, Pop3Client client)
{
List <string> uids = new List <string>();
using (var context = new db_sqlceEntities())
{
try
{
uids.AddRange(from al in context.package_al
where al.mail_uid != null
select al.mail_uid);
uids.AddRange(from al in context.package_iz
where al.mail_uid != null
select al.mail_uid);
uids.AddRange(from al in context.package_on
where al.mail_uid != null
select al.mail_uid);
uids.AddRange(from al in context.package_tm
where al.mail_uid != null
select al.mail_uid);
uids.AddRange(from al in context.package_ts
where al.mail_uid != null
select al.mail_uid);
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message);
}
}
return(uids);
}
private void updateDataPackagesGrid()
{
var context = new db_sqlceEntities();
var cn = listView1.Items[3].SubItems[1].Text;
try
{
var query = from c in context.package_iz
from p1 in context.impulse.Where(p => p.code == c.pw1).DefaultIfEmpty()
from p2 in context.impulse.Where(p => p.code == c.pw2).DefaultIfEmpty()
where (c.da >= dateTimePicker1.Value && c.da <= dateTimePicker2.Value) &&
(c.na.Equals(cn))
select new PackageC()
{
date = c.date_inc,
r1 = (float)(c.r1 * p1.weight) / 1000, // * c.pw1 / 1000,
r2 = (float)(c.r2 * p2.weight) / 1000, //* c.pw2 / 1000
r1_c = 0,
r2_c = 0
};
var results = query.ToList();
for (var i = 1; i < results.Count; i++)
{
results[i].r1_c = results[i].r1 - results[i - 1].r1;
results[i].r2_c = results[i].r2 - results[i - 1].r2;
}
this.bindingPackageSource.DataSource = results;
/* DataTable dat = new DataTable();
*
*
* using (SqlCeDataAdapter adap =
* new SqlCeDataAdapter("SELECT * from package_iz unpivot (Cons for r1_0, r1_1,r1_2,r1_3,r1_4,r1_5,r1_6,r1_7,r1_8,r1_9,r1_10,r1_11 FROM package_iz p" +
*
* " ", @"Data Source=C:\Users\User\Documents\Visual Studio 2013\Projects\VodopriborUchet\VodopriborUchet\db\db_sqlce.sdf"))
* {
* //the adapter will open and close the connection for you.
* adap.Fill(dat);
* }
*/
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void AddPlace_Load(object sender, EventArgs e)
{
var context = new db_sqlceEntities();
try
{
var query = from c in context.object_type
select new
{
c.id,
c.name //new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
};
var results = query.ToList();
var query1 = from c in context.net
select new
{
c.id,
c.name //new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
};
var results1 = query1.ToList();
this.comboBox1.DataSource = results;
this.comboBox1.DisplayMember = "name";
this.comboBox1.ValueMember = "id";
this.comboBox2.DataSource = results1;
this.comboBox2.DisplayMember = "name";
this.comboBox2.ValueMember = "id";
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
try
{
var query1 = from c in context.owners
select new
{
c.id, fio = c.surname + " " + c.name + " " + c.patronymic //new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
};
var results1 = query1.ToList();
this.comboBox3.DataSource = results1;
this.comboBox3.DisplayMember = "fio";
this.comboBox3.ValueMember = "id";
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public void listen()
{
string ip_adr = "127.0.0.1";
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
ip_adr = opt.ip_addr;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/* IPHostEntry host = Dns.GetHostEntry(Dns.GetHostName());
* foreach (IPAddress ip in host.AddressList)
* {
* if (ip.AddressFamily == AddressFamily.InterNetwork)
* {
* ip_adr = ip.ToString();
* }
* }*/
IPAddress localAddr = IPAddress.Parse(ip_adr);
try
{
listener = new TcpListener(localAddr, port);
listener.Start();
while (is_active)
{
Debug.WriteLine("HTTPServer listener thread start!");
TcpClient s = listener.AcceptTcpClient();
HttpProcessor processor = new HttpProcessor(s, this);
Thread thread = new Thread(new ThreadStart(processor.process));
thread.IsBackground = true;
thread.Start();
Thread.Sleep(1);
}
//listener.Stop();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
MessageBox.Show("Указан неверный ip-адрес для сервера!");
}
}
public void LoadData()
{
var context = new db_sqlceEntities();
try
{
var query = from c in context.owners
select c;
var results = query.ToList();
this.ownersBindingSource.DataSource = results;
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var context = new db_sqlceEntities())
{
try
{
var war = context.warning_conditions.FirstOrDefault();
if (war != null)
{
war.gprs_sig_min = float.Parse(this.gprs_sig_min.Text, CultureInfo.InvariantCulture.NumberFormat);
war.gprs_sig_max = float.Parse(this.gprs_sig_max.Text, CultureInfo.InvariantCulture.NumberFormat);
war.gprs_mod_min = float.Parse(this.gprs_mod_min.Text, CultureInfo.InvariantCulture.NumberFormat);
war.gprs_mod_max = float.Parse(this.gprs_mod_max.Text, CultureInfo.InvariantCulture.NumberFormat);
war.controller_voltage_min = float.Parse(this.cont_min.Text, CultureInfo.InvariantCulture.NumberFormat);
war.controller_voltage_max = float.Parse(this.cont_max.Text, CultureInfo.InvariantCulture.NumberFormat);
context.SaveChanges();
this.Close();
}
else
{
var wr = new warning_conditions()
{
gprs_sig_min =
float.Parse(this.gprs_sig_min.Text, CultureInfo.InvariantCulture.NumberFormat),
gprs_sig_max =
float.Parse(this.gprs_sig_max.Text, CultureInfo.InvariantCulture.NumberFormat),
gprs_mod_min =
float.Parse(this.gprs_mod_min.Text, CultureInfo.InvariantCulture.NumberFormat),
gprs_mod_max =
float.Parse(this.gprs_mod_max.Text, CultureInfo.InvariantCulture.NumberFormat),
controller_voltage_min =
float.Parse(this.cont_min.Text, CultureInfo.InvariantCulture.NumberFormat),
controller_voltage_max =
float.Parse(this.cont_max.Text, CultureInfo.InvariantCulture.NumberFormat)
};
context.warning_conditions.Add(wr);
context.SaveChanges();
this.Close();
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void tabControl1_Selected(object sender, TabControlEventArgs e)
{
if (this.tabControl1.SelectedTab == tabPage3)
{
var chart = this.chart1;
var context = new db_sqlceEntities();
var cn = listView1.Items[3].SubItems[1].Text;
try
{
var query = from c in context.package_iz
from p1 in context.impulse.Where(p => p.code == c.pw1).DefaultIfEmpty()
from p2 in context.impulse.Where(p => p.code == c.pw2).DefaultIfEmpty()
where (c.da >= dateTimePicker1.Value && c.da <= dateTimePicker2.Value) &&
(c.na.Equals(cn))
select new
{
date = c.da,
// r1 = c.r1/100,// * c.pw1 / 1000,
// r2 = c.r2/100 //* c.pw2 / 1000
r1 = (float)(c.r1 * p1.weight) / 1000, // * c.pw1 / 1000,
r2 = (float)(c.r2 * p2.weight) / 1000, //* c.pw2 / 1000
};
var results = query.ToList();
if (results.Count <= 0)
{
return;
}
chart.Series[1].XValueType = ChartValueType.DateTime;
chart.Series[1].YValueType = ChartValueType.Int64;
chart.Series[0].XValueType = ChartValueType.DateTime;
chart.Series[0].YValueType = ChartValueType.Int64;
chart.Series[1].Points.DataBindXY(results, "date", results, "r2");
chart.Series[0].Points.DataBindXY(results, "date", results, "r1");
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void EditUnits_Load(object sender, EventArgs e)
{
var context = new db_sqlceEntities();
try
{
var query = from c in context.units
select c;//new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
var results = query.ToList();
this.unitsBindingSource.DataSource = results;
//this.objects_placeBindingSource.Columns[0].Visible = false;
// context.SaveChanges();
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var context = new db_sqlceEntities())
{
var place = new objects_place()
{
name = this.textBox1.Text,
comment = this.textBox4.Text,
kod_BTI = this.textBox2.Text,
net_id = (int?)this.comboBox2.SelectedValue,
object_type_id = (int)this.comboBox1.SelectedValue
};
context.objects_place.Add(place);
context.SaveChanges();
_main.loadTree();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text != "")
{
using (var context = new db_sqlceEntities())
{
var objct = new object_type()
{
name = this.textBox1.Text,
comment = this.textBox2.Text
};
context.object_type.Add(objct);
context.SaveChanges();
mEditObjects.LoadData();
this.Close();
}
}
}
public void LoadData()
{
var context = new db_sqlceEntities();
try
{
var query = from c in context.object_type
select c;//new {c_name = c.name, c_ucost = c.net, a_name = c.kod_BTI};
var results = query.ToList();
this.object_typeBindingSource.DataSource = results;
//this.objects_placeBindingSource.Columns[0].Visible = false;
// context.SaveChanges();
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void editOptions_Load(object sender, EventArgs e)
{
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt != null)
{
this.textBox1.Text = opt.ip_addr;
this.textBox2.Text = opt.ip_port.ToString();
this.textBox3.Text = opt.pop_addr;
this.textBox4.Text = opt.pop_port.ToString();
this.textBox5.Text = opt.pop_mail;
this.textBox6.Text = opt.pop_passwd;
this.checkBox3.Checked = opt.pop_ssl;
this.textBox7.Text = opt.ppu_mail;
this.numericUpDown1.Value = (decimal)opt.pop_int;
this.checkBox1.Checked = opt.is_ip;
this.checkBox2.Checked = opt.is_mail;
this.checkBox4.Checked = (bool)opt.new_ip;
this.textBox8.Text = opt.new_ip_addr;
}
/*else
* {
* opt.ip_addr = "test";
* context.options.Attach(opt);
* context.Entry(opt).State = EntityState.Modified;
* context.SaveChanges();
* opt.ip_addr = "test";
* opt.is_ip = false;
* opt.is_mail = false;
* context.options.Add(opt);
* context.SaveChanges();
*
* }*/
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void WarningConditions_Load(object sender, EventArgs e)
{
using (var context = new db_sqlceEntities())
{
try
{
var war = context.warning_conditions.FirstOrDefault();
if (war != null)
{
this.gprs_sig_min.Text = war.gprs_sig_min.ToString();
this.gprs_sig_max.Text = war.gprs_sig_max.ToString();
this.gprs_mod_min.Text = war.gprs_mod_min.ToString();
this.gprs_mod_max.Text = war.gprs_mod_max.ToString();
this.cont_min.Text = war.controller_voltage_min.ToString();
this.cont_max.Text = war.controller_voltage_max.ToString();
}
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public override void handleGETRequest(HttpProcessor p)
{
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt.new_ip)
{
Console.WriteLine("request: {0}", p.http_url);
p.writeSuccess();
p.outputStream.WriteLine("T##" + DateTime.Now.ToString("yyMMddHHmm") + "YIP=" + opt.new_ip_addr);
}
else
{
Console.WriteLine("request: {0}", p.http_url);
p.writeSuccess();
p.outputStream.Write("T##" + DateTime.Now.ToString("yyMMddHHmm"));
}
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message);
}
}
/*p.writeSuccess();
* p.outputStream.WriteLine("<html><body><h1>test server</h1>");
* p.outputStream.WriteLine("Current Time: " + DateTime.Now.ToString());
* p.outputStream.WriteLine("url : {0}", p.http_url);*/
/* p.outputStream.WriteLine("<form method=post action=/form>");
* p.outputStream.WriteLine("<input type=text name=foo value=foovalue>");
* p.outputStream.WriteLine("<input type=submit name=bar value=barvalue>");
* p.outputStream.WriteLine("</form>");*/
}
/* public MailService(string pop3s, int pop3p, bool ssl, string m, string pass, string mailppu)
* {
* this.pop3_server = pop3s;
* this.pop3_port = pop3p;
* this.use_ssl = ssl;
* this.mail = m;
* this.passwd = pass;
* this.mail_ppu = mailppu;
* // "pop.mail.ru", 995, true, "*****@*****.**", "dontask_mewhy", "*****@*****.**"
* }*/
public void StartMailService()
{
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt != null && opt.is_mail == true)
{
this.pop3_server = opt.pop_addr;
this.pop3_port = (int)opt.pop_port;
this.use_ssl = opt.pop_ssl;
this.mail = opt.pop_mail;
this.passwd = opt.pop_passwd;
this.mail_ppu = opt.ppu_mail;
if (timer != null)
{
return;
}
timer = new Timer {
Interval = (double)(opt.pop_int * 60000)
};
timer.Elapsed += timerElapsed;
timer.Start();
Debug.WriteLine("MailService Started: " + DateTime.Now.TimeOfDay);
}
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void treeView1_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
contextMenuStrip1.Show(Cursor.Position);
TreeNode tn = treeView1.GetNodeAt(e.X, e.Y);
if (tn == null)
{
treeView1.SelectedNode = treeView1.TopNode;
contextMenuStrip1.Items[1].Enabled = false;
contextMenuStrip1.Items[2].Enabled = false;
contextMenuStrip1.Items[4].Enabled = false;
}
else
{
treeView1.SelectedNode = tn;
_treeNodeId = Convert.ToInt32(treeView1.SelectedNode.Name);
_treeNodeName = treeView1.SelectedNode.Text;
contextMenuStrip1.Items[1].Enabled = true;
contextMenuStrip1.Items[2].Enabled = true;
contextMenuStrip1.Items[4].Enabled = true;
}
// MessageBox.Show(treeView1.SelectedNode.FullPath);
}
if (e.Button == MouseButtons.Left)
{
TreeNode tn = treeView1.GetNodeAt(e.X, e.Y);
if (tn != null)
{
// MessageBox.Show(tn.Name+ " " + tn.Text + " " + tn.Tag);
treeView1.SelectedNode = tn;
var nodeID = Convert.ToInt32(treeView1.SelectedNode.Name);
_treeNodeId = Convert.ToInt32(treeView1.SelectedNode.Name);
_treeNodeName = treeView1.SelectedNode.Text;
using (var context = new db_sqlceEntities())
{
var query1 = from c in context.objects_place
/*join o in context.owners on c.owner_id equals o.id
* join cou in context.counters on c.id equals cou.objects_place_id
* where c.id == nodeID
* select new
* {
* fio = o.surname + " " + o.name + " " + o.patronymic,
* o.tel, counter = cou.serial_amspi, sn1 = cou.serial_r1, sn2 = cou.serial_r2
* };*/
from cou in context.counters.Where(cou => cou.objects_place_id == c.id).DefaultIfEmpty()
from o in context.owners.Where(o => o.id == c.owner_id)
where c.id == nodeID
select new
{
fio = o.surname + " " + o.name + " " + o.patronymic,
o.tel,
counter = cou.serial_amspi,
sn1 = cou.serial_r1,
sn2 = cou.serial_r2
};
var rr = query1.ToList();
if (rr.LongCount() > 0)
{
this.listView1.Items[0].SubItems[1].Text = rr.First().fio;
this.listView1.Items[1].SubItems[1].Text = rr.First().tel;
this.listView1.Items[2].SubItems[1].Text = FindRootNode(treeView1.SelectedNode).Text;
this.listView1.Items[3].SubItems[1].Text = rr.First().counter;
this.listView1.Items[4].SubItems[1].Text = rr.First().sn1;
this.listView1.Items[5].SubItems[1].Text = rr.First().sn2;
}
else
{
this.listView1.Items[0].SubItems[1].Text = "";
this.listView1.Items[1].SubItems[1].Text = "";
this.listView1.Items[2].SubItems[1].Text = "";
this.listView1.Items[3].SubItems[1].Text = "";
this.listView1.Items[4].SubItems[1].Text = "";
this.listView1.Items[5].SubItems[1].Text = "";
}
}
}
else
{
if (treeView1.TopNode != null)
{
treeView1.SelectedNode = treeView1.TopNode;
}
}
}
this.groupBox2.Text = treeView1.SelectedNode.Text;
updateDataPackagesGrid();
updateAlarmPackageGrid();
}
private void LoadMassagesInDb(Message message, Pop3Client client, int i_msg)
{
string[] separator = new string[] { "\r\n", "\n" };
MessageHeader headers = client.GetMessageHeaders(i_msg);
RfcMailAddress from = headers.From;
if (from.HasValidMailAddress && from.Address.Equals(this.mail_ppu))
{
if (message.Headers.Subject.Contains("_TEST"))
{
Debug.WriteLine("MAIL_TS");
var mail_strings =
message.FindFirstPlainTextVersion()
.GetBodyAsText()
.Split(separator, StringSplitOptions.RemoveEmptyEntries)
.Select(s => s.Split(new[] { '=' }));
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (var item in mail_strings)
{
dict.Add(item[0], item[1]);
}
using (var context = new db_sqlceEntities())
{
try
{
var package_ts = new package_ts()
{
pt = "/home/ts",
na = dict["na"],
r1 = Convert.ToInt32(dict["r1"]),
r2 = Convert.ToInt32(dict["r2"]),
pw1 = Convert.ToInt32(dict["pw1"]),
pw2 = Convert.ToInt32(dict["pw2"]),
gp = Convert.ToInt32(dict["gp"]),
te = Convert.ToInt32(dict["te"]),
vc = Convert.ToInt32(dict["vc"]),
vg = Convert.ToInt32(dict["vg"]),
ti = Convert.ToInt32(dict["ti"]),
sn1 = dict["sn1"],
sn2 = dict["sn2"],
mail_uid = client.GetMessageUid(i_msg),
ismail = true,
da = DateTime.ParseExact(dict["da"], "yyMMdd", null).Date,
date_time_inc = DateTime.Now
};
context.package_ts.Add(package_ts);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
log.Write(message.FindFirstPlainTextVersion()
.GetBodyAsText());
}
if (message.Headers.Subject.Contains("_TM"))
{
Debug.WriteLine("MAIL_TM");
var mail_strings =
message.FindFirstPlainTextVersion()
.GetBodyAsText()
.Split(separator, StringSplitOptions.RemoveEmptyEntries)
.Select(s => s.Split(new[] { '=' }));
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (var item in mail_strings)
{
dict.Add(item[0], item[1]);
}
using (var context = new db_sqlceEntities())
{
try
{
var package_tm = new package_tm()
{
pt = "/home/tm",
na = dict["na"],
ismail = true,
mail_uid = client.GetMessageUid(i_msg),
date_inc = DateTime.Now
};
context.package_tm.Add(package_tm);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (message.Headers.Subject.Contains("_ON"))
{
Debug.WriteLine("MAIL_ON");
var mail_strings =
message.FindFirstPlainTextVersion()
.GetBodyAsText()
.Trim()
.Split(separator, StringSplitOptions.RemoveEmptyEntries)
.Select(s => s.Split(new[] { '=' }));
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (var item in mail_strings)
{
dict.Add(item[0], item[1]);
}
using (var context = new db_sqlceEntities())
{
try
{
var package_on = new package_on()
{
pt = "/home/on",
na = dict["na"],
r1 = Convert.ToInt32(dict["r1"]),
r2 = Convert.ToInt32(dict["r2"]),
pw1 = Convert.ToInt32(dict["pw1"]),
pw2 = Convert.ToInt32(dict["pw2"]),
gp = Convert.ToInt32(dict["gp"]),
te = Convert.ToInt32(dict["te"]),
vc = Convert.ToInt32(dict["vc"]),
vg = Convert.ToInt32(dict["vg"]),
ti = Convert.ToInt32(dict["ti"]),
sn1 = dict["sn1"],
sn2 = dict["sn2"],
mail_uid = client.GetMessageUid(i_msg),
ismail = true,
da = DateTime.ParseExact(dict["da"], "yyMMdd", null).Date,
date_time_inc = DateTime.Now
};
context.package_on.Add(package_on);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
log.Write(message.FindFirstPlainTextVersion()
.GetBodyAsText());
}
if (message.Headers.Subject.Contains("_AL"))
{
Debug.WriteLine("MAIL_AL");
var mail_strings =
message.FindFirstPlainTextVersion()
.GetBodyAsText()
.Split(separator, StringSplitOptions.RemoveEmptyEntries)
.Select(s => s.Split(new[] { '=' }));
Dictionary <string, string> dict = new Dictionary <string, string>();
foreach (var item in mail_strings)
{
dict.Add(item[0], item[1]);
}
var wr_txt = "";
var war = Convert.ToInt32(dict["w"]);
switch (war)
{
case (0):
wr_txt = "Вскрыте крышки!";
break;
case (1):
wr_txt = "Расход за час для первого счетчика больше предельного!";
break;
case (2):
wr_txt = "Расход за час для второго счетчика больше предельного!";
break;
}
using (var context = new db_sqlceEntities())
{
try
{
var package_al = new package_al()
{
pt = "/home/wr",
na = dict["na"],
wr = war,
date_inc = DateTime.Now,
ismail = true,
mail_uid = client.GetMessageUid(i_msg),
wr_txt = wr_txt
};
context.package_al.Add(package_al);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (message.Headers.Subject.Contains("_Data"))
{
Debug.WriteLine("MAIL_IZ");
var mail_strings =
message.FindFirstPlainTextVersion()
.GetBodyAsText()
.Trim()
.Split(separator, StringSplitOptions.RemoveEmptyEntries)
.Select(s => s.Split(new[] { '=' }));
Dictionary <string, string> dict = mail_strings.ToDictionary(item => item[0], item => item[1]);
using (var context = new db_sqlceEntities())
{
try
{
string rw_1 = dict["r1"].Substring(0, 8);
string rw_2 = dict["r2"].Substring(0, 8);
string r1 = dict["r1"].Substring(8, 96);
string r2 = dict["r2"].Substring(8, 96);
// r1 = r1.Replace('g', '0');
// r2 = r2.Replace('g', '0');
r1 = Regex.Replace(r1, @"([^0-9])(\d){3}", "0000");
r2 = Regex.Replace(r2, @"([^0-9])(\d){3}", "0000");
IEnumerable <string> groups1 = Enumerable.Range(0, r1.Length / 4)
.Select(i => r1.Substring(i * 4, 4));
List <int> rw1 = new List <int>();
foreach (var grp in groups1)
{
rw1.Add(Convert.ToInt32(grp));
}
IEnumerable <string> groups2 = Enumerable.Range(0, r2.Length / 4)
.Select(i => r2.Substring(i * 4, 4));
List <int> rw2 = new List <int>();
foreach (var grp in groups2)
{
rw2.Add(Convert.ToInt32(grp));
}
string ppu_na = null;
if (!string.IsNullOrEmpty(dict["na"]))
{
ppu_na = dict["na"];
}
var package_iz = new package_iz()
{
pt = "/home/iz",
na = dict["na"],
r1 = Convert.ToInt32(rw_1),
r1_0 = Convert.ToInt32(groups1.ElementAt(0)),
r1_1 = Convert.ToInt32(groups1.ElementAt(1)),
r1_2 = Convert.ToInt32(groups1.ElementAt(2)),
r1_3 = Convert.ToInt32(groups1.ElementAt(3)),
r1_4 = Convert.ToInt32(groups1.ElementAt(4)),
r1_5 = Convert.ToInt32(groups1.ElementAt(5)),
r1_6 = Convert.ToInt32(groups1.ElementAt(6)),
r1_7 = Convert.ToInt32(groups1.ElementAt(7)),
r1_8 = Convert.ToInt32(groups1.ElementAt(8)),
r1_9 = Convert.ToInt32(groups1.ElementAt(9)),
r1_10 = Convert.ToInt32(groups1.ElementAt(10)),
r1_11 = Convert.ToInt32(groups1.ElementAt(11)),
r1_12 = Convert.ToInt32(groups1.ElementAt(12)),
r1_13 = Convert.ToInt32(groups1.ElementAt(13)),
r1_14 = Convert.ToInt32(groups1.ElementAt(14)),
r1_15 = Convert.ToInt32(groups1.ElementAt(15)),
r1_16 = Convert.ToInt32(groups1.ElementAt(16)),
r1_17 = Convert.ToInt32(groups1.ElementAt(17)),
r1_18 = Convert.ToInt32(groups1.ElementAt(18)),
r1_19 = Convert.ToInt32(groups1.ElementAt(19)),
r1_20 = Convert.ToInt32(groups1.ElementAt(20)),
r1_21 = Convert.ToInt32(groups1.ElementAt(21)),
r1_22 = Convert.ToInt32(groups1.ElementAt(22)),
r1_23 = Convert.ToInt32(groups1.ElementAt(23)),
// r1_24 = Convert.ToInt32(groups1.ElementAt(24)),
r2 = Convert.ToInt32(rw_2),
r2_0 = Convert.ToInt32(groups2.ElementAt(0)),
r2_1 = Convert.ToInt32(groups2.ElementAt(1)),
r2_2 = Convert.ToInt32(groups2.ElementAt(2)),
r2_3 = Convert.ToInt32(groups2.ElementAt(3)),
r2_4 = Convert.ToInt32(groups2.ElementAt(4)),
r2_5 = Convert.ToInt32(groups2.ElementAt(5)),
r2_6 = Convert.ToInt32(groups2.ElementAt(6)),
r2_7 = Convert.ToInt32(groups2.ElementAt(7)),
r2_8 = Convert.ToInt32(groups2.ElementAt(8)),
r2_9 = Convert.ToInt32(groups2.ElementAt(9)),
r2_10 = Convert.ToInt32(groups2.ElementAt(10)),
r2_11 = Convert.ToInt32(groups2.ElementAt(11)),
r2_12 = Convert.ToInt32(groups2.ElementAt(12)),
r2_13 = Convert.ToInt32(groups2.ElementAt(13)),
r2_14 = Convert.ToInt32(groups2.ElementAt(14)),
r2_15 = Convert.ToInt32(groups2.ElementAt(15)),
r2_16 = Convert.ToInt32(groups2.ElementAt(16)),
r2_17 = Convert.ToInt32(groups2.ElementAt(17)),
r2_18 = Convert.ToInt32(groups2.ElementAt(18)),
r2_19 = Convert.ToInt32(groups2.ElementAt(19)),
r2_20 = Convert.ToInt32(groups2.ElementAt(20)),
r2_21 = Convert.ToInt32(groups2.ElementAt(21)),
r2_22 = Convert.ToInt32(groups2.ElementAt(22)),
r2_23 = Convert.ToInt32(groups2.ElementAt(23)),
//r2_24 = Convert.ToInt32(groups2.ElementAt(24)),
pw1 = Convert.ToInt32(dict["pw1"]),
pw2 = Convert.ToInt32(dict["pw2"]),
gp = Convert.ToInt32(dict["gp"]),
te = dict["te"],
vc = Convert.ToInt32(dict["vc"]),
vg = Convert.ToInt32(dict["vg"]),
ti = Convert.ToInt32(dict["ti"]),
sn1 = dict["sn1"],
sn2 = dict["sn2"],
da = DateTime.ParseExact(dict["da"], "yyMMdd", null).Date,
ismail = true,
mail_uid = client.GetMessageUid(i_msg),
date_inc = DateTime.Now
};
context.package_iz.Add(package_iz);
context.SaveChanges();
var qu = context.counters.FirstOrDefault(c => c.serial_amspi == ppu_na);
if (qu != null)
{
qu.serial_r1 = dict["sn1"];
qu.serial_r2 = dict["sn2"];
context.SaveChanges();
}
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
log.Write(message.FindFirstPlainTextVersion()
.GetBodyAsText());
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (validateFields())
{
using (var context = new db_sqlceEntities())
{
try
{
var opt = context.options.FirstOrDefault();
if (opt != null)
{
opt.ip_addr = this.textBox1.Text;
opt.ip_port = Convert.ToInt32(this.textBox2.Text);
opt.pop_addr = this.textBox3.Text.Trim();
opt.pop_port = Convert.ToInt32(this.textBox4.Text);
opt.pop_mail = this.textBox5.Text.Trim();;
opt.pop_passwd = this.textBox6.Text.Trim();
opt.pop_ssl = this.checkBox3.Checked;
opt.ppu_mail = this.textBox7.Text.Trim();
opt.pop_int = Convert.ToInt32(this.numericUpDown1.Value);
opt.is_ip = this.checkBox1.Checked;
opt.is_mail = this.checkBox2.Checked;
opt.new_ip = checkBox4.Checked;
opt.new_ip_addr = this.textBox8.Text;
context.SaveChanges();
this.Close();
}
else
{
var opti = new options()
{
ip_addr = this.textBox1.Text,
ip_port = Convert.ToInt32(this.textBox2.Text),
pop_addr = this.textBox3.Text,
pop_port = Convert.ToInt32(this.textBox4.Text),
pop_mail = this.textBox5.Text,
pop_passwd = this.textBox6.Text,
pop_ssl = this.checkBox3.Checked,
ppu_mail = this.textBox7.Text,
pop_int = Convert.ToInt32(this.numericUpDown1.Value),
is_ip = this.checkBox1.Checked,
is_mail = this.checkBox2.Checked,
new_ip = checkBox4.Checked,
new_ip_addr = this.textBox8.Text
};
context.options.Add(opti);
context.SaveChanges();
this.Close();
}
MailService();
}
catch (EntitySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void warningDelegate()
{
var context = new db_sqlceEntities();
try
{
var w_query = context.warning_conditions.FirstOrDefault();
var tr = DateTime.Now.AddMonths(-1);
var ttr = DateTime.Now;
var query = from c in context.package_iz
where ((c.date_inc >= tr && c.date_inc <= ttr) &&
(c.vg <w_query.gprs_mod_min || c.vg> w_query.gprs_mod_max || c.gp <w_query.gprs_sig_min || c.gp> w_query.gprs_sig_max || c.vc <w_query.controller_voltage_min || c.vc> w_query.controller_voltage_max))
select new
{
na = c.na,
vc = c.vc,
vg = c.vg,
gp = c.gp
};
var results = query.ToList();
List <string> lst = new List <string>();
foreach (var item in results)
{
string txt_gp_max;
string txt_gp_min;
string txt_vg_max;
string txt_vg_min;
string txt_ct_min;
string txt_ct_max;
if (item.vg > w_query.gprs_mod_max)
{
txt_vg_max = "ППУ-РМ № " + item.na + " Напряжение GPRS модуля превышено!"; lst.Add(txt_vg_max);
}
if (item.vg < w_query.gprs_mod_min)
{
txt_vg_min = "ППУ-РМ № " + item.na + " Напряжение GPRS модуля ниже нормы!"; lst.Add(txt_vg_min);
}
if (item.gp < w_query.gprs_sig_min)
{
txt_gp_min = "ППУ-РМ № " + item.na + " Уровень GPRS сиграла ниже нормы!"; lst.Add(txt_gp_min);
}
if (item.gp > w_query.gprs_sig_max)
{
txt_gp_max = "ППУ-РМ № " + item.na + " Уровень GPRS сиграла превышен!"; lst.Add(txt_gp_max);
}
if (item.vc < w_query.controller_voltage_min)
{
txt_ct_min = "ППУ-РМ № " + item.na + " Напряжение контроллера ниже нормы!"; lst.Add(txt_ct_min);
}
if (item.vc > w_query.controller_voltage_max)
{
txt_ct_max = "ППУ-РМ № " + item.na + " Напряжение контроллера превышено!"; lst.Add(txt_ct_max);
}
}
listBox1.Items.Clear();
listBox1.Items.AddRange(lst.ToArray());
listBox1.Update();
lst.Clear();
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message);
}
}
public void parseRequest()
{
String request = streamReadLine(inputStream);
string[] tokens = request.Split(' ');
if (tokens.Length != 3)
{
throw new Exception("invalid http request line");
}
http_method = tokens[0].ToUpper();
http_url = tokens[1];
http_protocol_versionstring = tokens[2];
var spaceIndex = http_url.IndexOf("%20", System.StringComparison.Ordinal);
string s;
s = spaceIndex != -1 ? http_url.Substring(0, spaceIndex) : http_url;
var url = new Uri("http://www.example.com" + s);
var url_path = url.AbsolutePath;
NameValueCollection qscollection = HttpUtility.ParseQueryString(url.Query);
string ppu_na = null;
if (!string.IsNullOrEmpty(qscollection["na"]))
{
ppu_na = qscollection["na"];
}
//var pac = qscollection.Get(0).ToLower();
/* switch (qscollection.Get(0))
* {*/
if (url_path.IndexOf("/home/ts") > -1)
{
Debug.WriteLine("ts");
using (var context = new db_sqlceEntities())
{
try
{
var package_ts = new package_ts()
{
pt = url_path,
na = qscollection["na"],
r1 = Convert.ToInt32(qscollection["r1"]),
r2 = Convert.ToInt32(qscollection["r2"]),
pw1 = Convert.ToInt32(qscollection["pw1"]),
pw2 = Convert.ToInt32(qscollection["pw2"]),
gp = Convert.ToInt32(qscollection["gp"]),
te = Convert.ToInt32(qscollection["te"]),
vc = Convert.ToInt32(qscollection["vc"]),
vg = Convert.ToInt32(qscollection["vg"]),
ti = Convert.ToInt32(qscollection["ti"]),
sn1 = qscollection["sn1"],
sn2 = qscollection["sn2"],
ismail = false,
da = DateTime.ParseExact(qscollection["da"], "yyMMdd", null).Date,
date_time_inc = DateTime.Now
};
context.package_ts.Add(package_ts);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (url_path.IndexOf("/home/iz") > -1)
{
Debug.WriteLine("iz");
using (var context = new db_sqlceEntities())
{
try
{
string rw_1 = qscollection["r1"].Substring(0, 8);
string rw_2 = qscollection["r2"].Substring(0, 8);
string r1 = qscollection["r1"].Substring(8, 96);
string r2 = qscollection["r2"].Substring(8, 96);
IEnumerable <string> groups1 = Enumerable.Range(0, r1.Length / 4)
.Select(i => r1.Substring(i * 4, 4));
List <int> rw1 = new List <int>();
foreach (var grp in groups1)
{
rw1.Add(Convert.ToInt32(grp));
}
IEnumerable <string> groups2 = Enumerable.Range(0, r2.Length / 4)
.Select(i => r2.Substring(i * 4, 4));
List <int> rw2 = new List <int>();
foreach (var grp in groups2)
{
rw2.Add(Convert.ToInt32(grp));
}
var package_iz = new package_iz()
{
pt = url_path,
na = qscollection["na"],
r1 = Convert.ToInt32(rw_1),
r1_0 = Convert.ToInt32(groups1.ElementAt(0)),
r1_1 = Convert.ToInt32(groups1.ElementAt(1)),
r1_2 = Convert.ToInt32(groups1.ElementAt(2)),
r1_3 = Convert.ToInt32(groups1.ElementAt(3)),
r1_4 = Convert.ToInt32(groups1.ElementAt(4)),
r1_5 = Convert.ToInt32(groups1.ElementAt(5)),
r1_6 = Convert.ToInt32(groups1.ElementAt(6)),
r1_7 = Convert.ToInt32(groups1.ElementAt(7)),
r1_8 = Convert.ToInt32(groups1.ElementAt(8)),
r1_9 = Convert.ToInt32(groups1.ElementAt(9)),
r1_10 = Convert.ToInt32(groups1.ElementAt(10)),
r1_11 = Convert.ToInt32(groups1.ElementAt(11)),
r1_12 = Convert.ToInt32(groups1.ElementAt(12)),
r1_13 = Convert.ToInt32(groups1.ElementAt(13)),
r1_14 = Convert.ToInt32(groups1.ElementAt(14)),
r1_15 = Convert.ToInt32(groups1.ElementAt(15)),
r1_16 = Convert.ToInt32(groups1.ElementAt(16)),
r1_17 = Convert.ToInt32(groups1.ElementAt(17)),
r1_18 = Convert.ToInt32(groups1.ElementAt(18)),
r1_19 = Convert.ToInt32(groups1.ElementAt(19)),
r1_20 = Convert.ToInt32(groups1.ElementAt(20)),
r1_21 = Convert.ToInt32(groups1.ElementAt(21)),
r1_22 = Convert.ToInt32(groups1.ElementAt(22)),
r1_23 = Convert.ToInt32(groups1.ElementAt(23)),
// r1_24 = Convert.ToInt32(groups1.ElementAt(24)),
r2 = Convert.ToInt32(rw_2),
r2_0 = Convert.ToInt32(groups2.ElementAt(0)),
r2_1 = Convert.ToInt32(groups2.ElementAt(1)),
r2_2 = Convert.ToInt32(groups2.ElementAt(2)),
r2_3 = Convert.ToInt32(groups2.ElementAt(3)),
r2_4 = Convert.ToInt32(groups2.ElementAt(4)),
r2_5 = Convert.ToInt32(groups2.ElementAt(5)),
r2_6 = Convert.ToInt32(groups2.ElementAt(6)),
r2_7 = Convert.ToInt32(groups2.ElementAt(7)),
r2_8 = Convert.ToInt32(groups2.ElementAt(8)),
r2_9 = Convert.ToInt32(groups2.ElementAt(9)),
r2_10 = Convert.ToInt32(groups2.ElementAt(10)),
r2_11 = Convert.ToInt32(groups2.ElementAt(11)),
r2_12 = Convert.ToInt32(groups2.ElementAt(12)),
r2_13 = Convert.ToInt32(groups2.ElementAt(13)),
r2_14 = Convert.ToInt32(groups2.ElementAt(14)),
r2_15 = Convert.ToInt32(groups2.ElementAt(15)),
r2_16 = Convert.ToInt32(groups2.ElementAt(16)),
r2_17 = Convert.ToInt32(groups2.ElementAt(17)),
r2_18 = Convert.ToInt32(groups2.ElementAt(18)),
r2_19 = Convert.ToInt32(groups2.ElementAt(19)),
r2_20 = Convert.ToInt32(groups2.ElementAt(20)),
r2_21 = Convert.ToInt32(groups2.ElementAt(21)),
r2_22 = Convert.ToInt32(groups2.ElementAt(22)),
r2_23 = Convert.ToInt32(groups2.ElementAt(23)),
//r2_24 = Convert.ToInt32(groups2.ElementAt(24)),
pw1 = Convert.ToInt32(qscollection["pw1"]),
pw2 = Convert.ToInt32(qscollection["pw2"]),
gp = Convert.ToInt32(qscollection["gp"]),
te = qscollection["te"],
vc = Convert.ToInt32(qscollection["vc"]),
vg = Convert.ToInt32(qscollection["vg"]),
ti = Convert.ToInt32(qscollection["ti"]),
sn1 = qscollection["sn1"],
sn2 = qscollection["sn2"],
ismail = false,
da = DateTime.ParseExact(qscollection["da"], "yyMMdd", null).Date,
date_inc = DateTime.Now
};
context.package_iz.Add(package_iz);
context.SaveChanges();
var que = context.counters.FirstOrDefault(c => c.serial_amspi == ppu_na);
if (que != null)
{
que.serial_r1 = qscollection["sn1"];
que.serial_r2 = qscollection["sn2"];
context.SaveChanges();
}
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (url_path.IndexOf("/home/tm") > -1)
{
Debug.WriteLine("tm");
using (var context = new db_sqlceEntities())
{
try
{
var package_tm = new package_tm()
{
pt = url_path,
na = qscollection["na"],
ismail = false,
date_inc = DateTime.Now
};
context.package_tm.Add(package_tm);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (url_path.IndexOf("/home/on") > -1)
{
Debug.WriteLine("on");
using (var context = new db_sqlceEntities())
{
try
{
var package_on = new package_on()
{
pt = url_path,
na = qscollection["na"],
r1 = Convert.ToInt32(qscollection["r1"]),
r2 = Convert.ToInt32(qscollection["r2"]),
pw1 = Convert.ToInt32(qscollection["pw1"]),
pw2 = Convert.ToInt32(qscollection["pw2"]),
gp = Convert.ToInt32(qscollection["gp"]),
te = Convert.ToInt32(qscollection["te"]),
vc = Convert.ToInt32(qscollection["vc"]),
vg = Convert.ToInt32(qscollection["vg"]),
ti = Convert.ToInt32(qscollection["ti"]),
sn1 = qscollection["sn1"],
sn2 = qscollection["sn2"],
ismail = false,
da = DateTime.ParseExact(qscollection["da"], "yyMMdd", null).Date,
date_time_inc = DateTime.Now
};
context.package_on.Add(package_on);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if (url_path.IndexOf("/home/al") > -1)
{
Debug.WriteLine("al");
var wr_txt = "";
var war = Convert.ToInt32(qscollection.Get(2));
switch (war)
{
case (0):
wr_txt = "Вскрыте крышки!";
break;
case (1):
wr_txt = "Расход за час для первого счетчика больше предельного!";
break;
case (2):
wr_txt = "Расход за час для второго счетчика больше предельного!";
break;
}
using (var context = new db_sqlceEntities())
{
try
{
var package_al = new package_al()
{
pt = url_path,
na = qscollection["na"],
wr = war,
date_inc = DateTime.Now,
ismail = false,
wr_txt = wr_txt
};
context.package_al.Add(package_al);
context.SaveChanges();
var query1 = from c in context.objects_place
from cou in context.counters.Where(cou => cou.objects_place_id == c.id).DefaultIfEmpty()
where cou.serial_amspi == package_al.na
select new
{
c.name
};
string rr = query1.FirstOrDefault().name;
MessageBox.Show("ППУ-РМ №: " + package_al.na + " " + rr + " - " + package_al.wr_txt, "АВАРИЯ!",
MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
}
catch (DbEntityValidationException ex)
{
MessageBox.Show(ex.ToString());
}
}
}
log.Write(http_url);
}
