public static List <TblDatabaseManagement> GetDBToWork(StatusDB statusDB)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
return(context.TblDatabaseManagements.Where(x => x.FkStatusId == (int)statusDB).ToList());
}
}
private void CarregarStatus()
{
StatusDB statusDB = new StatusDB();
ddlStatus.DataSource = statusDB.ConsultarList();
ddlStatus.DataValueField = "Id";
ddlStatus.DataValueField = "Nome";
ddlStatus.DataBind();
}
public static Processo Select(int pro_cod)
{
Processo pro = null;
try
{
IDbConnection objConexao;
IDbCommand objComando;
IDataReader objReader;
objConexao = Mapped.Connection();
string sql = "select * from pro_processo where pro_cod=?pro_cod;";
objComando = Mapped.Command(sql, objConexao);
objComando.Parameters.Add(Mapped.Parameter("?pro_cod", pro_cod));
objReader = objComando.ExecuteReader();
int status = 0;
int modelo = 0;
int requerente = 0;
while (objReader.Read())
{
pro = new Processo();
pro.Pro_cod = Convert.ToInt32(objReader["pro_cod"]);
pro.Pro_numeroProcesso = Convert.ToString(objReader["pro_numeroProcesso"]);
pro.Pro_dataPedido = Convert.ToString(objReader["pro_dataPedido"]);
pro.Pro_ativo = Convert.ToString(objReader["pro_ativo"]);
if (objReader["cod_fun"] == DBNull.Value)
{
pro.Cod_fun = null;
}
else
{
pro.Cod_fun = Convert.ToInt32(objReader["cod_fun"]);
}
status = Convert.ToInt32(objReader["sta_cod"]);
modelo = Convert.ToInt32(objReader["mrq_cod"]);
requerente = Convert.ToInt32(objReader["req_cod"]);
}
objConexao.Close();
objComando.Dispose();
objConexao.Dispose();
pro.Status = StatusDB.Select(status);
pro.Requerente = RequerenteDB.Select(requerente);
return(pro);
}
catch (Exception e)
{
return(pro = null);
}
}
public void tearDown()
{
try
{
db = null;
testStatus = null;
}
catch
{
throw new Exception();
}
}
public static void tearDownAfterClass()
{
try
{
db = null;
testStatus = null;
}
catch
{
throw new Exception();
}
}
public void setUp()
{
try
{
db = new StatusDB();
testStatus = new Status {
Id = 2, Name = "OK"
};
}
catch
{
throw new Exception();
}
}
public static void UpdateStatus(TblDatabaseManagement tblDatabaseManagement, StatusDB newStatus)
{
tblDatabaseManagement.FkStatusId = (int)newStatus;
if (newStatus == StatusDB.InProcess)
{
tblDatabaseManagement.StartTime = DateTime.Now;
tblDatabaseManagement.CurrentArity = 2;
}
if (newStatus == StatusDB.Done)
{
tblDatabaseManagement.FinishTime = DateTime.Now;
}
Update(tblDatabaseManagement);
}
protected void btnSalvarStatus_Click(object sender, EventArgs e)
{
Status sta = new Status();
sta.Sta_valor = txbDescStatus.Text;
switch (StatusDB.Insert(sta))
{
case 0:
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>sucess();</script>", false);
txbDescStatus.Text = "";
break;
case -2:
Page.ClientScript.RegisterStartupScript(this.GetType(), "script", "<script>error();</script>", false);
break;
}
}
