public async Task <IActionResult> AddEditField(int id)
{
AddEditFieldViewModel model = new AddEditFieldViewModel();
model.SelectGroupList = await _context.SelectGroups.ToListAsync();
model.ICategories = await _context.Categories.Select(s => new SelectListItem
{
Text = s.Title,
Value = s.Id.ToString()
}).ToListAsync();
model.SelectFiledGroupList = await _context.FieldGroups.ToListAsync();
model.FildTypeModels = await _context.FieldTypes.Where(x => x.Id < 5).ToListAsync();
if (id != 0)
{
using (_serviceProvider.GetRequiredService <ApplicationDbContext>())
{
Field field = await _context.Fields.Where(a => a.Id == id).SingleOrDefaultAsync();
var select = _context.ProductCategoryFields.Where(a => a.IdFaild == id);
int[] b = new int[999];
int i = 0;
foreach (var item in select)
{
try
{
b[i] = item.IdCategory;
}
catch (Exception e)
{
throw;
}
i++;
}
if (field != null)
{
model.Id = field.Id;
model.Title = field.Title;
model.Type = field.Type;
model.IdSelectGroup = field.IdSelectGroup;
model.IdFieldGroup = field.IdFieldGroup;
model.IdCategory = b;
}
}
}
return(PartialView("AddEditField", model));
}
public async Task <IActionResult> AddEditField(int Id, AddEditFieldViewModel model, string redirectUrl)
{
if (ModelState.IsValid)
{
var query = (from f in _context.Fields
join pcf in _context.ProductCategoryFields on f.Id equals pcf.IdFaild
select new ProductFieldViewModel()
{
Type = f.Type,
IdProduct = f.Id,
IdCategory = pcf.IdCategory
}).Where(x => x.Type == 4);
if (Id == 0)
{
using (var db = _serviceProvider.GetRequiredService <ApplicationDbContext>())
{
//model.Type = (short)model.SelecteFieldTypeId;
int[] aa = model.IdCategory;
if (model.IdSelectGroup == 0)
{
model.IdSelectGroup = -1;
}
Field fieldModel = AutoMapper.Mapper.Map <AddEditFieldViewModel, Field>(model);
if (!CheckDuplicateDrp(model.IdCategory) || model.Type != 4)
{
db.Fields.Add(fieldModel);
await db.SaveChangesAsync();
var select = _context.Fields.LastOrDefault();
int ss = select.Id;
foreach (var item in aa)
{
ProductCategoryFields groupField = new ProductCategoryFields();
groupField.IdFaild = ss;
groupField.IdCategory = item;
db.ProductCategoryFields.Add(groupField);
//Add to ProductFields
ProductField pf = new ProductField();
var selectProducts = _context.Products.Where(x => x.IdCategory == item);
foreach (var itemProduct in selectProducts)
{
pf.IdProduct = itemProduct.Id;
pf.IdField = ss;
pf.Value = null;
db.ProductFields.Add(pf);
}
//Add to ProductFields
}
await db.SaveChangesAsync();
}
else
{
TempData["Notif"] = Notification.ShowNotif("فیلد خودرد ها قبلا به این دسته بندی اضافه شده است", type: ToastType.red);
return(PartialView("_Succefullyresponse", redirectUrl));
}
}
TempData["Notif"] = Notification.ShowNotif(MessageType.Add, type: ToastType.green);
return(PartialView("_Succefullyresponse", redirectUrl));
}
//Edit
else
{
using (var db = _serviceProvider.GetRequiredService <ApplicationDbContext>())
{
db.ProductCategoryFields.RemoveRange(_context.ProductCategoryFields.Where(x => x.IdFaild == Id));
if (model.ICategories != null)
{
}
await db.SaveChangesAsync();
if (!CheckDuplicateDrp(model.IdCategory))
{
var selectType = _context.Fields.AsNoTracking().Where(x => x.Id == Id).AsNoTracking().FirstOrDefault();
if (selectType.Type == 4 && model.Type != 4)
{
int idProductField = _context.ProductFields.Where(x => x.IdField == selectType.Id).AsNoTracking().FirstOrDefault().Id;
db.ProductSelectedItems.RemoveRange(_context.ProductSelectedItems.Where(x => x.IdProductField == idProductField));
//await db.SaveChangesAsync();
}
model.Type = (short)model.Type;
if (model.IdSelectGroup == 0)
{
model.IdSelectGroup = -1;
}
int[] aa = model.IdCategory;
Field fieldModel = AutoMapper.Mapper.Map <AddEditFieldViewModel, Field>(model);
try
{
db.Fields.Update(fieldModel);
}
catch (Exception e)
{
throw;
}
foreach (var item in aa)
{
ProductCategoryFields groupField = new ProductCategoryFields();
groupField.IdFaild = Id;
groupField.IdCategory = item;
db.ProductCategoryFields.Add(groupField);
}
await db.SaveChangesAsync();
}
else
{
TempData["Notif"] = Notification.ShowNotif("فیلد خودرد ها قبلا به این دسته بندی اضافه شده است", type: ToastType.red);
return(PartialView("_Succefullyresponse", redirectUrl));
}
}
TempData["Notif"] = Notification.ShowNotif(MessageType.Edit, type: ToastType.blue);
return(PartialView("_Succefullyresponse", redirectUrl));
}
}
if (Id == 0)
{
TempData["Notif"] = Notification.ShowNotif(MessageType.addError, type: ToastType.yellow);
}
else
{
TempData["Notif"] = Notification.ShowNotif(MessageType.editError, type: ToastType.yellow);
}
model.SelectGroupList = await _context.SelectGroups.ToListAsync();
//model.SelectGroupList = await _context.SelectGroups.Select(c => new SelectListItem()
//{
// Text = c.Title,
// Value = c.Id.ToString()
//}).ToListAsync();
return(PartialView("AddEditField", model));
}