private void PrintClick(object sender, RoutedEventArgs e)
{
try
{
if (Dtdata != null && Dtdata.Rows.Count > 0)
{
CrptOrderDetail objCrptOrderDetail = new CrptOrderDetail();
DataTable dt = Dtdata.Copy();
dt.TableName = "ORDER_DETAIL";
objCrptOrderDetail.SetDataSource(dt);
objCrptOrderDetail.SetParameterValue("@ReportNAME", "Order Detail");
objCrptOrderDetail.SetParameterValue("TitleNAME", "Customer");
UcReportViewer objucReportViewer = new UcReportViewer();
objucReportViewer.Height = 500;
objucReportViewer.Width = 1000;
objucReportViewer.ReportSource = objCrptOrderDetail;
objucReportViewer.Title = "Order";
objucReportViewer.ShowDialog();
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
e.Handled = true;
//throw;
}
}
private void GOButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (validate())
{
if (Dtdata != null && Dtdata.Columns.Count > 0)
{
if (EditRow == null)
{
DataRow drtemp = Dtdata.NewRow();
drtemp["NAME"] = Txttype;
drtemp["CATEGORY"] = Dr["TYPE"];
Dtdata.Rows.Add(drtemp);
serialcount();
}
else
{
EditRow["NAME"] = Txttype;
EditRow["CATEGORY"] = Dr["TYPE"];
serialcount();
}
}
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
e.Handled = true;
//throw;
}
}
private void GETButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(Txttype) || (Dr != null && Dr["TYPE"] != DBNull.Value))
{
using (OracleConnection objConn = new OracleConnection())
{
objConn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
if (objConn.State != ConnectionState.Open)
{
objConn.Open();
}
OracleCommand objCmd = new OracleCommand();
objCmd.Connection = objConn;
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = "SELECT 1 AS SL_NO,NAME AS NAME,WCF AS CATEGORY FROM WCF_TEMP WHERE NAME='" + Txttype + "' AND WCF='" + Dr["TYPE"] + "'";
//AND WCF='" + Dr["TYPE"] + "' ";
//objCmd.Parameters.Add("P_NAME", OracleType.VarChar).Value = !string.IsNullOrEmpty(Txttype) ? Txttype : string.Empty;
//objCmd.Parameters.Add("P_TYPE", OracleType.VarChar).Value = (Dr != null && Dr["TYPE"] != DBNull.Value) ? Dr["TYPE"] : DBNull.Value;
//objCmd.Parameters.Add("P_CURSOR", OracleType.Cursor).Direction = ParameterDirection.Output;
DataSet ds = new DataSet();
OracleDataAdapter adapter = new OracleDataAdapter(objCmd);
adapter.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
Dtdata.Merge(ds.Tables["Table"]);
serialcount();
}
}
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
e.Handled = true;
//throw;
}
}
