public IActionResult getComuna([FromBody] string code_ids)
{
try
{
Communes communes = new Communes();
var c = _db.communes.Where(c => c.code_deis.Equals(code_ids)).Select(per => new { per.id, per.name });
return(Ok(c));
}
catch (Exception)
{
return(BadRequest("Error.... Intente más tarde."));
}
}
public InsertData(string etat, Communes ele, CommunesViewModel view)
{
InitializeComponent();
this.DataContext = viewVM = view;
Etat = etat;
if (etat == "AJOUT")
{
this.Title = "Enregistrement d'un Quartier";
}
else
{
this.Title = "Modification d'un Quartier";
}
}
private void btnValider_Click(object sender, RoutedEventArgs e)
{
try
{
CommunesViewModel vm = this.DataContext as CommunesViewModel;
Communes ent = vm.SelectedData;
if (Etat == "AJOUT")
{
try
{
ent.Etat = "ACTIF";
ent.idHotel = 1;
viewVM.model.Communes.Add(ent);
viewVM.model.SaveChanges();
Msg = "OK";
this.Close();
}
catch (Exception ex)
{
Msg = "Error";
ErrorMsg = ex.Message;
}
}
else
{
try
{
viewVM.model.SaveChanges();
Msg = "OK";
this.Close();
}
catch (Exception ex)
{
Msg = "Error";
ErrorMsg = ex.Message;
}
}
}
catch (Exception)
{
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
//if (GlobalData.VerificationDroit("CanAddCommunes"))
//{
var result = MessageBox.Show("Voulez vous vraiment supprimer ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
if (dataGrid.SelectedItem != null)
{
try
{
viewM = this.Main.DataContext as CommunesViewModel;
Communes ent = dataGrid.SelectedItem as Communes;
ent.Etat = "SUPPRIMER";
viewM.model.SaveChanges();
viewM.Refresh();
MessageBox.Show("Opération effectuée avec succès", "Communes", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Communes", MessageBoxButton.OK, MessageBoxImage.Warning);
viewM.Refresh();
}
}
else
{
MessageBox.Show("Aucune ligne selectionnée dans la liste", "Communes", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
//}
}
public void Update(Communes entity)
{
_repositoryBase.Update(entity);
}
public void Delete(Communes entity)
{
_repositoryBase.Delete(entity);
}
public void Add(Communes entity)
{
_repositoryBase.Add(entity);
}
public static Communes ListOfCommunes()
{
Communes communes = new Communes();
List <Commune> coms = new List <Commune>();
try
{
using (var client = CommonUtility.GetHttpConnection("MutuelleSmartAPI"))
{
var URL = new Uri(client.BaseAddress, "communes");
var response = client.GetAsync(URL.ToString()).Result;
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
communes.status = 200;
var result = response.Content.ReadAsStringAsync().Result;
try
{
JsonConvert.DeserializeObject <USSD.Entities.Communes>(result).communes.ForEach(n => coms.Add(new Commune {
city_id = n.city_id, commune_name = n.commune_name, commune_id = n.commune_id
}));
}
catch
{
}
}
}
}
catch (Exception exp)
{
communes.status = 500;
coms.Add(new Commune {
city_id = 19, commune_id = 1, commune_name = "Kananga"
});
coms.Add(new Commune {
city_id = 19, commune_id = 2, commune_name = "Katoka"
});
coms.Add(new Commune {
city_id = 20, commune_id = 3, commune_name = "Bipemba"
});
coms.Add(new Commune {
city_id = 20, commune_id = 4, commune_name = "Dibindi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 5, commune_name = "Barumbu"
});
coms.Add(new Commune {
city_id = 21, commune_id = 6, commune_name = "Gombe"
});
coms.Add(new Commune {
city_id = 21, commune_id = 7, commune_name = "Masina"
});
coms.Add(new Commune {
city_id = 21, commune_id = 8, commune_name = "Matete"
});
coms.Add(new Commune {
city_id = 3, commune_id = 9, commune_name = "commune Annexe"
});
coms.Add(new Commune {
city_id = 3, commune_id = 10, commune_name = "Kamalondo"
});
coms.Add(new Commune {
city_id = 3, commune_id = 11, commune_name = "Lubumbashi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 12, commune_name = "Matadi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 13, commune_name = "Nzanza"
});
coms.Add(new Commune {
city_id = 21, commune_id = 14, commune_name = "Mvuzi"
});
coms.Add(new Commune {
city_id = 14, commune_id = 15, commune_name = "Kitotolo"
});
coms.Add(new Commune {
city_id = 18, commune_id = 16, commune_name = "Mbandaka"
});
coms.Add(new Commune {
city_id = 18, commune_id = 17, commune_name = "Wangata"
});
coms.Add(new Commune {
city_id = 13, commune_id = 18, commune_name = "Beni"
});
coms.Add(new Commune {
city_id = 13, commune_id = 19, commune_name = "Oicha"
});
coms.Add(new Commune {
city_id = 15, commune_id = 20, commune_name = "Goma"
});
coms.Add(new Commune {
city_id = 16, commune_id = 21, commune_name = "Birambizo"
});
coms.Add(new Commune {
city_id = 17, commune_id = 22, commune_name = "Bagira"
});
coms.Add(new Commune {
city_id = 17, commune_id = 23, commune_name = "Ibanda"
});
coms.Add(new Commune {
city_id = 17, commune_id = 24, commune_name = "Kadutu"
});
coms.Add(new Commune {
city_id = 1, commune_id = 25, commune_name = "Kolwezi"
});
coms.Add(new Commune {
city_id = 2, commune_id = 26, commune_name = "Likasi"
});
coms.Add(new Commune {
city_id = 3, commune_id = 27, commune_name = "Katuba"
});
coms.Add(new Commune {
city_id = 4, commune_id = 28, commune_name = "Bukama"
});
coms.Add(new Commune {
city_id = 5, commune_id = 29, commune_name = "Dilolo"
});
coms.Add(new Commune {
city_id = 6, commune_id = 30, commune_name = "Fungurume"
});
coms.Add(new Commune {
city_id = 7, commune_id = 31, commune_name = "Kabalo"
});
}
communes.communes = coms;
return(communes);
}
public static Communes ListOfCommunes()
{
Communes communes = new Communes();
List <Commune> coms = new List <Commune>();
communes.status = 200;
coms.Add(new Commune {
city_id = 19, commune_id = 1, commune_name = "Kananga"
});
coms.Add(new Commune {
city_id = 19, commune_id = 2, commune_name = "Katoka"
});
coms.Add(new Commune {
city_id = 20, commune_id = 3, commune_name = "Bipemba"
});
coms.Add(new Commune {
city_id = 20, commune_id = 4, commune_name = "Dibindi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 5, commune_name = "Barumbu"
});
coms.Add(new Commune {
city_id = 21, commune_id = 6, commune_name = "Gombe"
});
coms.Add(new Commune {
city_id = 21, commune_id = 7, commune_name = "Masina"
});
coms.Add(new Commune {
city_id = 21, commune_id = 8, commune_name = "Matete"
});
coms.Add(new Commune {
city_id = 3, commune_id = 9, commune_name = "commune Annexe"
});
coms.Add(new Commune {
city_id = 3, commune_id = 10, commune_name = "Kamalondo"
});
coms.Add(new Commune {
city_id = 3, commune_id = 11, commune_name = "Lubumbashi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 12, commune_name = "Matadi"
});
coms.Add(new Commune {
city_id = 21, commune_id = 13, commune_name = "Nzanza"
});
coms.Add(new Commune {
city_id = 21, commune_id = 14, commune_name = "Mvuzi"
});
coms.Add(new Commune {
city_id = 14, commune_id = 15, commune_name = "Kitotolo"
});
coms.Add(new Commune {
city_id = 18, commune_id = 16, commune_name = "Mbandaka"
});
coms.Add(new Commune {
city_id = 18, commune_id = 17, commune_name = "Wangata"
});
coms.Add(new Commune {
city_id = 13, commune_id = 18, commune_name = "Beni"
});
coms.Add(new Commune {
city_id = 13, commune_id = 19, commune_name = "Oicha"
});
coms.Add(new Commune {
city_id = 15, commune_id = 20, commune_name = "Goma"
});
coms.Add(new Commune {
city_id = 16, commune_id = 21, commune_name = "Birambizo"
});
coms.Add(new Commune {
city_id = 17, commune_id = 22, commune_name = "Bagira"
});
coms.Add(new Commune {
city_id = 17, commune_id = 23, commune_name = "Ibanda"
});
coms.Add(new Commune {
city_id = 17, commune_id = 24, commune_name = "Kadutu"
});
coms.Add(new Commune {
city_id = 1, commune_id = 25, commune_name = "Kolwezi"
});
coms.Add(new Commune {
city_id = 2, commune_id = 26, commune_name = "Likasi"
});
coms.Add(new Commune {
city_id = 3, commune_id = 27, commune_name = "Katuba"
});
coms.Add(new Commune {
city_id = 4, commune_id = 28, commune_name = "Bukama"
});
coms.Add(new Commune {
city_id = 5, commune_id = 29, commune_name = "Dilolo"
});
coms.Add(new Commune {
city_id = 6, commune_id = 30, commune_name = "Fungurume"
});
coms.Add(new Commune {
city_id = 7, commune_id = 31, commune_name = "Kabalo"
});
communes.communes = coms;
return(communes);
}
