public string GetSqlOrder(SqlOrders c) { string sql = null; if (sqlOrderLookup.TryGetValue(c, out sql) == false) { return(string.Empty); } return(sql); }
public SqlOrder AddOrderBy(string fieldName, string tableName, SqlOrders direction, int index = -1) { try { if (tableName.ToUpper() == BaseTable.ToUpper() && Fields.Count == 0) { SqlField field = new SqlField(fieldName, null, null, Tables[0], false, false); SqlOrder order = new SqlOrder(field, GetSqlOrder(direction)); if (index >= 0) { Orders.Insert(index, order); } else { Orders.Add(order); } return(order); } foreach (SqlOrder order in Orders) { if (order.Field.Name == fieldName && order.Field.Table.Name == tableName) { return(order); } } foreach (SqlField field in Fields) { if (field.Name.ToUpper() == fieldName.ToUpper() && field.Table.Name.ToUpper() == tableName.ToUpper()) { SqlOrder order = new SqlOrder(field, GetSqlOrder(direction)); if (index >= 0) { Orders.Insert(index, order); } else { Orders.Add(order); } return(order); } } return(null); } catch { return(null); } }
protected void btnSaveOrders_Click(object sender, EventArgs e) { SqlOrders.InsertParameters["Purchase_Order_ID"].DefaultValue = PurchaseOrder_IDDropDownList.SelectedValue; SqlOrders.InsertParameters["RawMaterial_ID"].DefaultValue = PurchaseOrder_IDDropDownList.SelectedValue; SqlOrders.InsertParameters["Unit_Price"].DefaultValue = txtUnitPrice.Text.ToUpper().Trim(); SqlOrders.InsertParameters["Quantity"].DefaultValue = txtQuantity.Text.ToUpper().Trim(); SqlOrders.InsertParameters["Total_price"].DefaultValue = txtTotal.Text.ToUpper().Trim(); SqlOrders.Insert(); gvOrders.DataBind(); PaneladdOrders.Visible = false; PanelgvOrders.Visible = true; RawMaterial_IDDropDownList.SelectedIndex = -1; PurchaseOrder_IDDropDownList.SelectedIndex = -1; txtUnitPrice.Text = string.Empty; txtQuantity.Text = string.Empty; txtTotal.Text = string.Empty; }