//To add new Project public bool AddProject(T_Projects tproject) { try { entities.T_Projects.Add(tproject); entities.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
/// <summary> /// Save user's role details /// </summary> /// <param name="roleDetails">Role details</param> public void SaveUserRoleDetails(ConfigurationModel roleDetails) { using (var db = new ContinuousIntegrationEntities()) { var userRoleMappings = new T_UserRoleMappings { C_RegisterID = roleDetails.SelectedUserID, C_RoleID = roleDetails.SelectedRoleID, C_LastModified = DateTime.Now }; db.T_UserRoleMappings.Add(userRoleMappings); db.SaveChanges(); } }
/// <summary> /// Save user's details in T_Registrations table /// </summary> /// <param name="registrationDetails">Details of registering user</param> public void SaveUserDetails(UserRegisteration registrationDetails) { using (var db = new ContinuousIntegrationEntities()) { var registrations = new T_Registrations { C_FirstName = registrationDetails.C_FirstName, C_LastName = registrationDetails.C_LastName, C_EmailID = registrationDetails.C_EmailID, C_Password = registrationDetails.C_Password }; db.T_Registrations.Add(registrations); db.SaveChanges(); } }
public string AccessRoles(ConfigurationModel configurationDetails) { try { T_UserProjectMappings userProjectMappings; var db = new ContinuousIntegrationEntities(); //Remove project id from T_UserProjectMappings table db.RemoveAllMapProjectIdsOfUser(configurationDetails.SelectedUserID); //Remove role id from T_UserRoleMappings table db.RemoveAllMapRoleIdsOfUser(configurationDetails.SelectedUserID); //PREVIOUS CODE // if (configurationDetails.ProjectsAssigned != null) //{ // //Loop to save data in T_UserProjectMappings table // foreach (var item in configurationDetails.ProjectsAssigned) // { // userProjectMappings = new T_UserProjectMappings // { // C_RegisterID = configurationDetails.SelectedUserID, // C_ProjectID = item, // C_LastModified = DateTime.Now // }; // db.T_UserProjectMappings.Add(userProjectMappings); // db.SaveChanges(); // } //} if (configurationDetails.SelectedRoleID.Equals(2)) { //Loop to save data in T_UserProjectMappings table if (configurationDetails.ProjectsAssigned != null) { foreach (var item in configurationDetails.ProjectsAssigned) { userProjectMappings = new T_UserProjectMappings { C_RegisterID = configurationDetails.SelectedUserID, C_ProjectID = item, C_LastModified = DateTime.Now }; db.T_UserProjectMappings.Add(userProjectMappings); db.SaveChanges(); } } } else if (configurationDetails.SelectedRoleID.Equals(1)) { db.RemoveAllMapProjectIdsOfUser(configurationDetails.SelectedUserID); } dbHelper.SaveUserRoleDetails(configurationDetails); return("true"); } catch (Exception) { return("false"); } }