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);
}
