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