private static void MigrateProducers()
{
List <string> exceptions = new List <string>();
List <Producer> producers = ProducerOld.GetProducers();
ProducerBL bl = new ProducerBL(connectionString);
foreach (Producer producer in producers)
{
if (string.IsNullOrEmpty(producer.Name.Trim()) &&
string.IsNullOrEmpty(producer.MaternalSurname.Trim()) &&
string.IsNullOrEmpty(producer.PaternalSurname.Trim()))
{
continue;
}
try
{
bl.InsertProducer(producer);
}
catch (Exception ex)
{
exceptions.Add(producer.Name + " " + producer.PaternalSurname + ". Error " + ex.Message);
}
}
foreach (string ex in exceptions)
{
Console.WriteLine(ex);
}
Console.ReadLine();
}
public void TestInsertUpdateAndGetWeightTicket()
{
//Test get by Id
ProducerBL producerBL = new ProducerBL(connectionString);
List <Producer> producers = producerBL.GetProducer(2);
Assert.IsTrue(producers.Count() == 1);
Producer producer = producers[0];
//Assert.IsTrue(producer.Id == weightTicket.Id); //Todo create custom validator to check all properties
}
public ProducerController()
{
string connectionString = "Server=tcp:lasmargaritas.database.windows.net,1433;Initial Catalog=LasMargaritasDBDev;Persist Security Info=False;User ID=LasMargaritasDbUser;Password=LasMargaritasPassw0rd!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
if (ConfigurationManager.ConnectionStrings["LasMargaritasDb"] != null)
{
connectionString = ConfigurationManager.ConnectionStrings["LasMargaritasDb"].ConnectionString;
}
producerBL = new ProducerBL(connectionString);
}
