private GeographicZone AddGeographicZoneToDB(GeographicZone zone) { using (var ctx = new BusinessContext()) { var result = ctx.GeographicZones.Add(zone); ctx.SaveChanges(); return(result); } }
public GeographicZone AddGeographicZone(GeographicZone zone) { try { if (IsZoneNameInUse(zone.Name)) { throw new DBFieldDuplicationException("This GeograpicZone name is already in use. (" + zone.Name + ")"); } return(AddGeographicZoneToDB(zone)); } catch (Exception) { return(null); } }
public static List <GeographicZoneModel> ToGeographicZoneModel(List <GeographicZone> l) { List <GeographicZoneModel> gzm = new List <GeographicZoneModel>(); foreach (var item in l) { GeographicZone gz = DataAccessAction.geographicZone.GetGeographicZoneById(item.Father); gzm.Add(new GeographicZoneModel { Id = item.Id, Father = item.Father, Name = item.Name, FatherName = (gz != null)?gz.Name:"", }); } return(gzm); }
public ActionResult Users() { if (Session["XenonStatus"] != null && ((string)Session["XenonStatus"]).Equals("admin")) { List <UserModel> lu = new List <UserModel>(); foreach (var item in DataAccessAction.user.GetAllUsers()) { //if (item.Status.Equals("admin")) //{ GeographicZone gz = DataAccessAction.geographicZone.GetGeographicZoneById(item.GeographicZone); lu.Add(new UserModel() { Id = item.Id, Username = item.Username, Mail = item.Mail, Status = item.Status, GeographicZone = item.GeographicZone, GeographicZoneName = (gz == null) ? "" : gz.Name }); /*else * { * lu.Add(new UserModel() * { * Id = item.Id, * Username = item.Username, * Mail = item.Mail, * Status = item.Status, * //GeographicZone = item.GeographicZone, * GeographicZoneName = "" * * }); * }*/ } return(View(lu)); } return(Redirect("/")); }
/* API WEB SERVICE */ public string UsersApi() { if (Session["XenonStatus"] != null && ((string)Session["XenonStatus"]).Equals("admin")) { List <UserModel> lu = new List <UserModel>(); foreach (var item in DataAccessAction.user.GetAllUsers()) { GeographicZone gz = DataAccessAction.geographicZone.GetGeographicZoneById(item.GeographicZone); lu.Add(new UserModel() { Id = item.Id, Username = item.Username, Mail = item.Mail, Status = item.Status, GeographicZone = item.GeographicZone, GeographicZoneName = (gz == null) ? "" : gz.Name }); } return(JsonConvert.SerializeObject(lu)); } return(JsonConvert.SerializeObject(new List <UserModel>())); }
private static void FillDatabase() { /** FILL GEOGRAPHIC ZONE **/ GeographicZone world = new GeographicZone() { Name = "World", Father = new Guid() }; /** Fill Continent **/ DataAccessAction.geographicZone.AddGeographicZone(world); GeographicZone europe = new GeographicZone() { Name = "Europe", Father = world.Id }; GeographicZone asia = new GeographicZone() { Name = "Asie", Father = world.Id }; GeographicZone africa = new GeographicZone() { Name = "Afrique", Father = world.Id }; GeographicZone america = new GeographicZone() { Name = "Amerique", Father = world.Id }; DataAccessAction.geographicZone.AddGeographicZone(europe); DataAccessAction.geographicZone.AddGeographicZone(asia); DataAccessAction.geographicZone.AddGeographicZone(africa); DataAccessAction.geographicZone.AddGeographicZone(america); /** Fill Europe Country **/ GeographicZone france = new GeographicZone() { Name = "France", Father = europe.Id, }; GeographicZone espagne = new GeographicZone() { Name = "Espagne", Father = europe.Id }; GeographicZone allemagne = new GeographicZone() { Name = "Allemagne", Father = europe.Id }; GeographicZone belgique = new GeographicZone() { Name = "Belgique", Father = europe.Id }; DataAccessAction.geographicZone.AddGeographicZone(france); DataAccessAction.geographicZone.AddGeographicZone(espagne); DataAccessAction.geographicZone.AddGeographicZone(allemagne); DataAccessAction.geographicZone.AddGeographicZone(belgique); /** fill asia country **/ GeographicZone china = new GeographicZone() { Name = "Chine", Father = asia.Id }; GeographicZone japan = new GeographicZone() { Name = "Japon", Father = asia.Id }; GeographicZone southKorea = new GeographicZone() { Name = "Coree du sud", Father = asia.Id }; DataAccessAction.geographicZone.AddGeographicZone(china); DataAccessAction.geographicZone.AddGeographicZone(japan); DataAccessAction.geographicZone.AddGeographicZone(southKorea); /** fill africa country **/ GeographicZone senegal = new GeographicZone() { Name = "Senegal", Father = africa.Id }; GeographicZone morroco = new GeographicZone() { Name = "Maroc", Father = africa.Id }; DataAccessAction.geographicZone.AddGeographicZone(senegal); DataAccessAction.geographicZone.AddGeographicZone(morroco); /** fill america country **/ GeographicZone usa = new GeographicZone() { Name = "USA", Father = america.Id }; GeographicZone canada = new GeographicZone() { Name = "Canada", Father = america.Id }; DataAccessAction.geographicZone.AddGeographicZone(usa); DataAccessAction.geographicZone.AddGeographicZone(canada); /** FILL USER **/ User sous = new User() { Id = new Guid(), Username = "******", Password = "******", Mail = "*****@*****.**", Status = "souscripteur", GeographicZone = world.Id, }; User admin = new User() { Id = new Guid(), Username = "******", Password = "******", Mail = "*****@*****.**", Status = "admin", GeographicZone = world.Id, }; User manager = new User() { Id = new Guid(), Username = "******", Password = "******", Mail = "*****@*****.**", Status = "manager", GeographicZone = europe.Id }; User collaborateur = new User() { Id = new Guid(), Username = "******", Password = "******", Mail = "*****@*****.**", Status = "collaborateur", GeographicZone = france.Id }; DataAccessAction.user.Register(sous); DataAccessAction.user.Register(admin); DataAccessAction.user.Register(manager); DataAccessAction.user.Register(collaborateur); /** FILL WALLET **/ Wallet textile = new Wallet() { Service = "textile", Image = "http://www.logoground.com/uploads/201612016-07-144914158textiles-logo.jpg" }; List <Wallet> lw = new List <Wallet> { new Wallet() { Service = "health", Image = "http://freedesignfile.com/upload/2016/05/Green-medical-health-logos-design-vector-05.jpg" }, new Wallet() { Service = "defense", Image = "https://stocklogos-pd.s3.amazonaws.com/styles/logo-medium-alt/logos/image/1424377465-a61786215a22f67da35e3fa9347f22ca.png?itok=Yze7BSsy" }, new Wallet() { Service = "sport", Image = "http://hddfhm.com/images/clipart-sports-logos-10.jpg" }, new Wallet() { Service = "bank", Image = "http://www.fsroundtable.org/wp-content/uploads/2015/06/dot-bank-logo-website.png" }, new Wallet() { Service = "technology", Image = "https://thumb1.shutterstock.com/display_pic_with_logo/1864790/429855787/stock-vector-tech-logo-technology-logo-element-429855787.jpg" }, new Wallet() { Service = "plastic", Image = "https://botw-pd.s3.amazonaws.com/styles/logo-thumbnail/s3/0011/5708/brand.gif?itok=cW1XHoHd" } }; Random r = new Random(); foreach (var item in lw) { DataAccessAction.wallet.AddWallet(item, sous.Id, (r.Next(0, 9) > 5)); } DataAccessAction.wallet.AddWallet(textile, manager.Id, true); generateContract(lw); lw = new List <Wallet>() { textile }; generateContract(lw); /** FILL CONTRACT **/ }