public void UpdateWard(WardDTO ward)
{
var wardEF = wardRepository.GetBy(ward.IdWard);
ward.MappingWard(wardEF);
wardRepository.Update(wardEF);
}
public ActionResult SearchWards(string id)
{
wardService warService = new wardService();
WardDTO ward = warService.GetbyId(id);
return(Json(ward));
}
public WardDTO Edit(long id, WardEntity ward)
{
var transaction = _humanManagerContext.Database.BeginTransaction();
try
{
WardEntity entity = _humanManagerContext.Wards.SingleOrDefault(item => item.Id == id);
if (entity != null)
{
// entity.Id = ward.Id;
entity.Name = ward.Name;
entity.District_Id = ward.District_Id;
_humanManagerContext.SaveChanges();
}
transaction.Commit();
WardDTO dto = _mapper.Map <WardDTO>(entity);
return(dto);
}
catch
{
transaction.Rollback();
return(null);
}
}
public object ImportNTM([FromBody] List <NTMRequestDTO> NTMData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(NTMData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
var xmlElements = new XElement("Data",
from item in NTMData
select new XElement("Item",
new XElement("Reporter", item.reporter),
new XElement("ReporterCode", item.reporter_code),
new XElement("Partner", item.partner),
new XElement("PartnerCode", item.partner_code),
new XElement("PartnerComment", item.partner_comment),
new XElement("ProductCode", item.product_code),
new XElement("ProductCoverage", item.product_coverage),
new XElement("HSRevision", item.hs_revision),
new XElement("ProductComment", item.product_comment),
new XElement("NTMCode", item.ntm_code),
new XElement("NTMRevision", item.ntm_revision),
new XElement("NTMComment", item.ntm_comment),
new XElement("CategoryCode", item.category_code)
));
string data = xmlElements.ToString();
Response = LegislationBUS.ImportNTM(xmlElements);
return(Response);
}
public object ImportLegislation([FromBody] List <LegislationRequestDTO> LegislationData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(LegislationData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
var xmlElements = new XElement("Data",
from item in LegislationData
select new XElement("Item",
new XElement("Title", item.title),
new XElement("Description", item.description),
new XElement("Summary", item.summary),
new XElement("StartDate", item.start_date),
new XElement("EndDate", item.end_date),
new XElement("CategoryCode", item.category_code),
new XElement("Reporter", item.reporter),
new XElement("ImplementingAuthority", item.implementing_authority),
new XElement("IsImportingCountry", item.is_importing_country),
new XElement("Agency", item.agency)
));
string data = xmlElements.ToString();
Response = LegislationBUS.ImportLegislation(xmlElements);
return(Response);
}
public object ImportWard([FromBody] List <WardRequestDTO> WardData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(WardData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
var xmlElements = new XElement("Data",
from item in WardData
select new XElement("Item",
new XElement("WardCode", item.ward_code),
new XElement("WardName", item.ward_name),
new XElement("Type", item.type),
new XElement("DistrictCode", item.district_code),
new XElement("DistrictName", item.district_name),
new XElement("CityCode", item.city_code),
new XElement("CityName", item.city_name),
new XElement("Population", item.population),
new XElement("Area", item.area)
));
string data = xmlElements.ToString();
Response = WardBUS.ImportWard(xmlElements);
return(Response);
}
public object ImportStore([FromBody] List <StoreRequestDTO> StoreData)
{
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(StoreData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
var xmlElements = new XElement("Data",
from item in StoreData
select new XElement("Item",
new XElement("Code", item.code),
new XElement("Name", item.name),
new XElement("Adress", item.adress),
new XElement("Information", item.information),
new XElement("WardCode", item.ward_code),
new XElement("Latitude", item.latitude),
new XElement("Longitude", item.longitude),
new XElement("CategoryCode", item.category_code),
new XElement("Type", item.type),
new XElement("Note", item.note)
));
string data = xmlElements.ToString();
Response = StoreBUS.ImportStore(xmlElements);
return(Response);
}
public ActionResult <Api <WardDTO> > AddWard(WardEntity ward)
{
WardDTO dto = _wardService.Save(ward);
Api <WardDTO> result = new Api <WardDTO>(200, dto, "Success", null);
return(Ok(result));
}
public static Ward MappingWard(this WardDTO wardDTO)
{
var ward = new Ward
{
NameWard = wardDTO.NameWard,
IdProvince = wardDTO.IdProvince
};
return(ward);
}
public static WardDTO MappingWardDto(this Ward ward)
{
var wardDTO = new WardDTO
{
NameWard = ward.NameWard,
IdProvince = ward.IdProvince
};
return(wardDTO);
}
private WardDTO ToDTO(Ward s)
{
WardDTO dto = new WardDTO();
dto.ward_ID = s.ward_ID;
dto.ward_dept = s.ward_dept;
dto.capacity = s.capacity;
dto.is_full = s.is_full;
return(dto);
}
public Ward ConvertToEF(WardDTO DTO)
{
var EF = new Ward()
{
WardId = DTO.WardId,
WardName = DTO.WardName,
W_DistrictId = DTO.W_DistrictId
};
return(EF);
}
public object CreateNewWard([FromBody] WardRequestDTO WardData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(WardData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
WardDTO UserResponse = new WardDTO();
Response = WardBUS.AddOrUpdateWard(WardData);
return(Response);
}
public WardDTO ConvertToDTO(Ward EF)
{
var DTO = new WardDTO()
{
WardId = EF.WardId,
WardName = EF.WardName,
W_DistrictId = EF.W_DistrictId
};
if (EF.District != null)
{
DTO.DistrictDTO = new ConvertDataDistrict().ConvertToDTO(EF.District);
}
return(DTO);
}
public WardDTO Save(WardEntity ward)
{
var transaction = _humanManagerContext.Database.BeginTransaction();
try
{
ward = _humanManagerContext.Wards.Add(ward).Entity;
_humanManagerContext.SaveChanges();
transaction.Commit();
WardDTO dto = _mapper.Map <WardDTO>(ward);
return(dto);
}
catch
{
transaction.Rollback();
return(null);
}
}
public void AddWard(WardDTO ward)
{
var wardEF = ward.MappingWard();
wardRepository.Add(wardEF);
}
public static void MappingWard(this WardDTO wardDto, Ward ward)
{
ward.NameWard = wardDto.NameWard;
ward.IdProvince = wardDto.IdProvince;
}
public static ResponseDTO GetAllWard(string city_code, string district_code, string ward_name, int page, int size)
{
ErrorDTO ErrorResponse = new ErrorDTO();
ResponseDTO Response = new ResponseDTO();
List <WardDTO> ListWardData = new List <WardDTO>();
SqlConnection con = connection.loadDB();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SearchWardData";
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "CityCode";
param1.SqlDbType = SqlDbType.VarChar;
param1.Value = city_code;
cmd.Parameters.Add(param1);
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "DistrictCode";
param2.SqlDbType = SqlDbType.VarChar;
param2.Value = district_code;
cmd.Parameters.Add(param2);
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "WardName";
param3.SqlDbType = SqlDbType.NVarChar;
param3.Value = ward_name;
cmd.Parameters.Add(param3);
SqlParameter param4 = new SqlParameter();
param4.ParameterName = "Page";
param4.SqlDbType = SqlDbType.Int;
param4.Value = page;
cmd.Parameters.Add(param4);
SqlParameter param5 = new SqlParameter();
param5.ParameterName = "Size";
param5.SqlDbType = SqlDbType.Int;
param5.Value = size;
cmd.Parameters.Add(param5);
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
WardDTO WardData = new WardDTO();
WardData.ID = Convert.ToInt64(reader["ID"].ToString());
WardData.WardCode = reader["ward_code"].ToString();
WardData.WardName = reader["ward_name"].ToString();
WardData.Type = reader["type"].ToString();
WardData.DistrictCode = reader["district_code"].ToString();
WardData.DistrictName = reader["district_name"].ToString();
WardData.CityCode = reader["city_code"].ToString();
WardData.CityName = reader["city_name"].ToString();
WardData.Population = Convert.ToInt64(reader["population"].ToString());
WardData.Area = Convert.ToInt64(reader["area"].ToString());
WardData.CreateAt = reader["create_at"].ToString();
WardData.UpdateAt = reader["update_at"].ToString();
ListWardData.Add(WardData);
ErrorResponse.Code = Convert.ToInt64(reader["Total"].ToString());
}
}
Response.Data = ListWardData;
Response.Error = ErrorResponse;
}
catch (Exception ex)
{
ErrorResponse.Code = 400;
ErrorResponse.Message = ex.ToString();
Response.Error = ErrorResponse;
}
finally
{
con.Close();
}
return(Response);
}
public static ResponseDTO GetWardByID(int id)
{
ErrorDTO ErrorResponse = new ErrorDTO();
ResponseDTO Response = new ResponseDTO();
List <WardDTO> ListWardData = new List <WardDTO>();
SqlConnection con = connection.loadDB();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SearchWardDataByID";
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "ID";
param1.SqlDbType = SqlDbType.NVarChar;
param1.Value = id;
cmd.Parameters.Add(param1);
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
WardDTO WardData = new WardDTO();
WardData.ID = Convert.ToInt16(reader["ID"].ToString());
WardData.WardCode = reader["ward_code"].ToString();
WardData.WardName = reader["ward_name"].ToString();
WardData.Type = reader["type"].ToString();
WardData.DistrictCode = reader["district_code"].ToString();
WardData.DistrictName = reader["district_name"].ToString();
WardData.CityCode = reader["city_code"].ToString();
WardData.CityName = reader["city_name"].ToString();
WardData.Population = Convert.ToInt64(reader["population"].ToString());
WardData.Area = Convert.ToInt64(reader["area"].ToString());
WardData.CreateAt = reader["create_at"].ToString();
WardData.UpdateAt = reader["update_at"].ToString();
ListWardData.Add(WardData);
}
}
Response.Data = ListWardData;
}
catch (Exception ex)
{
ErrorResponse.Code = 400;
ErrorResponse.Message = ex.ToString();
Response.Error = ErrorResponse;
}
finally
{
con.Close();
}
return(Response);
}
