public static OrderIfo GetOrderInfo(string orderID) { DbCommand cmd = DataAccess.CreateCommand(); cmd.CommandText = "AdminGetOrderInfo"; cmd.Parameters.Add(CatalogAccess.NewParameter("@OrderID", orderID, DbType.Int32, -1, cmd)); DataTable dt = DataAccess.ExecuteSelectedCommand(cmd); DataRow dr = dt.Rows[0]; OrderIfo ord = new OrderIfo(); ord.OrderID = Int32.Parse(dr["OrderID"].ToString()); ord.TotalAmount = Decimal.Parse(dr["TotalAmount"].ToString()); ord.DateCreated = dr["DateCreated"].ToString(); ord.DateShipped = dr["DateShipped"].ToString(); ord.Verified = bool.Parse(dr["Verified"].ToString()); ord.Canceled = bool.Parse(dr["Canceled"].ToString()); ord.Completed = bool.Parse(dr["Completed"].ToString()); ord.Comments = dr["Comments"].ToString(); ord.CustomerName = dr["CustomerName"].ToString(); ord.CustomeEmail = dr["CustomerEmail"].ToString(); ord.ShippingAddress = dr["ShippingAddress"].ToString(); ord.AuthCode = dr["AuthCode"].ToString(); return(ord); }
protected void btnUpdate_Click(object sender, EventArgs e) { OrderIfo order = new OrderIfo(); string orderID = GetOrderID(); order.OrderID = Convert.ToInt32(orderID); order.DateCreated = txtDateCreated.Text; order.DateShipped = txtShippedDate.Text; order.Verified = verifiedCheckBox.Checked; order.Canceled = canceledCheckBox.Checked; order.Completed = completedCheckBox.Checked; order.Comments = txtComments.Text; order.CustomerName = txtCustomerName.Text; order.CustomeEmail = txtCustomerEmail.Text; order.ShippingAddress = txtShippingAddress.Text; try { OrderAccess.OrderUpdate(order); } catch (Exception) { } lblStatus.Text = "İşlem Başarılı!"; SetEditMode(false); DenetimlerDoldur(orderID); }
private void DenetimlerDoldur(string orderID) { OrderIfo o = OrderAccess.GetOrderInfo(orderID); lblTotalAmount.Text = String.Format("{0:c}", o.TotalAmount); txtDateCreated.Text = o.DateCreated; txtShippedDate.Text = o.DateShipped; verifiedCheckBox.Checked = o.Verified; completedCheckBox.Checked = o.Completed; canceledCheckBox.Checked = o.Canceled; txtComments.Text = o.AuthCode; txtCustomerName.Text = o.CustomerName; txtCustomerEmail.Text = o.CustomeEmail; txtShippingAddress.Text = o.ShippingAddress; btnEdit.Enabled = true; btnUpdate.Enabled = false; btnCancel.Enabled = false; if (canceledCheckBox.Checked || completedCheckBox.Checked) { btnMarkVerified.Enabled = false; btnMarkCompleted.Enabled = false; btnMarkCalceled.Enabled = false; } else if (verifiedCheckBox.Checked) { btnMarkVerified.Enabled = false; btnMarkCompleted.Enabled = true; btnMarkCalceled.Enabled = true; } else { btnMarkVerified.Enabled = true; btnMarkCompleted.Enabled = false; btnMarkCalceled.Enabled = true; } grid.DataSource = OrderAccess.GetOrderDetails(orderID); grid.DataBind(); }
public static void OrderUpdate(OrderIfo o) { DbCommand cmd = DataAccess.CreateCommand(); cmd.CommandText = "AdminOrderUpdate"; cmd.Parameters.Add(CatalogAccess.NewParameter("@OrderID", o.OrderID.ToString(), DbType.Int32, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@DateCreated", o.DateCreated, DbType.DateTime, -1, cmd)); if (o.DateShipped.Trim() != "") { cmd.Parameters.Add(CatalogAccess.NewParameter("@DateShipped", o.DateShipped, DbType.DateTime, -1, cmd)); } cmd.Parameters.Add(CatalogAccess.NewParameter("@Verified", o.Verified, DbType.Byte, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@Complated", o.Completed, DbType.Byte, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@Canceled", o.Canceled, DbType.Byte, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@Comments", o.Comments, DbType.String, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@CustomerName", o.CustomerName, DbType.String, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@ShippingAddress", o.ShippingAddress, DbType.String, -1, cmd)); cmd.Parameters.Add(CatalogAccess.NewParameter("@CustomerEmail", o.CustomeEmail, DbType.String, -1, cmd)); DataAccess.ExecuteNonQuery(cmd); }