public void AddTaluk(Village V) { bool isTPresent = checkIfTalukAlreadyExists(V.Taluk_Name); if (!isTPresent) { tblTaluk tT = new tblTaluk(); tT.Taluk_Name = V.Taluk_Name; tT.District_Id = getDistrictIdFromName(V.District_Name); // Add the Taluk dc.tblTaluks.InsertOnSubmit(tT); dc.SubmitChanges(); } return; }
// [Start] - Places Info Form. public void AddDistrict(Village V) { bool isDPresent = checkIfDistrictAlreadyExists(V.District_Name); if (!isDPresent) { tblDistrict tD = new tblDistrict(); tD.District_Name = V.District_Name; // Add the District dc.tblDistricts.InsertOnSubmit(tD); dc.SubmitChanges(); } return; }
public void AddVillage(Village V) { //throw new NotImplementedException(); bool isVPresent = checkIfVillageAlreadyExists(V.Village_Name); if (!isVPresent) { tblVillage tV = new tblVillage(); tV.Taluk_Id = getTalukIdFromName(V.Taluk_Name); tV.Village_Name = V.Village_Name; // Add the Village dc.tblVillages.InsertOnSubmit(tV); dc.SubmitChanges(); } return; }
public List<Village> GetAllVillages() { IEnumerable<tblVillage> villages = from V in dc.tblVillages select V; List<Village> villagesList = null; if (null != villages && villages.Count() > 0) { villagesList = new List<Village>(); foreach (tblVillage tV in villages) { Village V = new Village(); V.Village_Id = tV.Village_Id; V.Village_Name = tV.Village_Name; V.Taluk_Name = getTalukNameFromId(tV.Taluk_Id); V.District_Name = getDistrictNameFromTalukId(tV.Taluk_Id); villagesList.Add(V); } } return villagesList; }