public async Task <List <MarkerOutput> > Goster(marker Il)
{
var output = new List <MarkerOutput>();
var db = client.GetDatabase("Sehirler");
var collection = db.GetCollection <BsonDocument>("AkaryakitIStasyonlari");
var filter = Builders <BsonDocument> .Filter.Eq("Il", Il.Il);
//var result = collection.Find(filter).FirstOrDefault();
var result = collection.Find(filter).ToList();
if (result.Count > 0)
{
foreach (var item in result)
{
var gelen = new MarkerOutput()
{
Geo = new GeoPointBs()
{
type = item["Geo"]["type"].AsString,
coordinates = item["Geo"]["coordinates"].AsBsonArray
},
Il = item["Il"].AsString,
Ad = item["Ad"].AsString
};
output.Add(gelen);
}
}
return(output);
}
public async Task <List <markerIl> > ComboSehirDoldur(marker Il)
{
var db = client.GetDatabase("Sehirler");
var collection = db.GetCollection <BsonDocument>("AkaryakitIStasyonlari");
//var filter = Builders<BsonDocument>.Filter.Ne("Il", "");
var output = new List <markerIl>();
//var result = collection.Find(filter).ToList();
var aggregate = collection.Aggregate()
.Group(new BsonDocument {
{ "_id", "$Il" }, { "count", new BsonDocument("$sum", 1) }
})
.Sort(new BsonDocument {
{ "count", -1 }
});
var results = await aggregate.ToListAsync();
if (results.Count > 0)
{
foreach (var item in results)
{
var gelen = new markerIl()
{
Il = item["_id"].AsString,
count = item["count"].AsInt32
};
output.Add(gelen);
}
}
return(output);
}
public ActionResult Delete(marker marker)
{
using (RnBEntities db = new RnBEntities())
{
db.Entry(marker).State = EntityState.Deleted;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public void CopyTo(marker marker)
{
foreach (var propertyInfo in marker.GetType().GetProperties())
{
if (!propertyInfo.Name.Contains("Id") && (propertyInfo.PropertyType.IsValueType || propertyInfo.PropertyType.Name == "String"))
{
propertyInfo.SetValue(marker, propertyInfo.GetValue(this));
}
}
}
public ActionResult AddPlace(marker Marker)
{
if (!ModelState.IsValid)
{
return(HttpNotFound());
}
using (RnBEntities db = new RnBEntities())
{
db.markers.Add(Marker);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(marker marker)
{
using (RnBEntities db = new RnBEntities())
{
if (!ModelState.IsValid)
{
return(HttpNotFound());
}
db.markers.Attach(marker);
db.Entry(marker).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public NewMarkerModel(marker marker)
{
foreach (var propertyInfo in marker.GetType().GetProperties())
{
if (propertyInfo.PropertyType.IsValueType || propertyInfo.PropertyType.Name == "String")
{
propertyInfo.SetValue(this, propertyInfo.GetValue(marker));
}
}
WorkTimes = marker.worktime.ToList();
SubCategories = marker.subcategory.Select(sc => sc.CategoryId).ToList();
Phones = marker.phone.Select(p => p.Number).ToList();
marker_photos = marker.marker_photos.ToList();
}
// Start is called before the first frame update
void Start()
{
hs = PlayerStats.stats.GetMaxInk();
HSMarker.position = Vector2.right * hs;
HSText.text = hs.ToString("0.0");
pencil.SetPosition(1, Vector2.right * hs);
for (int i = 0; i < 8; i++)
{
GameObject g = GameObject.Instantiate(markerPrefab, Vector3.right * i * 5, Quaternion.identity, markerParent);
marker m = g.GetComponent <marker>();
m.SetPos(i * 5, i * 5 >= hs);
markers.Add(m);
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (RnBEntities db = new RnBEntities())
{
marker marker = db.markers.Find(id);
if (marker == null)
{
return(HttpNotFound());
}
return(View(marker));
}
}
private void user_level_handler(object sender, EventArgs e)
{
marker temp = user_insertion_correct().Level;
if (marker.convert_marker(user_level.Text) <= user_insertion_correct().Initial_level)
{
MessageBox.Show("Права користувача змінено!");
user_insertion_correct().Level = marker.convert_marker(user_level.Text);
T.Rows[user_insertion_correct().Number + 1].Cells[0].Value = data.get_user(user_insertion_correct().Number).Name + ": " + (data.get_user(user_insertion_correct().Number).Level.convert_marker());
}
else
{
MessageBox.Show("Користувачу неможливо надати такі права");
user_level.Text = temp.convert_marker();
user_insertion_correct().Level = temp;
}
}
public static async Task <List <marker> > GetMarcadores()
{
List <marker> markers = new List <marker>();
var inspectionDaily = db.InspectionDaily.Include(i => i.InspectionState)
.Include(u => u.UserDBs);
foreach (var item in await inspectionDaily.Where(i => i.IdStatus != 2).OrderBy(u => u.UserDBs.UserName)
.ToListAsync())
{
marker marker = new marker();
marker.User = item.UserDBs.UserName;
marker.Status = item.InspectionState.Description;
marker.Text = "NumInspection: " + item.NumInspection + "</br> Location: " + item.Address;
marker.latitude = item.LatitudeIni / 100000000;
marker.longitude = item.LongitudeIni / 100000000;
markers.Add(marker);
}
return(markers);
}
public void AddMarker(marker marker, List <WorkTimeDay> openTimes, List <WorkTimeDay> closeTimes, int userId, int[] subCategoryIds, string[] phonesStrings)
{
var trans = _db.Database.BeginTransaction();
try
{
_db.marker.Add(marker);
_db.SaveChanges();
var subCategories =
subCategoryIds.Select(sc => new subcategory {
CategoryId = sc, MarkerId = marker.Id
}).ToList();
var phones = phonesStrings.Select(p => new phone {
Number = p, MarkerId = marker.Id, Primary = false
}).ToList();
if (phones.Any())
{
phones.First().Primary = true;
}
var workTimes =
openTimes.Join(closeTimes.Select(ct => new { ct.WeekDayId, CloseTime = ct.Time }),
ot => ot.WeekDayId, ct => ct.WeekDayId, (ot, ct) => new { ot.WeekDayId, OpenTime = ot.Time, ct.CloseTime }).Where(t => t.CloseTime != null && t.OpenTime != null).ToList();
_db.subcategory.AddRange(subCategories);
_db.phone.AddRange(phones);
_db.worktime.AddRange(workTimes.Select(t => new worktime {
CloseTime = t.CloseTime.Value, OpenTime = t.OpenTime.Value, MarkerId = marker.Id, WeekDayId = t.WeekDayId
}));
_db.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
public int AddMarker(NewMarkerModel model, List <WorkTimeDay> openTimes, List <WorkTimeDay> closeTimes,
string userGuid)
{
var trans = _db.Database.BeginTransaction();
try
{
var adder = GetUserByGuid(userGuid);
var newMarker = new marker();
model.CopyTo(newMarker);
newMarker.BaseCategoryId = model.BaseCategoryId;
newMarker.CityId = model.CityId;
newMarker.DiscountId = model.DiscountId;
newMarker.StatusId = model.StatusId;
newMarker.UserId = adder.Id;
if (model.StatusId == GetStatusByTag(MarkerStatuses.Published).Id)
{
newMarker.PublishedDate = DateTime.Now;
}
else if (model.StatusId == GetStatusByTag(MarkerStatuses.Checking).Id)
{
newMarker.CheckDate = DateTime.Now;
newMarker.PublishedDate = null;
}
else
{
newMarker.CheckDate = null;
newMarker.PublishedDate = null;
}
_db.marker.Add(newMarker);
if (model.marker_photos != null && model.marker_photos.Count > 0)
{
_db.marker_photos.AddRange(model.marker_photos.Select(p =>
new marker_photos {
MarkerId = newMarker.Id, Photo = p.Photo
}));
}
_db.SaveChanges();
var subCategories = model.SubCategories?.Select(sc => new subcategory {
CategoryId = sc, MarkerId = newMarker.Id
})
.ToList() ?? new List <subcategory>();
var phones =
model.Phones.Where(p => p.Length != 0).Select(p => new phone {
Number = p, MarkerId = newMarker.Id, Primary = false
}).ToList();
var firstOrDefault = phones.FirstOrDefault();
if (firstOrDefault != null)
{
firstOrDefault.Primary = true;
}
var workTimes =
openTimes.Join(closeTimes.Select(ct => new { ct.WeekDayId, CloseTime = ct.Time }),
ot => ot.WeekDayId, ct => ct.WeekDayId,
(ot, ct) => new { ot.WeekDayId, OpenTime = ot.Time, ct.CloseTime })
.Where(t => t.CloseTime != null && t.OpenTime != null)
.ToList(); //собираем из двух частей полное время работы
_db.subcategory.AddRange(subCategories);
_db.phone.AddRange(phones);
_db.worktime.AddRange(
workTimes.Select(
t =>
new worktime
{
CloseTime = t.CloseTime.Value,
OpenTime = t.OpenTime.Value,
MarkerId = newMarker.Id,
WeekDayId = t.WeekDayId
}));
_db.SaveChanges();
trans.Commit();
return(newMarker.Id);
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
