/// <summary>
///
/// </summary>
/// <param name="ProjectID"></param>
/// <param name="ModuleID"></param>
/// <returns></returns>
public ProjectDTO GetProjectByID(string ProjectID)
{
TblProjects projects = _projectRepository.GetProjectByID(ProjectID);
ProjectDTO space = _mapper.Map <ProjectDTO>(projects);
return(space);
}
public bool CreateProject(TblProjects projects, TblCustomFields customFields)
{
_projectContext.TblProjects.Add(projects);
customFields.ProjectId = projects.ProjectId;
_projectContext.TblCustomFields.Add(customFields);
_projectContext.SaveChanges();
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="Project"></param>
/// <returns></returns>
public bool DeleteProject(ProjectDTO Project)
{
var result = false;
TblProjects projects = _mapper.Map <TblProjects>(Project);
result = _projectRepository.DeleteProject(projects);
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="fullProject"></param>
/// <returns></returns>
public bool CreateProject(FullProjectDTO fullProject)
{
var result = false;
TblProjects projects = _mapper.Map <TblProjects>(fullProject.projectDTO);
TblCustomFields customFileds = _mapper.Map <TblCustomFields>(fullProject.customFieldsDTO);
result = _projectRepository.CreateProject(projects, customFileds);
return(result);
}
public virtual ActionResult Add(TblProjects model)
{
if (!ModelState.IsValid)
{
return View(model);
}
db.TblProjects.Add(model);
db.SaveChanges();
return RedirectToAction(MVC.Image.ActionNames.Add, MVC.Image.Name, new { tableName = "Project", id = model.TblProjectsID });
}
public virtual ActionResult Edit(TblProjects model)
{
if (!ModelState.IsValid)
{
return View(model);
}
db.TblProjects.Attach(model);
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return RedirectToAction(MVC.Image.ActionNames.Add, MVC.Image.Name, new { tableName = "Project", id = model.TblProjectsID });
}
public TblProjects CreateProject(TblProjects projects, List <TblCustomFields> customFields)
{
_projectContext.TblProjects.Add(projects);
foreach (TblCustomFields customfield in customFields)
{
customfield.ProjectId = projects.ProjectId;
_projectContext.TblCustomFields.Add(customfield);
}
_projectContext.SaveChanges();
return(projects);
}
/// <summary>
///
/// </summary>
/// <param name="fullProject"></param>
/// <returns></returns>
public ProjectDTO CreateProject(FullProjectDTO fullProject)
{
TblProjects projects = _mapper.Map <TblProjects>(fullProject.projectDTO);
projects.CreatedDate = DateTime.UtcNow;
projects.ProjectId = Guid.NewGuid().ToString();
List <TblCustomFields> customFields = CastObject <CustomFieldsDTO, TblCustomFields>(fullProject.customFieldsDTO);
projects = _projectRepository.CreateProject(projects, customFields);
ProjectDTO projectdto = _mapper.Map <ProjectDTO>(projects);
return(projectdto);
}
/// <summary>
///
/// </summary>
/// <param name="fullProject"></param>
/// <returns></returns>
public ProjectDTO UpdateProject(FullProjectDTO fullProject)
{
var result = false;
TblProjects projects = _mapper.Map <TblProjects>(fullProject.projectDTO);
projects.UpdatedDate = DateTime.UtcNow;
TblCustomFields customFields = _mapper.Map <TblCustomFields>(fullProject.customFieldsDTO);
projects = _projectRepository.UpdateProject(projects, customFields);
ProjectDTO projectdto = _mapper.Map <ProjectDTO>(projects);
return(projectdto);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
TblProjects = await _context.TblProjects.FirstOrDefaultAsync(m => m.ProjectID == id);
if (TblProjects == null)
{
return(NotFound());
}
return(Page());
}
public bool DeleteProject(TblProjects Projects)
{
var _projectobj = _projectContext.TblProjects.Where(m => m.ProjectId == Projects.ProjectId).FirstOrDefault();
var _customobj = _projectContext.TblCustomFields.SingleOrDefault(m => m.ProjectId == Projects.ProjectId);
if (_projectobj != null)
{
_projectContext.Entry <TblProjects>(_projectobj).State = EntityState.Deleted;
_projectContext.SaveChanges();
}
if (_customobj != null)
{
_projectContext.Entry <TblCustomFields>(_customobj).State = EntityState.Deleted;
_projectContext.SaveChanges();
}
return(true);
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
TblProjects = await _context.TblProjects.FindAsync(id);
//if (TblProjects != null)
//{
// _context.TblProjects.Remove(TblProjects);
// await _context.SaveChangesAsync();
//}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
if (HttpContext.Session.GetString("userid") == null)
{
return(RedirectToPage("/Login/Index"));
}
TblProjects = await _context.TblProjects.FirstOrDefaultAsync(m => m.ProjectID == id);
if (TblProjects == null)
{
return(NotFound());
}
else
{
TblProjects.ModifiedBy = HttpContext.Session.GetString("userid");
TblProjects.ModifiedDate = DateTime.Now;
TblProjects.IsActive = false;
_context.Attach(TblProjects).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblProjectsExists(TblProjects.ProjectID))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(RedirectToPage("./Index"));
}
public TblProjects UpdateProject(TblProjects Projects, TblCustomFields customFields)
{
var _projectobj = _projectContext.TblProjects.SingleOrDefault(m => m.ProjectId == Projects.ProjectId);
var _customobj = _projectContext.TblCustomFields.SingleOrDefault(m => m.ProjectId == Projects.ProjectId);
if (_projectobj != null)
{
Projects.CreatedDate = _projectobj.CreatedDate;
//Projects.Pid = _projectobj.Pid;
//_projectobj = Projects;
_projectobj.UpdatedDate = DateTime.UtcNow;
_projectobj.ProjectName = Projects.ProjectName;
_projectobj.SpaceId = Projects.SpaceId;
_projectobj.ModuleId = Projects.ModuleId;
_projectobj.ProjectStatus = Projects.ProjectStatus;
_projectobj.ProjectPhases = Projects.ProjectPhases;
_projectobj.ProjectManager = Projects.ProjectManager;
_projectobj.ProjectStartDate = Projects.ProjectStartDate;
_projectobj.TargetDate = Projects.TargetDate;
_projectobj.Resources = Projects.Resources;
// _projectContext.Entry<TblProjects>(_projectobj).State = EntityState.Modified;
// _projectContext.Entry(_projectobj).State = EntityState.Modified;
// _projectContext.Entry(Projects).State = EntityState.Detached;
_projectContext.Update(_projectobj).Property(x => x.Pid).IsModified = false;
_projectContext.SaveChanges();
}
if (_customobj != null)
{
//_customobj.DieCode = customFields.DieCode;
//_customobj.MfgPart = customFields.MfgPart;
//_customobj.Fgpart = customFields.Fgpart;
_projectContext.Update(_customobj).Property(x => x.Cid).IsModified = false;
_projectContext.SaveChanges();
}
return(Projects);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
if (HttpContext.Session.GetString("userid") == null)
{
return(RedirectToPage("/Login/Index"));
}
TblProjects = await _context.TblProjects.FirstOrDefaultAsync(m => m.ProjectID == id);
if (TblProjects == null)
{
return(NotFound());
}
return(Page());
}
