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();
}
