public bool AdicionaBalancete(balancete balancetesp) { try { conservadoraEntities model = Conexao.getInstance(); IQueryable<balancete> i = from p in model.balancetes select p; IEnumerable<balancete> max = i.OrderBy(p => p.idbalancete); if (max.Count() > 0) balancetesp.idbalancete = max.Last().idbalancete == null ? 1 : max.Last().idbalancete + 1; else balancetesp.idbalancete = 1; model.AddTobalancetes(balancetesp); model.SaveChanges(); return true; } catch (Exception e) { var x = e.InnerException; return false; } }
public bool SalvaBalancete(balancete balancetesp) { try { conservadoraEntities model = Conexao.getInstance(); IQueryable<balancete> query = from p in model.balancetes where p.idbalancete == balancetesp.idbalancete select p; balancete balancetes2 = query.First(); balancetes2.idbalancete = balancetesp.idbalancete; balancetes2.data = balancetesp.data; balancetes2.caminhoArquivo = balancetesp.caminhoArquivo; balancetes2.idcondominios = balancetesp.idcondominios; model.SaveChanges(); return true; } catch (Exception e) { return false; } }
/// <summary> /// Deprecated Method for adding a new object to the balancetes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTobalancetes(balancete balancete) { base.AddObject("balancetes", balancete); }
/// <summary> /// Create a new balancete object. /// </summary> /// <param name="idbalancete">Initial value of the idbalancete property.</param> /// <param name="idcondominios">Initial value of the idcondominios property.</param> /// <param name="apenasSindico">Initial value of the apenasSindico property.</param> public static balancete Createbalancete(global::System.Int32 idbalancete, global::System.Int32 idcondominios, global::System.Boolean apenasSindico) { balancete balancete = new balancete(); balancete.idbalancete = idbalancete; balancete.idcondominios = idcondominios; balancete.apenasSindico = apenasSindico; return balancete; }
public bool SalvaBalancete(balancete balancetesp, string acesso) { if (acesso != Conexao.SenhaAcesso) throw new Exception(); return controle.SalvaBalancete(balancetesp); }