public ActionResult DistrictEdit(int CityCd = 0, int DistrictCd = 0)
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0;
if (currentUser == null || authorityList != 2)
{
return(RedirectToAction("Login", "UserAccount"));
}
DistrictModel model = new DistrictModel();
CommonService comService = new CommonService();
ManageDistrictDa dataAccess = new ManageDistrictDa();
if (CityCd > 0 && DistrictCd > 0)
{
model = dataAccess.getInfoDistrict(CityCd, DistrictCd);
}
model.CITY_LIST = comService.GetCityList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString(),
Text = f.CITY_NAME
}).ToList();
model.CITY_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = ""
});
return(View(model));
}
// GET: /AdminManageDistrict/
public ActionResult DistrictList()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser.USER_AUTHORITY;
if (currentUser == null || authorityList != 2)
{
return(RedirectToAction("Login", "UserAccount"));
}
DistrictModel model = new DistrictModel();
CommonService comService = new CommonService();
model.CITY_LIST = comService.GetCityList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString(),
Text = f.CITY_NAME
}).ToList();
model.CITY_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = ""
});
return(View(model));
}
public IActionResult Update([FromBody] DistrictModel itemDto)
{
return(new ControllerHelper <District, DistrictModel>(this, _mapper)
.Update(itemDto, (session, item) =>
{
var itemEx = session.Get <District>(item.ID);
if (itemEx == null)
{
throw new AppException("Record not found");
}
session.Evict(itemEx);
var exists = session.CreateCriteria <District>()
.Add(Restrictions.Eq("Name", item.Name))
.Add(!Restrictions.Eq("ID", item.ID))
.List <District>().Any();
if (exists)
{
throw new AppException($"District name {item.Name} already exists!");
}
TrackModification(item);
}, (session, item) =>
{
item = session.Get <District>(item.ID);
return _mapper.Map <DistrictModel>(item);
}));
}
public List <DistrictModel> ComboLoadByList()
{
List <DistrictModel> distList = new List <DistrictModel>();
try
{
string connstring = @"server=FARHANAMOSTO-PC; Database = CustomerDB;Integrated Security=true";
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
string cmdstring = @"select * from tblDistrict";
SqlCommand cmd = new SqlCommand(cmdstring, conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
DistrictModel d = new DistrictModel();
d.DId = Convert.ToInt16(sdr["DId"].ToString());
d.District = sdr["District"].ToString();
distList.Add(d);
}
conn.Close();
}
catch (Exception)
{
throw;
}
return(distList);
}
public long InsertDistrict(DistrictModel model)
{
long result = 0;
//Check create new customer
StringBuilder sqlinsert = new StringBuilder();
model.DEL_FLG = DeleteFlag.NON_DELETE;
sqlinsert.Append(@"
INSERT INTO [MstDistrict]
([CITY_CD]
,[DISTRICT_CD]
,[DISTRICT_NAME]
,[DSP_ORDER]
,[DEL_FLG]
,[STATUS]
,[INSIDE])
VALUES
(@CITY_CD,
@DISTRICT_CD,
@DISTRICT_NAME,
@DSP_ORDER,
@DEL_FLG,
@STATUS,
@INSIDE)");
result = base.DbAdd(sqlinsert.ToString(), model);
return(result);
}
public async Task <ResponseModel> Delete(DistrictModel model)
{
ResponseModel response = new ResponseModel();
try
{
District md = await _context.DistrictRepository.FirstOrDefaultAsync(m => m.Id == model.Id);
if (!md.RowVersion.SequenceEqual(model.RowVersion))
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData;
return(response);
}
md.Deleted = true;
md.UpdateBy = base.UserId;
md.UpdateDate = DateTime.Now;
_context.DistrictRepository.Update(md);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public JsonResult GetAllDistrictByUserPermission(int id)
{
List <DistrictModel> districtVMList = new List <DistrictModel>();
int userId = UserSession.GetUserIdFromSession();
var userPermissionObj = this.userPermissionService.GetUserPermissionByUserId(userId).Where(x => x.DivisionId == id || x.DivisionId == 0);
var districtAll = userPermissionObj.Where(x => x.DistrictId == 0);
IEnumerable <District> districtListObj = null;
if (districtAll.Count() > 0)
{
districtListObj = districtService.GetAllDistrict().Where(x => x.DivisionId == id);
}
else
{
var districtIds = userPermissionObj.Select(x => x.DistrictId);
districtListObj = districtService.GetAllDistrict().Where(x => districtIds.Contains(x.Id));
}
foreach (var district in districtListObj.Where(x => x.IsActive == true && x.Id > 0))
{
DistrictModel districtTemp = new DistrictModel();
districtTemp.Id = district.Id;
districtTemp.Name = district.Name;
districtVMList.Add(districtTemp);
}
return(Json(districtVMList, JsonRequestBehavior.AllowGet));
}
public ActionResult DistrictEditPopUp(string btnId, string formId, DistrictModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries))
{
return(AccessDeniedView());
}
var ds = _districtService.GetDistrictById(model.Id);
if (ds == null)
{
//No state found with the specified id
return(RedirectToAction("List"));
}
if (ModelState.IsValid)
{
ds = model.ToEntity(ds);
_districtService.UpdateDistrict(ds);
ViewBag.RefreshPage = true;
ViewBag.btnId = btnId;
ViewBag.formId = formId;
return(View(model));
}
//If we got this far, something failed, redisplay form
return(View(model));
}
public JsonResult LoadDistrict(int idProvince)
{
var xmlDoc = XDocument.Load(Server.MapPath("~/Assets/Client/data/Provinces_Data.xml"));
var tinh = xmlDoc
.Element("Root")
.Elements("Item")
.Single(x => x.Attribute("type").Value.Equals("province") &&
int.Parse(x.Attribute("id").Value) == idProvince);
var dsHuyen = new List <DistrictModel>();
DistrictModel district = null;
var dataHuyen = tinh.Elements("Item").Where(x => x.Attribute("type").Value.Equals("district"));
foreach (var item in dataHuyen)
{
district = new DistrictModel();
district.ID = int.Parse(item.Attribute("id").Value);
district.Name = item.Attribute("value").Value;
dsHuyen.Add(district);
}
return(Json(new
{
data = dsHuyen,
status = true
}, JsonRequestBehavior.AllowGet));
}
public ActionResult CreateDistrict(DistrictModel objDistrict)
{
var resultDto = new ResultDto();
if (ModelState.IsValid)
{
var districtDto = Mapper.Map <DistrictModel, DistrictDto>(objDistrict);
districtDto.UserId = UserInfo.UserID;
if (districtDto.DistrictID == 0)
{
resultDto = _districtService.Insert(districtDto);
}
else
{
resultDto = _districtService.Update(districtDto);
}
if (resultDto.ObjectId > 0)
{
districtDto = _districtService.GetByID(resultDto.ObjectId);
objDistrict = Mapper.Map <DistrictDto, DistrictModel>(districtDto);
resultDto.ObjectCode = districtDto.DistrictCode;
}
}
var stateSelectListDto = _stateservice.GetStateSelectList();
var stateSelectList = new SelectList(stateSelectListDto, "ID", "Text");
ViewBag.states = stateSelectList;
ViewBag.Result = resultDto;
return(View(objDistrict));
}
public IEnumerable <MstDistrictEx> SearchDistrictList(DataTableModel dt, DistrictModel model, out int total_row)
{
ManageDistrictDa dataAccess = new ManageDistrictDa();
IEnumerable <MstDistrictEx> results = dataAccess.SearchDistrictList(dt, model, out total_row);
return(results);
}
public ActionResult Save(DistrictModel District)
{
if (ModelState.IsValid)
{
using (MyDbContext dc = new MyDbContext())
{
if (District.Id > 0)
{
//Edit
var v = dc.tblDistrict.Where(a => a.Id == District.Id).FirstOrDefault();
if (v != null)
{
v.DistricName = District.DistricName;
v.RegionId = District.RegionId;
}
}
else
{
//Save
dc.tblDistrict.Add(District);
}
dc.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}
public async Task <IHttpActionResult> GetDistrict(DistrictModel district)
{
if (district == null)
{
return(BadRequest("Please provide valid inputs!"));
}
if (string.IsNullOrEmpty(district.Location))
{
return(BadRequest("Please provide valid location!"));
}
if (await AuthService.ValidateUserAndToken(district.Token, district.UserID, district.Email, district.Location))
{
var districts = await DistrictService.GetDistrict(district);
if (districts.Count > 0)
{
return(Ok(districts));
}
else
{
return(BadRequest("No Such District Exists!"));
}
}
else
{
return(Unauthorized());
}
}
public JsonResult LoadDistrict(int provinceID)
{
var xmlDoc = XDocument.Load(Server.MapPath(@"~/assets/client/data/Provinces_Data.xml"));
var xElement = xmlDoc.Element("Root").Elements("Item")
.Single(x => x.Attribute("type").Value == "province" && int.Parse(x.Attribute("id").Value) == provinceID);
var list = new List <DistrictModel>();
DistrictModel district = null;
foreach (var item in xElement.Elements("Item").Where(x => x.Attribute("type").Value == "district"))
{
district = new DistrictModel();
district.ID = int.Parse(item.Attribute("id").Value);
district.Name = item.Attribute("value").Value;
district.ProvinceID = int.Parse(xElement.Attribute("id").Value);
list.Add(district);
}
return(Json(new
{
data = list,
status = true
}));
}
public JsonResult LoadDistrict(string provinceName)
{
var xmlDoc = XDocument.Load(Server.MapPath(@"~/Contents/data/provinces-data.xml"));
// Lấy ra tỉnh theo tên truyền vào tương ứng
var xElement = xmlDoc.Element("Root").Elements("Item")
.Single(x => x.Attribute("type").Value == "province" &&
(x.Attribute("value").Value) == provinceName);
var list = new List <DistrictModel>();
DistrictModel districtModel = null;
// Vòng lặp các quận theo tỉnh
foreach (var item in xElement.Elements("Item").Where(x => x.Attribute("type").Value == "district"))
{
districtModel = new DistrictModel();
districtModel.Id = int.Parse(item.Attribute("id").Value);
districtModel.Name = item.Attribute("value").Value;
districtModel.ProvinceId = int.Parse(xElement.Attribute("id").Value);
list.Add(districtModel);
}
return(Json(new
{
data = list,
status = true
}));
}
/// <summary>
/// 递归根据code获取下一级
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public List <DistrictModel> DistrictChildren(List <DistrictModel> list)
{
List <DistrictModel> ModelData = new List <DistrictModel>();
List <DistrictModel> Model = new List <DistrictModel>();
foreach (var item in list)
{
var hasChildren = list.Where(x => x.DistrictCode.StartsWith(item.DistrictCode) && x.DistrictID != item.DistrictID);
if (hasChildren.Count() > 0)
{
foreach (var items in hasChildren)
{
var Children = new DistrictModel();
Children.DistrictID = items.DistrictID;
Children.DistrictName = items.DistrictName;
Children.DistrictCode = items.DistrictCode;
Children.ParentID = item.DistrictID;
Model.Add(Children);
}
}
else
{
ModelData.Add(item);
}
}
if (Model.Count() > 0)
{
var ChildrenList = DistrictChildren(Model);
ModelData.AddRange(ChildrenList);
}
return(ModelData);
}
public async Task <ResponseModel> Insert(DistrictModel model)
{
ResponseModel response = new ResponseModel();
try
{
District md = new District();
md.Name = model.Name;
md.ProvinceId = model.ProvinceId;
md.Precedence = model.Precedence;
md.IsActive = model.IsActive;
md.CreateBy = base.UserId;
md.CreateDate = DateTime.Now;
md.Deleted = false;
await _context.DistrictRepository.AddAsync(md).ConfigureAwait(true);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
/// <summary>
/// load ra danh sách các quận huyện (droplist)
/// </summary>
/// <param name="provinceID"></param>
/// <returns></returns>
public JsonResult LoadDistrict(int provinceID)
{
//ko hiểu thì mở sang file /assets/Client/Data/Provinces_Data.xml đọc lướt qua sẽ hiểu
var xmlDoc = XDocument.Load(Server.MapPath(@"~/assets/Client/Data/Provinces_Data.xml")); //load ra đối tượng trong assets
var xElement = xmlDoc.Element("Root").Elements("Item") //lấy phần tử có id bắt đầu bằng id của Province truyền vào
.Single(x => x.Attribute("type").Value == "province" && int.Parse(x.Attribute("id").Value) == provinceID); //lọc theo type có values province và parse id từ Provinces_Data.xml trùng với id truyền vào
var list = new List <DistrictModel>(); //khởi tạo 1 list theo định dạng ProvinceModel
DistrictModel district = null; //khởi tạo 1 biến có dạng ProvinceModel null
foreach (var item in xElement.Elements("Item").Where(x => x.Attribute("type").Value == "district")) //chạy lấy ra từng phần tử
{
district = new DistrictModel();
district.ID = int.Parse(item.Attribute("id").Value); //lấy ra id và value rồi parse sang int
district.Name = item.Attribute("value").Value;
district.ProvinceID = int.Parse(xElement.Attribute("id").Value);
list.Add(district); //add province theo định dạng list
}
return(Json(new
{
data = list,
status = true
}));
}
public DistrictModel UpdateDistrict(DistrictModel model)
{
var sql = "[Location].[InsertAnUpdateDistrict]";
var queryParams = new DynamicParameters();
queryParams.Add("@DistrictId", model.DistrictId);
queryParams.Add("@DistrictName", model.DistrictName);
queryParams.Add("@DistrictStateId", model.DistrictStateId);
queryParams.Add("@DistrictAddress", model.DistrictAddress);
queryParams.Add("@DistrictPhone", model.DistrictPhone);
queryParams.Add("@DistrictEmail", model.DistrictEmail);
queryParams.Add("@DistrictEmployees", model.DistrictEmployees);
queryParams.Add("@DistrictSubstitutes", model.DistrictSubstitutes);
queryParams.Add("@DistrictWorkLoad", model.DistrictWorkLoad);
queryParams.Add("@DistrictStaffingComp", model.DistrictStaffingComp);
queryParams.Add("@DistrictTimeZone", model.DistrictTimeZone);
queryParams.Add("@DistrictStartTime", model.DistrictStartTime);
queryParams.Add("@DistrictEndTime", model.DistrictEndTime);
queryParams.Add("@District1stHalfEnd", model.District1stHalfEnd);
queryParams.Add("@District2ndHalfStart", model.District2ndHalfStart);
queryParams.Add("@DistrictZipCode", model.DistrictZipCode);
queryParams.Add("@City", model.City);
queryParams.Add("@IsActive", model.IsActive);
queryParams.Add("@CountryId", model.CountryId);
model.DistrictId = Db.ExecuteScalar <int>(sql, queryParams, commandType: CommandType.StoredProcedure);
return(model);
}
/// <summary>
/// Get list of Districts
/// Filter by provinceId
/// </summary>
/// <param name="provinceId"></param>
/// <returns></returns>
public ActionResult FilterFromProvinceAjax(string provinceId)
{
//Use to generate VEP Search Reports
Session["SearchProvinceId"] = provinceId;
if (String.IsNullOrEmpty(provinceId))
{
provinceId = "-1";
}
var municipalityModel = new DistrictModel();
var municipalitiesList = municipalityModel.GetListOfDistricts(int.Parse(provinceId));
var result = (from x in municipalitiesList
orderby x.Description
select new
{
id = x.District_Id,
name = x.Description
})
.ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static string CreateDistrict(DistrictModel district, string connstring)
{
Dictionary <string, object> spParams = new Dictionary <string, object>();
spParams.Add("@Name", district.Name);
return(DBAccess.ExecuteSQLScalar(connstring, "CALL usp_InsertDistrict(@Name)", spParams));
}
public DistrictModel Post([FromBody] DistrictModel district)
{
Response.StatusCode = 201;
string result = DistrictService.CreateDistrict(district, dbConn);
district.Id = Convert.ToInt32(result);
return(district);
}
/// <summary>
/// Service Method To Get Districts
/// </summary>
/// <param name="district"></param>
/// <returns></returns>
public static async Task <List <DistrictModel> > GetDistrict(DistrictModel district)
{
List <DistrictModel> Districts = new List <DistrictModel>();
using (SqlConnection dbConn = new SqlConnection(selectConnection(district.Location)))
{
var isExistingDistrict = "SELECT * from District";
SqlDataReader reader;
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand(isExistingDistrict, dbConn);
reader = await cmd.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
DistrictModel districtItem = new DistrictModel();
districtItem.ID = reader.GetInt32(0);
districtItem.Name = reader.GetString(1);
districtItem.IsAvailable = reader.GetBoolean(2);
Districts.Add(districtItem);
}
}
}
catch (Exception ex)
{
reader = null;
ActionLogService.LogAction(new ActionLogModel()
{
UserID = district.UserID,
ActionPerformed = "District Exists Error : " + ex.Message,
MethodName = "GetDistrict",
IsError = true
},
district.Location);
}
finally
{
dbConn.Close();
ActionLogService.LogAction(new ActionLogModel()
{
UserID = district.UserID,
ActionPerformed = "Check If District Exists ",
MethodName = "GetDistrict",
IsError = false
},
district.Location);
}
return(Districts);
}
}
public District AddDistrict([FromBody] DistrictModel districtModel)
{
var city = _db.Cities.FirstOrDefault(x => x.CityID == districtModel.CityID);
var district = new District();
district.city = city;
district.DistrictName = districtModel.DistrictName;
_db.Districts.Add(district);
_db.SaveChanges();
return(district);
}
public IEnumerable <MstDistrictEx> SearchDistrictList(DataTableModel dt, DistrictModel model, out int total_row)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"
SELECT A. *, B.CITY_NAME
FROM MstDistrict A
LEFT JOIN MstCity B
ON A.CITY_CD = B.CITY_CD
WHERE
A.DEL_FLG = @DEL_FLG AND A.INSIDE = @INSIDE");
if (model.CITY_CD > 0)
{
sql.Append(" AND (A.CITY_CD LIKE @CITY_CD)");
}
if (!string.IsNullOrEmpty(model.DISTRICT_NAME))
{
sql.Append(" AND (A.DISTRICT_NAME LIKE @DISTRICT_NAME)");
}
int lower = dt.iDisplayStart + 1;
int upper = dt.iDisplayStart + dt.iDisplayLength;
PagingHelper.SQLParts parts;
PagingHelper.SplitSQL(sql.ToString(), out parts);
string sqlpage = PagingHelper.BuildPageQuery(lower, dt.iDisplayLength, parts);
string sqlcount = parts.sqlCount;
var dataList = base.Query <MstDistrictEx>(sqlpage,
new
{
DEL_FLG = model.DEL_FLG,
INSIDE = model.INSIDE,
CITY_CD = model.CITY_CD,
DISTRICT_NAME = '%' + model.DISTRICT_NAME + '%',
pageindex = lower,
pagesize = upper
}).ToList();
total_row = base.Query <int>(sqlcount,
new
{
DEL_FLG = model.DEL_FLG,
INSIDE = model.INSIDE,
CITY_CD = model.CITY_CD,
DISTRICT_NAME = '%' + model.DISTRICT_NAME + '%',
pageindex = lower,
pagesize = upper
}).FirstOrDefault();
return(dataList);
}
private async Task <BaseResult> Update(City city, int updateBy = 0, string updateByUserName = "")
{
var result = new BaseResult()
{
Result = Result.Success
};
var cityForUpdate = _cityRepository.Query().FirstOrDefault(c => c.Id == city.Id);
if (cityForUpdate == null || city.Id <= 0)
{
result.Result = Result.Failed;
result.Message = "Không tìm thấy thành phố yêu cầu!";
return(result);
}
else
{
var exists = _cityRepository.Query().Any(c => !c.IsDeleted && c.Name == city.Name && c.Id != cityForUpdate.Id);
if (exists)
{
result.Result = Result.Failed;
result.Message = "Tỉnh / thành phố đã tồn tại!";
return(result);
}
city.Name = city.Name.Trim();
city.UnsignName = !string.IsNullOrEmpty(city.Name) ? city.Name.Unsigned() : "";
}
try
{
cityForUpdate = city.ToCity(cityForUpdate);
//Cập nhật thông tin chung của thực thể
cityForUpdate = cityForUpdate.UpdateCommonInt(updateBy, updateByUserName);
await _cityRepository.UpdateAsync(cityForUpdate);
var districts = _districtRepository.Query()
.Include(d => d.City)
.Where(d => d.ParentId == cityForUpdate.Id)
.ToList();
foreach (District d in districts)
{
DistrictModel district = d.ToModel();
district.CityRealm = cityForUpdate.CityRealm;
await _districtService.CreateOrUpdate(district);
}
}
catch (Exception e)
{
result.Result = Result.SystemError;
result.Message = e.ToString();
}
return(result);
}
public DistrictModel UpdateSettings(DistrictModel model)
{
var sql = "[Location].[sp_updateDistrictSettings]";
var queryParams = new DynamicParameters();
queryParams.Add("@DistrictId", model.DistrictId);
queryParams.Add("@WeeklyHourLimit", model.WeeklyHourLimit);
queryParams.Add("@IsWeeklyLimitApplicable", model.IsWeeklyLimitApplicable ? 1: 0);
queryParams.Add("@DeductAfterTime", model.DeductAfterTime);
queryParams.Add("@IsDeductOnBreak", model.IsDeductOnBreak);
return(Db.Query <DistrictModel>(sql, queryParams, commandType: CommandType.StoredProcedure).FirstOrDefault());
}
public int AddDistrict(DistrictModel model)
{
using (var context = new HallAutomationSystemEntities())
{
District district = new District()
{
DistrictName = model.DistrictName
};
context.District.Add(district);
context.SaveChanges();
return(district.DistrictId);
}
}
public ActionResult Districts(DistrictModel model)
{
if (ModelState.IsValid)
{
int id = districtInformation.AddDistrict(model);
if (id > 0)
{
ModelState.Clear();
ViewBag.Success = "Data inserted";
}
}
return(View());
}
public ActionResult GetListOfMunicipalities(string provinceId)
{
var municipalityModel = new DistrictModel();
var municipalityList = municipalityModel.GetListOfDistricts(int.Parse(provinceId));
var result = (from x in municipalityList
select new
{
id = x.District_Id,
name = x.Description
}).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
