public ActionResult AdicionaBeneficiarios(Beneficiarios beneficiarios, int id)
{
var familiaDAO = new FamiliaDAO();
var familia = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familia;
if (ModelState.IsValid)
{
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
byte[] buffer = new byte[file.InputStream.Length];
file.InputStream.Read(buffer, 0, buffer.Length);
beneficiarios.Img = Convert.ToBase64String(buffer);
}
var dao = new BeneficiariosDAO();
beneficiarios.Id = 0;
dao.Adiciona(beneficiarios);
return(RedirectToAction($"Formulario/{@ViewBag.Familia.Id}", "BeneficiariosPJ"));
}
else
{
ViewBag.Beneficiario = beneficiarios;
return(View("Formulario"));
}
}
public ActionResult Atualizar([Bind(Include = "Id, ContratoId, EmpresaId ")] Familia familia)
{
var familiaDAO = new FamiliaDAO();
familiaDAO.Atualiza(familia);
return(View());
}
public ActionResult Atualizar(int id)
{
var familiaDAO = new FamiliaDAO();
Familia familia = familiaDAO.BuscaPorId(id);
return(View(familia));
}
protected void btnguardar_Click(object sender, EventArgs e)
{
try
{
FamiliaDAO db = new FamiliaDAO();
bool existe = db.ExisteFamilia(txtdescripcion.Text);
if (existe)
{
txtmensaje.Text = "El codigo del mercado ya existe.";
string script = "openModal();";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", script, true);
}
else
{
Familia familia = new Familia();
familia.Nombre = txtdescripcion.Text;
db.Create(familia);
Response.Redirect("ManteFamilia.aspx", true);
}
}
catch (Exception ex)
{
txtmensaje.Text = ex.Message;
string script = "openModal();";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", script, true);
}
}
public ActionResult DeleteConfirmed(int id)
{
Familia familia = FamiliaDAO.BuscarFamiliaPorId(id);
FamiliaDAO.RemoverFamilia(familia);
return(RedirectToAction("Index"));
}
public ActionResult Finalizar(int id)
{
var familiaDAO = new FamiliaDAO();
var familiaid = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familiaid;
var familiaId = familiaDAO.BuscaPorId(id);
ViewBag.FamiliaId = familiaId.ContratoId;
var familia = familiaDAO.Lista();
ViewBag.FamiliaLista = familia;
var dao = new EmpresaDAO();
var empresa = dao.BuscaPorId(familiaId.Empresa.Id);
var listaRecibo = new ReciboEmpresa().CalcularPorEmpresa(empresa.Id);
var soma = listaRecibo.Select(b => new
{
beneficiario = b,
somaValores = b.BeneficiarioTabelaPreco.ToList()
.Sum(x => x._tabelaDeValores.Valor)
}).Sum(b => b.somaValores);
ViewBag.Soma = soma;
return(View(familia));
}
void cargar()
{
FamiliaDAO db = new FamiliaDAO();
grvfamilia.DataSource = db.Listar();
grvfamilia.DataBind();
}
// GET: PagamentoPJ
public ActionResult Index(int id)
{
var familiadao = new FamiliaDAO();
var familia = familiadao.BuscaPorId(id);
ViewBag.Familia = familia;
return(View());
}
public ActionResult Remover(int id)
{
var familiaDAO = new FamiliaDAO();
Familia familia = familiaDAO.BuscaPorId(id);
familiaDAO.Remover(familia);
return(RedirectToAction("Lista"));
}
// GET: BeneficiariosPJ
public ActionResult Formulario(int id)
{
var familiaDAO = new FamiliaDAO();
var familia = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familia;
return(View());
}
public static void ListarFamilia(DropDownList cbo)
{
FamiliaDAO db = new FamiliaDAO();
cbo.DataSource = db.Listar();
cbo.DataTextField = "nombre";
cbo.DataValueField = "Id_Familia";
cbo.DataBind();
}
public ActionResult Adicionada(Familia familia)
{
var familiasDAO = new FamiliaDAO();
familiasDAO.Adiciona(familia);
ViewBag.Familia = familia;
return(View());
}
// GET: Estilo/Create
public ActionResult Create()
{
List <Familia> listafamilias = new List <Familia>();
listafamilias = FamiliaDAO.ListarFamilias();
ViewBag.FamiliaId = new SelectList(listafamilias, "id", "nome");
return(View());
}
protected void btnguardar_Click(object sender, EventArgs e)
{
FamiliaDAO db = new FamiliaDAO();
Familia fa = new Familia();
fa.Id_Familia = Convert.ToInt32(txtid.Text);
fa.Nombre = txtdescripcion.Text;
db.update(fa);
Response.Redirect("ManteFamilia.aspx", true);
}
void cargarfamilia()
{
int id = Convert.ToInt32(Request.QueryString["IDF"]);
FamiliaDAO db = new FamiliaDAO();
Familia zon = db.BuscarFamilia(id);
txtcodigo.Text = zon.Id_Familia.ToString();
txtdescripcion.Text = zon.Nombre.ToString();
txtid.Text = zon.Id_Familia.ToString();
}
// GET: RecibosPJ
public ActionResult Gerar(int id)
{
var familiaDAO = new FamiliaDAO();
var familiaId = familiaDAO.BuscaPorId(id);
ViewBag.FamiliaId = familiaId.ContratoId;
var familia = familiaDAO.Lista();
ViewBag.FamiliaLista = familia;
return(View(familia));
}
public ActionResult Adiciona(Endereco endereco, int Id)
{
endereco.FamiliaId = Id;
var enderecoDAO = new EnderecoDAO();
enderecoDAO.Adiciona(endereco);
var familiaDAO = new FamiliaDAO();
var familia = familiaDAO.BuscaPorId(Id);
ViewBag.Familia = familia;
return(View());
}
// GET: Familia/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Familia familia = FamiliaDAO.BuscarFamiliaPorId(id);
if (familia == null)
{
return(HttpNotFound());
}
return(View(familia));
}
// GET: Beneficiarios
public ActionResult Formulario(int id)
{
var familiaDAO = new FamiliaDAO();
var familia = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familia;
var beneficiariosDAO = new BeneficiariosDAO();
var beneficiarios = beneficiariosDAO.Lista();
ViewBag.Beneficiarios = beneficiarios;
return(View());
}
public ActionResult Visualiza(int id)
{
var familiaDAO = new FamiliaDAO();
Familia familia = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familia;
var empresaDAO = new EmpresaDAO();
IList <Empresa> empresa = empresaDAO.Lista();
ViewBag.Empresa = empresa;
return(View(familia));
}
public ActionResult Alterar(int id)
{
var beneficiariosDAO = new BeneficiariosDAO();
Beneficiarios beneficiarios = beneficiariosDAO.BuscaPorId(id);
ViewBag.Beneficiarios = beneficiarios;
var dao = new FamiliaDAO();
var familia = dao.BuscaPorId(beneficiarios.FamiliaId);
ViewBag.Familia = familia;
return(View(beneficiarios));
}
// GET: Familia
public ActionResult Lista()
{
var empresaDAO = new EmpresaDAO();
var empresa = empresaDAO.Lista();
ViewBag.Empresa = empresa;
var familiaDAO = new FamiliaDAO();
var familia = familiaDAO.Lista();
ViewBag.Familia = familia;
return(View(familia));
}
public ActionResult Create([Bind(Include = "id,usuario_id,nome,ult_modificacao")] Familia familia)
{
String email = Session["email"].ToString();
Usuario usuario = UsuarioDAO.BuscarUsuarioPorEmail(email);
familia.usuario_id = usuario.id;
familia.ult_modificacao = DateTime.Now;
if (ModelState.IsValid)
{
FamiliaDAO.CadastrarFamilia(familia);
return(RedirectToAction("Index"));
}
return(View(familia));
}
public ActionResult Finalizar(int id)
{
var familiadao = new FamiliaDAO();
var familia = familiadao.BuscaPorId(id);
ViewBag.Familia = familia;
var beneficiariosDAO = new BeneficiariosDAO();
var beneficiarios = beneficiariosDAO.Lista();
ViewBag.Beneficiarios = beneficiarios;
var listaRecibo = new Recibo().CalcularPorFamiliaPorContrato(id);
var soma = listaRecibo.Sum(x => x._tabelaDeValores.Valor);
ViewBag.Soma = soma;
return(View(beneficiarios));
}
public ActionResult Alterar(int id)
{
var empresaDAO = new EmpresaDAO();
var empresa = empresaDAO.Lista();
ViewBag.Empresa = empresa;
var contratoDAO = new ContratoDAO();
var contrato = contratoDAO.Lista();
ViewBag.Contrato = contrato;
var familiaDAO = new FamiliaDAO();
Familia familia = familiaDAO.BuscaPorId(id);
ViewBag.Familia = familia;
return(View(familia));
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int fila = Convert.ToInt32(e.CommandArgument);
int idfamilia = Convert.ToInt32(grvfamilia.Rows[fila].Cells[0].Text);
if (e.CommandName == "Modificar")
{
Response.Redirect("~/ModFamilia.aspx?IDF=" + idfamilia, true);
}
else if (e.CommandName == "Ver")
{
Response.Redirect("VerFamilia.aspx?IDF=" + idfamilia, true);
}
else if (e.CommandName == "Eliminar")
{
FamiliaDAO db = new FamiliaDAO();
db.Eliminar(idfamilia);
cargar();
string script = "openModal();";
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", script, true);
}
}
// GET: Familia
public ActionResult Index()
{
return(View(FamiliaDAO.ListarFamilias()));
}
