/// <summary>
/// Delete Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel DeleteCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
var customFieldDelete = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == customFieldAddViewModel.customFields.TenantId && x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.FieldId == customFieldAddViewModel.customFields.FieldId);
if (customFieldDelete != null)
{
var customFieldsValueExists = this.context?.CustomFieldsValue.FirstOrDefault(x => x.TenantId == customFieldDelete.TenantId && x.SchoolId == customFieldDelete.SchoolId && x.CategoryId == customFieldDelete.CategoryId && x.FieldId == customFieldDelete.FieldId);
if (customFieldsValueExists != null)
{
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = "It Can't Be Deleted Because It Has Association";
}
else
{
this.context?.CustomFields.Remove(customFieldDelete);
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
customFieldAddViewModel._message = "Custom Field Deleted Successfully";
}
}
}
catch (Exception es)
{
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = es.Message;
}
return(customFieldAddViewModel);
}
/// <summary>
/// Add Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel AddCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
if (!string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Type) && !string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Module))
{
int?MasterFieldId = Utility.GetMaxPK(this.context, new Func <CustomFields, int>(x => x.FieldId));
customFieldAddViewModel.customFields.FieldId = (int)MasterFieldId;
customFieldAddViewModel.customFields.LastUpdate = DateTime.UtcNow;
this.context?.CustomFields.Add(customFieldAddViewModel.customFields);
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
}
else
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = "Please enter Type and Module";
}
}
catch (Exception es)
{
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = es.Message;
}
return(customFieldAddViewModel);
}
/// <summary>
/// Update Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel UpdateCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
if (!string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Type) && !string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Module))
{
var customFieldUpdate = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == customFieldAddViewModel.customFields.TenantId && x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.FieldId == customFieldAddViewModel.customFields.FieldId);
customFieldAddViewModel.customFields.LastUpdate = DateTime.Now;
customFieldAddViewModel.customFields.SortOrder = customFieldUpdate.SortOrder;
customFieldAddViewModel.customFields.Module = customFieldUpdate.Module;
this.context.Entry(customFieldUpdate).CurrentValues.SetValues(customFieldAddViewModel.customFields);
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
customFieldAddViewModel._message = "Custom Field Updated Successfully";
}
else
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = "Please enter Type and Module";
}
}
catch (Exception ex)
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = ex.Message;
}
return(customFieldAddViewModel);
}
public ActionResult <CustomFieldAddViewModel> AddCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
CustomFieldAddViewModel customFieldAdd = new CustomFieldAddViewModel();
try
{
if (customFieldAddViewModel.customFields.SchoolId > 0)
{
customFieldAdd = _customFieldService.SaveCustomField(customFieldAddViewModel);
}
else
{
customFieldAdd._token = customFieldAddViewModel._token;
customFieldAdd._tenantName = customFieldAddViewModel._tenantName;
customFieldAdd._failure = true;
customFieldAdd._message = "Please enter valid school id";
}
}
catch (Exception es)
{
customFieldAdd._failure = true;
customFieldAdd._message = es.Message;
}
return(customFieldAdd);
}
/// <summary>
/// Add Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel AddCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
if (!string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Type) && !string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Module))
{
//int? MasterFieldId = Utility.GetMaxPK(this.context, new Func<CustomFields, int>(x => x.FieldId));
int?MasterFieldId = 1;
int?SortOrder = 1;
var CustomFieldData = this.context?.CustomFields.Where(x => x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.TenantId == customFieldAddViewModel.customFields.TenantId).OrderByDescending(x => x.FieldId).FirstOrDefault();
if (CustomFieldData != null)
{
MasterFieldId = CustomFieldData.FieldId + 1;
}
var SortOrderData = this.context?.CustomFields.Where(x => x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.TenantId == customFieldAddViewModel.customFields.TenantId && x.CategoryId == customFieldAddViewModel.customFields.CategoryId).OrderByDescending(x => x.SortOrder).FirstOrDefault();
if (SortOrderData != null)
{
SortOrder = SortOrderData.SortOrder + 1;
}
string fieldName = Regex.Replace(customFieldAddViewModel.customFields.Title, @"\s+", "");
customFieldAddViewModel.customFields.FieldId = (int)MasterFieldId;
customFieldAddViewModel.customFields.SortOrder = (int)SortOrder;
customFieldAddViewModel.customFields.LastUpdate = DateTime.UtcNow;
customFieldAddViewModel.customFields.FieldName = fieldName;
this.context?.CustomFields.Add(customFieldAddViewModel.customFields);
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
customFieldAddViewModel._message = "Custom Field Added Successfully";
}
else
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = "Please enter Type and Module";
}
}
catch (Exception es)
{
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = es.Message;
}
return(customFieldAddViewModel);
}
/// <summary>
/// Add Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel SaveCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
CustomFieldAddViewModel customFieldAdd = new CustomFieldAddViewModel();
if (TokenManager.CheckToken(customFieldAddViewModel._tenantName + customFieldAddViewModel._userName, customFieldAddViewModel._token))
{
customFieldAdd = this.customFieldRepository.AddCustomField(customFieldAddViewModel);
}
else
{
customFieldAdd._failure = true;
customFieldAdd._message = TOKENINVALID;
}
return(customFieldAdd);
}
public ActionResult <CustomFieldAddViewModel> DeleteCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
CustomFieldAddViewModel customFieldDelete = new CustomFieldAddViewModel();
try
{
customFieldDelete = _customFieldService.DeleteCustomField(customFieldAddViewModel);
}
catch (Exception es)
{
customFieldDelete._failure = true;
customFieldDelete._message = es.Message;
}
return(customFieldDelete);
}
/// <summary>
/// View Custom Field By Id
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
//public CustomFieldAddViewModel ViewCustomField(CustomFieldAddViewModel customFieldAddViewModel)
//{
// CustomFieldAddViewModel customFieldView = new CustomFieldAddViewModel();
// try
// {
// var CustomField = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == customFieldAddViewModel.customFields.TenantId && x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.FieldId == customFieldAddViewModel.customFields.FieldId);
// if (CustomField != null)
// {
// customFieldView.customFields = CustomField;
// customFieldView._failure = false;
// }
// else
// {
// customFieldView._failure = true;
// customFieldView._message = NORECORDFOUND;
// }
// }
// catch (Exception es)
// {
// customFieldView._failure = true;
// customFieldView._message = es.Message;
// }
// return customFieldView;
//}
/// <summary>
/// Update Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel UpdateCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
if (!string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Type) && !string.IsNullOrWhiteSpace(customFieldAddViewModel.customFields.Module))
{
var customFieldUpdate = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == customFieldAddViewModel.customFields.TenantId && x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.FieldId == customFieldAddViewModel.customFields.FieldId);
customFieldUpdate.TenantId = customFieldAddViewModel.customFields.TenantId;
customFieldUpdate.SchoolId = customFieldAddViewModel.customFields.SchoolId;
customFieldUpdate.FieldId = customFieldAddViewModel.customFields.FieldId;
customFieldUpdate.Type = customFieldAddViewModel.customFields.Type;
customFieldUpdate.Search = customFieldAddViewModel.customFields.Search;
customFieldUpdate.Title = customFieldAddViewModel.customFields.Title;
customFieldUpdate.SortOrder = customFieldAddViewModel.customFields.SortOrder;
customFieldUpdate.SelectOptions = customFieldAddViewModel.customFields.SelectOptions;
customFieldUpdate.CategoryId = customFieldAddViewModel.customFields.CategoryId;
customFieldUpdate.SystemField = customFieldAddViewModel.customFields.SystemField;
customFieldUpdate.Required = customFieldAddViewModel.customFields.Required;
customFieldUpdate.DefaultSelection = customFieldAddViewModel.customFields.DefaultSelection;
customFieldUpdate.Hide = customFieldAddViewModel.customFields.Hide;
customFieldUpdate.LastUpdate = DateTime.UtcNow;
customFieldUpdate.UpdatedBy = customFieldAddViewModel.customFields.UpdatedBy;
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
customFieldAddViewModel._message = "Entity Updated";
}
else
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = "Please enter Type and Module";
}
}
catch (Exception ex)
{
customFieldAddViewModel.customFields = null;
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = ex.Message;
}
return(customFieldAddViewModel);
}
/// <summary>
/// Delete Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel DeleteCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
try
{
var customFieldDelete = this.context?.CustomFields.FirstOrDefault(x => x.TenantId == customFieldAddViewModel.customFields.TenantId && x.SchoolId == customFieldAddViewModel.customFields.SchoolId && x.FieldId == customFieldAddViewModel.customFields.FieldId);
this.context?.CustomFields.Remove(customFieldDelete);
this.context?.SaveChanges();
customFieldAddViewModel._failure = false;
customFieldAddViewModel._message = "Deleted";
}
catch (Exception es)
{
customFieldAddViewModel._failure = true;
customFieldAddViewModel._message = es.Message;
}
return(customFieldAddViewModel);
}
/// <summary>
/// View Custom Field By Id
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
//public CustomFieldAddViewModel ViewCustomField(CustomFieldAddViewModel customFieldAddViewModel)
//{
// CustomFieldAddViewModel customFieldView = new CustomFieldAddViewModel();
// try
// {
// if (TokenManager.CheckToken(customFieldAddViewModel._tenantName, customFieldAddViewModel._token))
// {
// customFieldView = this.customFieldRepository.ViewCustomField(customFieldAddViewModel);
// }
// else
// {
// customFieldView._failure = true;
// customFieldView._message = TOKENINVALID;
// }
// }
// catch (Exception es)
// {
// customFieldView._failure = true;
// customFieldView._message = es.Message;
// }
// return customFieldView;
//}
/// <summary>
/// Update Custom Field
/// </summary>
/// <param name="customFieldAddViewModel"></param>
/// <returns></returns>
public CustomFieldAddViewModel UpdateCustomField(CustomFieldAddViewModel customFieldAddViewModel)
{
CustomFieldAddViewModel customFieldUpdate = new CustomFieldAddViewModel();
try
{
if (TokenManager.CheckToken(customFieldAddViewModel._tenantName + customFieldAddViewModel._userName, customFieldAddViewModel._token))
{
customFieldUpdate = this.customFieldRepository.UpdateCustomField(customFieldAddViewModel);
}
else
{
customFieldUpdate._failure = true;
customFieldUpdate._message = TOKENINVALID;
}
}
catch (Exception es)
{
customFieldUpdate._failure = true;
customFieldUpdate._message = es.Message;
}
return(customFieldUpdate);
}
