/// <summary>
/// Delete FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel DeleteFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
try
{
var fieldsCategoryDelete = this.context?.FieldsCategory.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.CategoryId == fieldsCategoryAddViewModel.fieldsCategory.CategoryId);
if (fieldsCategoryDelete != null)
{
var customFieldsExists = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == fieldsCategoryDelete.TenantId && x.SchoolId == fieldsCategoryDelete.SchoolId && x.CategoryId == fieldsCategoryDelete.CategoryId);
if (customFieldsExists != null)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = "It Can't Be Deleted Because It Has Association";
}
else
{
this.context?.FieldsCategory.Remove(fieldsCategoryDelete);
this.context?.SaveChanges();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = "Field Category Deleted Successfully";
}
}
}
catch (Exception es)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = es.Message;
}
return(fieldsCategoryAddViewModel);
}
/// <summary>
/// View FieldsCategory By Id
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
//public FieldsCategoryAddViewModel ViewFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
//{
// FieldsCategoryAddViewModel fieldsCategoryViewModel = new FieldsCategoryAddViewModel();
// try
// {
// var fieldsCategoryView = this.context?.FieldsCategory.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.CategoryId == fieldsCategoryAddViewModel.fieldsCategory.CategoryId);
// if (fieldsCategoryView != null)
// {
// fieldsCategoryViewModel.fieldsCategory = fieldsCategoryView;
// fieldsCategoryViewModel._failure = false;
// }
// else
// {
// fieldsCategoryViewModel._failure = true;
// fieldsCategoryViewModel._message = NORECORDFOUND;
// }
// }
// catch (Exception es)
// {
// fieldsCategoryViewModel._failure = true;
// fieldsCategoryViewModel._message = es.Message;
// }
// return fieldsCategoryViewModel;
//}
/// <summary>
/// Update FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel UpdateFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
FieldsCategoryAddViewModel fieldsCategoryUpdateModel = new FieldsCategoryAddViewModel();
try
{
var fieldsCategoryUpdate = this.context?.FieldsCategory.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.CategoryId == fieldsCategoryAddViewModel.fieldsCategory.CategoryId);
fieldsCategoryUpdate.IsSystemCategory = fieldsCategoryAddViewModel.fieldsCategory.IsSystemCategory;
fieldsCategoryUpdate.Search = fieldsCategoryAddViewModel.fieldsCategory.Search;
fieldsCategoryUpdate.Title = fieldsCategoryAddViewModel.fieldsCategory.Title;
fieldsCategoryUpdate.Module = fieldsCategoryAddViewModel.fieldsCategory.Module;
fieldsCategoryUpdate.SortOrder = fieldsCategoryAddViewModel.fieldsCategory.SortOrder;
fieldsCategoryUpdate.Required = fieldsCategoryAddViewModel.fieldsCategory.Required;
fieldsCategoryUpdate.Hide = fieldsCategoryAddViewModel.fieldsCategory.Hide;
fieldsCategoryUpdate.LastUpdate = DateTime.UtcNow;
fieldsCategoryUpdate.UpdatedBy = fieldsCategoryAddViewModel.fieldsCategory.UpdatedBy;
this.context?.SaveChanges();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = "Entity Updated";
}
catch (Exception es)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = es.Message;
}
return(fieldsCategoryAddViewModel);
}
/// <summary>
/// Add FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel AddFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
int?CategoryId = Utility.GetMaxPK(this.context, new Func <FieldsCategory, int>(x => x.CategoryId));
fieldsCategoryAddViewModel.fieldsCategory.CategoryId = (int)CategoryId;
fieldsCategoryAddViewModel.fieldsCategory.LastUpdate = DateTime.UtcNow;
this.context?.FieldsCategory.Add(fieldsCategoryAddViewModel.fieldsCategory);
this.context?.SaveChanges();
fieldsCategoryAddViewModel._failure = false;
return(fieldsCategoryAddViewModel);
}
public ActionResult <FieldsCategoryAddViewModel> DeleteFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
FieldsCategoryAddViewModel fieldsCategorylDelete = new FieldsCategoryAddViewModel();
try
{
fieldsCategorylDelete = _customFieldService.DeleteFieldsCategory(fieldsCategoryAddViewModel);
}
catch (Exception es)
{
fieldsCategorylDelete._failure = true;
fieldsCategorylDelete._message = es.Message;
}
return(fieldsCategorylDelete);
}
/// <summary>
/// Delete FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel DeleteFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
try
{
var fieldsCategoryDelete = this.context?.FieldsCategory.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.CategoryId == fieldsCategoryAddViewModel.fieldsCategory.CategoryId);
this.context?.FieldsCategory.Remove(fieldsCategoryDelete);
this.context?.SaveChanges();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = "Deleted";
}
catch (Exception es)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = es.Message;
}
return(fieldsCategoryAddViewModel);
}
/// <summary>
/// Update FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel UpdateFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
FieldsCategoryAddViewModel fieldsCategoryUpdateModel = new FieldsCategoryAddViewModel();
try
{
var fieldsCategoryUpdate = this.context?.FieldsCategory.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.CategoryId == fieldsCategoryAddViewModel.fieldsCategory.CategoryId);
fieldsCategoryAddViewModel.fieldsCategory.LastUpdate = DateTime.Now;
this.context.Entry(fieldsCategoryUpdate).CurrentValues.SetValues(fieldsCategoryAddViewModel.fieldsCategory);
this.context?.SaveChanges();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = "Field Category Updated Successfully";
}
catch (Exception es)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = es.Message;
}
return(fieldsCategoryAddViewModel);
}
/// <summary>
/// Add FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel SaveFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
FieldsCategoryAddViewModel FieldsCategoryAddModel = new FieldsCategoryAddViewModel();
try
{
if (TokenManager.CheckToken(fieldsCategoryAddViewModel._tenantName + fieldsCategoryAddViewModel._userName, fieldsCategoryAddViewModel._token))
{
FieldsCategoryAddModel = this.customFieldRepository.AddFieldsCategory(fieldsCategoryAddViewModel);
}
else
{
FieldsCategoryAddModel._failure = true;
FieldsCategoryAddModel._message = TOKENINVALID;
}
}
catch (Exception es)
{
FieldsCategoryAddModel._failure = true;
FieldsCategoryAddModel._message = es.Message;
}
return(FieldsCategoryAddModel);
}
/// <summary>
/// Add FieldsCategory
/// </summary>
/// <param name="fieldsCategoryAddViewModel"></param>
/// <returns></returns>
public FieldsCategoryAddViewModel AddFieldsCategory(FieldsCategoryAddViewModel fieldsCategoryAddViewModel)
{
using (var transaction = this.context.Database.BeginTransaction())
{
try
{
var checkFieldCategoryTitle = this.context?.FieldsCategory.Where(x => x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.Title.ToLower() == fieldsCategoryAddViewModel.fieldsCategory.Title.ToLower()).FirstOrDefault();
if (checkFieldCategoryTitle != null)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = "Field Category Title Already Exists";
}
else
{
//int? CategoryId = Utility.GetMaxPK(this.context, new Func<FieldsCategory, int>(x => x.CategoryId));
int?CategoryId = 1;
var FieldCategoryData = this.context?.FieldsCategory.Where(x => x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId).OrderByDescending(x => x.CategoryId).FirstOrDefault();
if (FieldCategoryData != null)
{
CategoryId = FieldCategoryData.CategoryId + 1;
}
fieldsCategoryAddViewModel.fieldsCategory.CategoryId = (int)CategoryId;
fieldsCategoryAddViewModel.fieldsCategory.LastUpdate = DateTime.UtcNow;
this.context?.FieldsCategory.Add(fieldsCategoryAddViewModel.fieldsCategory);
var permissionGroup = this.context?.PermissionGroup.FirstOrDefault(x => x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.PermissionGroupName.ToLower().Contains(fieldsCategoryAddViewModel.fieldsCategory.Module.ToLower()));
if (permissionGroup != null)
{
var permissionCategory = this.context?.PermissionCategory.FirstOrDefault(e => e.PermissionGroupId == permissionGroup.PermissionGroupId && e.TenantId == permissionGroup.TenantId && e.SchoolId == permissionGroup.SchoolId && e.PermissionGroupId == permissionGroup.PermissionGroupId);
if (permissionCategory != null)
{
var checkPermissionSubCategoryName = this.context?.PermissionSubcategory.Where(x => x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId && x.PermissionSubcategoryName.ToLower() == fieldsCategoryAddViewModel.fieldsCategory.Title.ToLower()).FirstOrDefault();
if (checkPermissionSubCategoryName != null)
{
fieldsCategoryAddViewModel._failure = true;
fieldsCategoryAddViewModel._message = "Permission Subcategory Name Already Exists";
}
else
{
int?PermissionSubCategoryId = 1;
var permissionSubCategoryData = this.context?.PermissionSubcategory.Where(x => x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId).OrderByDescending(x => x.PermissionSubcategoryId).FirstOrDefault();
if (permissionSubCategoryData != null)
{
PermissionSubCategoryId = permissionSubCategoryData.PermissionSubcategoryId + 1;
}
var permissionSubCategory = new PermissionSubcategory()
{
TenantId = fieldsCategoryAddViewModel.fieldsCategory.TenantId,
SchoolId = fieldsCategoryAddViewModel.fieldsCategory.SchoolId,
PermissionSubcategoryId = (int)PermissionSubCategoryId,
PermissionGroupId = permissionCategory.PermissionGroupId,
PermissionCategoryId = permissionCategory.PermissionCategoryId,
PermissionSubcategoryName = fieldsCategoryAddViewModel.fieldsCategory.Title,
Title = fieldsCategoryAddViewModel.fieldsCategory.Title,
EnableView = true,
EnableAdd = true,
EnableEdit = true,
EnableDelete = true,
CreatedBy = fieldsCategoryAddViewModel.fieldsCategory.UpdatedBy,
CreatedOn = DateTime.UtcNow
};
this.context?.PermissionSubcategory.Add(permissionSubCategory);
int?rolePermissionId = 1;
var rolePermissionData = this.context?.RolePermission.Where(x => x.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && x.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId).OrderByDescending(x => x.RolePermissionId).FirstOrDefault();
if (rolePermissionData != null)
{
rolePermissionId = rolePermissionData.RolePermissionId + 1;
}
var rolePermission = new RolePermission()
{
TenantId = fieldsCategoryAddViewModel.fieldsCategory.TenantId,
SchoolId = fieldsCategoryAddViewModel.fieldsCategory.SchoolId,
RolePermissionId = (int)rolePermissionId,
PermissionGroupId = null,
PermissionCategoryId = null,
PermissionSubcategoryId = (int)PermissionSubCategoryId,
CanView = true,
CanAdd = true,
CanEdit = true,
CanDelete = true,
CreatedBy = fieldsCategoryAddViewModel.fieldsCategory.UpdatedBy,
CreatedOn = DateTime.UtcNow,
MembershipId = this.context?.Membership.FirstOrDefault(e => e.SchoolId == fieldsCategoryAddViewModel.fieldsCategory.SchoolId && e.TenantId == fieldsCategoryAddViewModel.fieldsCategory.TenantId).MembershipId
};
this.context?.RolePermission.Add(rolePermission);
}
}
this.context?.SaveChanges();
transaction.Commit();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = "Field Category Added Successfully";
}
}
}
catch (Exception es)
{
transaction.Rollback();
fieldsCategoryAddViewModel._failure = false;
fieldsCategoryAddViewModel._message = es.Message;
}
}
return(fieldsCategoryAddViewModel);
}
