public void UpdateBankData(Bank bank)
{
using (var ctx = new HLIMSYSTEMEntities())
{
var data = ctx.tblBanks.First <tblBank>();
data.Name = bank.Name;
ctx.SaveChanges();
IList <Bank> bnkList = getBankData();
updateCache(bnkList);
}
}
public void InsertBankData(Bank bank)
{
using (var ctx = new HLIMSYSTEMEntities())
{
ctx.tblBanks.Add(new tblBank()
{
Name = bank.Name
});
ctx.SaveChanges();
IList <Bank> bnkList = getBankData();
updateCache(bnkList);
}
}
public void InsertPropertyData(Property property)
{
using (var ctx = new HLIMSYSTEMEntities())
{
ctx.tblProperties.Add(new tblProperty()
{
Type = Convert.ToInt32(property.PropertyType.Value),
Address = property.Address
});
ctx.SaveChanges();
IList <Property> propList = getPropertyData();
updateCache(propList);
}
}
private IList <Bank> getBankData()
{
IList <Bank> data = null;
using (var ctx = new HLIMSYSTEMEntities())
{
data = ctx.tblBanks.Select(s => new Bank()
{
Id = s.Id,
Name = s.Name
}).ToList <Bank>();
}
return(data);
}
private IList <Property> getPropertyData()
{
IList <Property> data = null;
using (var ctx = new HLIMSYSTEMEntities())
{
data = ctx.tblProperties.Select(s => new Property()
{
Id = s.Id,
PropertyType = s.Type == 1 ? PropertyType.Apartment : PropertyType.House,
Address = s.Address
}).ToList <Property>();
}
return(data);
}
