public static bool Add(BusinessObjects.Village villageBO)
{
VillageDA V = new VillageDA();
var village = new Village
{
Name = villageBO.Name,
DistrictId = villageBO.DistrictId,
Block = villageBO.Block
};
V.context.Villages.Add(village);
int affectedRows = V.context.SaveChanges();
V.context.Dispose();
if (affectedRows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool Delete(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from Villages where Id='{0}'", info.Id)));
}
public static bool Update(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Villages set CityId='{0}',Name='{1}', PinCode='{2}' where Id='{3}'", info.CityId, info.Name, info.PinCode, info.Id)));
}
public static bool Add(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Villages(CityId, Name, PinCode)values('{0}','{1}','{2}')", info.CityId, info.Name, info.PinCode)));
}