public ActionResult Edit(ProjectCategoryOrganizationSettings projectCategoryOrganizationSettings, bool EnableProjectCategory)
{
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
try
{
if (tenantId == null)
{
return(Json(new
{
success = false,
message = "TenantId is null",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
DateTime dt = DateTime.Now;
var currentProjectCategoryID = db.ProjectCategoryOrganizationSettings.FirstOrDefault(p => p.ProjectCategoryID == projectCategoryOrganizationSettings.ProjectCategoryID);
if (currentProjectCategoryID == null)
{
LogHelper.Log(Log.Event.UPDATE_PROJECTCATEGORY, "ProjectCategoryID not found");
return(Json(new
{
success = false,
message = "ProjectCategoryID not found",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
currentProjectCategoryID.EnableProjectCategory = EnableProjectCategory;
currentProjectCategoryID.DateModified = dt;
db.SaveChanges();
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.UPDATE_PROJECTCATEGORY, ex.Message);
ExceptionError(ex.Message, ex.StackTrace);
}
return(Json(new
{
success = true,
message = "Edited successfully",
data = db.ProjectCategoryOrganizationSettings.Where(x => x.TenantID == tenantId).Select(x => new
{
x.ProjectCategoryID,
x.ProjectCategory.Name,
x.EnableProjectCategory
})
}, JsonRequestBehavior.AllowGet));
}
public void SaveDefaultProjectCategoryRecord(Guid TenantID, Guid OrganizationID)
{
DateTime dt = DateTime.Now;
var ProjectCategory = db.ProjectCategory.ToList();
foreach (ProjectCategory source in ProjectCategory)
{
db.ProjectCategoryOrganizationSettings.Add(new ProjectCategoryOrganizationSettings()
{
ProjectCategoryID = source.ProjectCategoryID,
OrganizationID = OrganizationID,
TenantID = TenantID,
EnableProjectCategory = false,
DateCreated = dt
});
db.SaveChanges();
}
var DefaultProjectCategory1 = "Goods";
var DefaultProjectCategoryID1 = db.ProjectCategory.Where(x => x.Name.Contains(DefaultProjectCategory1)).Select(x => x.ProjectCategoryID).FirstOrDefault();
var ProjectCategory1 = db.ProjectCategoryOrganizationSettings.Where(x => x.ProjectCategoryID == DefaultProjectCategoryID1 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
ProjectCategoryOrganizationSettings projectCategoryOrganizationSettings = ProjectCategory1.First();
projectCategoryOrganizationSettings.EnableProjectCategory = true;
projectCategoryOrganizationSettings.DateModified = dt;
var DefaultProjectCategory2 = "Services";
var DefaultProjectCategoryID2 = db.ProjectCategory.Where(x => x.Name.Contains(DefaultProjectCategory2)).Select(x => x.ProjectCategoryID).FirstOrDefault();
var ProjectCategory2 = db.ProjectCategoryOrganizationSettings.Where(x => x.ProjectCategoryID == DefaultProjectCategoryID2 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
projectCategoryOrganizationSettings = ProjectCategory2.First();
projectCategoryOrganizationSettings.EnableProjectCategory = true;
projectCategoryOrganizationSettings.DateModified = dt;
var DefaultProjectCategory3 = "Works";
var DefaultProjectCategoryID3 = db.ProjectCategory.Where(x => x.Name.Contains(DefaultProjectCategory3)).Select(x => x.ProjectCategoryID).FirstOrDefault();
var ProjectCategory3 = db.ProjectCategoryOrganizationSettings.Where(x => x.ProjectCategoryID == DefaultProjectCategoryID3 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
projectCategoryOrganizationSettings = ProjectCategory3.First();
projectCategoryOrganizationSettings.EnableProjectCategory = true;
projectCategoryOrganizationSettings.DateModified = dt;
db.SaveChanges();
}
