public Delivery Update(int id, Delivery delivery)
{
if (id != delivery.Id) return null;
var old = _deliveryRepository.GetById(id);
if (old == null) return null;
Delivery result = null;
if (!String.IsNullOrEmpty(delivery.Printed) && !String.IsNullOrEmpty(delivery.Signature))
result = _deliveryRepository.Complete(delivery);
return delivery;
}
public Delivery Complete(Delivery delivery)
{
var query = new DapperQuery(ConnectionString)
{
Sql = @"UPDATE [Delivery]
SET [Signature] = @Signature,
[Printed] = @Printed,
[Completed] = @Completed
WHERE [Id] = @Id",
Parameters = new
{
Id = delivery.Id,
Signature = delivery.Signature,
Printed = delivery.Printed,
Completed = DateTime.UtcNow
}
};
QueryExecutor.Execute(query);
foreach (var item in delivery.Items)
{
SaveDeliveredQty(item);
}
return GetById(delivery.Id);
}
public Delivery Insert(Delivery delivery)
{
return _deliveryRepository.Insert(delivery);
}
public Delivery Insert(Delivery delivery)
{
lock (locker)
{
delivery.Id = id++;
}
_repo.Add(delivery);
return delivery;
}
public Delivery Complete(Delivery delivery)
{
var old = _repo.Where(x => x.Id == delivery.Id).FirstOrDefault();
if (old == null) return null;
old.Signature = delivery.Signature;
old.Printed = delivery.Printed;
old.Completed = DateTime.Now;
foreach (var item in delivery.Items)
{
old.Items.First(x => x.Id == item.Id).Delivered = item.Delivered;
}
return delivery;
}
public Delivery Insert(Delivery delivery)
{
using (var conn = new SqlConnection(ConnectionString))
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO [Delivery]
([Number],[SeqNum],[Company],[Salesman],[Addr1],[Addr2],[City],[State],[Zip],[Phone],[Contact],[PoNumber],[Truck]) Values
(@Number, @SeqNum, @Company, @Salesman, @Addr1, @Addr2, @City, @State, @Zip, @Phone, @Contact, @PoNumber, @Truck)
select SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@Number", delivery.Number);
cmd.Parameters.AddWithValue("@SeqNum", delivery.SeqNum);
cmd.Parameters.AddWithValue("@Company", delivery.Company);
cmd.Parameters.AddWithValue("@Salesman", delivery.Salesman);
cmd.Parameters.AddWithValue("@Addr1", delivery.Addr1);
cmd.Parameters.AddWithValue("@Addr2", delivery.Addr2 ?? "");
cmd.Parameters.AddWithValue("@City", delivery.City);
cmd.Parameters.AddWithValue("@State", delivery.State);
cmd.Parameters.AddWithValue("@Zip", delivery.Zip);
cmd.Parameters.AddWithValue("@Phone", delivery.Phone);
cmd.Parameters.AddWithValue("@Contact", delivery.Contact);
cmd.Parameters.AddWithValue("@PoNumber", delivery.PoNumber);
cmd.Parameters.AddWithValue("@Truck", delivery.Truck);
conn.Open();
delivery.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
InsertItems(delivery.Items, delivery.Id);
return delivery;
}
