public JsonResult fetchData() { BlogEntities1 blogEntities1 = new BlogEntities1(); var list = blogEntities1.Tbl_Team.ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
public string DeleteMember(int id) { Tbl_Team tbl_Services = new Tbl_Team { id = id }; BlogEntities1 blogEntities = new BlogEntities1(); blogEntities.Entry(tbl_Services).State = EntityState.Deleted; blogEntities.SaveChanges(); return("deleted"); }
public string DeleteService(int id) { Tbl_Services tbl_Services = new Tbl_Services { Service_Id = id }; BlogEntities1 blogEntities = new BlogEntities1(); blogEntities.Entry(tbl_Services).State = EntityState.Deleted; blogEntities.SaveChanges(); return("deleted"); }
public string DeleteProject(int id) { Tbl_Projects tbl_Projects = new Tbl_Projects { Id = id }; BlogEntities1 blog = new BlogEntities1(); blog.Entry(tbl_Projects).State = EntityState.Deleted; blog.SaveChanges(); return("deleted"); }
public string UpdateService(int id, string name, string description) { BlogEntities1 blogEntities = new BlogEntities1(); var service = blogEntities.Tbl_Services.Find(id); if (service != null) { service.Service_Name = name; service.Service_Description = description; } blogEntities.Entry(service).State = EntityState.Modified; blogEntities.SaveChanges(); return("editied"); }
public string AddService(string Title, string Description) { BlogEntities1 blogEntities = new BlogEntities1(); var foo = blogEntities.Tbl_Services.Where(v => v.Service_Name == Title && v.Service_Description == Description).FirstOrDefault(); if (foo != null) { return("Already exists"); } else { Tbl_Services tbl_Services = new Tbl_Services(); tbl_Services.Service_Name = Title; tbl_Services.Service_Description = Description; blogEntities.Tbl_Services.Add(tbl_Services); blogEntities.SaveChanges(); return("Inserted"); } }
public string AddMember(string name, string job_t, string job_d, HttpPostedFileBase image, string facebook, string twitter, string email, string linkedin, string skype) { if (name != "" && job_t != "" && job_d != "" && image != null) { BlogEntities1 blogEntities = new BlogEntities1(); var checkMember = blogEntities.Tbl_Team.Where(rowHere => rowHere.Email == email || rowHere.Facebook_Url == facebook || rowHere.Twitter_Url == twitter || rowHere.LinkedIn_Url == linkedin || rowHere.Skype_Url == skype).FirstOrDefault(); if (checkMember != null) { return("present"); } else { var relativePath = Guid.NewGuid() + "-" + image.FileName; var path = Server.MapPath("~/Photo/" + relativePath); image.SaveAs(path); Tbl_Team _Team = new Tbl_Team(); _Team.Name = name; _Team.Job_Title = job_t; _Team.Job_Description = job_d; _Team.Image = relativePath; _Team.Facebook_Url = facebook; _Team.Twitter_Url = twitter; _Team.Email = email; _Team.LinkedIn_Url = linkedin; _Team.Skype_Url = skype; blogEntities.Tbl_Team.Add(_Team); blogEntities.SaveChanges(); return("Added"); } } else { return("empty"); } }
public Repository() { context = new BlogEntities1(); }