public string SaveVillage(utblMstVillage model)
{
var parVillageID = new SqlParameter("@VillageID", model.VillageID);
var parVillageName = new SqlParameter("@VillageName", model.VillageName);
var parTransDate = new SqlParameter("@TransDate", model.TransDate);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspVillageSave @VillageID, @VillageName, @TransDate, @UserID",
parVillageID, parVillageName, parTransDate, parUserID).FirstOrDefault());
}
public string DeleteVillage(long id)
{
try
{
utblMstVillage model = db.utblMstVillages.Find(id);
db.utblMstVillages.Remove(model);
db.SaveChanges();
return("Village Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
