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