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)); }