public async Task <AddSalloonOutput> AddSalloon(Salloon Salloon)
{
return(await SalloonManager.AddSalloon(Salloon));
//SalloonManager.AddSalloon(Salloon);
//return new AddSalloonOutput() { Type = 1, Message = "Kayit Basarıyla Eklendi..." };
}
public ActionResult Edit(Salloon salloon)
{
try
{
salloonRepository.Update(salloon);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
//INSERT
public static async Task <AddSalloonOutput> AddSalloon(Salloon Salloon)
{
try
{
if (Salloon.SalloonName == "")
{
return(new AddSalloonOutput()
{
Type = 0, Message = "Kayit Ekleme sırasında hata gerçekleşti..."
});
}
Salloon.ID = Guid.NewGuid().ToString();
await db.GetCollection <Salloon>("Salloons").InsertOneAsync(Salloon);
}
catch (Exception ex)
{
return(new AddSalloonOutput()
{
Type = 0, Message = "Kayit Ekleme sırasında hata gerçekleşti..." + ex.Message
});
}
return(new AddSalloonOutput()
{
Type = 1, Message = "Kayit Başarıyla Eklendi..."
});
//Salloon.ID = Guid.NewGuid().ToString();
//var g = new Guid();
//var id = g.ToString();
//var obj = new Salloon()
//{
// ID = "24",
// Branch = "Balıkesir",
// Capacity = 20,
// InternetStatus = true,
// AirConditioningStatus = false,
// ProvisionsStatus = true,
//};
//db.GetCollection<Salloon>("Salloons").InsertOne(Salloon);
}
public IActionResult UpdateSaloon(Salloon salloon)
{
sallonRepository.Update(salloon);
return(RedirectToAction("Index"));
}
public IActionResult GetSaloon(Salloon salloon)
{
var result = sallonRepository.GetSalloons().Where(x => x.Id == salloon.Id);
return(View(result));
}
public IActionResult RemoveSaloon(Salloon salloon)
{
sallonRepository.Delete(salloon);
return(RedirectToAction("Index"));
}
public IActionResult UpdateSaloon(Salloon salloon)
{
salloonService.Update(salloon);
return(RedirectToAction("Index"));
}
public IActionResult AddSaloon(Salloon salloon)
{
salloonService.Add(salloon);
return(RedirectToAction("Index"));
}
public static async Task <List <Salloon> > GetSalloon(GetSallooninput Parameters)
{
var List = new List <Salloon>();
var projection = Builders <Salloon> .Projection;
var project = projection.Exclude("_id");
//var filter = Builders<Salloon>.Filter.Eq(x => x.ID, "14");
var filter = FilterDefinition <Salloon> .Empty;
BsonValue val;
if (Parameters.ColumnType == "int")
{
val = Convert.ToInt64(Parameters.Value);
}
else if (Parameters.ColumnType == "bool")
{
val = Convert.ToBoolean(Parameters.Value);
}
else
{
val = Convert.ToString(Parameters.Value);
}
if (Parameters.Statement == "=")
{
filter = Builders <Salloon> .Filter.Eq(Parameters.Column, val);
}
else if (Parameters.Statement == "<")
{
filter = Builders <Salloon> .Filter.Lt(Parameters.Column, val);
}
else if (Parameters.Statement == ">")
{
filter = Builders <Salloon> .Filter.Gt(Parameters.Column, val);
}
var option = new FindOptions <Salloon, BsonDocument> {
Projection = project
};
using (var cursor = await db.GetCollection <Salloon>("Salloons").FindAsync(filter, option))
{
while (await cursor.MoveNextAsync())
{
var batch = cursor.Current;
foreach (BsonDocument s in batch)
{
var salloon = new Salloon();
if (s.Contains("Branch"))
{
salloon.Branch = s["Branch"].AsString;
}
if (s.Contains("ID"))
{
salloon.ID = s["ID"].AsString;
}
if (s.Contains("AirConditioningStatus"))
{
salloon.AirConditioningStatus = s["AirConditioningStatus"].AsBoolean;
}
if (s.Contains("Capacity"))
{
salloon.Capacity = s["Capacity"].AsInt32;
}
if (s.Contains("InternetStatus"))
{
salloon.InternetStatus = s["InternetStatus"].AsBoolean;
}
if (s.Contains("ProjectionStatus"))
{
salloon.ProjectionStatus = s["ProjectionStatus"].AsBoolean;
}
if (s.Contains("ProvisionsStatus"))
{
salloon.ProvisionsStatus = s["ProvisionsStatus"].AsBoolean;
}
if (s.Contains("SalloonName"))
{
salloon.SalloonName = s["SalloonName"].AsString;
}
List.Add(salloon);
}
}
}
return(List);
}
public void Update(Salloon salloon)
{
context.Salloons.Update(salloon);
context.SaveChanges();
}
public void Delete(Salloon salloon)
{
context.Salloons.Remove(salloon);
context.SaveChanges();
}
public void Create(Salloon salloon)
{
context.Salloons.Add(salloon);
context.SaveChanges();
}
