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);
}
