public HttpResponseMessage ActiveDeactiveGrampanchayat(int id, Grampanchayat grampanchayat)
        {
            if (!ModelState.IsValid)
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.BadRequest, new { data = new { string.Empty }, success = false, error = string.Empty }));
            }

            if (id != grampanchayat.Id)
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.BadRequest, new { data = new { string.Empty }, success = false, error = string.Empty }));
            }

            try
            {
                Grampanchayat GrampanchayatUpdateData = db.Grampanchayats.Where(a => a.Id == grampanchayat.Id).FirstOrDefault();
                GrampanchayatUpdateData.ActiveBy = grampanchayat.ActiveBy;
                GrampanchayatUpdateData.ActiveOn = grampanchayat.ActiveOn;
                GrampanchayatUpdateData.Active   = grampanchayat.Active;
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!GrampanchayatExists(id))
                {
                    return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.NotFound, new { data = new { string.Empty }, success = false, error = string.Empty }));
                }
                else
                {
                    throw;
                }
            }

            return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.OK, new { data = new { grampanchayat }, success = true, error = string.Empty }));
        }
        public IHttpActionResult GetGrampanchayat(int id)
        {
            Grampanchayat grampanchayat = db.Grampanchayats.Find(id);

            if (grampanchayat == null)
            {
                return(NotFound());
            }

            return(Ok(grampanchayat));
        }
        public IHttpActionResult DeleteGrampanchayat(int id)
        {
            Grampanchayat grampanchayat = db.Grampanchayats.Find(id);

            if (grampanchayat == null)
            {
                return(NotFound());
            }

            db.Grampanchayats.Remove(grampanchayat);
            db.SaveChanges();

            return(Ok(grampanchayat));
        }
        public HttpResponseMessage PutGrampanchayat(int id, Grampanchayat grampanchayat)
        {
            if (!ModelState.IsValid)
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.BadRequest, new { data = new { string.Empty }, success = false, error = string.Empty }));
            }

            if (id != grampanchayat.Id)
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.BadRequest, new { data = new { string.Empty }, success = false, error = string.Empty }));
            }
            var grampanchayatData = db.Grampanchayats.Where(q => q.GrampanchayatName.ToUpper() == grampanchayat.GrampanchayatName.ToUpper()).Any() ? db.Grampanchayats.Where(p => p.GrampanchayatName.ToUpper() == grampanchayat.GrampanchayatName.ToUpper()).First() : null;

            if (grampanchayatData != null && grampanchayatData.Id != grampanchayat.Id)
            {
                if (db.Grampanchayats.Any(p => p.GrampanchayatName.ToUpper() == grampanchayat.GrampanchayatName.ToUpper()))
                {
                    return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.OK, new { data = new { string.Empty }, success = false, error = "Grampanchayat Name already exists" }));
                }
            }
            else
            {
                try
                {
                    Grampanchayat grampanchayatUpdateData = db.Grampanchayats.Where(a => a.Id == grampanchayat.Id).FirstOrDefault();
                    grampanchayatUpdateData.GrampanchayatName = grampanchayat.GrampanchayatName;
                    grampanchayatUpdateData.State             = grampanchayat.State;
                    grampanchayatUpdateData.District          = grampanchayat.District;
                    grampanchayatUpdateData.UpdatedBy         = grampanchayat.UpdatedBy;
                    grampanchayatUpdateData.UpdatedOn         = grampanchayat.UpdatedOn;
                    grampanchayatUpdateData.Active            = grampanchayat.Active;
                    db.SaveChanges();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!GrampanchayatExists(id))
                    {
                        return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.NotFound, new { data = new { string.Empty }, success = false, error = string.Empty }));
                    }
                    else
                    {
                        throw;
                    }
                }
            }

            return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.OK, new { data = new { grampanchayat }, success = true, error = string.Empty }));
        }
        public HttpResponseMessage PostGrampanchayat(Grampanchayat grampanchayat)
        {
            if (!ModelState.IsValid)
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.BadRequest, new { data = new { string.Empty }, success = false, error = string.Empty }));
            }

            var DataFound = (from Grampanchayatdata in db.Grampanchayats
                             where Grampanchayatdata.GrampanchayatName.ToUpper() == grampanchayat.GrampanchayatName.ToUpper()
                             select Grampanchayatdata.GrampanchayatName).SingleOrDefault();

            if (DataFound == null)
            {
                db.Grampanchayats.Add(grampanchayat);
                db.SaveChanges();
            }
            else
            {
                return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.OK, new { data = new { string.Empty }, success = false, error = "Grampanchayat Name already exists" }));
            }
            return((HttpResponseMessage)Request.CreateResponse(HttpStatusCode.OK, new { data = new { id = grampanchayat.Id }, success = true, error = string.Empty }));
        }