public void AddProject(ProjectEntity project)
{
var newProj = new T_PROJECT();
newProj.PROJ_NM = project.ProjectName;
newProj.PROJ_PRIORITY = project.Priority;
newProj.PROJ_MGR_ID = project.ProjectManagerId;
newProj.PROJ_STRT_DT = Utility.GetFormattedDate(project.StartDate);
newProj.PROJ_END_DT = Utility.GetFormattedDate(project.EndDate);
_db.T_PROJECT.Add(newProj);
_db.SaveChanges();
}
public bool CreateProject(T_PROJECT project, int userID, string userName)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
DbContext.Insert(project);
var projectMember = new T_PROJECT_MEMBER();
projectMember.P_PROJECT_ID = project.ID;
projectMember.U_USER_ID = userID;
projectMember.T_STATE = 1;
projectMember.U_USER_NAME = userName;
projectMember.U_USER_EMAIL = project.CREATE_USER_MAIL;
projectMember.R_ROLE_CODE = RoleCode.Owner;
projectMember.CREATE_USER_MAIL = project.CREATE_USER_MAIL;
projectMember.CREATE_TIME = DateTime.Now;
DbContext.Insert(projectMember);
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
