private void MakeOrderButton_Click(object sender, EventArgs e)
{
try {
var result = Microsoft.VisualBasic.Interaction.InputBox("F&&V", "Enter the quantity", "1", -1, -1);
string[] values = new string[8];
//
values[4] = DateTime.Today.ToShortDateString();
values[1] = servConn.GetCurrentUser();
values[0] = servConn.FindIdByName(goodsName).ToString();
values[6] = result;
Random rand = new Random();
values[2] = "1";
values[3] = rand.Next(10, 100).ToString();
values[5] = "1";
values[7] = "";
List <string> attributes = new List <string>();
attributes = servConn.GetAttributesTable("FV_Order").ToList();
attributes.RemoveAt(0);
servConn.InsertInto("FV_Order", values, attributes.ToArray());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static void СreateNewEntry(SQLServerConnect servConn, GroupBox gb, string tableName, int attributesCount)
{
string[] values = new string[attributesCount];
string[] attributes = new string[attributesCount];
int i = 0;
foreach (TextBox tb in gb.Controls.Cast <Control>().Where(x => x is TextBox).Select(x => x as TextBox))
{
values[i] = tb.Text;
attributes[i] = tb.Tag.ToString();
i++;
}
servConn.InsertInto(tableName, values, attributes);
}
