/// <summary> /// Create a new HeaderDeliveryTransaction object. /// </summary> /// <param name="receiptID">Initial value of the ReceiptID property.</param> /// <param name="staffID">Initial value of the StaffID property.</param> /// <param name="customerID">Initial value of the CustomerID property.</param> /// <param name="destinationID">Initial value of the DestinationID property.</param> /// <param name="vehicle">Initial value of the Vehicle property.</param> /// <param name="totalPayment">Initial value of the TotalPayment property.</param> /// <param name="transactionDate">Initial value of the TransactionDate property.</param> /// <param name="expectedDeliveredDate">Initial value of the ExpectedDeliveredDate property.</param> /// <param name="deliveredDate">Initial value of the DeliveredDate property.</param> /// <param name="status">Initial value of the Status property.</param> public static HeaderDeliveryTransaction CreateHeaderDeliveryTransaction(global::System.String receiptID, global::System.String staffID, global::System.String customerID, global::System.String destinationID, global::System.String vehicle, global::System.Decimal totalPayment, global::System.DateTime transactionDate, global::System.DateTime expectedDeliveredDate, global::System.DateTime deliveredDate, global::System.String status) { HeaderDeliveryTransaction headerDeliveryTransaction = new HeaderDeliveryTransaction(); headerDeliveryTransaction.ReceiptID = receiptID; headerDeliveryTransaction.StaffID = staffID; headerDeliveryTransaction.CustomerID = customerID; headerDeliveryTransaction.DestinationID = destinationID; headerDeliveryTransaction.Vehicle = vehicle; headerDeliveryTransaction.TotalPayment = totalPayment; headerDeliveryTransaction.TransactionDate = transactionDate; headerDeliveryTransaction.ExpectedDeliveredDate = expectedDeliveredDate; headerDeliveryTransaction.DeliveredDate = deliveredDate; headerDeliveryTransaction.Status = status; return headerDeliveryTransaction; }
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(); } }
/// <summary> /// Deprecated Method for adding a new object to the HeaderDeliveryTransaction EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToHeaderDeliveryTransaction(HeaderDeliveryTransaction headerDeliveryTransaction) { base.AddObject("HeaderDeliveryTransaction", headerDeliveryTransaction); }
private void txtID_TextChanged(object sender, EventArgs e) { string id = txtID.Text; //validate the receiptId can only be 5 characters max if (id.Length > 5) { txtID.Text = id.Substring(0, 5); lblStatus.ForeColor = Color.Black; lblStatus.Text = "Receipt ID can only receives 5 characters at max"; } else if (id.Length == 5) { try { //check if the id match in the database temp = (from x in ent.HeaderDeliveryTransaction where x.ReceiptID.Equals(txtID.Text) select x).First(); if (temp != null) { if (temp.Status.Equals("In Progress")) { //if the id matched, and the status is In Progress btnDelivered.Visible = true; lblStatus.ForeColor = Color.Red; lblStatus.Visible = true; lblStatus.Text = "In Progress"; } else if (temp.Status.Equals("Delivered")) { //if the id matched, and the status is Delivered btnDelivered.Visible = false; lblStatus.ForeColor = Color.Green; lblStatus.Visible = true; lblStatus.Text = "Delivered"; } else { lblStatus.ForeColor = Color.Black; lblStatus.Text = "No Transaction with this ReceiptID"; } } else { //if the id don't match lblStatus.ForeColor = Color.Black; lblStatus.Text = "No Transaction with this ReceiptID"; } } catch (Exception) { //if exception occured lblStatus.ForeColor = Color.Black; lblStatus.Text = "No Transaction with this ReceiptID"; } } else { btnDelivered.Visible = false; lblStatus.Visible = false; } }