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