private void DisplayRecord()
{
_MainAdapter = DBClass.GetAdaptor("OrderMain");
_DataTable = new DataTable();
_MainAdapter.Fill(_DataTable);
dsMain.Tables.Add(_DataTable);
dsMain.Tables[0].TableName = "OrderMain";
_MainDTAdapter = DBClass.GetAdaptor("OrderDetail");
_DataTable = new DataTable();
_MainDTAdapter.Fill(_DataTable);
dsMain.Tables.Add(_DataTable);
dsMain.Tables[1].TableName = "OrderDetail";
DataColumn tcolumn = new DataColumn();
tcolumn.DataType = System.Type.GetType("System.Decimal");
tcolumn.ColumnName = "Total";
tcolumn.Expression = "Qty * UnitPrice ";
dsMain.Tables["OrderDetail"].Columns.Add(tcolumn);
Set_Grid();
FillOrders(0);
}
private void DisplayRecord()
{
_OrderAdapter = DBClass.GetAdapterByQuery(Query);
_OrderAdapter.Fill(dsMain);
dsMain.Tables[0].TableName = "Order";
_PayAdapter = DBClass.GetAdaptor("PaymentDetail");
_PayAdapter.Fill(dsMain);
dsMain.Tables[1].TableName = "PaymentDetail";
Set_OrderGrid();
Set_PaymentGrid();
Filter_OrderDetail();
Filter_PaymentDetail();
}
private void dgvLED_RowValidated(object sender, DataGridViewCellEventArgs e)
{
if (!dsMain.HasChanges())
{
return;
}
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(_MainAdapter);
_MainAdapter.UpdateCommand = commandBuilder.GetUpdateCommand();
_MainAdapter.InsertCommand = commandBuilder.GetInsertCommand();
_MainAdapter.Update(dsMain.Tables["ItemMaster"]);
dsMain.Tables["ItemMaster"].Clear();
_MainAdapter = DBClass.GetAdaptor("ItemMaster");
_MainAdapter.Fill(dsMain.Tables["ItemMaster"]);
}
private void dgvPayment_RowValidated(object sender, DataGridViewCellEventArgs e)
{
if (!dsMain.HasChanges())
{
return;
}
decimal PAmt = decimal.Parse(dgvPayment.Rows[e.RowIndex].Cells["Paid_Amt"].Value.ToString());
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(_PayAdapter);
_PayAdapter.UpdateCommand = commandBuilder.GetUpdateCommand();
_PayAdapter.InsertCommand = commandBuilder.GetInsertCommand();
_PayAdapter.Update(dsMain.Tables["PaymentDetail"]);
dsMain.Tables["PaymentDetail"].Clear();
_PayAdapter = DBClass.GetAdaptor("PaymentDetail");
_PayAdapter.Fill(dsMain.Tables["PaymentDetail"]);
}
private void displayRecord()
{
_MainAdapter = DBClass.GetAdaptor("ItemMaster");
dsMain = new DataSet();
_MainAdapter.Fill(dsMain);
dsMain.Tables[0].TableName = "ItemMaster";
dgvLED.DataSource = null;
dgvLED.DataSource = dsMain.Tables["ItemMaster"];
dgvLED.Columns["ItemCode"].ReadOnly = true;
dgvLED.Columns["ItemCode"].HeaderText = "No.";
dgvLED.Columns["ItemCode"].Width = 50;
dgvLED.Columns["ItemName"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvLED.Columns["ItemName"].HeaderText = "Items Name";
dgvLED.Columns["UnitPrice"].Width = 100;
dgvLED.Columns["UnitPrice"].HeaderText = "Items Price";
}
private void Fill_Combo()
{
_DataTable = new DataTable();
_CustomerAdapter = DBClass.GetAdapterByQuery("Select distinct CustomerID,CustomerName from OrderMain");
_CustomerAdapter.Fill(_DataTable);
dsForCombo.Tables.Add(_DataTable);
dsForCombo.Tables[0].TableName = "Customer";
cmbcustomername.DisplayMember = "CustomerName";
cmbcustomername.ValueMember = "CustomerID";
cmbcustomername.DataSource = dsForCombo.Tables["Customer"];
_ItemAdapter = DBClass.GetAdaptor("ItemMaster");
_DataTable = new DataTable();
_ItemAdapter.Fill(_DataTable);
dsForCombo.Tables.Add(_DataTable);
dsForCombo.Tables[1].TableName = "ItemMaster";
}
private void SaveRedord()
{
DataRow[] row = dsMain.Tables["OrderMain"].Select("Orderid=" + int.Parse(txtOrderID.Text));
if (row.Length == 0)
{
_MainAdapter.InsertCommand = new SqlCommand(@"insert into OrderMain(OrderDate,Deliverydate,CustomerID,CustomerName,Contactno,Place,Discount,Advance_Amt)
output inserted.Orderid
Values(@OrderDate,@Deliverydate,@CustomerID,@CustomerName,@Contactno,@Place,@Discount,@Advance_Amt)", DBClass.connection);
DBClass.connection.Open();
_MainAdapter.InsertCommand.Parameters.AddWithValue("@OrderDate", txtOrderDate.Text);
_MainAdapter.InsertCommand.Parameters.AddWithValue("@Deliverydate", txtDeliveryDate.Text);
_MainAdapter.InsertCommand.Parameters.AddWithValue("@CustomerID", int.Parse(txtCustmorid.Text));
_MainAdapter.InsertCommand.Parameters.AddWithValue("@CustomerName", cmbcustomername.Text);
_MainAdapter.InsertCommand.Parameters.AddWithValue("@Contactno", txtContectNo.Text);
_MainAdapter.InsertCommand.Parameters.AddWithValue("@Place", txtAdders.Text);
string DiscAmt = (txtDiscount.Text == "") ? "0" : txtDiscount.Text;
_MainAdapter.InsertCommand.Parameters.AddWithValue("@Discount", Convert.ToDecimal(DiscAmt));
string AdvAmt = (txtDiscount.Text == "") ? "0" : txtAdvance.Text;
_MainAdapter.InsertCommand.Parameters.AddWithValue("@Advance_Amt", decimal.Parse(AdvAmt));
int id = (int)_MainAdapter.InsertCommand.ExecuteScalar();
txtOrderID.Text = id.ToString();
DBClass.connection.Close();
}
else
{
DBClass.connection.Open();
_MainAdapter.UpdateCommand = new SqlCommand(@"update OrderMain set OrderDate=@OrderDate,Deliverydate=@Deliverydate,CustomerID=@CustomerID,CustomerName=@CustomerName,
Contactno=@Contactno,Place=@Place,Discount=@Discount,Advance_Amt=@Advance_Amt
where OrderID= @OrderID ", DBClass.connection);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@OrderID", txtOrderID.Text);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@OrderDate", txtOrderDate.Text);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@Deliverydate", txtDeliveryDate.Text);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@CustomerID", int.Parse(txtCustmorid.Text));
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@CustomerName", cmbcustomername.Text);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@Contactno", txtContectNo.Text);
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@Place", txtAdders.Text);
string DiscAmt = (txtDiscount.Text == "") ? "0" : txtDiscount.Text;
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@Discount", Convert.ToDecimal(DiscAmt));
string AdvAmt = (txtDiscount.Text == "") ? "0" : txtAdvance.Text;
_MainAdapter.UpdateCommand.Parameters.AddWithValue("@Advance_Amt", decimal.Parse(AdvAmt));
_MainAdapter.UpdateCommand.ExecuteNonQuery();
DBClass.connection.Close();
}
dsMain.Tables["OrderMain"].Clear();
_MainAdapter.Fill(dsMain.Tables["OrderMain"]);
//////////////// Save Order Detail ///////////
//foreach (DataRow row1 in dsMain.Tables["OrderDetail"].Rows)
//{
// row1["OrderId"] = txtOrderID.Text;
//}
//dsMain.Tables["OrderDetail"].Columns["OrderId"].DefaultValue = txtOrderID.Text;
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(_MainDTAdapter);
_MainDTAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
_MainDTAdapter.InsertCommand = cmdBuilder.GetInsertCommand();
_MainDTAdapter.Update(dsMain.Tables["OrderDetail"]);
dsMain.Tables["OrderDetail"].Clear();
_MainDTAdapter = DBClass.GetAdaptor("OrderDetail");
_MainDTAdapter.Fill(dsMain.Tables["OrderDetail"]);
dsForCombo.Tables["Customer"].Clear();
_CustomerAdapter = DBClass.GetAdapterByQuery("Select distinct CustomerID,CustomerName from OrderMain");
_CustomerAdapter.Fill(dsForCombo.Tables["Customer"]);
FillCustomerDetail(txtCustmorid.Text);
FillOrders(dsMain.Tables["OrderMain"].Rows.Count - 1);
Enable_Disable_Controls(true);
}
