public void SearchSalesMaster()
{
try
{
clsSalesMaster objSearch = new clsSalesMaster();
objSearch.Mode = "SELECTALL";
objSearch.CompanyID = cId;
String FromDate = dtpFromDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != FromDate)
{
objSearch.FromDate = clsCommoan.GetDateInddMMYYYY(FromDate);
}
String ToDate = dtpToDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != ToDate)
{
objSearch.ToDate = clsCommoan.GetDateInddMMYYYY(ToDate);
}
objSearch.SalesMasterCustomerFKeyName = txtCustomerName.Text;
objSearch.SalesMasterCustomerFKeyAddress = txtCustomerAddress.Text;
objSearch.SalesMasterType = cmbSalesType.Text;
var ds = objSearch.SearchSalesMaster();
dgvSalesView.AutoGenerateColumns = false;
dgvSalesView.DataSource = ds.Tables[0];
lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SearchSalesMaster", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SearchSalesMaster()
{
try
{
String showBillTotal;
clsSalesMaster objSearch = new clsSalesMaster();
objSearch.Mode = "SELECTALL";
objSearch.CompanyID = cId;
String FromDate = dtpFromDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != FromDate)
{
objSearch.FromDate = clsCommoan.GetDateInddMMYYYY(FromDate);
}
String ToDate = dtpToDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != ToDate)
{
objSearch.ToDate = clsCommoan.GetDateInddMMYYYY(ToDate);
}
objSearch.SalesMasterCustomerFKeyAddress = txtCustomerAddress.Text;
objSearch.SalesMasterType = cmbSalesType.Text;
objSearch.SalesMasterCustomerFKeyName = txtCustomerName.Text;
var ds = objSearch.Report_SalesRegister();
SetReportValue("SenseInventoryLogoUI.Reports.SenseSalesRegisterReport.rdlc", "dsPrint", ds, "Star Sales Item and Payment Report", null, "");
LoadReportData(String.Empty);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SearchSalesMaster", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SearchSalesMaster()
{
try
{
clsSalesMaster objSearch = new clsSalesMaster();
objSearch.Mode = "SELECTALL";
String showBillTotal;
objSearch.CompanyID = cId;
String FromDate = dtpFromDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != FromDate)
{
objSearch.FromDate = clsCommoan.GetDateInddMMYYYY(FromDate);
}
String ToDate = dtpToDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != ToDate)
{
objSearch.ToDate = clsCommoan.GetDateInddMMYYYY(ToDate);
}
objSearch.SalesMasterCustomerFKeyAddress = txtCustomerAddress.Text;
int isAvaibleinListItem = cmbCustomer.FindStringExact(cmbCustomer.Text);
if (isAvaibleinListItem.Equals(-1))
{
objSearch.SalesMasterCustomerFKey = 0;
}
else
{
objSearch.SalesMasterCustomerFKey = Convert.ToInt32(cmbCustomer.SelectedValue);
}
if (objSearch.SalesMasterCustomerFKey.Equals(0))
{
showBillTotal = "No";
}
else
{
showBillTotal = "Yes";
}
var ds = objSearch.SearchSalesMasterItemSalesPaymentReport();
SetReportValue("SenseInventoryLogoUI.Reports.SenseInventorySalesPaymentReport.rdlc", "dsPrint", ds, "Star Sales Item and Payment Report", null, "");
LoadReportData(showBillTotal);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SearchSalesMaster", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SetReportData()
{
try
{
if (MultipleKeys.Length > 0)
{
int i;
clsSalesMaster objLoad = new clsSalesMaster();
objLoad.Mode = "SELECTALL";
objLoad.CompanyID = cId;
objLoad.SalesMasterKey = 0;
objLoad.SalesMasterNoofKey = MultipleKeys;
var dsReportData = objLoad.GetSalesMasterReport();
for (i = 1; i <= NoReport; i++)
{
var dsFinalDataset = InsertBlanckRowForFormate(dsReportData, "Multiple", i);
SetReportValue("SenseInventoryLogoUI.Reports.NewSenseInventorySalesReport.rdlc", "dsPrint", dsFinalDataset, "Star Sales Report", null, "");
LoadReportData(BlankRow, "Multiple");
}
}
else
{
if (PagePrimaryKey != 0)
{
int noofActualRow;
clsSalesMaster objLoad = new clsSalesMaster();
objLoad.Mode = "SELECTONE";
objLoad.CompanyID = cId;
objLoad.SalesMasterKey = PagePrimaryKey;
var dsReportData = objLoad.GetSalesMasterReport();
noofActualRow = dsReportData.Tables[0].Rows.Count;
var dsFinalDataset = InsertBlanckRowForFormate(dsReportData, "Single", 1);
SetReportValue("SenseInventoryLogoUI.Reports.NewSenseInventorySalesReport.rdlc", "dsPrint", dsFinalDataset, "Star Sales Report", null, "");
LoadReportData(noofActualRow, "Single");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SetReportData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SearchSalesMaster()
{
try
{
String showBillTotal;
clsSalesMaster objSearch = new clsSalesMaster();
objSearch.Mode = "SELECTALL";
objSearch.CompanyID = cId;
String FromDate = dtpFromDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != FromDate)
{
objSearch.FromDate = clsCommoan.GetDateInddMMYYYY(FromDate);
}
String ToDate = dtpToDate.Value.ToString("dd/MM/yyyy");
if (DateTime.Now.ToString("dd/MM/yyyy") != ToDate)
{
objSearch.ToDate = clsCommoan.GetDateInddMMYYYY(ToDate);
}
int isAvaibleinListItem = cmbCustomer.FindStringExact(cmbCustomer.Text);
if (isAvaibleinListItem.Equals(-1))
{
objSearch.SalesMasterCustomerFKey = 0;
}
else
{
objSearch.SalesMasterCustomerFKey = Convert.ToInt32(cmbCustomer.SelectedValue);
}
var ds = objSearch.Report_SalesGSTReport();
SetReportValue("SenseInventoryLogoUI.Reports.SenseSalesGSTRegisterReport.rdlc", "dsPrint", ds, "GST Summary Reort", null, "");
LoadReportData(String.Empty);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SearchSalesMaster", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
