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; } }