Пример #1
0
        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;
        }
Пример #2
0
        // [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;
        }
Пример #3
0
        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;
        }
Пример #4
0
        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;
        }