public void ArrayTest_Success() { var context = new tpvenlanubecalendarEntities(); // clients toAdd = new clients(); var sortedClients = from t in context.clients orderby t.clientId ascending select t.clientId; // var sortedClients = context.clients.clientId.ToArray(); var maxId = sortedClients.Max(); var sortedArray = sortedClients.ToArray(); Assert.IsTrue(maxId > sortedArray[sortedArray.Length - 2]); }
public long MaxClientsId() { var context = new tpvenlanubecalendarEntities(); // clients toAdd = new clients(); var sortedClients = from t in context.clients orderby t.clientId ascending select t.clientId; // var sortedClients = context.clients.clientId.ToArray(); var maxId = sortedClients.Max(); //var sortedArray = sortedClients.ToArray(); return maxId; }
public long MaxClientsId() { var context = new tpvenlanubecalendarEntities(); // clients toAdd = new clients(); var sortedClients = from t in context.clients orderby t.clientId ascending select t.clientId; // var sortedClients = context.clients.clientId.ToArray(); var maxId = sortedClients.Max(); //var sortedArray = sortedClients.ToArray(); return(maxId); }
public void DeleteTest_Succes() { var context = new tpvenlanubecalendarEntities(); var count = context.clients.Count(); var deleteOrderClients = from clients in context.clients where clients.clientId == 100 select clients; foreach (var client in deleteOrderClients) { context.clients.Remove(client); } context.SaveChanges(); var count2 = context.clients.Count(); Assert.AreNotEqual(count2, count); }
public void AddTest_Succes() { var context = new tpvenlanubecalendarEntities(); clients toAdd = new clients(); toAdd.clientId = 100; toAdd.clientName = "Charo"; toAdd.clientPicture = string.Empty; toAdd.contactNumber = "56524"; toAdd.lastProduct = "suavizante"; toAdd.lastService = "corte"; context.clients.Add(toAdd); context.SaveChanges(); var result = context.clients.FirstOrDefault(s => s.clientName == "Manuel"); Assert.IsNotNull(result); }
public void ReadTest_Succes() { var context = new tpvenlanubecalendarEntities(); var firstClient = context.clients.First(); Assert.IsTrue(firstClient != null); }
public List<clients> GetClients() { var context = new tpvenlanubecalendarEntities(); return context.clients.clientId.Tolist(); }