/// <summary>
/// Deprecated Method for adding a new object to the DetailDeliveryTransaction EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToDetailDeliveryTransaction(DetailDeliveryTransaction detailDeliveryTransaction)
{
base.AddObject("DetailDeliveryTransaction", detailDeliveryTransaction);
}
/// <summary>
/// Create a new DetailDeliveryTransaction object.
/// </summary>
/// <param name="receiptID">Initial value of the ReceiptID property.</param>
/// <param name="productID">Initial value of the ProductID property.</param>
/// <param name="qty">Initial value of the Qty property.</param>
public static DetailDeliveryTransaction CreateDetailDeliveryTransaction(global::System.String receiptID, global::System.String productID, global::System.Decimal qty)
{
DetailDeliveryTransaction detailDeliveryTransaction = new DetailDeliveryTransaction();
detailDeliveryTransaction.ReceiptID = receiptID;
detailDeliveryTransaction.ProductID = productID;
detailDeliveryTransaction.Qty = qty;
return detailDeliveryTransaction;
}
private void btnSubmit_Click(object sender, EventArgs e)
{
//if button submit is clicked, validate the field according to the project case
if (cmbStaff.SelectedIndex < 0)
{
MessageBox.Show("Please select delivery staff");
}
else if (dateTrans.Value < DateTime.Now.Date)
{
MessageBox.Show("Transaction date must be at least today");
}
else if (cmbVehicle.SelectedIndex < 0)
{
MessageBox.Show("Please select vehicle");
}
else
{
//if all field is valid, insert into table headerdeliverytransaction
string oldID = "TR000";
HeaderDeliveryTransaction[] temp = (from x in ent.HeaderDeliveryTransaction select x).ToArray();
if( temp.Length != 0 )
oldID = temp[temp.Length - 1].ReceiptID;
int newID = 0;
int.TryParse(oldID.Substring(2), out newID);
newID++;
String transID = "TR" + newID.ToString("000");
//insert the new customer data if user use new customer
if (newc)
{
ent.AddToMsCustomer(newCustomer);
ent.SaveChanges();
}
//insert the new destination data if user use new destination
if (newd)
{
ent.AddToMsDestination(newDestination);
ent.SaveChanges();
}
HeaderDeliveryTransaction newTrans = new HeaderDeliveryTransaction();
newTrans.ReceiptID = transID;
newTrans.StaffID = staff[cmbStaff.SelectedIndex].StaffID;
newTrans.CustomerID = newCustomer.CustomerID;
newTrans.DestinationID = newDestination.DestinationID;
newTrans.Vehicle = cmbVehicle.SelectedItem.ToString();
newTrans.TotalPayment = decimal.Parse(txtTotal.Text);
newTrans.TransactionDate = dateTrans.Value;
newTrans.ExpectedDeliveredDate = dateDelivered.Value;
newTrans.DeliveredDate = dateDelivered.Value;
newTrans.Status = "In Progress";
ent.AddToHeaderDeliveryTransaction(newTrans);
ent.SaveChanges();
for (int i = 0; i < totalProduct; i++)
{
//insert into table detaildeliverytransaction for each product
DetailDeliveryTransaction newDetail = new DetailDeliveryTransaction();
newDetail.ReceiptID = transID;
newDetail.ProductID = newProduct[i].ProductID;
newDetail.Qty = qty[i];
ent.AddToDetailDeliveryTransaction(newDetail);
ent.SaveChanges();
}
MessageBox.Show("Transaction is complete");
this.Dispose();
}
}
