private void LoadPageInformations(string _PKey1)
{
try
{
HttpWebRequest WebReq = (HttpWebRequest)WebRequest.Create(string.Format(System.Configuration.ConfigurationManager.AppSettings["uri"] + "api/PoPrintLists"));
WebReq.Method = "GET";
HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();
Console.WriteLine(WebResp.StatusCode);
Console.WriteLine(WebResp.Server);
string jsonString;
using (Stream stream = WebResp.GetResponseStream())
{
StreamReader reader = new StreamReader(stream, System.Text.Encoding.UTF8);
jsonString = reader.ReadToEnd();
}
oDT_Header = (DataTable)JsonConvert.DeserializeObject(jsonString, (typeof(DataTable)));
if (_PKey1 != "")
{
DataView oDV = new DataView(oDT_Header);
oDV.RowFilter = "poNo='" + _PKey1 + "'";
oDT_Header = oDV.ToTable();
}
//oDT_Header = (DataTable)JsonConvert.DeserializeObject(jsonString, (typeof(DataTable)));
ReportDataSource rds = new ReportDataSource("ds_PORequest", oDT_Header);
this.rv_webBI_InvoicePrint.LocalReport.DataSources.Clear();
this.rv_webBI_InvoicePrint.LocalReport.DataSources.Add(rds);
string strFromDate = "";
string strToDate = "";
string postData1Title = "{\"fromDate\":\"" + strFromDate.Trim() + "\"," +
"\"toDate\":\"" + strToDate.Trim() + "\"," +
//"\"ReportTitle\":\"" + "Sales Collection" + "\"," +
"\"ReportTitle\":\"" + " Invoice Print " + "\"," +
"\"site\":\"" + System.Configuration.ConfigurationManager.AppSettings["SiteCode"].ToString() + "\"}";
//oDT_GeneralTitle = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webBI_ReportTittle", postData1Title);
oDT_GeneralTitle = oCommonEngine.ExecuteDataTable("select '' as fromDate,'' as toDate ,'Goods Receive Note Print' as reportTitle,'' as site ,'' as userCode,'' as siteText, Comp_Title1 as companyHeader1,Comp_Title2 as companyHeader2,Comp_Title3 as companyHeader3,Comp_Title4 as companyHeader4,Footer_1 as companyFooter1,Footer_2 as companyFooter2,Footer_3 as companyFooter3,Footer_4 as companyFooter4 from Title where Product_License='" + oDT_Header.Rows[0]["itemSiteCode"] + "'");
ReportDataSource titledatasource = new ReportDataSource("ds_webBI_ReportTittle", oDT_GeneralTitle);
this.rv_webBI_InvoicePrint.LocalReport.DataSources.Add(titledatasource);
oDT_Logo = oCommonEngine.ExecuteDataTable("select Trans_Logo as Logo from Title ");
ReportDataSource Logodatasource = new ReportDataSource("ds_Logo", oDT_Logo);
this.rv_webBI_InvoicePrint.LocalReport.DataSources.Add(Logodatasource);
this.rv_webBI_InvoicePrint.LocalReport.ReportPath = "rpt_webBI_Invoice.rdlc";
this.rv_webBI_InvoicePrint.LocalReport.Refresh();
this.rv_webBI_InvoicePrint.SizeToReportContent = true;
this.rv_webBI_InvoicePrint.Width = Unit.Percentage(100);
this.rv_webBI_InvoicePrint.Height = Unit.Percentage(100);
this.rv_webBI_InvoicePrint.AsyncRendering = false;
this.rv_webBI_InvoicePrint.ZoomMode = ZoomMode.FullPage;
oCommonEngine.SetAlert(this.Page, "Report Loaded Sucessfully...!", Utilities.CommonEngine.MessageType.Success, Utilities.CommonEngine.MessageDuration.Short);
}
catch (Exception Ex)
{
oCommonEngine.SetAlert(this.Page, Ex.Message, Utilities.CommonEngine.MessageType.Error, Utilities.CommonEngine.MessageDuration.Medium);
throw;
}
}
private void LoadPageInformations(string _PKey1)
{
try
{
var client = new HttpClient();
client.BaseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["uri"]);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
string api = "api/Stkprintlists?filter={\"where\":{\"docNo\":\"" + _PKey1 + "\"}}";
var response = client.GetAsync(api).Result;
var a = response.Content.ReadAsStringAsync().Result;
oDT_Header = (DataTable)JsonConvert.DeserializeObject(a, (typeof(DataTable)));
oDT_Header.DefaultView.Sort = "docLineno asc";
oDT_Header = oDT_Header.DefaultView.ToTable();
ReportDataSource rds = new ReportDataSource("ds_Stkprintlist", oDT_Header);
this.rv_webBI_GRNReturnPrint.LocalReport.DataSources.Clear();
this.rv_webBI_GRNReturnPrint.LocalReport.DataSources.Add(rds);
string strFromDate = "";
string strToDate = "";
string postData1Title = "{\"fromDate\":\"" + strFromDate.Trim() + "\"," +
"\"toDate\":\"" + strToDate.Trim() + "\"," +
//"\"ReportTitle\":\"" + "Sales Collection" + "\"," +
"\"ReportTitle\":\"" + " Goods Return Print " + "\"," +
"\"site\":\"" + System.Configuration.ConfigurationManager.AppSettings["SiteCode"].ToString() + "\"}";
//oDT_GeneralTitle = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webBI_ReportTittle", postData1Title);
oDT_GeneralTitle = oCommonEngine.ExecuteDataTable("select '' as fromDate,'' as toDate ,'Goods Receive Note Print' as reportTitle,'' as site ,'' as userCode,'' as siteText, Comp_Title1 as companyHeader1,Comp_Title2 as companyHeader2,Comp_Title3 as companyHeader3,Comp_Title4 as companyHeader4,Footer_1 as companyFooter1,Footer_2 as companyFooter2,Footer_3 as companyFooter3,Footer_4 as companyFooter4 from Title where Product_License='" + oDT_Header.Rows[0]["storeNo"] + "'");
ReportDataSource titledatasource = new ReportDataSource("ds_webBI_ReportTittle", oDT_GeneralTitle);
this.rv_webBI_GRNReturnPrint.LocalReport.DataSources.Add(titledatasource);
oDT_Logo = oCommonEngine.ExecuteDataTable("select Trans_Logo as Logo from Title ");
ReportDataSource Logodatasource = new ReportDataSource("ds_Logo", oDT_Logo);
this.rv_webBI_GRNReturnPrint.LocalReport.DataSources.Add(Logodatasource);
this.rv_webBI_GRNReturnPrint.LocalReport.ReportPath = "rpt_webGRNReturn.rdlc";
this.rv_webBI_GRNReturnPrint.LocalReport.Refresh();
this.rv_webBI_GRNReturnPrint.SizeToReportContent = true;
this.rv_webBI_GRNReturnPrint.Width = Unit.Percentage(100);
this.rv_webBI_GRNReturnPrint.Height = Unit.Percentage(100);
this.rv_webBI_GRNReturnPrint.AsyncRendering = false;
this.rv_webBI_GRNReturnPrint.ZoomMode = ZoomMode.FullPage;
oCommonEngine.SetAlert(this.Page, "Report Loaded Sucessfully...!", Utilities.CommonEngine.MessageType.Success, Utilities.CommonEngine.MessageDuration.Short);
}
catch (Exception Ex)
{
oCommonEngine.SetAlert(this.Page, Ex.Message, Utilities.CommonEngine.MessageType.Error, Utilities.CommonEngine.MessageDuration.Medium);
throw;
}
}
private void LoadPageInformations()
{
try
{
string strDept = "";
string strBrand = "";
string strRange = "";
string strSite = "";
string strFromItem = "";
string strToItem = "";
string strAsOnDate = "";
string strShowZeroQty = "N";
string strShowInactive = "N";
for (int i = 0; i < ddlDept_webBI_StockBalance.Items.Count; i++)
{
if (ddlDept_webBI_StockBalance.Items[i].Selected == true)
{
strDept = strDept + ddlDept_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
}
}
for (int i = 0; i < ddlBrand_webBI_StockBalance.Items.Count; i++)
{
if (ddlBrand_webBI_StockBalance.Items[i].Selected == true)
{
strBrand = strBrand + ddlBrand_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
}
}
for (int i = 0; i < ddlRange_webBI_StockBalance.Items.Count; i++)
{
if (ddlRange_webBI_StockBalance.Items[i].Selected == true)
{
strRange = strRange + ddlRange_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
}
}
for (int i = 0; i < ddlSite_webBI_StockBalance.Items.Count; i++)
{
if (ddlSite_webBI_StockBalance.Items[i].Selected == true)
{
strSite = strSite + ddlSite_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
}
}
for (int i = 0; i < ddlFItem_webBI_StockBalance.Items.Count; i++)
{
if (ddlFItem_webBI_StockBalance.Items[i].Selected == true)
{
strFromItem = strFromItem + ddlFItem_webBI_StockBalance.Items[i].Value.ToString().Trim().Replace("'", "") + ",";
}
}
//strFromItem = ddlFItem_webBI_StockBalance.Items[ddlFItem_webBI_StockBalance.SelectedIndex].Value;
//strToItem = ddlTItem_webBI_StockBalance.Items[ddlTItem_webBI_StockBalance.SelectedIndex].Value;
strAsOnDate = dtAsOnDate_webBI_StockBalance.Value.ToString();
if (chkShowZeroQtyItems_webBI_StockBalance.Checked)
{
strShowZeroQty = "Y";
}
if (chkShowInActive_webBI_StockBalance.Checked)
{
strShowInactive = "Y";
}
string postData = "{\"toDate\":\"" + strAsOnDate.Trim() + "\"," +
"\"Site\":\"" + strSite.Trim() + "\"," +
"\"Dept\":\"" + strDept.Trim() + "\"," +
"\"Brand\":\"" + strBrand.Trim() + "\"," +
"\"fromItem\":\"" + strFromItem.Trim() + "\"," +
"\"toItem\":\"" + strToItem.Trim() + "\"," +
"\"Range\":\"" + strRange.Trim() + "\"," +
"\"showInActive\":\"" + strShowInactive.Trim() + "\"," +
"\"showZeroQty\":\"" + strShowZeroQty.Trim() + "\"}";
oDT_General = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webInventory_StockBalance", postData);
ReportDataSource rds = new ReportDataSource("ds_webBI_StockBalance", oDT_General);
this.rv_webBI_StockBalance.LocalReport.DataSources.Clear();
this.rv_webBI_StockBalance.LocalReport.DataSources.Add(rds);
string postData1Title = "{\"fromDate\":\"" + strAsOnDate.Trim() + "\"," +
"\"toDate\":\"" + strSite.Trim() + "\"," +
"\"ReportTitle\":\"" + "Stock Balance" + "\"," +
"\"site\":\"" + strSite.Trim() + "\"}";
//oDT_GeneralTitle = oCommonEngine.GetDataTableFromAPI(Login.strAPIURL + "/api/webBI_ReportTittle", postData1Title);
oDT_GeneralTitle = oCommonEngine.ExecuteDataTable("select '' as fromDate,'' as toDate ,'Goods Receive Note Print' as reportTitle,'' as site ,'' as userCode,'' as siteText, Comp_Title1 as companyHeader1,Comp_Title2 as companyHeader2,Comp_Title3 as companyHeader3,Comp_Title4 as companyHeader4,Footer_1 as companyFooter1,Footer_2 as companyFooter2,Footer_3 as companyFooter3,Footer_4 as companyFooter4 from Title where Product_License='" + ddlSite_webBI_StockBalance.Value + "'");
ReportDataSource titledatasource = new ReportDataSource("ds_webBI_ReportTittle", oDT_GeneralTitle);
this.rv_webBI_StockBalance.LocalReport.DataSources.Add(titledatasource);
this.rv_webBI_StockBalance.LocalReport.ReportPath = "rpt_webBI_StockBalance.rdlc";
this.rv_webBI_StockBalance.LocalReport.Refresh();
this.rv_webBI_StockBalance.SizeToReportContent = true;
this.rv_webBI_StockBalance.Width = Unit.Percentage(100);
this.rv_webBI_StockBalance.Height = Unit.Percentage(100);
this.rv_webBI_StockBalance.AsyncRendering = false;
this.rv_webBI_StockBalance.ZoomMode = ZoomMode.FullPage;
oCommonEngine.SetAlert(this.Page, "Report Loaded Sucessfully...!", Utilities.CommonEngine.MessageType.Success, Utilities.CommonEngine.MessageDuration.Short);
}
catch (Exception)
{
throw;
}
}