private DBConnector() { factory = new ConnectionFactory() { HostName = "localhost", Password = "******", UserName = "******" }; cards = new List <AssemblyCard>(); Task.Run(() => FetchCards()); // send empty card so DBManager will sent updated cards using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { AssemblyCard card = new AssemblyCard { CardId = string.Empty, }; byte[] body; BinaryFormatter bf = new BinaryFormatter(); using (MemoryStream ms = new MemoryStream()) { bf.Serialize(ms, card); body = ms.ToArray(); } Console.WriteLine("#########################try to fetch db "); channel.BasicPublish(exchange: "", routingKey: "queue-card-create", basicProperties: null, body: body); } }
static void insertProduct(AssemblyCard card) { using (var db = new CardsContext()) { db.Add(card); db.SaveChanges(); } }
static void deleteProduct(string id) { using (var db = new CardsContext()) { AssemblyCard card = db.Cards.SingleOrDefault(r => r.CardId == id); if (card == null) { return; } db.Cards.Remove(card); db.SaveChanges(); } }
public void Create(string employeeLN, string employeeFN, string employeeID, string knnr, string sort, string prnr) { var card = new AssemblyCard { CardId = Guid.NewGuid().ToString(), EmployeeFN = employeeFN, EmployeeLN = employeeLN, EmployeeID = employeeID, KNNR = knnr, Sort = sort, PrNr = prnr, }; dbConnector.Create(card); return; }
static void updateProduct(AssemblyCard card) { using (var db = new CardsContext()) { AssemblyCard savedCard = db.Cards.SingleOrDefault(r => r.CardId == card.CardId); if (savedCard == null) { return; } savedCard.EmployeeFN = card.EmployeeFN; savedCard.EmployeeLN = card.EmployeeLN; savedCard.EmployeeID = card.EmployeeID; savedCard.KNNR = card.KNNR; savedCard.Sort = card.Sort; db.SaveChanges(); } }
public CardsResource Edited(string id, string employeeLN, string employeeFN, string employeeID, string knnr, string sort) { var card = new AssemblyCard { CardId = id, EmployeeFN = employeeFN, EmployeeLN = employeeLN, EmployeeID = employeeID, KNNR = knnr, Sort = sort, }; dbConnector.Edited(card); return(new CardsResource { Id = id, AssemblyCard = card }); }
public async Task <ActionResult> Send(string id, string destinationEmail) { AssemblyCard cardToSend = dbConnector.cards.SingleOrDefault(r => r.CardId == id); if (cardToSend == null) { return(NotFound($"AssemblyCard with id: {id} does not exist")); } await _publishEndpoint.Publish <CardToSend>(new { destinationEmail = destinationEmail, EmployeeLN = cardToSend.EmployeeLN, EmployeeFN = cardToSend.EmployeeFN, EmployeeID = cardToSend.EmployeeID, KNNR = cardToSend.KNNR, Sort = cardToSend.Sort, PrNr = cardToSend.PrNr }); return(Ok()); }
public void Edited(AssemblyCard card) { using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { byte[] body; BinaryFormatter bf = new BinaryFormatter(); using (MemoryStream ms = new MemoryStream()) { bf.Serialize(ms, card); body = ms.ToArray(); } channel.BasicPublish(exchange: "", routingKey: "queue-card-update", basicProperties: null, body: body); } }