public ActionResult Nuevo(PersonaViewModel persona)
{
try
{
//validar datos
if (ModelState.IsValid)
{
//guardamos datos en bd
using (PersonaEntities bd = new PersonaEntities())
{
var opersona = new Persona();
opersona.Nombre = persona.Nombre;
opersona.Apellido = persona.Apellido;
opersona.Edad = persona.Edad;
bd.Persona.Add(opersona);
bd.SaveChanges();
}
//luego de agregar registro redirecionamos hacia nuestro index
return(Redirect("~/Persona/"));
}
return(View(persona));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult Editar(PersonaViewModel persona)
{
try
{
//validar datos
if (ModelState.IsValid)
{
//guardamos datos en bd
using (PersonaEntities bd = new PersonaEntities())
{
var opersona = bd.Persona.Find(persona.Id);//obtenemos registro por medio de id
opersona.Nombre = persona.Nombre;
opersona.Apellido = persona.Apellido;
opersona.Edad = persona.Edad;
//editamos registro
bd.Entry(opersona).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
}
return(Redirect("~/Persona/"));
}
return(View(persona));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static List<BloodBankModel> GetBloodBank(Expression<Func<BloodBankModel, bool>> expression)
{
using (PersonaEntities dataContext = new PersonaEntities())
{
return (from bank in dataContext.BloodBanks
select new BloodBankModel
{
BloodBankId = bank.BloodBankId,
BloodBankName = bank.BloodBankName,
Address = bank.Address,
TownId = bank.TownId,
Town = bank.Town_Lookup.TownValue,
DistrictId = bank.Town_Lookup.DistrictId,
District = bank.Town_Lookup.District_Lookup.DistrictValue,
StateId = bank.Town_Lookup.District_Lookup.StateID,
State = bank.Town_Lookup.District_Lookup.State_Lookup.StateValue,
CountryId = bank.Town_Lookup.District_Lookup.State_Lookup.CountryId,
Country = bank.Town_Lookup.District_Lookup.State_Lookup.Country_Lookup.CountryValue,
Pincode = bank.Pincode,
MobileNo1 = bank.MobileNo1,
MobileNo2 = bank.MobileNo2,
LandlineNo = bank.LandlineNo,
FaxNumber = bank.FaxNumber,
Email = bank.Email,
Website = bank.Website,
CreatedOn = bank.CreatedOn
}).Where(expression).ToList();
}
}
public ActionResult Eliminar(int id)
{
PersonaViewModel model = new PersonaViewModel();
using (PersonaEntities bd = new PersonaEntities())
{
var opersona = bd.Persona.Find(id);//obtengo entidad con id
bd.Persona.Remove(opersona);
bd.SaveChanges();
}
return(Content("ok"));
}
public ActionResult Editar(int id)
{
PersonaViewModel model = new PersonaViewModel();
using (PersonaEntities bd = new PersonaEntities())
{
var opersona = bd.Persona.Find(id);//obtenemos registro por medio de id
model.Id = opersona.Id;
model.Nombre = opersona.Nombre;
model.Apellido = opersona.Apellido;
model.Edad = opersona.Edad;
}
return(View(model));
}
// GET: Persona
public ActionResult Index()
{
//creamos una lista de nuestra clase ListarPersona
List <ListarPersonas> list;
using (PersonaEntities bd = new PersonaEntities())
{
//hacemos un select a nuestra tabla con los campos que queremos mostrar
list = (from b in bd.Persona
select new ListarPersonas
{
Id = b.Id,
Nombre = b.Nombre,
Apellido = b.Apellido,
Edad = b.Edad,
}).ToList();
}
return(View(list));
}
public void Save()
{
using (PersonaEntities dataContext = new PersonaEntities())
{
BloodBank bloodBank = null;
if (this.BloodBankId == 0)
{
bloodBank = new BloodBank
{
BloodBankId = this.BloodBankId,
BloodBankName = this.BloodBankName,
Address = this.Address,
TownId = this.TownId,
Pincode = this.Pincode,
MobileNo1 = this.MobileNo1,
MobileNo2 = this.MobileNo2,
LandlineNo = this.LandlineNo,
FaxNumber = this.FaxNumber,
Email = this.Email,
Website = this.Website,
CreatedOn = this.CreatedOn
};
dataContext.BloodBanks.AddObject(bloodBank);
}
else
{
bloodBank = (from blank in dataContext.BloodBanks where blank.BloodBankId == this.BloodBankId select blank).SingleOrDefault();
bloodBank.BloodBankId = this.BloodBankId;
bloodBank.BloodBankName = this.BloodBankName;
bloodBank.Address = this.Address;
bloodBank.TownId = this.TownId;
bloodBank.Pincode = this.Pincode;
bloodBank.MobileNo1 = this.MobileNo1;
bloodBank.MobileNo2 = this.MobileNo2;
bloodBank.LandlineNo = this.LandlineNo;
bloodBank.FaxNumber = this.FaxNumber;
bloodBank.Email = this.Email;
bloodBank.Website = this.Website;
bloodBank.CreatedOn = this.CreatedOn;
dataContext.BloodBanks.ApplyCurrentValues(bloodBank);
}
dataContext.SaveChanges();
}
}
