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 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 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 AddCategory(string name) { if (name != "") { var exist = blogEntities.Tbl_ProjectCategory.Where(pc => pc.Name.ToLower() == name.ToLower()).FirstOrDefault(); if (exist != null) { return("exist"); } else { Tbl_ProjectCategory category = new Tbl_ProjectCategory() { Name = name }; blogEntities.Tbl_ProjectCategory.Add(category); blogEntities.SaveChanges(); return("created"); } } return("fail"); }
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"); }
// landing method public string Create_New_User(string username, string email, string user_role, string password, string CPassword) { //Password hashing string Str_Pwd = hashCode.PassHash(password); //Empty values checking if (username.Equals("") || email.Equals("") || user_role.Equals("") || password.Equals("") || CPassword.Equals("") || password != CPassword) { return("Any Feilds Are Empty or password does not match"); } var checkUser = blogEntities.Tbl_Users.Where(rowHere => rowHere.Email == email && rowHere.Pwd == Str_Pwd); if (checkUser == null) { //Add new user code here //Users table object creation here Tbl_Users Obj_tbl_Users = new Tbl_Users(); //Fetch user role id from here long User_Role_Id_ = 0; foreach (var usertype in blogEntities.Tbl_Roles.ToList()) { if ((usertype.Role_Name.Equals(user_role))) { User_Role_Id_ = usertype.User_Role_Id; break; } } //Table row of data Obj_tbl_Users.Username = username; //string Obj_tbl_Users.Email = email; //string Obj_tbl_Users.User_Role_Id = User_Role_Id_; //long Obj_tbl_Users.Status_Code = "1"; //string Obj_tbl_Users.Pwd = Str_Pwd; //string Obj_tbl_Users.CPwd = Str_Pwd; //string blogEntities.Tbl_Users.Add(Obj_tbl_Users); blogEntities.SaveChanges(); return("Registered successfully"); } return("User Already Present"); }
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 void Insert(TEntity entity) { context.Set <TEntity>().Add(entity); context.SaveChanges(); }