public void MouseClick(object sender, EventArgs e)
{
Button bt = (Button)sender;
flowLayoutPanel1.Controls.Clear();
DataTable dt = ConnectionClass.Selectcommand("select category_id from Category where CategoryName='" + bt.Text + "'");
try
{
DataTable dt11 = ConnectionClass.Selectcommand("select ProductName from Product where Category_id='" + dt.Rows[0][0].ToString() + "'");
foreach (DataRow row in dt11.Rows)
{
AddNewSubButton(row[0].ToString());
}
}
catch { }
}
private void Form1_Load(object sender, EventArgs e)
{
DataTable dt1 = ConnectionClass.Selectcommand("select Type from Category");
foreach (DataRow row in dt1.Rows)
{
comboBox1.Items.Add(row[0].ToString());
}
DataTable dt = ConnectionClass.Selectcommand("select type from language");
if (dt.Rows[0][0].ToString() == "English")
{
English();
}
else
{
Urdu();
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (BusinessName.Text == "" || BusinessName.Text == null)
{
MessageBox.Show("Please Fill the TextBox First", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ConnectionClass.InsertCommand("insert into Business_type Values('" + BusinessName.Text + "','" + Description.Text + "')");
MessageBox.Show("Successfully Added", "Success Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
BusinessName.Text = Description.Text = "";
}
}
catch
{
}
}
private void Form1_Load(object sender, EventArgs e)
{
InitializeTimer();
//if (InternetConnection.IsConnectedToInternet())
//{
// List<SalesDetail> lst = new List<SalesDetail>();
// businessCode = DatabaseActivities.GetBusinessCode();
// lst = OnlineActivities.GetOnlineSalesDetailDB();
// foreach (var items in lst)
// {
// OnlineActivities.SendOnlineSalesDetail(items.ProductID, items.ProductName, Convert.ToInt32(items.Quantity), items.UnitPrice, items.TotalPrice, items.SalesMasterIDLocal, 1, businessCode);
// }
// OnlineActivities.UpdateSalesDetailConnection();
//}
//else
//{
// lblResponse.Text = "Offline So not Sales Details to be inserted";
//}
editbox.Visible = false;
autoCompleteMethod();
//DataTable dt = ConnectionClass.Selectcommand("select type from language");
//if (dt.Rows[0][0].ToString() == "English")
//{
// English();
//}
//else
//{
// Urdu();
//}
DataTable dt11 = ConnectionClass.Selectcommand("select CategoryName from Category");
foreach (DataRow row in dt11.Rows)
{
AddNewButton(row[0].ToString());
}
}
private void button1_Click_1(object sender, EventArgs e)
{
string message = "";
#region var initialisation
long salesMasterID;
totalAmount = Convert.ToDouble(LbTotal.Text);
discount = Convert.ToDecimal(LbDiscount.Text);
salesTaxRate = 15.00;
salesTax = Convert.ToDouble(LBKpra.Text);
netAmount = Convert.ToDouble(LbPayable.Text);
paid = Convert.ToDouble(TBPaid.Text);
todayTime = DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff"), CultureInfo.InvariantCulture);
// todayTime = DateTime.Parse("2018-18-9 03:05.000");
description = "Signed by Vendor";
otherCharges = 10.00;
businessId = 1;
businessCode = DatabaseActivities.GetBusinessCode();
stationId = 0;
// salesMasterID = OnlineActivities.GetLastMasterIDLocal();
#endregion end calculations
#region Local Data Store Operation
Thread threadSalesLocal = new Thread(() =>
{
ConnectionClass.InsertCommand("insert into sales_Master2 values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','1','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')");
});
threadSalesLocal.Start();
threadSalesLocal.Join();
//detail list for local
List <SalesDetail> salesDetailLstLocal = new List <SalesDetail>();
foreach (ListViewItem item in listView1.Items)
{
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master2");
SalesDetail salesDetail = new SalesDetail();
salesDetail.ProductID = Convert.ToInt64(item.SubItems[0].Text);
salesDetail.ProductName = item.SubItems[1].Text.ToString();
salesDetail.Quantity = Convert.ToInt32(item.SubItems[2].Text.ToString());
salesDetail.UnitPrice = Convert.ToDecimal(item.SubItems[3].Text.ToString());
salesDetail.TotalPrice = Convert.ToDecimal(item.SubItems[4].Text.ToString());
salesDetail.SalesMasterIDLocal = Convert.ToInt64(dt.Rows[0][0].ToString());
salesDetailLstLocal.Add(salesDetail);
}
Thread threadDetailLocal = new Thread(() =>
{
foreach (var item in salesDetailLstLocal)
{
SalesDetail salesDetail = new SalesDetail();
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master2");
ConnectionClass.InsertCommand("insert into Sales_Details2 " +
" values ('" +
item.ProductID + "','" +
item.ProductName + "','" +
item.Quantity + "','" +
item.UnitPrice + "','" +
item.TotalPrice + "','" +
dt.Rows[0][0].ToString() + "','True')");
}
});
threadDetailLocal.Start();
threadDetailLocal.Join();
PrintReport();
ClearItems();
lblHttpResponse.Text += "items cleared";
#endregion
Thread t = new Thread(() =>
{
if (InternetConnection.IsConnectedToInternet())
{
// MessageBox.Show(WebAPIResource.statusCodes);
// lblHttpResponse.Text += WebAPIResource.statusCodes.ToString();
//message = WebAPIResource.statusCodes.ToString();
ConnectionClass.InsertCommand("insert into sales_Master values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','1','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')");
#region comments
//List<SalesMasterForLocal> listLocalSalesMaster = new List<SalesMasterForLocal>();
//OnlineActivities.StoreSalesMasterDataOnline(Convert.ToDecimal(LbTotal.Text), Convert.ToDecimal(LbDiscount.Text),
// Convert.ToDecimal(ConfigurationManager.AppSettings["sales_tax"]), Convert.ToDecimal(LBKpra.Text),
// Convert.ToDecimal(LbPayable.Text), Convert.ToDecimal(TBPaid.Text),true,
// InternetConnection.GetBusinessCode(),1,System.DateTime.Today.ToString("yyyy-MM-dd"),
// DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")));
// //SalesMasterForLocal salesMasterLocalStorage = new SalesMasterForLocal();
//salesMasterLocalStorage.TotalAmount = Convert.ToDecimal(LbTotal.Text);
//salesMasterLocalStorage.Discount = Convert.ToDecimal(LbDiscount.Text);
//salesMasterLocalStorage.SalesTaxRate = Convert.ToDecimal(ConfigurationManager.AppSettings["sales_tax"]);
//salesMasterLocalStorage.SalesTax = Convert.ToDecimal(LBKpra.Text);
//salesMasterLocalStorage.NetAmount = Convert.ToDecimal(LbPayable.Text);
//salesMasterLocalStorage.Paid = Convert.ToDecimal(TBPaid.Text);
//salesMasterLocalStorage.isConnected = true;
//salesMasterLocalStorage.BusinessCode = InternetConnection.GetBusinessCode();
//salesMasterLocalStorage.StationID = 1;
//salesMasterLocalStorage.SalesDate = System.DateTime.Today.ToString("yyyy-MM-dd");
//salesMasterLocalStorage.SalesDate2 = DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff"));
//listLocalSalesMaster.Add(salesMasterLocalStorage);
#endregion
}
else
{
// MessageBox.Show(WebAPIResource.statusCodes);
// lblHttpResponse.Text += WebAPIResource.statusCodes.ToString();
ConnectionClass.InsertCommand("insert into sales_Master values('" + Convert.ToDecimal(totalAmount) + "','" + discount + "','15','" + salesTax + "','" + Convert.ToDecimal(netAmount) + "','" + Convert.ToDecimal(paid) + "','" + InternetConnection.GetBusinessCode() + "','1','" + System.DateTime.Today.ToString("yyyy-MM-dd") + "','0','" + DateTime.Parse(System.DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.fff")) + "')");
// lblResponse.Text += "\nSales Master DATA TRANSFER FAILS!";
}
}
);
t.Start();
t.IsBackground = true;
t.Join();
//lblHttpResponse.Text += message.ToString();
Thread threadSales = new Thread(() =>
{
if (InternetConnection.IsConnectedToInternet())
{
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
OnlineActivities.SendOnlineInvoice(totalAmount, discount,
salesTaxRate, salesTax, netAmount, paid,
todayTime, description,
otherCharges, Convert.ToInt64(dt.Rows[0][0].ToString()), InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode());
Thread.Sleep(3000);
}
else
{
//update isConnected value to 0 in sales_master table where isConnected Value happened to be 1 recently
SqlConnection conn = new SqlConnection(connStaticString);
SqlCommand cmd = new SqlCommand("sp_InvertClientUpdateConnectionStatusInSales_Master", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
});
threadSales.Start();
threadSales.IsBackground = true;
#region lll
// foreach (ListViewItem item in listView1.Items)
// {
// DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
// //Stopwatch stopwatch = new Stopwatch();
// //stopwatch.Start();
// Task t1 = Task.Factory.StartNew(() =>
// {
// ConnectionClass.InsertCommand("insert into Sales_Details " +
// " values ('" +
// item.SubItems[0].Text + "','" +
// item.SubItems[1].Text + "','" +
// item.SubItems[2].Text + "','" +
// item.SubItems[3].Text + "','" +
// item.SubItems[4].Text + "','" +
// dt.Rows[0][0].ToString() + "','True')");
// });
// }//end foreach
// if (InternetConnection.IsConnectedToInternet() && InternetConnection.CheckServerConnectivity(serverIP) == true)
// {
// foreach (ListViewItem item in listView1.Items)
// {
// DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
// OnlineActivities.SendOnlineSalesDetail(Convert.ToInt64(item.SubItems[0].Text), item.SubItems[1].Text.ToString()
// , Convert.ToInt32(item.SubItems[2].Text),
// Convert.ToDecimal(item.SubItems[3].Text),
// Convert.ToDecimal(item.SubItems[4].Text),
// Convert.ToInt64(dt.Rows[0][0].ToString()),
// InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode());
// }
//}//end if
//else
//{
// foreach (ListViewItem item in listView1.Items)
// {
// DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
// ConnectionClass.InsertCommand("insert into Sales_Details " +
// " values ('" +
// item.SubItems[0].Text + "','" +
// item.SubItems[1].Text + "','" +
// item.SubItems[2].Text + "','" +
// item.SubItems[3].Text + "','" +
// item.SubItems[4].Text + "','" +
// dt.Rows[0][0].ToString() + "','True')");
// lblResponse.Text += "\nSales Detial Data Transfer Fails!";
// }//end foreach
// PrintReport();
//}//end else
#endregion
#region internet status check was checked per item
//detail list for transfer
List <SalesDetail> salesDetailLst = new List <SalesDetail>();
foreach (var item in salesDetailLstLocal)
{
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
SalesDetail salesDetail = new SalesDetail();
salesDetail.ProductID = item.ProductID;
salesDetail.ProductName = item.ProductName;
salesDetail.Quantity = item.Quantity;
salesDetail.UnitPrice = item.UnitPrice;
salesDetail.TotalPrice = item.TotalPrice;
salesDetail.SalesMasterIDLocal = Convert.ToInt64(dt.Rows[0][0].ToString());
salesDetailLst.Add(salesDetail);
}
// MessageBox.Show(WebAPIResource.statusCodes);
// lblHttpResponse.Text += WebAPIResource.statusCodes.ToString();
// List<SalesDetail> salesDetailList = new List<SalesDetail>();
Thread t1 = new Thread(() =>
{
if (InternetConnection.IsConnectedToInternet())
{
foreach (var item in salesDetailLst)
{
SalesDetail salesDetail = new SalesDetail();
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
ConnectionClass.InsertCommand("insert into Sales_Details " +
" values ('" +
item.ProductID + "','" +
item.ProductName + "','" +
item.Quantity + "','" +
item.UnitPrice + "','" +
item.TotalPrice + "','" +
dt.Rows[0][0].ToString() + "','True')");
}
}
else
{
foreach (var item in salesDetailLst)
{
SalesDetail salesDetail = new SalesDetail();
DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
ConnectionClass.InsertCommand("insert into Sales_Details " +
" values ('" +
item.ProductID + "','" +
item.ProductName + "','" +
item.Quantity + "','" +
item.UnitPrice + "','" +
item.TotalPrice + "','" +
dt.Rows[0][0].ToString() + "','False')");
}
/// PrintReport();
////ClearItems();
// lblHttpResponse.Text += "not connected!";
}
});
t1.Start();
t1.IsBackground = true;
t1.Join();
//PrintReport();
////Thread t2 = new Thread(() =>
////{
//// PrintReport();
////});
////t2.Start();
////t2.Join();
Thread t3 = new Thread(() =>
{
if (InternetConnection.IsConnectedToInternet())
{
foreach (var item in salesDetailLst)
{
OnlineActivities.SendOnlineSalesDetail(item.ProductID, item.ProductName,
Convert.ToInt32(item.Quantity), item.UnitPrice, item.TotalPrice,
item.SalesMasterIDLocal,
InternetConnection.GetBusinessID(),
InternetConnection.GetBusinessCode());
}
}
else
{
//update isconnected value to 0 in sales_details table where isConnected is equal to 1 recently
SqlConnection conn = new SqlConnection(connStaticString);
SqlCommand cmd = new SqlCommand("sp_InvertClientUpdateConnectionStatusInSales_Details", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// lblHttpResponse.Text += "not connected to internet";
}
});
t3.Start();
t3.IsBackground = true;
#endregion
#region original
//foreach (ListViewItem item in listView1.Items)
//{
// if (InternetConnection.IsConnectedToInternet() && InternetConnection.CheckServerConnectivity(serverIP) == true)
// {
// DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
// //Stopwatch stopwatch = new Stopwatch();
// //stopwatch.Start();
// Task t1 = Task.Factory.StartNew(() =>
// {
// ConnectionClass.InsertCommand("insert into Sales_Details " +
// " values ('" +
// item.SubItems[0].Text + "','" +
// item.SubItems[1].Text + "','" +
// item.SubItems[2].Text + "','" +
// item.SubItems[3].Text + "','" +
// item.SubItems[4].Text + "','" +
// dt.Rows[0][0].ToString() + "','True')");
// });
// //stopwatch.Stop();
// ////long ts = stopwatch.Elapsed.Seconds;
// ////lblTimeElapsed.Text = ts.ToString();
// Task t2 = t1.ContinueWith(antTask =>
// {
// OnlineActivities.SendOnlineSalesDetail(Convert.ToInt64(item.SubItems[0].Text), item.SubItems[1].Text.ToString()
// , Convert.ToInt32(item.SubItems[2].Text),
// Convert.ToDecimal(item.SubItems[3].Text),
// Convert.ToDecimal(item.SubItems[4].Text),
// Convert.ToInt64(dt.Rows[0][0].ToString()),
// InternetConnection.GetBusinessID(), InternetConnection.GetBusinessCode()
// );
// });
// }
// else
// {
// DataTable dt = ConnectionClass.Selectcommand("select max(salesMasterID) from Sales_Master");
// ConnectionClass.InsertCommand("insert into Sales_Details " +
// " values ('" +
// item.SubItems[0].Text + "','" +
// item.SubItems[1].Text + "','" +
// item.SubItems[2].Text + "','" +
// item.SubItems[3].Text + "','" +
// item.SubItems[4].Text + "','" +
// dt.Rows[0][0].ToString() + "','True')");
// lblResponse.Text += "\nSales Detial Data Transfer Fails!";
// }
//}
#endregion
}
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = ConnectionClass.Selectcommand("select * from Category");
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = ConnectionClass.Selectcommand("select Category_id from Category where CategoryName='" + comboBox1.Text + "'");
pid = dt.Rows[0][0].ToString();
}
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = ConnectionClass.Selectcommand("select Productid,ProductName,CostPrice,SalePrice,description from product");
}
// foreach( ){}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
dataGridView2.DataSource = ConnectionClass.Selectcommand("select * from sales_details where salesMaster_id='" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "'");
}
private void BoardReg_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = ConnectionClass.Selectcommand("select * from sales_Master");
calculation();
}
private void DTIssuingDate_ValueChanged(object sender, EventArgs e)
{
param = "Sales List for Date Between " + DTP1.Text + " and " + DTP2.Text;
dataGridView1.DataSource = ConnectionClass.Selectcommand("select * from sales_Master where Salesdate between '" + DTP1.Text + "' and '" + DTP2.Text + "'");
calculation();
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
dataGridView1.DataSource = ConnectionClass.Selectcommand("select * from sales_Master where Salesdate between '" + DTP1.Text + "' and '" + DTP2.Text + "'");
calculation();
}