public static Bkp_Backup Select(int id) { try { Bkp_Backup objTipo = null; IDbConnection objConexao; IDbCommand objCommand; IDataReader objDataReader; string sql = "SELECT * FROM bkp_backup WHERE bkp_codigo = ?bkp_codigo"; objConexao = Mapped.Connection(); objCommand = Mapped.Command(sql, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?bkp_codigo", id)); objDataReader = objCommand.ExecuteReader(); while (objDataReader.Read()) { objTipo = new Bkp_Backup(); objTipo.Bkp_codigo = Convert.ToInt32(objDataReader["bkp_codigo"]); objTipo.Bkp_nome = objDataReader["bkp_nome"].ToString(); objTipo.Bkp_diretorio = objDataReader["bkp_diretorio"].ToString(); objTipo.Bkp_data = Convert.ToDateTime(objDataReader["bkp_data"]); } objDataReader.Close(); objConexao.Close(); objCommand.Dispose(); objConexao.Dispose(); objDataReader.Dispose(); return(objTipo); } catch (Exception e) { return(null); } }
public static int Update(Bkp_Backup backup) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objCommand; string sql = "UPDATE bkp_backup SET (bkp_nome = ?bkp_nome, bkp_diretotio = ?bkp_diretorio, bkp_data = ?bkp_data) "; sql += "WHERE bkp_codigo = ?bkp_codigo"; objConexao = Mapped.Connection(); objCommand = Mapped.Command(sql, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?bkp_nome", backup.Bkp_nome)); objCommand.Parameters.Add(Mapped.Parameter("?bkp_diretotio", backup.Bkp_diretorio)); objCommand.Parameters.Add(Mapped.Parameter("?bkp_data", backup.Bkp_data)); objCommand.ExecuteNonQuery(); objConexao.Close(); objCommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }
protected void lkbExportar_Click(object sender, EventArgs e) { string arq = FazerBackup(); Response.Write(@"<script language='javascript'>alert('Exportação realizada com sucesso.');</script>"); Bkp_Backup backup = new Bkp_Backup(); backup.Bkp_nome = arq; backup.Bkp_data = DateTime.Now; switch (Bkp_BackupDB.Insert(backup)) { case 0: Response.Write(@"<script language='javascript'>alert('Cadastro Efetuado com Sucesso');</script>"); CarregarGrid(); break; case -2: Response.Write(@"<script language='javascript'>alert('Cadastro Não Efetuado');</script>"); break; } }
public static int Insert(Bkp_Backup backup) { int retorno = 0; try { IDbConnection objConexao; IDbCommand objCommand; string sql = "INSERT INTO bkp_backup (bkp_nome, bkp_data) VALUES (?bkp_nome, ?bkp_data)"; objConexao = Mapped.Connection(); objCommand = Mapped.Command(sql, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?bkp_nome", backup.Bkp_nome)); objCommand.Parameters.Add(Mapped.Parameter("?bkp_data", backup.Bkp_data)); objCommand.ExecuteNonQuery(); objConexao.Close(); objCommand.Dispose(); objConexao.Dispose(); } catch (Exception e) { retorno = -2; } return(retorno); }