private void EditButton_Click(object sender, EventArgs e)
{
readerConnectionML = new ReaderConnectionML();
readerConnectionML.id = int.Parse(ConectioncomboBox.SelectedValue.ToString());
EnabledControls(true);
SaveButton.Enabled = true;
}
private void LoadData()
{
try
{
BussinesLayer.ModelReaderBLL modelReaderBLL = new BussinesLayer.ModelReaderBLL();
readerConnectionBLL = new ReaderConnectionBLL();
readerConnectionML = new ReaderConnectionML();
dtModelReader = modelReaderBLL.All();
ModelComboBox.DisplayMember = ModelReaderML.DataBase.brand;
ModelComboBox.ValueMember = ModelReaderML.DataBase.id;
ModelComboBox.DataSource = dtModelReader;
dtConnection = readerConnectionBLL.All();
ConectioncomboBox.DisplayMember = ReaderConnectionML.DataBase.name;
ConectioncomboBox.ValueMember = ReaderConnectionML.DataBase.id;
ConectioncomboBox.DataSource = dtConnection;
LoadControls();
EnabledControls(false);
}
catch (Exception ex)
{
MessageBox.Show(string.Format("LoadData: {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int Update(ReaderConnectionML readerConnectionML, string ConnectionString)
{
try
{
if (readerConnectionML != null)
{
if (readerConnectionML.isDefault)
{
StringBuilder QueryUpdate = new StringBuilder();
QueryUpdate.AppendFormat("UPDATE {0} SET ", TableName);
QueryUpdate.AppendFormat("{0} = Convert(Bit, 'false')", ReaderConnectionML.DataBase.isDefault);
SqlConnection ConexionUpdate = new SqlConnection
{
ConnectionString = ConnectionString
};
using (SqlCommand cmd2Update = new SqlCommand(QueryUpdate.ToString(), ConexionUpdate))
{
ConexionUpdate.Open();
cmd2Update.ExecuteScalar();
if (ConexionUpdate.State == System.Data.ConnectionState.Open)
{
ConexionUpdate.Close();
}
}
}
StringBuilder Query = new StringBuilder();
Query.AppendFormat("UPDATE {0} SET ", TableName);
Query.AppendFormat("{0} = '{1}', ", ReaderConnectionML.DataBase.name, readerConnectionML.name);
Query.AppendFormat("{0} = '{1}', ", ReaderConnectionML.DataBase.ip, readerConnectionML.ip);
Query.AppendFormat("{0} = '{1}', ", ReaderConnectionML.DataBase.port, readerConnectionML.port);
Query.AppendFormat("{0} = convert(bit, '{1}'), ", ReaderConnectionML.DataBase.isDefault, readerConnectionML.isDefault);
Query.AppendFormat("{0} = {1}, ", ReaderConnectionML.DataBase.idReader, readerConnectionML.idReader);
Query.AppendFormat("idUserUpdate = {0}, ", idUser);
Query.AppendLine("dateUpdate = GETDATE() ");
Query.AppendFormat("WHERE id = {0}", readerConnectionML.id);
SqlConnection Conexion = new SqlConnection()
{
ConnectionString = ConnectionString
};
Conexion.Open();
SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion);
cmd2.ExecuteNonQuery();
Conexion.Close();
return(readerConnectionML.id);
}
return(0);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Update : {1}", core, ex));
}
}
private void AddButton_Click(object sender, EventArgs e)
{
CancelButton.Visible = true;
AddButton.Enabled = false;
ClearControls();
ConectioncomboBox.Enabled = false;
EnabledControls(true);
readerConnectionML = new ReaderConnectionML();
readerConnectionML.id = 0;
SaveButton.Enabled = true;
}
public int save(ReaderConnectionML readerConnectionML)
{
try
{
if (readerConnectionML.id > 0)
{
return(readerConnectionDAL.Update(readerConnectionML, ConnectionStrings));
}
else
{
return(readerConnectionDAL.Insert(readerConnectionML, ConnectionStrings));
}
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Save: {1}", core, ex));
}
}
private void LoadConnection(int id)
{
try
{
ReaderConnectionBLL readerConnectionBLL = new ReaderConnectionBLL();
ReaderConnectionML readerConnectionML = readerConnectionBLL.GetConnectionById(id);
NameConectiontextBox.Text = readerConnectionML.name;
IPtextBox.Text = readerConnectionML.ip;
PortTextBox.Text = readerConnectionML.port;
DefaultCheckBox.Checked = readerConnectionML.isDefault;
ModelComboBox.SelectedItem = readerConnectionML.idReader;
}
catch (Exception ex)
{
MessageBox.Show(string.Format("LoadConnection: {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool connect()
{
try
{
ReaderConnectionBLL readerConnectionBLL = new ReaderConnectionBLL();
ReaderConnectionML readerConnectionML = readerConnectionBLL.GetActiveConnection();
if (readerConnectionML != null)
{
return(connect(readerConnectionML.ip, int.Parse(readerConnectionML.port)));
}
else
{
throw new Exception("No se encontró una conexión valida");
}
}catch (Exception ex)
{
throw new Exception(string.Format("ZKTecoDeviceBLL.connect: {0}", ex.Message));
}
}
public ReaderConnectionML GetEntity(DataRow row)
{
try
{
if (row != null)
{
ReaderConnectionML readerConnectionML = new ReaderConnectionML()
{
ip = (row[ReaderConnectionML.DataBase.ip] != DBNull.Value) ? row[ReaderConnectionML.DataBase.ip].ToString() : string.Empty,
port = (row[ReaderConnectionML.DataBase.port] != DBNull.Value) ? row[ReaderConnectionML.DataBase.port].ToString() : string.Empty,
name = (row[ReaderConnectionML.DataBase.name] != DBNull.Value) ? row[ReaderConnectionML.DataBase.name].ToString() : string.Empty,
isDefault = (row[ReaderConnectionML.DataBase.isDefault] != DBNull.Value) ? Convert.ToBoolean(row[ReaderConnectionML.DataBase.isDefault].ToString()) : false,
};
return(readerConnectionML);
}
return(null);
}catch (Exception ex)
{
throw new Exception(String.Format("{0}.ReaderConnectionML : {1}", core, ex));
}
}
public int Insert(ReaderConnectionML readerConnectionML, string ConnectionString)
{
try
{
if (readerConnectionML != null)
{
if (readerConnectionML.isDefault)
{
StringBuilder QueryUpdate = new StringBuilder();
QueryUpdate.AppendFormat("UPDATE {0} SET ", TableName);
QueryUpdate.AppendFormat("{0} = Convert(Bit, 'false')", ReaderConnectionML.DataBase.isDefault);
SqlConnection ConexionUpdate = new SqlConnection
{
ConnectionString = ConnectionString
};
using (SqlCommand cmd2 = new SqlCommand(QueryUpdate.ToString(), ConexionUpdate))
{
ConexionUpdate.Open();
cmd2.ExecuteScalar();
if (ConexionUpdate.State == System.Data.ConnectionState.Open)
{
ConexionUpdate.Close();
}
}
}
StringBuilder Query = new StringBuilder();
Query.AppendFormat("INSERT INTO {0}", TableName);
Query.AppendFormat("({0}, {1}, {2}, {3}, {4}, _registry, idUserInsert, dateInsert)", ReaderConnectionML.DataBase.name, ReaderConnectionML.DataBase.ip, ReaderConnectionML.DataBase.port, ReaderConnectionML.DataBase.isDefault, ReaderConnectionML.DataBase.idReader);
Query.AppendLine(" VALUES( ");
Query.AppendFormat(" '{0}', ", readerConnectionML.name);
Query.AppendFormat(" '{0}', ", readerConnectionML.ip);
Query.AppendFormat(" '{0}', ", readerConnectionML.port);
Query.AppendFormat(" convert(bit, '{0}'), ", readerConnectionML.isDefault);
Query.AppendFormat(" {0}, ", readerConnectionML.idReader);
Query.AppendLine(" 1, ");
Query.AppendFormat(" {0}, ", idUser);
Query.AppendLine(" GETDATE()) ");
Query.AppendLine(" SELECT CAST(scope_identity() AS int)");
SqlConnection Conexion = new SqlConnection
{
ConnectionString = ConnectionString
};
using (SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion))
{
Conexion.Open();
int newID = (Int32)cmd2.ExecuteScalar();
if (Conexion.State == System.Data.ConnectionState.Open)
{
Conexion.Close();
}
return(newID);
}
}
return(0);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Insert : {1}", core, ex));
}
}
