private void OpenInvoice(Int64 vID) { try { btnClear_Click(null, null); DataTable dt = objDAL.getRecord(" AND CustomerIssue.IssueID=" + vID); if (dt.Rows.Count > 0) { txtInvNo.Text = dt.Rows[0]["IssueID"].ToString(); dtEntryDate.Text = dt.Rows[0]["IssueDate"].ToString(); txtCustomerID.Text = dt.Rows[0]["CustomerID"].ToString(); txtCustomerName.Text = dt.Rows[0]["PartyName"].ToString(); txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); txtSecurity.Text = decimal.Parse(dt.Rows[0]["SecurityDeposit"].ToString()).ToString("G29"); //Grid.DataSource = dt; foreach (DataRow dr in dt.Rows) { Grid.Rows.Add(dr["ProductID"].ToString(), dr["ProductName"].ToString(), decimal.Parse(dr["UnitID"].ToString()).ToString("0"), dr["UnitTitle"].ToString(), dr["Units"].ToString(), decimal.Parse(dr["Qty"].ToString()).ToString("G29"), decimal.Parse(dr["Cost"].ToString()).ToString("G29")); } SetMode(true); } else { MessageBox.Show("Invalid Issue ID.", "Invalid Information"); SetMode(false); } } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }
private void btnPreview_Click(object sender, EventArgs e) { try { string vWhere = string.Empty; string criteria = string.Empty; Reports.RptReportViewer vForm = new Reports.RptReportViewer(); if (!chkReturn.Checked) { if (!string.IsNullOrEmpty(this.txtVendorID.Text)) { vWhere += " AND CustomerIssue.CustomerID=" + this.txtVendorID.Text; } if (!string.IsNullOrEmpty(this.txt_ProductID.Text)) { vWhere += " AND CustomerIssueBody.ProductID=" + this.txt_ProductID.Text; } if (optRange.Checked == true) { vWhere += " AND convert(datetime,Convert(varchar,CustomerIssue.IssueDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_From.Text + " 00:00:00',102),1))) AND Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_ToDate.Text + " 00:00:00',102),1)))"; criteria += "From: " + dt_From.Value.ToString("dd-MMM-yyyy") + " To: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } else { criteria += " Till Date: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } DataTable dt = objDAL.getRecord(vWhere); if (dt.Rows.Count == 0) { MessageBox.Show("No Data To Display", "No Data"); return; } vForm.PartyStockIssue(criteria, dt); vForm.ShowDialog(); } else { if (!string.IsNullOrEmpty(this.txtVendorID.Text)) { vWhere = " AND CustomerReturn.CustomerID=" + this.txtVendorID.Text; } if (!string.IsNullOrEmpty(this.txt_ProductID.Text)) { vWhere += " AND CustomerReturnBody.ProductID=" + this.txt_ProductID.Text; } if (optRange.Checked == true) { vWhere += " AND convert(datetime,Convert(varchar,CustomerReturn.ReturnDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_From.Text + " 00:00:00',102),1))) AND Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_ToDate.Text + " 00:00:00',102),1)))"; criteria = "From: " + dt_From.Value.ToString("dd-MMM-yyyy") + " To: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } else { criteria = " Till Date: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } DAL.CustomerReturn obj = new DAL.CustomerReturn(); obj.connectionstring = objDAL.connectionstring; DataTable dt = obj.getRecord(vWhere); if (dt.Rows.Count == 0) { MessageBox.Show("No Data To Display", "No Data"); return; } vForm.PartyStockReturn(criteria, dt); vForm.ShowDialog(); } } catch (Exception exc) { MessageBox.Show(exc.Message, "Error"); } }