public IActionResult Create(ESSEntryModel model)
{
if (model.ESSCode == null && model.EmployeeId == 0)
{
Employee employee = new Employee
{
Name = model.EmployeeName,
Designation = model.Designation,
Phone = model.EmployeePhone
};
_context.Employees.Add(employee);
string essCode = _ess.GenerateESSCode();
ESSInfo info = new ESSInfo
{
EmployeeId = employee.Id,
EntryTime = DateTime.UtcNow.Date,
WorkingArea = model.WorkingArea,
ESSCode = essCode
};
_context.ESSInfos.Add(info);
_context.SaveChanges();
return(Json(new { essCode, employeeId = employee.Id }));
}
else
{
Employee employee = new Employee
{
Id = model.EmployeeId,
Name = model.EmployeeName,
Designation = model.Designation,
Phone = model.EmployeePhone
};
_context.Employees.Update(employee);
ESSInfo info = _context.ESSInfos.Where(x => x.ESSCode == model.ESSCode).FirstOrDefault();
info.WorkingArea = model.WorkingArea;
_context.ESSInfos.Update(info);
if (model.Divisions.Count() > 0)
{
List <EmpDivisionMap> empDivisionMap = _context.EmpDivisionMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpDivisionMaps.RemoveRange(empDivisionMap);
foreach (var item in model.Divisions)
{
Division division = _context.Divisions.Where(x => x.Name == item).FirstOrDefault();
EmpDivisionMap empDivision = new EmpDivisionMap
{
EmployeeId = model.EmployeeId,
DivisionId = division.Id,
ESSInfoId = info.Id
};
_context.EmpDivisionMaps.Add(empDivision);
}
}
else
{
List <EmpDivisionMap> empDivisionMap = _context.EmpDivisionMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpDivisionMaps.RemoveRange(empDivisionMap);
}
if (model.Districts.Count() > 0)
{
List <EmpDistrictMap> empDistrictMaps = _context.EmpDistrictMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpDistrictMaps.RemoveRange(empDistrictMaps);
foreach (var item in model.Districts)
{
District district = _context.Districts.Where(x => x.Name == item).FirstOrDefault();
EmpDistrictMap empDistrict = new EmpDistrictMap
{
EmployeeId = model.EmployeeId,
DistrictId = district.Id,
ESSInfoId = info.Id
};
_context.EmpDistrictMaps.Add(empDistrict);
}
}
else
{
List <EmpDistrictMap> empDistrictMaps = _context.EmpDistrictMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpDistrictMaps.RemoveRange(empDistrictMaps);
}
if (model.Upazilas.Count() > 0)
{
List <EmpUpazilaMap> empUpazilaMaps = _context.EmpUpazilaMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpUpazilaMaps.RemoveRange(empUpazilaMaps);
foreach (var item in model.Upazilas)
{
Upazila upazila = _context.Upazilas.Where(x => x.Name == item).FirstOrDefault();
EmpUpazilaMap empUpazila = new EmpUpazilaMap
{
EmployeeId = model.EmployeeId,
UpazilaId = upazila.Id,
ESSInfoId = info.Id
};
_context.EmpUpazilaMaps.Add(empUpazila);
}
}
else
{
List <EmpDistrictMap> empDistrictMaps = _context.EmpDistrictMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpDistrictMaps.RemoveRange(empDistrictMaps);
}
if (model.Products.Count() > 0)
{
List <EmpProductMap> empProductMaps = _context.EmpProductMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpProductMaps.RemoveRange(empProductMaps);
foreach (var item in model.Products)
{
EmpProductMap empProduct = new EmpProductMap
{
EmployeeId = model.EmployeeId,
ESSInfoId = info.Id,
Price = item.Price,
Quantity = item.Quantity,
ProductId = item.Id
};
_context.EmpProductMaps.Add(empProduct);
}
}
else
{
List <EmpProductMap> empProductMaps = _context.EmpProductMaps.Where(x => x.ESSInfoId == info.Id).ToList();
_context.EmpProductMaps.RemoveRange(empProductMaps);
}
_context.SaveChanges();
}
return(View());
}
public IActionResult Edit(ESSEntryModel model)
{
var ess = _context.ESSInfos.SingleOrDefault(x => x.ESSCode == model.ESSCode);
var empProducts = _context.EmpProductMaps.Where(x => x.ESSInfoId == ess.Id).ToList();
_context.EmpProductMaps.RemoveRange(empProducts);
if (model.Products.Count() > 0)
{
foreach (var item in model.Products)
{
EmpProductMap empProduct = new EmpProductMap
{
EmployeeId = model.EmployeeId,
ESSInfoId = ess.Id,
Price = item.Price,
Quantity = item.Quantity,
ProductId = item.Id
};
_context.EmpProductMaps.Add(empProduct);
}
}
var empDivisions = _context.EmpDivisionMaps.Where(x => x.ESSInfoId == ess.Id).ToList();
_context.EmpDivisionMaps.RemoveRange(empDivisions);
if (model.Divisions.Count() > 0)
{
foreach (var item in model.Divisions)
{
Division division = _context.Divisions.Where(x => x.Name == item).FirstOrDefault();
EmpDivisionMap empDivision = new EmpDivisionMap
{
EmployeeId = model.EmployeeId,
DivisionId = division.Id,
ESSInfoId = ess.Id
};
_context.EmpDivisionMaps.Add(empDivision);
}
}
var empDistricts = _context.EmpDistrictMaps.Where(x => x.ESSInfoId == ess.Id).ToList();
_context.EmpDistrictMaps.RemoveRange(empDistricts);
if (model.Districts.Count() > 0)
{
foreach (var item in model.Districts)
{
District district = _context.Districts.Where(x => x.Name == item).FirstOrDefault();
EmpDistrictMap empDistrict = new EmpDistrictMap
{
EmployeeId = model.EmployeeId,
DistrictId = district.Id,
ESSInfoId = ess.Id
};
_context.EmpDistrictMaps.Add(empDistrict);
}
}
var empUpazilas = _context.EmpUpazilaMaps.Where(x => x.ESSInfoId == ess.Id).ToList();
_context.EmpUpazilaMaps.RemoveRange(empUpazilas);
if (model.Upazilas.Count() > 0)
{
foreach (var item in model.Upazilas)
{
Upazila upazila = _context.Upazilas.Where(x => x.Name == item).FirstOrDefault();
EmpUpazilaMap empUpazila = new EmpUpazilaMap
{
EmployeeId = model.EmployeeId,
UpazilaId = upazila.Id,
ESSInfoId = ess.Id
};
_context.EmpUpazilaMaps.Add(empUpazila);
}
}
_context.SaveChanges();
return(View());
}
