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