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