private void button1_Click(object sender, EventArgs e)
{
int nextDocNum = Sales_Main.GetNextNumber("SalesQuotes", 0, "");
CreateSalesQuote newSalesQuote = new CreateSalesQuote(base.ident, "SalesQuotes", "29", nextDocNum.ToString());
newSalesQuote.Show();
}
private void button_CreateSalesOrder_Click(object sender, EventArgs e)
{
int nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "");
CreateSalesOrder newSalesOrder = new CreateSalesOrder(base.ident, "SalesOrders", "21", nextDocNum.ToString());
newSalesOrder.Show();
}
private void button_PostSalesOrder_Click(object sender, EventArgs e)
{
int nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "") + 1;
string sql = String.Format("insert into ProcessDocs values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}',{8},{9},'{10}')",
nextDocNum, textBox_DocType.Text, textBox_ExtAgent.Text, textBox_IntAgent.Text,
textBox_Status.Text, nextDocNum, textBox_TextValue1.Text, textBox_TextValue2.Text,
textBox_NumValue1.Text, textBox_NumValue2.Text, textBox_Comment.Text);
string update = Utilities.DataBaseUtility.Execute(sql, ident);
DataTable quoteLines = new DataTable();
string cmd = String.Format("Select * from SalesOrders_Details where DocNum = {0} and DocType = {1}", textBox_DocNum.Text, textBox_DocType.Text);
quoteLines = Utilities.DataBaseUtility.GetTable(cmd);
foreach (DataRow row in quoteLines.Rows)
{
string materialID = row[2].ToString();
string index2 = row[3].ToString();
string listPrice = row[4].ToString();
string quantity = row[5].ToString();
string price = row[6].ToString();
string comment = row[7].ToString();
sql = String.Format("insert into ProcessDocs_Details values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}')",
nextDocNum, textBox_DocType.Text, materialID, textBox_Status.Text,
nextDocNum, quantity, price, textBox_Comment.Text);
update = Utilities.DataBaseUtility.Execute(sql, ident);
}
MessageBox.Show(update);
}
public CreateSalesOrder(IdentityObject ident, string tableName, string docType, string docNum)
{
InitializeComponent();
base.SaveIdent(ident);
base.DisplayIdent(ident);
textBox_DocNum.Text = docNum;
textBox_DocType.Text = docType;
textBox_TableName.Text = tableName;
textBox_IntAgent.Text = ident.UserID;
textBox_Status.Text = "2";
textBox_ExtAgent.Text = "0";
textBox_TextValue1.Text = DateTime.Now.ToShortDateString().Substring(0, 9);
textBox_TextValue2.Text = DateTime.Now.ToShortDateString().Substring(0, 9);
textBox_ExpectedAmount.Text = "0";
textBox_ActualAmount.Text = "0";
//find next processID
nextProcessID = Sales_Main.GetNextNumber("ProcessDocs", 0, "");
textBox_ProcessID.Text = nextProcessID.ToString();
button_ResetCommand_Click(this, null);
List <string> materials = Utilities.DataBaseUtility.GetList("select Comments from Materials order by Comments", ',');
for (int i = 0; i < materials.Count; i++)
{
this.comboBox_Material.Items.Add(materials[i]);
}
Bind();
}
private void button1_Click(object sender, EventArgs e)
{
//Take the next sales order
int nextDocNum = Sales_Main.GetNextNumber("SalesOrders", 0, "");
int extRef = Convert.ToInt32(textBox_ExtAgent.Text);
int intRef = Convert.ToInt32(textBox_IntAgent.Text);
int processID = Convert.ToInt32(textBox_ProcessID.Text);
int numValue1 = Convert.ToInt32(textBox_NumValue1.Text);
int numValue2 = Convert.ToInt32(textBox_NumValue2.Text);
// insert header into sales order
//string sqlSelectMaterial = String.Format("Select DocNum from Materials where MaterialName = '{0}'", p);
//List<string> mDocNumSelected = Utilities.DataBaseUtility.GetList(sqlSelectMaterial, ',');
//string idSelected = mDocNumSelected[1];
//string sql = String.Format("insert into SalesOrders values ( 220, 21, 12, 120, 2, 301, '09/09/2016','09/09/2016',120,120,'abc')");
string sql = String.Format("insert into SalesOrders values ( {0}, 21, {1}, {2}, 2, {3}, '{4}','{5}',{6},{7},'{8}')",
nextDocNum, //0
extRef, intRef, //1,2
processID, //3
textBox_TextValue1.Text, textBox_TextValue2.Text, //4,5
numValue1, numValue2, //6,7
textBox_Comment.Text); //8
string update = Utilities.DataBaseUtility.Execute(sql, ident);
//insert into ProcessDocs
string commentProcessDocs = "Sales Order for customer " + textBox_ExtAgent.Text;
string sqlProcessDocs = String.Format("insert into ProcessDocs values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}',{8},{9},'{10}')",
processID, "21", extRef, intRef,
textBox_Status.Text, processID, textBox_TextValue1.Text, textBox_TextValue2.Text,
numValue1, numValue2, commentProcessDocs);
string updateProcessDocs = Utilities.DataBaseUtility.Execute(sqlProcessDocs, ident);
//insert details into sales order detail
//Select sales quotes line
DataTable quoteLines = new DataTable();
string cmd = String.Format("Select * from SalesQuotes_Details where DocNum = {0} and DocType = {1}", textBox_DocNum.Text, textBox_DocType.Text);
quoteLines = Utilities.DataBaseUtility.GetTable(cmd);
foreach (DataRow row in quoteLines.Rows)
{
string materialID = row[2].ToString();
string index2 = row[3].ToString();
string listPrice = row[4].ToString();
string quantity = row[5].ToString();
string price = row[6].ToString();
string comment = row[7].ToString();
sql = String.Format("insert into SalesOrders_Details values ({0}, 21, {1}, {2}, 2, {3}, {4},{5})", nextDocNum,
materialID, index2, listPrice, quantity, price, comment);
update = Utilities.DataBaseUtility.Execute(sql, ident);
string sqlProcessDocDetails = String.Format("insert into ProcessDocs_Details values ({0}, {1}, {2},{3}, {4}, {5},'{6}','{7}')",
processID, "21", materialID, textBox_Status.Text,
processID, quantity, price, commentProcessDocs);
update = Utilities.DataBaseUtility.Execute(sqlProcessDocDetails, ident);
}
//
MessageBox.Show("Converted and posted successfully! Your Sales Order number is " + nextDocNum);
button1.Visible = false;
//load display form
}
