private void GetOrderDetails() { string query = "Select PurchaseOrderDetails.ItemName,PurchaseOrderDetails.ItemID,PurchaseOrderDetails.ComodityCode,PurchaseOrderDetails.Unit,PurchaseOrderDetails.qty,PurchaseOrder.PurchaseOrderNo,PurchaseOrder.OrderDate,PurchaseOrder.LedgerID from PurchaseOrder" + " inner join PurchaseOrderDetails on PurchaseOrder.OrderId=PurchaseOrderDetails.OrderId where PurchaseOrder.OrderId='" + mOrderid + "'"; DataTable dt = SQLHelper.GetInstance().ExcuteNonQuery(query, out msg); if (dt.IsValidDataTable()) { object orderno = dt.Rows[0]["PurchaseOrderNo"]; lblOrderNo.Text = orderno.ISValidObject() ? orderno.ToString() : "Not Assign"; lblOrderate.Text = DateTime.Parse(dt.Rows[0]["OrderDate"].ToString()).ToString("dd-MMM-yyyy"); mLedgerId = dt.Rows[0]["LedgerId"].ToString(); string ledgerName = ""; Supplier._DicSuppliers.TryGetValue(mLedgerId, out ledgerName); lblSupplierName.Text = ledgerName; string itemName = dt.Rows[0]["ItemName"].ToString(); mitemid = dt.Rows[0]["ItemID"].ToString(); string hsnCode = dt.Rows[0]["ComodityCode"].ToString(); string unit = dt.Rows[0]["Unit"].ToString(); string qty = dt.Rows[0]["qty"].ToString(); GetOrgBillingAndShippingDetails(); GetSupplierDetails(mLedgerId); if (mIsRegular) { ItemTools.GetItemGSTRateIsiGst(mitemid, mIsIGST, out mcgstrate, out msgstrate, out migstrate, out mcessrate); } dgvItemList.Rows.Add(1, mitemid, itemName, hsnCode, qty, unit, "", "", "", "", "", mcgstrate, "", msgstrate, "", migstrate, "" , mcessrate, "", ""); } }
private void GetOrderDetails() { string query = "Select SalesOrderDetails.ItemName,SalesOrderDetails.ItemID,SalesOrderDetails.ComodityCode,SalesOrderDetails.Unit,SalesOrderDetails.qty,SalesOrderDetails.Rate,salesorder.CustomerOrderNo,salesorder.OrderDate,salesorder.LedgerID,salesorder.TotalAmount from salesorder" + " inner join SalesOrderDetails on SalesOrder.OrderId=SalesOrderDetails.orderid where SalesOrder.OrderId='" + mOrderid + "'"; DataTable dt = SQLHelper.GetInstance().ExcuteNonQuery(query, out msg); if (dt.IsValidDataTable()) { object orderno = dt.Rows[0]["CustomerOrderNo"]; lblOrderNo.Text = orderno.ISValidObject() ? orderno.ToString() : "Not Assign"; lblOrderate.Text = DateTime.Parse(dt.Rows[0]["OrderDate"].ToString()).ToString("dd-MMM-yyyy"); mLedgerId = dt.Rows[0]["LedgerId"].ToString(); lblOrdervalue.Text = dt.Rows[0]["TotalAmount"].ToString(); string ledgerName = ""; Customertools._DicCustomers.TryGetValue(mLedgerId, out ledgerName); lblCustomername.Text = ledgerName; GetCustomerAddressDetails(mLedgerId); GetCustomerShippedDetails(mLedgerId); string itemName = dt.Rows[0]["ItemName"].ToString(); mitemid = dt.Rows[0]["ItemID"].ToString(); string hsnCode = dt.Rows[0]["ComodityCode"].ToString(); string unit = dt.Rows[0]["Unit"].ToString(); string qty = dt.Rows[0]["qty"].ToString(); string rate = dt.Rows[0]["Rate"].ToString(); ItemTools.GetItemGSTRateIsiGst(mitemid, mIsIGST, out mcgstrate, out msgstrate, out migstrate, out mcessrate); dgvItemList.Rows.Add(1, mitemid, itemName, hsnCode, qty, unit, rate, "", "", "", "", mcgstrate, "", msgstrate, "", migstrate, "" , mcessrate, "", ""); } }