private void DeleteSignals(int PlcID)
{
DBLite db = new DBLite("delete from PLC_Signal where PLC=@id");
db.AddParameter("id", PlcID, DbType.Int32);
db.Exec();
}
private void LoadPlc()
{
DBLite db = new DBLite("select Name, Desc, IP, Rack, Slot, Type from PLC where ID=@id");
db.AddParameter("id", _id, DbType.Int32);
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.Read())
{
_name = dr.GetString(dr.GetOrdinal("Name"));
_ip = dr.GetString(dr.GetOrdinal("IP"));
_rack = dr.GetInt32(dr.GetOrdinal("Rack"));
_slot = dr.GetInt32(dr.GetOrdinal("Slot"));
switch (dr.GetString(dr.GetOrdinal("Type")))
{
case "s7-1500":
_type = Plc.S7Type.S71500;
break;
case "s7-1200":
_type = Plc.S7Type.S71200;
break;
case "s7-400":
_type = Plc.S7Type.S7400;
break;
case "s7-300":
_type = Plc.S7Type.S7300;
break;
}
}
}
}
private void smazatToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Delete PLC?", "Delete PLC", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
int id = Convert.ToInt32(treeView1.SelectedNode.Tag);
if (id >= 0)
{
// Signals
DBLite dbsignals = new DBLite("delete from PLC_Signal where PLC=@id");
dbsignals.AddParameter("id", id, DbType.Int32);
dbsignals.Exec();
// PLC
DBLite db = new DBLite("delete from PLC where ID=@id");
db.AddParameter("id", id, DbType.Int32);
db.Exec();
// Close
CloseEdit();
}
LoadTree();
}
private void AddProductBTN_Click(object sender, EventArgs e)
{
double result;
if (!(double.TryParse(PriceTXT.Text, out result)))
{
lblWarning.Text = "Enter a valid Value!";
lblWarning.Visible = true;
return;
}
if (NewProduct != null)
{
NewProduct = new Product {
ID = NewProduct.ID, Price = Convert.ToDouble(PriceTXT.Text), ProductName = ProductTXT.Text
};
DB.Update(NewProduct);
}
else
{
NewProduct = new Product();
NewProduct.ProductName = ProductTXT.Text.Trim();
NewProduct.Price = Convert.ToDouble(PriceTXT.Text.Trim());
DBLite db = new DBLite();
db.Add(NewProduct);
}
this.DialogResult = DialogResult.OK;
}
private void btn_ok_Click(object sender, EventArgs e)
{
try {
if (!string.IsNullOrEmpty(txt_ip.Text) && !string.IsNullOrEmpty(txt_name.Text))
{
if (!Test())
{
if (MessageBox.Show("Unable to connect to PLC, continue anyway?", "Unable to connect", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
if (!Edit)
{
if (!PLCExists())
{
DBLite db = new DBLite("insert into PLC values (null, @name, ifnull(@desc,''), @ip, @r, @s, @type)");
db.AddParameter("name", txt_name.Text, DbType.String);
db.AddParameter("desc", txt_desc.Text, DbType.String);
db.AddParameter("ip", txt_ip.Text, DbType.String);
db.AddParameter("r", rack.Value, DbType.Int32);
db.AddParameter("s", slot.Value, DbType.Int32);
db.AddParameter("type", combo_typ.SelectedValue.ToString(), DbType.String);
db.Exec();
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("There is already PLC with this name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
if (!PLCExists())
{
DBLite db = new DBLite("update PLC set Name=@name, Desc=@desc, IP=@ip, Rack=@r, Slot=@s, Type=@type where ID=@id ");
db.AddParameter("name", txt_name.Text, DbType.String);
db.AddParameter("desc", txt_desc.Text, DbType.String);
db.AddParameter("ip", txt_ip.Text, DbType.String);
db.AddParameter("r", rack.Value, DbType.Int32);
db.AddParameter("s", slot.Value, DbType.Int32);
db.AddParameter("type", combo_typ.SelectedValue.ToString(), DbType.String);
db.AddParameter("id", ID, DbType.Int32);
db.Exec();
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("There is already PLC with this name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
} catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error while saving", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadTypes()
{
combo_typ.Items.Clear();
DBLite db = new DBLite("select ID, Name from PLC_type");
DataTable dt = db.ExecTable();
combo_typ.DataSource = dt;
combo_typ.ValueMember = "ID";
combo_typ.DisplayMember = "Name";
combo_typ.SelectedIndex = 0;
}
private void LoadSignals()
{
// TODO: GetPlcID is not needed, ID is already known
// TODO: Should use _id;
int plcid = GetPlcID();
DBLite db = new DBLite("select Addr, Desc, repre from PLC_Signal where PLC=@id");
db.AddParameter("id", plcid, DbType.Int32);
using (SQLiteDataReader dr = db.ExecReader())
{
while (dr.Read())
{
dataGridView1.Rows.Add();
int newrow = dataGridView1.Rows.Count - 2;
string addr = "";
string desc = "";
string repre = "";
if (!dr["Addr"].Equals(DBNull.Value))
{
addr = dr.GetString(dr.GetOrdinal("Addr"));
}
if (!dr["Desc"].Equals(DBNull.Value))
{
desc = dr.GetString(dr.GetOrdinal("Desc"));
}
if (!dr["repre"].Equals(DBNull.Value))
{
repre = dr.GetString(dr.GetOrdinal("repre"));
}
dataGridView1.Rows[newrow].Cells["address"].Value = string.IsNullOrEmpty(addr) ? null : addr;
dataGridView1.Rows[newrow].Cells["desc"].Value = desc;
if (!string.IsNullOrEmpty(addr))
{
dataGridView1_CellEndEdit(dataGridView1, new DataGridViewCellEventArgs(dataGridView1.Rows[newrow].Cells["address"].ColumnIndex, dataGridView1.Rows[newrow].Index));
}
dataGridView1.Rows[newrow].Cells["format"].Value = repre.ToUpper();
}
dataGridView1.Update();
}
}
private void LoadTree()
{
treeView1.Nodes.Clear();
DBLite db = new DBLite("select PLC.ID as ID, PLC.Name as Name, PLC_type.Name as Type from PLC left join PLC_Type on PLC.Type=PLC_type.ID");
using (SQLiteDataReader dr = db.ExecReader())
{
while (dr.Read())
{
TreeNode node = new TreeNode(dr.GetString(dr.GetOrdinal("Name")) + " [" + dr.GetString(dr.GetOrdinal("Type")) + "]");
node.Tag = dr.GetInt32(dr.GetOrdinal("ID"));
treeView1.Nodes.Add(node);
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtAmount.Text))
{
MessageBox.Show("თანხის ველი ცარიელია", "გაფრთხილება");
}
if (Changes < 0)
{
MessageBox.Show("კლიენტის თანხა ნაკლებია შეკვეთის თანხასთან შედარებით", "გაფრთხილება");
}
DBLite db = new DBLite();
db.AddOrder(List);
}
private void combo_typ_SelectedIndexChanged(object sender, EventArgs e)
{
if (combo_typ.SelectedIndex >= 0)
{
DBLite db = new DBLite("select Def_Rack, Def_Slot from PLC_type where ID like @id");
db.AddParameter("id", combo_typ.SelectedValue, DbType.String);
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.Read())
{
rack.Value = dr.GetValue(0).Equals(DBNull.Value) ? 0 : dr.GetInt32(0);
slot.Value = dr.GetValue(1).Equals(DBNull.Value) ? 0 : dr.GetInt32(1);
}
}
}
}
private int GetPlcID()
{
int id = 0;
DBLite db = new DBLite("select ID from PLC where Name like @name and IP like @ip");
db.AddParameter("name", this._name, DbType.String);
db.AddParameter("ip", this._ip, DbType.String);
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.Read())
{
id = dr.GetInt32(0);
}
}
return(id);
}
private void TestDB()
{
try {
DBLite db = new DBLite("select 1");
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.Read())
{
return;
}
}
} catch (Exception ex)
{
MessageBox.Show(ex.Message, "Unable to read from database", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
private void LoadPLC()
{
DBLite db = new DBLite("SELECT Name,Desc,IP,Rack,Slot,Type FROM PLC where ID=@id");
db.AddParameter("id", ID, DbType.Int32);
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.Read())
{
txt_name.Text = dr.GetString(dr.GetOrdinal("Name"));
txt_ip.Text = dr.GetString(dr.GetOrdinal("IP"));
txt_desc.Text = dr.GetValue(dr.GetOrdinal("Desc")) == DBNull.Value ? "" : dr.GetString(dr.GetOrdinal("Desc"));
combo_typ.SelectedValue = dr.GetString(dr.GetOrdinal("Type"));
rack.Value = dr.GetInt32(dr.GetOrdinal("Rack"));
slot.Value = dr.GetInt32(dr.GetOrdinal("Slot"));
}
}
}
private void SaveSignals(int PlcID)
{
try
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string desc = "";
string repre = "";
string addr = "";
if (row.Cells["desc"].Value != null)
{
desc = row.Cells["desc"].Value.ToString();
}
if (row.Cells["address"].Value != null)
{
addr = row.Cells["address"].Value.ToString();
}
if (row.Cells["format"].Value != null)
{
repre = row.Cells["format"].Value.ToString();
}
DBLite db = new DBLite("insert into PLC_Signal values (@id, @addr, @desc, @repre)");
db.AddParameter("id", this._id, DbType.Int32);
db.AddParameter("addr", addr, DbType.String);
db.AddParameter("desc", desc, DbType.String);
db.AddParameter("repre", repre.ToLower(), DbType.String);
db.Exec();
db = null;
}
MessageBox.Show("Successfully saved", "Saved");
}catch (Exception ex)
{
MessageBox.Show(ex.Message, "Save error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private Boolean PLCExists()
{
string query = "select * from PLC where Name like @name";
if (Edit)
{
query = "select * from PLC where Name like @name and ID<>@id";
}
DBLite db = new DBLite(query);
db.AddParameter("name", txt_name.Text, DbType.String);
if (Edit)
{
db.AddParameter("id", ID, DbType.Int32);
}
using (SQLiteDataReader dr = db.ExecReader())
{
if (dr.HasRows)
{
return(true);
}
}
return(false);
}
