public int ExecuteNonQuery(string Sql) { cnn.Open(); int reg = cnn.ExecuteNonQuery(Sql); cnn.Close(); return(reg); }
public bool chkLog(string Login, string psw) { cnn.Open(); string query = "SELECT Persona.Identificacion FROM Usuario INNER JOIN Persona ON Persona.idPersona = Usuario.idUsuario WHERE Usuario.Login = "******"Usuario"); string validate = "SELECT idUsuario,idPerfil FROM Usuario WHERE esActivo = 1 AND Login = "******" AND eClave = " + fun.gsql(fun.Sha256(fun.Sha256(psw) + fun.Sha256(id))) + " AND Clave = " + fun.gsql(fun.Sha256(psw)); cnn.dtFill(dtU, validate); bool rt = fun.TryBool(dtU); if (rt) { DataRow drU = dtU.Rows[0]; Variables.idUsuarioActual = fun.TryInt(drU["idUsuario"]); Variables.idPerfilUsuarioActual = fun.TryInt(drU["idPerfil"]); } cnn.Close(); return(rt); }
public static string getMaxString(string nomTable, string column, string filter = ";") { DataTable dt = new DataTable(); int max = 0, num = 0; afgCon cn = new afgCon(Variables.strCon); cn.Open(); string cmd = "SELECT " + column + " FROM " + nomTable + " " + filter; cn.dtFill(dt, cmd); foreach (DataRow dr in dt.Rows) { num = TryInt(dr[column]); if (num > max) { max = num; } } max++; return(max.ToString()); }