private void GetDist()
{
try
{
distObj = new Districts(ComObj);
DataSet ds = distObj.selectmp(dist);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
DDL_Dist.DataSource = ds.Tables[0];
DDL_Dist.DataTextField = "DistrictName";
DDL_Dist.DataValueField = "DistrictCode";
DDL_Dist.DataBind();
DDL_Dist.Enabled = false;
}
}
}
catch (Exception ex)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> ");
}
}
public void Include(EntityData otherData)
{
Alerts.AddRange(otherData.Alerts);
EmailAlertRecipients.AddRange(otherData.EmailAlertRecipients);
SmsAlertRecipients.AddRange(otherData.SmsAlertRecipients);
AlertReports.AddRange(otherData.AlertReports);
AlertRules.AddRange(otherData.AlertRules);
ApplicationLanguages.AddRange(otherData.ApplicationLanguages);
ContentLanguages.AddRange(otherData.ContentLanguages);
Countries.AddRange(otherData.Countries);
DataCollectors.AddRange(otherData.DataCollectors);
Districts.AddRange(otherData.Districts);
GatewaySettings.AddRange(otherData.GatewaySettings);
HeadManagerConsents.AddRange(otherData.HeadManagerConsents);
HealthRisks.AddRange(otherData.HealthRisks);
HealthRiskLanguageContents.AddRange(otherData.HealthRiskLanguageContents);
Localizations.AddRange(otherData.Localizations);
LocalizedTemplates.AddRange(otherData.LocalizedTemplates);
NationalSocieties.AddRange(otherData.NationalSocieties);
Notifications.AddRange(otherData.Notifications);
Projects.AddRange(otherData.Projects);
SupervisorUserProjects.AddRange(otherData.SupervisorUserProjects);
ProjectHealthRisks.AddRange(otherData.ProjectHealthRisks);
RawReports.AddRange(otherData.RawReports);
Regions.AddRange(otherData.Regions);
Reports.AddRange(otherData.Reports);
Users.AddRange(otherData.Users);
UserNationalSocieties.AddRange(otherData.UserNationalSocieties);
Villages.AddRange(otherData.Villages);
Zones.AddRange(otherData.Zones);
}
public static List <Districts> GetAllDistricts()
{
List <Districts> lDist = new List <Districts>();
Districts dist;
using (OracleConnection conn = new OracleConnection(ConString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = conn;
cmd.CommandText = "select * from districts";
cmd.CommandType = CommandType.Text;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
dist = new Districts();
dist.DistrictId = reader.GetInt32(0);
dist.DistrictName = reader.GetString(1);
lDist.Add(dist);
}
conn.Close();
}
}
return(lDist);
}
public void bntCreate_Click(Object sender, EventArgs e)
{
var id = Page.Request.Params["id"];
var trackId = Convert.ToInt32(ddlTrack.SelectedValue);
var district = new Districts
{
Name = tbName.Text,
DeliveryTerms = Convert.ToInt32(tbDeliveryTerms.Text),
Monday = cbMonday.Checked ? 1 : 0,
Tuesday = cbTuesday.Checked ? 1 : 0,
Wednesday = cbWednesday.Checked ? 1 : 0,
Thursday = cbThursday.Checked ? 1 : 0,
Friday = cbFriday.Checked ? 1 : 0,
Saturday = cbSaturday.Checked ? 1 : 0,
Sunday = cbSunday.Checked ? 1 : 0,
ID = Convert.ToInt32(id),
TrackID = trackId
};
district.Update();
var dm = new DataManager();
dm.QueryWithoutReturnData(null, "UPDATE city SET TrackID = " + trackId + " WHERE DistrictID = " + district.ID);
//загружаем backend в оперативную память
var districts = new DAL.DataBaseObjects.Districts();
Application["Districts"] = districts.GetAllItemsToList();
Page.Response.Redirect("~/ManagerUI/Menu/Souls/DistrictsView.aspx");
}
public ActionResult CreateDistrict(Districts eDistricts)
{
string message = "";
if (ModelState.IsValid)
{
try
{
FASM_Enums.InfoMessages SaveResult = DistrictsBI.SaveDistricts(ref eDistricts);
switch (SaveResult)
{
case FASM_Enums.InfoMessages.Success:
message = FASM_Msg.SuccessfulSaved;
break;
case FASM_Enums.InfoMessages.AlreadyExist:
message = "Sorry! the district name already exist";
break;
}
return(Json(new { msg = message, JsonRequestBehavior.AllowGet }));
}
catch (Exception ex)
{
ViewBag.CatchedMsg = ex.Message;
}
}
return(View(eDistricts));
}
public GetFreightByServiceInputDto(ExpeditionService expeditionService, Districts origin, Districts destination, decimal weight)
{
this.ExpeditionService = expeditionService;
this.Origin = origin;
this.Destination = destination;
this.Weight = weight;
}
public void PopulateList(
IEnumerable <City> cities,
IEnumerable <District> districts,
IEnumerable <Position> positions)
{
foreach (var city in cities)
{
Cities.Add(new SelectListItem {
Value = city.Id.ToString(), Text = city.Name
});
}
foreach (var district in districts)
{
Districts.Add(new SelectListItem {
Value = district.Id.ToString(), Text = district.Name
});
}
foreach (var position in positions)
{
if (Positions.All(p => p.Id != position.Id))
{
Positions.Add(new PositionViewModel {
Id = position.Id, Name = position.Name, Selected = false
});
}
}
Positions.Sort((x, y) => x.Id - y.Id);
}
public async Task <IActionResult> Edit(string id, [Bind("DistCode,DistName,DistNameDari,DistNamePashto,ProvCode")] Districts districts)
{
if (id != districts.DistCode)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Entry(districts).State = EntityState.Modified;
_context.Entry(districts).Property("CreatedDate").IsModified = false;
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DistrictsExists(districts.DistCode))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
ViewData["ProvCode"] = new SelectList(_context.Provinces, "ProvCode", "ProvName", districts.ProvCode);
return(View(districts));
}
public IHttpActionResult GetDistricts(int?countryID, int?cityID)
{
if (countryID == null || cityID == null)
{
return(Json("0"));
}
List <Districts> districts = new List <Districts>();
try
{
Uri url = new Uri("https://namazvakitleri.diyanet.gov.tr/tr-TR/home/GetRegList?ChangeType=state&CountryId=" + countryID + "&Culture=tr-TR&StateId=" + cityID);
WebClient client = new WebClient();
client.Encoding = Encoding.UTF8;
string json = client.DownloadString(url);
JObject obj = JObject.Parse(json);
var stateRegList = obj["StateRegionList"].Children();
foreach (var item in stateRegList)
{
Districts rg = new Districts();
rg.CityID = (int)cityID;
rg.CountryID = (int)countryID;
rg.ID = Convert.ToInt32(item.Value <string>("IlceID"));
rg.DistrictName = item.Value <string>("IlceAdi");
districts.Add(rg);
}
}
catch (Exception)
{
return(Json("-1"));
}
return(Json(districts));
}
public ActionResult DeleteDistrict(Districts eDistricts)
{
string message = "";
try
{
if (eDistricts.DistrictId > 0)
{
FASM_Enums.InfoMessages DeleteResult = DistrictsBI.DeleteDistricts(eDistricts.DistrictId);
switch (DeleteResult)
{
case FASM_Enums.InfoMessages.Success:
message = "Successfully Deleted!";
break;
case FASM_Enums.InfoMessages.Failed:
message = "Still in Use!";
break;
}
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
catch (Exception ex)
{
ViewBag.CatchedMsg = ex.Message;
}
return(View());
}
/// <summary>
/// Get the current User instance
/// </summary>
/// <returns>The current user</returns>
public User GetDetail()
{
var user = new User(Users.fetchUserByIdentityId(managerIdentityId));
user.District = new District(Districts.fetchDistrictById(user.DistrictId.Value));
return(user);
}
public void Dropdown_IndexChanged(int index)
{
Districts name = (Districts)index - 1;
dataLoader.addDistrict(name);
Debug.Log("District Length after adding: " + dataLoader.selectedDistricts.Count);
}
//to Add New Districts
protected void AddNewDistricts()
{
dstM = new Districts();
showAddMaster = true;
showAddDetail = false;
Messages = "";
}
protected override async Task OnParametersSetAsync()
{
if (action == "fetch")
{
await FetchDistricts();
this.StateHasChanged();
}
else if (action == "create")
{
Messages = "Add Districts";
dstM = new Districts();
}
else if (paramDistrictID != "0")
{
if (action == "edit")
{
Messages = "Edit Districts";
}
else if (action == "delete")
{
Messages = "Delete Districts";
}
dstM = await Http.GetJsonAsync <Districts>("/api/Districts/Details/" + Convert.ToInt32(paramDistrictID));
}
}
public async Task <IActionResult> PutDistricts([FromRoute] int id, [FromBody] Districts districts)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != districts.DistrictId)
{
return(BadRequest());
}
_context.Entry(districts).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DistrictsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit(short districtId = 0)
{
var model = new DistrictEditModel();
if (districtId > 0)
{
var district = new Districts().Get(districtId);
if (district.DistrictId > 0)
{
model.DistrictId = district.DistrictId;
model.CountryId = district.CountryId;
model.ProvinceId = district.ProvinceId;
model.DistrictName = district.DistrictName;
model.DistrictDesc = district.DistrictDesc;
model.DisplayOrder = district.DisplayOrder;
model.CrUserId = district.CrUserId;
model.CrDateTime = district.CrDateTime;
model.ListProvinces = new Provinces().GetList(district.CountryId);
}
}
else
{
model.ListProvinces = new List <Provinces>();
}
return(View(model));
}
public JsonResult getCity(int id)
{
Districts districts = (Districts)Enum.GetValues(typeof(Districts)).GetValue(id);
List <Cities> list = new List <Cities>();
list = _context.Cities.Where(city => city.District == districts).ToList();
return(Json(new SelectList(list, "ID", "City")));
}
public virtual void Update(string name, string whatsapp, string address, string phone, Districts district)
{
Name = name;
_whatsappNumber = whatsapp;
_address = address;
_phone = phone;
_district = district;
}
public ActionResult Create([Bind(Include = "DistrictName,StateID")] Districts districts)
{
districts.ID = Guid.NewGuid().ToString();
db.Districts.Add(districts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Districts Districts()
{
if (_districts == null)
{
_districts = new Districts();
}
return(_districts);
}
public ActionResult DeleteConfirmed(int id)
{
Districts districts = db.Districts.Find(id);
db.Districts.Remove(districts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
static void Main(string[] args)
{
XmlSerializer xs = new XmlSerializer(typeof(Provinces));
StreamReader sr = new StreamReader("Provinces.xml");
Provinces provinces = xs.Deserialize(sr) as Provinces;
sr.Close();
foreach (Province p in provinces.ProvinceArray)
{
Console.WriteLine(
@"INSERT INTO Provinces (Province_ID, Province_Name) VALUES ({0}, '{1}') ;",
p.ID,
p.ProvinceName);
}
Console.WriteLine();
xs = new XmlSerializer(typeof(Cities));
sr = new StreamReader("Cities.xml");
Cities cities = xs.Deserialize(sr) as Cities;
sr.Close();
foreach (City c in cities.CityArray)
{
Console.WriteLine(
@"INSERT INTO City (City_id, Province_ID, City_Name, City_ZipCode) VALUES ({0}, {1}, '{2}', '{3}') ;",
c.ID,
c.PID,
c.CityName,
c.ZipCode);
}
Console.WriteLine();
xs = new XmlSerializer(typeof(Districts));
sr = new StreamReader("Districts.xml");
Districts districts = xs.Deserialize(sr) as Districts;
sr.Close();
foreach (District d in districts.DistrictArray)
{
Console.WriteLine(
@"INSERT INTO District (District_ID, City_ID, District_Name) VALUES ({0}, {1}, '{2}') ;",
d.ID,
d.CID,
d.DistrictName);
}
// 通过重定向，产生 .sql 文件
// A0205_XmlToSql.exe >> test.sql
}
/// <summary>
/// Gets 5 days forecast for a district ID.
/// </summary>
/// <param name="districts">The district identifier</param>
/// <returns>LocalForecast[]</returns>
public async Task <IEnumerable <Forecast> > GetForecastForLocation(Districts districts)
{
var requestUrl = DaiyCityForecastUrl + (int)districts + ".json";
var response = await GetHttpResponseFor(requestUrl);
var localForecast = JsonConvert.DeserializeObject <IEnumerable <Forecast> >(response);
return(localForecast);
}
protected override async Task OnInitAsync()
{
//districtsList = await Http.GetJsonAsync<List<Districts>>("api/Districts/Index");
districtsList = await Http.GetJsonAsync <Districts[]>("/api/Districts");
dstM = new Districts();
subdstD = new SubDistricts();
Messages = "";
}
public Tenant(string tenancyName, string name, string whatsapp, string address, string phone, Districts district)
: base(tenancyName.ToLower(), name)
{
_whatsappNumber = whatsapp;
_address = address;
_phone = phone;
_district = district;
_externalDomain = string.Empty;
}
protected void GetRate()
{
DObj = new Districts(ComObj);
//string getcat = "select Block_cat from pds.block_master where District_code ='" + distid + "' and block_code='" + ddl_block.SelectedValue +"'";
//DataSet dscat = DObj.selectAny(getcat);
//if (dscat.Tables[0].Rows.Count == 0)
//{
//}
//else
//{
// DataRow drcat = dscat.Tables[0].Rows[0];
// cat = drcat["Block_cat"].ToString();
//}
if (ddl_rate_type.SelectedItem.Value == "U")
{
string qry = "Select Uraban_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "'and District_code='" + distid + "'";
DObj = new Districts(ComObj);
DataSet ds = DObj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> ");
tx_rate_qt.ReadOnly = false;
tx_rate_qt.Focus();
tx_rate_qt.BackColor = System.Drawing.Color.White;
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
tx_rate_qt.Text = dr["Uraban_rate"].ToString();
tx_rate_qt.ReadOnly = true;
}
}
else
{
string qry = "Select Rural_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "'";
DObj = new Districts(ComObj);
DataSet ds = DObj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> ");
tx_rate_qt.ReadOnly = false;
tx_rate_qt.Focus();
tx_rate_qt.BackColor = System.Drawing.Color.White;
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
tx_rate_qt.Text = dr["Rural_rate"].ToString();
tx_rate_qt.ReadOnly = true;
}
}
}
/// <summary>
/// Create an intervention
/// </summary>
/// <param name="intervention">An intervention instance</param>
/// <returns>An instance of Intervention created</returns>
public bool createIntervention(Intervention intervention)
{
var newIntervention = new Intervention(Interventions.create(intervention));
newIntervention.InterventionType = new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
newIntervention.Client = new Client(Clients.fetchClientById((Guid)newIntervention.ClientId)); ///new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
newIntervention.District = new District(Districts.fetchDistrictById(newIntervention.Client.DistrictId)); //new InterventionType(InterventionTypes.fetchInterventionTypesById(intervention.InterventionTypeId.Value));
return(approveAnIntervention(newIntervention.Id));
}
/// <summary>
/// Задание удаления микрорайона
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
private Task OnDeleteDistrict(OnDelete <District> arg)
{
var item = Districts.FirstOrDefault(s => s.Id == arg.Id);
if (item != null)
{
Districts.Remove(item);
}
return(Task.CompletedTask);
}
public void Create(CreateDistrictInputDto inputDto)
{
var city = _cityRepository.FirstOrDefault(i => i.IdRajaOngkir == inputDto.IdCityRajaOngkir);
Validate.Found(city, "Kota");
var district = new Districts(inputDto.IdRajaOngkir, city, inputDto.Code, inputDto.Name);
_districtRepository.Insert(district);
}
void GetDist()
{
DObj = new Districts(ComObj);
DataSet ds = DObj.selectAll(" order by district_name");
ddldistrict.DataSource = ds.Tables[0];
ddldistrict.DataTextField = "district_name";
ddldistrict.DataValueField = "District_Code";
ddldistrict.DataBind();
//ddldistrict.Items.Insert(0, "--Select--");
}
public void T010_GetZipsFromDistrict_NY_29()
{
var req = new Districts(ConfigData.API_KEY);
var result = req.GetZipsFromDistrict("NY", 29);
Assert.IsTrue(result.Count() > 0, "GetZipsFromDistrict failed for NY-29");
}
public void T020_GetDistrictFromLatLong_22079()
{
var req = new Districts(ConfigData.API_KEY);
var result = req.GetDistrictFromLatLong(38.695, -77.214);
Assert.IsTrue(result.Count() > 0, "GetDistrictFromLatLong failed for 38.695, -77.214");
}
public void T001_GetDistrictsFromZip_22079()
{
var req = new Districts(ConfigData.API_KEY);
var result = req.GetDistrictsFromZip("22079");
Assert.IsTrue(result.Count() > 0, "GetDistrictsFromZip failed for 22079");
}
public JsonResult CreateDistrict(int id, string name, int city_id)
{
Districts dbEntry = new Districts();
dbEntry.name = name;
dbEntry.city_id = city_id;
dbEntry.Cities = repository.Cities.FirstOrDefault(x => x.id == dbEntry.city_id);
//dbEntry.city_name = dbEntry.Cities.name;
repository.CreateRecord<Districts>(dbEntry);
return Json(dbEntry, JsonRequestBehavior.AllowGet);
}
