public static async Task <AddMeetingHistoryOutput> AddMeetingHistory(MeetingHistory MeetingHistory)
{
try
{
if (MeetingHistory.Title == "")
{
return(new AddMeetingHistoryOutput()
{
Type = 0, Message = "Kayıt Ekleme Sırasında Hata Gerçekleşti.. "
});
}
MeetingHistory.ID = Guid.NewGuid().ToString();
await db.GetCollection <MeetingHistory>("MeetingHistory").InsertOneAsync(MeetingHistory);
}
catch (Exception ex)
{
return(new AddMeetingHistoryOutput()
{
Type = 0, Message = "Kayıt Ekleme sırasında hata var.. Hata : " + ex.Message
});
}
return(new AddMeetingHistoryOutput()
{
Type = 1, Message = "Kayıt Başarıyla Eklendi.."
});
}
public void putMeetingHistory(int id, MeetingHistory status)
{
db.Entry(status).State = EntityState.Modified;
db.SaveChanges();
}
public string DeleteStatus(int id)
{
MeetingHistory status = db.MeetingHistories.Find(id);
db.MeetingHistories.Remove(status);
db.SaveChanges();
return(id.ToString());
}
public static async Task <List <MeetingHistory> > GetMeetingHistory(GetMeetingHistoryInput Parameters)
{
var List = new List <MeetingHistory>();
var projection = Builders <MeetingHistory> .Projection;
var project = projection.Exclude("_id");
var filter = FilterDefinition <MeetingHistory> .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 <MeetingHistory> .Filter.Eq(Parameters.Column, val);
}
else if (Parameters.Statement == "<")
{
filter = Builders <MeetingHistory> .Filter.Lt(Parameters.Column, val);
}
else if (Parameters.Statement == ">")
{
filter = Builders <MeetingHistory> .Filter.Gt(Parameters.Column, val);
}
var option = new FindOptions <MeetingHistory, BsonDocument>
{
Projection = project
};
using (var cursor = await db.GetCollection <MeetingHistory>("MeetingHistory").FindAsync(filter, option))
{
while (await cursor.MoveNextAsync())
{
var batch = cursor.Current;
foreach (BsonDocument m in batch)
{
var meet = new MeetingHistory();
if (m.Contains("ID"))
{
meet.ID = m["ID"].AsString;
}
if (m.Contains("Title"))
{
meet.Title = m["Title"].AsString;
}
if (m.Contains("StartDate"))
{
meet.StartDate = m["StartDate"].AsString;
}
if (m.Contains("FinishDate"))
{
meet.FinishDate = m["FinishDate"].AsString;
}
if (m.Contains("ParticipantNumber"))
{
meet.ParticipantNumber = m["ParticipantNumber"].AsInt32;
}
if (m.Contains("BranchID"))
{
meet.BranchID = m["BranchID"].AsString;
}
if (m.Contains("Salloon"))
{
meet.Salloon = m["Salloon"].AsString;
}
if (m.Contains("Moderator"))
{
meet.Moderator = m["Moderator"].AsString;
}
List.Add(meet);
}
}
}
return(List);
}
public void PostStatusOfMeeting(MeetingHistory status)
{
db.MeetingHistories.Add(status);
db.SaveChanges();
}
public async Task <AddMeetingHistoryOutput> AddMeetingHistory(MeetingHistory MeetingHistory)
{
return(await MeetHistoryManager.AddMeetingHistory(MeetingHistory));
}
