public JsonResult DeleteUpazila(Upazila upazila)
{
var isSuccess = true;
var message = string.Empty;
const string url = "/Upazila/Index";
permission = (RoleSubModuleItem)cacheProvider.Get(cacheKey) ?? roleSubModuleItemService.GetRoleSubModuleItemBySubModuleIdandRole(url,
Helpers.UserSession.GetUserFromSession().RoleId);
if (permission.DeleteOperation == true)
{
isSuccess = this.upazilaService.DeleteUpazila(upazila.Id);
if (isSuccess)
{
message = Resources.ResourceUpazila.MsgUpazilaDeleteSuccessful;
}
else
{
message = Resources.ResourceUpazila.MsgUpazilaDeleteFailed;
}
}
else
{
message = Resources.ResourceCommon.MsgNoPermissionToDelete;
}
return(Json(new
{
isSuccess = isSuccess,
message = message
}, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit(int id, [Bind("UpazilaId,UpazilaName,DistricId,DivisionId,EntryDate")] Upazila upazila)
{
if (id != upazila.UpazilaId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(upazila);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UpazilaExists(upazila.UpazilaId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DivisionId"] = new SelectList(_context.Division, "DivisionId", "DivisionName", upazila.DivisionId);
return(View(upazila));
}
public void Delete(int id)
{
var Upazila = new Upazila
{
UpazilaId = id
};
unitOfWork.UpazilaRepository.Delete(Upazila);
unitOfWork.Save();
}
public void Create(UpazilaViewModel upazilaVM)
{
var Upazila = new Upazila
{
UpazilaName = upazilaVM.UpazilaName
};
unitOfWork.UpazilaRepository.Insert(Upazila);
unitOfWork.Save();
}
public void Update(UpazilaViewModel upazilaVM)
{
var Upazila = new Upazila
{
UpazilaId = upazilaVM.UpazilaId,
UpazilaName = upazilaVM.UpazilaName
};
unitOfWork.UpazilaRepository.Update(Upazila);
unitOfWork.Save();
}
public async Task <IActionResult> Create([Bind("Id,DistrictId,Name")] Upazila upazila)
{
if (ModelState.IsValid)
{
_context.Add(upazila);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DistrictId"] = new SelectList(_context.Districts, "Id", "Id", upazila.DistrictId);
return(View(upazila));
}
public async Task <IActionResult> Create([Bind("UpazilaId,UpazilaName,DistricId,DivisionId")] Upazila upazila)
{
if (ModelState.IsValid)
{
upazila.EntryDate = DateTime.Now;
_context.Add(upazila);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DivisionId"] = new SelectList(_context.Division, "DivisionId", "DivisionName", upazila.DivisionId);
return(View(upazila));
}
public bool UpdateUpazila(Upazila upazila)
{
bool isSuccess = true;
try
{
upazilaRepository.Update(upazila);
this.SaveRecord();
ServiceUtil <Upazila> .WriteActionLog(upazila.Id, ENUMOperation.UPDATE, upazila);
}
catch (Exception ex)
{
isSuccess = false;
logger.Error("Error in updating Upazila", ex);
}
return(isSuccess);
}
public List <Upazila> GetAllUpazila(int districtId)
{
string getUpazila = "SELECT * FROM tbl_upazila where district_id = '" + districtId + "' Order By upazila_name ASC";
ConnectionObj.Open();
CommandObj.CommandText = getUpazila;
SqlDataReader reader = CommandObj.ExecuteReader();
var upazilaList = new List <Upazila>();
while (reader.Read())
{
Upazila aUpazila = new Upazila();
aUpazila.Id = Convert.ToInt32(reader["id"].ToString());
aUpazila.UpazilaName = reader["upazila_name"].ToString();
upazilaList.Add(aUpazila);
}
reader.Close();
ConnectionObj.Close();
return(upazilaList);
}
private UpazilaModel PrepareUpazilaModel(Upazila upazila)
{
UpazilaModel upazilaTemp = new UpazilaModel();
upazilaTemp.Id = upazila.Id;
upazilaTemp.Name = upazila.Name;
upazilaTemp.DistrictId = upazila.DistrictId;
if (upazilaTemp.DistrictId > 0)
{
var district = districtService.GetDistrict(Convert.ToInt32(upazila.DistrictId));
upazilaTemp.DistrictName = district.Name;
upazilaTemp.DivisionId = district.DivisionId;
upazilaTemp.DivisionName = district.Division.Name;
}
if (upazila.IsActive != null)
{
upazilaTemp.IsActive = upazila.IsActive.Value;
}
return(upazilaTemp);
}
public JsonResult SaveUpazila(int dsid, string upzname)
{
var ds = _context.District.FirstOrDefault(x => x.Id == dsid);
if (ds == null)
{
return(Json(new { result = "failed", message = "Sorry ! District is not found." }));
}
if (string.IsNullOrEmpty(upzname))
{
return(Json(new { result = "failed", message = "Sorry ! Null or Empty could not be stored." }));
}
Upazila upz = new Upazila();
upz.Name = upzname;
upz.DistrictId = dsid;
_context.Upazila.Add(upz);
_context.SaveChanges();
return(Json(new { result = "ok", message = "Upazila info is saved successfully." }));
}
public JsonResult GetUpazilaAll()
{
Upazila upazila = new Upazila();
return(Json(upazila.GetUpazilaAll(), JsonRequestBehavior.AllowGet));
}
public JsonResult GetUpazila(UpazilaFilter filter)
{
Upazila upazila = new Upazila();
return(Json(upazila.GetUpazila(filter), JsonRequestBehavior.AllowGet));
}
public ActionResult UpazilaCreate(/*[Bind(Include = "UpazilaName,ZilaId")] */ Upazila upazila, int?Zilaid)
{
int er = 0;
if (Zilaid == null)
{
er++;
}
if (er > 0)
{
ViewBag.ZilaId = new SelectList(db.Zilas, "ZilaId", "ZilaName");
return(View());
}
if (ModelState.IsValid)
{
db.Upazilas.Add(upazila);
db.SaveChanges();
return(RedirectToAction("UpazilaInformation", "Address"));
}
ViewBag.ZilaId = new SelectList(db.Zilas, "ZilaId", "ZilaName");
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());
}
public JsonResult CreateUpazila(Upazila upazila)
{
const string url = "/Upazila/Index";
permission = (RoleSubModuleItem)cacheProvider.Get(cacheKey);
if (permission == null)
{
permission = roleSubModuleItemService.GetRoleSubModuleItemBySubModuleIdandRole(url, Helpers.UserSession.GetUserFromSession().RoleId);
}
var isSuccess = false;
var message = string.Empty;
var isNew = upazila.Id == 0 ? true : false;
if (isNew)
{
if (permission.CreateOperation == true)
{
if (!CheckIsExist(upazila))
{
if (this.upazilaService.CreateUpazila(upazila))
{
isSuccess = true;
message = Resources.ResourceUpazila.MsgUpazilaSaveSuccessful;
}
else
{
message = Resources.ResourceUpazila.MsgUpazilaSaveFailed;
}
}
else
{
isSuccess = false;
message = Resources.ResourceUpazila.MsgDuplicateUpazila;
}
}
else
{
message = Resources.ResourceCommon.MsgNoPermissionToCreate;
}
}
else
{
if (permission.UpdateOperation == true)
{
if (this.upazilaService.UpdateUpazila(upazila))
{
isSuccess = true;
message = Resources.ResourceUpazila.MsgUpazilaUpdateSuccessful;
}
else
{
message = Resources.ResourceUpazila.MsgUpazilaUpdateFailed;
}
}
else
{
message = Resources.ResourceCommon.MsgNoPermissionToUpdate;
}
}
return(Json(new
{
isSuccess = isSuccess,
message = message,
}, JsonRequestBehavior.AllowGet));
}
private bool CheckIsExist(Upazila upazila)
{
return(this.upazilaService.CheckIsExist(upazila));
}
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 bool CheckIsExist(Upazila upazila)
{
return(upazilaRepository.Get(chk => chk.Name == upazila.Name && chk.DistrictId == upazila.DistrictId) == null ? false : true);
}
