public bool Recuperar_Dotacion_DB()
{
try {
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var dt = db.ExecQuery(QueryListAll, sConexion);
if (dt.Rows.Count > 0)
{
this.personas = new List <Persona>();
foreach (DataRow row in dt.Rows)
{
var per = new Persona();
try {
per.id = Convert.ToInt32(cryp.Desencriptar(row["Id"].ToString()));
per.ape = cryp.Desencriptar(row["Ape"].ToString());
per.nom = cryp.Desencriptar(row["Nom"].ToString());
per.tar = cryp.Desencriptar(row["Tar"].ToString());
per.doc = Convert.ToInt32(cryp.Desencriptar(row["Doc"].ToString()));
this.personas.Add(per);
}
catch {
continue;
}
}
return(true);
}
throw new Exception();
}
catch
{
return(false);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUser.Text == user_adm && txtPass.Text == pass_adm)
{
LoguearUsuario(true);
return;
}
DataBase db = new DataBase();
string sConexion = db.GenerarConexionString(DataBase.getDefaultPathConfig());
string ConsultaSQL = "SELECT COUNT(Id) as login FROM usr WHERE name = '@name' AND pass = '******';";
CCryptorEngine cryp = new CCryptorEngine();
ConsultaSQL = ConsultaSQL.Replace("@name", cryp.Encriptar(txtUser.Text));
ConsultaSQL = ConsultaSQL.Replace("@pass", cryp.EncodeMD5(txtPass.Text));
DataTable dt = db.ExecQuery(ConsultaSQL, sConexion);
if ((int)(dt.Rows[0]["login"]) != 1)
{
MessageBox.Show("El nombre de usuario o la contraseña introducidos no son correctos.", "Atención", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUser.SelectAll();
txtPass.SelectAll();
return;
}
LoguearUsuario(false);
}
public static bool Actualizar_Usuario_Validado(string user, string pass)
{
DataBase db = new DataBase();
string sConexion = db.GenerarConexionString(DataBase.getDefaultPathConfig());
string ConsultaSQL = QueryVerificarExistenciaUsuario;
CCryptorEngine cryp = new CCryptorEngine();
ConsultaSQL = ConsultaSQL.Replace("@name", cryp.Encriptar(user));
ConsultaSQL = ConsultaSQL.Replace("@pass", cryp.EncodeMD5(pass));
DataTable dt = db.ExecQuery(ConsultaSQL, sConexion);
//Existe el usuario?
if ((int)(dt.Rows[0]["login"]) < 1)
{
// Agrego al usuario Logueado por Web
ConsultaSQL = QueryInsertarUsuario;
}
else
{
// Actualizo la pass del usuario
ConsultaSQL = QueryActualizarUsuario;
}
ConsultaSQL = ConsultaSQL.Replace("@name", cryp.Encriptar(user));
ConsultaSQL = ConsultaSQL.Replace("@pass", cryp.EncodeMD5(pass));
return(db.ExecNonQuery(ConsultaSQL, sConexion));
}
public static void Eliminar_Usuario_Local()
{
DataBase db = new DataBase();
string sConexion = db.GenerarConexionString(DataBase.getDefaultPathConfig());
string ConsultaSQL = QueryEliminarUsuario;
CCryptorEngine cryp = new CCryptorEngine();
ConsultaSQL = ConsultaSQL.Replace("@name", cryp.Encriptar(user_name_login));
db.ExecNonQuery(ConsultaSQL, sConexion);
}
private void button1_Click(object sender, EventArgs e)
{
if (txtOriginal.Text.CompareTo(string.Empty) == 0)
{
return;
}
CCryptorEngine c = new CCryptorEngine();
txtMD5.Text = c.EncodeMD5(txtOriginal.Text);
txtEncriptado.Text = c.Encriptar(txtOriginal.Text);
txtDesencriptado.Text = c.Desencriptar(txtEncriptado.Text);
}
public DataTable Get_Edificios()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathConfig());
var query = QueryTodos;
return(db.ExecQuery(query, sConexion));
}
catch
{
return(null);
}
}
public DataTable Get_Lotes_Informados()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryLotesInf;
return(db.ExecQuery(query, sConexion));
}
catch
{
return(null);
}
}
public bool Grabar_Dotacion_JS()
{
try
{
var cryp = new CCryptorEngine();
var path_file = DataBase.getDefaultPathDotacionJsCryp();
var dot_js_cryp = cryp.Encriptar(JsonConvert.SerializeObject(this.personas));
System.IO.File.WriteAllText(path_file, dot_js_cryp);
return(true);
}
catch
{
return(false);
}
}
public static int Cantidad_De_Reg_Para_Informar()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryExistenRegistrosParaInformar;
var dt = db.ExecQuery(query, sConexion);
return(Convert.ToInt32(dt.Rows[0]["REG_PARA_INF"]));
}
catch
{
return(-1);
}
}
public Boolean Actualizar_Edificio_Sel()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathConfig());
db.ExecNonQuery(QueryDeselEdif, sConexion);
var query = QueryActualizarEdiSel.Replace("@Id", this.id.ToString());
return(db.ExecNonQuery(query, sConexion));
}
catch
{
return(false);
}
}
public bool Recuperar_Dotacion_JS()
{
try
{
var cryp = new CCryptorEngine();
var path_file = DataBase.getDefaultPathDotacionJsCryp();
var dot_js = cryp.Desencriptar(System.IO.File.ReadAllText(path_file));
this.personas = JsonConvert.DeserializeObject <List <Persona> >(dot_js);
return(true);
}
catch (Exception ex)
{
this._error_desc = ex.Message;
return(false);
}
}
public bool Marcar_Registros_No_Informados()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryCrearNuevoLote;
query = query.Replace("@lot", cryp.Encriptar(this.id));
query = query.Replace("@int", cryp.Encriptar("1")); // Es el primer intento de informar
return(db.ExecNonQuery(query, sConexion));
}
catch
{
return(false);
}
}
public bool Insert_Base_Local_Masivo(DataBase db)
{
try
{
var cryp = new CCryptorEngine();
var query = QueryInsert;
query = query.Replace("@Ape", cryp.Encriptar(this.ape));
query = query.Replace("@Nom", cryp.Encriptar(this.nom));
query = query.Replace("@Doc", cryp.Encriptar(this.doc.ToString()));
query = query.Replace("@Tar", cryp.Encriptar(this.tar));
query = query.Replace("@Id", cryp.Encriptar(this.id.ToString()));
return(db.ExecNonQueryMasivo(query));
}
catch
{
return(false);
}
}
// private static string QuerySelect = "SELECT TOP 1 * FROM Dot WHERE Doc = @Doc OR Tar = '@Tar';";
// private static string QueryListAll = "SELECT * FROM Dot;";
public bool Fecha_Actual_Es_Mayor_Ult_Fecha_Grabacion(ref DateTime ult_fecha_grabada)
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var dt = db.ExecQuery(QueryUltFecha, sConexion);
if (dt.Rows.Count < 1)
{
return(true); // No hay registros ingresados
}
ult_fecha_grabada = DateTime.ParseExact(cryp.Desencriptar((string)dt.Rows[0]["fec"]), "yyyyMMdd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
return(ult_fecha_grabada.CompareTo(DateTime.Now) < 0);
}
catch
{
return(false);
}
}
public bool Existe_Base_Local()
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryExiste;
query = query.Replace("@Id", cryp.Encriptar(this.id.ToString()));
var dt = db.ExecQuery(query, sConexion);
if (dt.Rows.Count > 0 && Convert.ToInt32(dt.Rows[0]["Existe"]) == 1)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool Insert(Persona per, bool es_ingreso, bool reg_x_doc)
{
try
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryInsert
.Replace("@Pid", cryp.Encriptar(per.id.ToString()))
.Replace("@Fec", cryp.Encriptar(DateTime.Now.ToString("yyyyMMdd HH:mm:ss")))
.Replace("@Ing", es_ingreso.ToString().ToUpper())
.Replace("@Usr", cryp.Encriptar(Seguridad.user_name_login))
.Replace("@Edi", cryp.Encriptar(Seguridad.edificio.id.ToString()))
.Replace("@Rdc", cryp.Encriptar(reg_x_doc.ToString()));
db.ExecNonQuery(query, sConexion);
return(true);
}
catch
{
return(false);
}
}
private void Cargar_Grilla_Lotes_Informados()
{
var cryp = new CCryptorEngine();
var lca = new LoteControlAcceso();
var dt = lca.Get_Lotes_Informados();
foreach (DataRow row in dt.Rows)
{
if (row["LOTE"].ToString() == string.Empty)
{
row["LOTE"] = "< Registros sin Lote >";
}
else
{
row["LOTE"] = cryp.Desencriptar(row["LOTE"].ToString());
}
}
dgvLotes.DataSource = dt;
foreach (DataGridViewColumn col in dgvLotes.Columns)
{
col.Width = ((dgvLotes.Width - 45) / dgvLotes.Columns.Count);
}
}
public bool Cargar_Registros_Del_Lote()
{
var db = new DataBase();
var cryp = new CCryptorEngine();
var sConexion = db.GenerarConexionString(DataBase.getDefaultPathDB());
var query = QueryRegLote;
query = query.Replace("@lot", cryp.Encriptar(this.id));
var dt = db.ExecQuery(query, sConexion);
this.registros = new List <RegistroControlAcceso>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var rca = new RegistroControlAcceso();
try
{
rca.id = Convert.ToInt32(row["Id"]);
rca.per_id = Convert.ToInt32(cryp.Desencriptar(row["pid"].ToString()));
rca.fecha = DateTime.ParseExact(cryp.Desencriptar(row["fec"].ToString()), "yyyyMMdd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
rca.es_ingreso = (Convert.ToInt32(row["ing"]) != 0? true : false);
rca.usu = cryp.Desencriptar(row["usr"].ToString());
rca.edif = Convert.ToInt32(cryp.Desencriptar(row["edi"].ToString()));
try { rca.reg_x_doc = (cryp.Desencriptar(row["rdc"].ToString()) == true.ToString() ? true : false); }
catch { rca.reg_x_doc = false; }
this.registros.Add(rca);
}
catch
{
continue;
}
}
return(true);
}
return(false);
}
