private void BindSaleaOrderDetails()
{
SoNumber = hidSoNumber.Value;
string whereClause = HeaderIDColumn + "=" + SoNumber.ToUpper().Replace("W", "");
DataTable dsSalesOrderDetails = Sod.GetSalesOrderDetails(Session["OrderTableName"].ToString(), "SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToName,ShipToAddress1,City,State,PhoneNo,Zip,Country", whereClause);
if (dsSalesOrderDetails != null)
{
//SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToProvidence,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToCd,ShipToName,ShipToAddress1,ShipToAddress2,ShipToAddress3,City,State,Zip,PhoneNo,FaxNo,ContactName,ContactPhoneNo";
lblSold_Name.Text = dsSalesOrderDetails.Rows[0]["SellToCustName"].ToString().Trim();
lblSold_Address.Text = dsSalesOrderDetails.Rows[0]["SellToAddress1"].ToString().Trim();
lblSold_City.Text = (dsSalesOrderDetails.Rows[0]["SellToCity"].ToString().Trim() != "" ? dsSalesOrderDetails.Rows[0]["SellToCity"].ToString().Trim() + ", " :dsSalesOrderDetails.Rows[0]["SellToCity"].ToString().Trim());
lblSold_Territory.Text = dsSalesOrderDetails.Rows[0]["SellToState"].ToString().Trim();
lblSold_Phone.Text = dsSalesOrderDetails.Rows[0]["SellToContactPhoneNo"].ToString().Trim();
lblSold_Pincode.Text = dsSalesOrderDetails.Rows[0]["SellToZip"].ToString().Trim();
lblSoldCom.Visible = ((lblSold_City.Text.Trim() != "" && lblSold_Territory.Text.Trim() != "") ? true : false);
lblSoldCountry.Text = dsSalesOrderDetails.Rows[0]["SellToCountry"].ToString().Trim();
lblShip_Name.Text = dsSalesOrderDetails.Rows[0]["ShipToName"].ToString().Trim();
lblShip_Contact.Text = dsSalesOrderDetails.Rows[0]["ShipToAddress1"].ToString().Trim();
lblShip_City.Text = dsSalesOrderDetails.Rows[0]["City"].ToString().Trim();
lblShip_State.Text = dsSalesOrderDetails.Rows[0]["State"].ToString().Trim();
lblShip_Phone.Text = dsSalesOrderDetails.Rows[0]["PhoneNo"].ToString().Trim();
lblShip_Pincode.Text = dsSalesOrderDetails.Rows[0]["Zip"].ToString().Trim();
lblShipCom.Visible = ((lblShip_City.Text.Trim() != "" && lblShip_State.Text.Trim() != "") ? true : false);
lblShipCountry.Text = dsSalesOrderDetails.Rows[0]["Country"].ToString().Trim();
lblSoldCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim();
lblShipCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim();
lblSalesRepdisp.Text = salesHis.GetSalesRepName(salesHis.GetSalesRepNo(custNumber));
}
}
private void BindSaleaOrderDetails()
{
SalesOrderDetails salesOrder = new SalesOrderDetails();
DataTable dsSalesOrderDetails = salesOrder.GetSalesOrderDetails("SOHeader", "pSOHeaderID,SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToName,ShipToAddress1,City,State,PhoneNo,Zip,Country", "pSOHeaderID=" + SoNumber);
if (dsSalesOrderDetails != null)
{
lblSold_Name.Text = dsSalesOrderDetails.Rows[0]["SellToCustName"].ToString().Trim();
lblSold_Contact.Text = dsSalesOrderDetails.Rows[0]["SellToAddress1"].ToString().Trim();
lblSold_City.Text = dsSalesOrderDetails.Rows[0]["SellToCity"].ToString().Trim();
lblSold_Territory.Text = dsSalesOrderDetails.Rows[0]["SellToState"].ToString().Trim();
lblSold_Phone.Text = dsSalesOrderDetails.Rows[0]["SellToContactPhoneNo"].ToString().Trim();
lblSold_Pincode.Text = dsSalesOrderDetails.Rows[0]["SellToZip"].ToString().Trim();
lblSoldCom.Visible = ((lblSold_City.Text.Trim() != "" && lblSold_Territory.Text.Trim() != "") ? true : false);
lblSoldCountry.Text = dsSalesOrderDetails.Rows[0]["SellToCountry"].ToString().Trim();
lblShip_Name.Text = dsSalesOrderDetails.Rows[0]["ShipToName"].ToString().Trim();
lblShip_Contact.Text = dsSalesOrderDetails.Rows[0]["ShipToAddress1"].ToString().Trim();
lblShip_City.Text = dsSalesOrderDetails.Rows[0]["City"].ToString().Trim();
lblShip_State.Text = dsSalesOrderDetails.Rows[0]["State"].ToString().Trim();
lblShip_Phone.Text = dsSalesOrderDetails.Rows[0]["PhoneNo"].ToString().Trim();
lblShip_Pincode.Text = dsSalesOrderDetails.Rows[0]["Zip"].ToString().Trim();
lblShipCom.Visible = ((lblShip_City.Text.Trim() != "" && lblShip_State.Text.Trim() != "") ? true : false);
lblShipCountry.Text = dsSalesOrderDetails.Rows[0]["Country"].ToString().Trim();
lblSoldCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim();
lblShipCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim();
}
}
private void BindData()
{
try
{
DataTable dssubHeader = salesOrder.GetSalesOrderDetails("SOHeader", "pSOHeaderID,SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToName,ShipToAddress1,City,State,PhoneNo,Zip,Country", "pSOHeaderID=" + SONumber);
dlSOEHeader.DataSource = dssubHeader;
dlSOEHeader.DataBind();
dgExpense.DataSource = expenseEntry.GetExpensePrint(SONumber);
dgExpense.DataBind();
}
catch (Exception ex) { }
}
private void BindData()
{
try
{
string whereClause = HeaderIDColumn + "= '" + SONumber + " ' and DeleteDt is null";
if (Convert.ToBoolean(Request.QueryString["Deleted"]))
{
whereClause = HeaderIDColumn + "= '" + SONumber + "'";
}
if (Request.QueryString["Type"] != null && Request.QueryString["Type"].ToString() != "")
{
whereClause += " and Type ='" + Request.QueryString["Type"].ToString() + "'";
}
DataTable dssubHeader = salesOrder.GetSalesOrderDetails(OrderTable, "OrderNo,SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToName,ShipToAddress1,City,State,PhoneNo,Zip,Country", "OrderNo=" + SONumber);
dlSOEHeader.DataSource = dssubHeader;
dlSOEHeader.DataBind();
dgComment.DataSource = commentEntry.GetCommentPrint(CommentTable, whereClause);
dgComment.DataBind();
}
catch (Exception ex) { }
}