public static List <LOCATION> GetAllLOCATIONsForSearchByID(int lOCATIONID)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsForSearchByID(lOCATIONID);
return(lOCATIONs);
}
public static List <LOCATION> GetAllLOCATIONsCountry()
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsCountry();
return(lOCATIONs);
}
public static List <LOCATION> GetAllLOCATIONsByAgentIDnGroupID(int agentID, int groupID)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsByAgentIDnGroupID(agentID, groupID);
return(lOCATIONs);
}
public static List <LOCATION> GetAllLOCATIONsNotInGroupByGroupID(int groupID)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsNotInGroupByGroupID(groupID);
return(lOCATIONs);
}
public static LOCATION GetLOCATIONByIDByAgentID(int id, int agentID)
{
LOCATION lOCATION = new LOCATION();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATION = sqlLOCATIONProvider.GetLOCATIONByIDByAGNETID(id, agentID);
return(lOCATION);
}
public static LOCATION GetLOCATIONByID(int id)
{
LOCATION lOCATION = new LOCATION();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATION = sqlLOCATIONProvider.GetLOCATIONByID(id);
return(lOCATION);
}
public static List <LOCATION> GetAllLOCATIONsForReportByDatenAmountCustomerIDs(string customerID, string receiverID, int agentID, string fromDate, string toDate, int amount)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsForReportByDatenAmountCustomerIDs(customerID, receiverID, agentID, fromDate, toDate, amount);
return(lOCATIONs);
}
public static List <LOCATION> GetAllLOCATIONsForReportByDatenAmountLocationIDsStatus(string status, string locationIDs, int agentID, string fromDate, string toDate, int amount)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsByDatenAmountLocationIDsStatus(status, locationIDs, agentID, fromDate, toDate, amount);
return(lOCATIONs);
}
public static List <LOCATION> GetAllLOCATIONsForSearch(int agentID, string country, string city, string branch)
{
List <LOCATION> lOCATIONs = new List <LOCATION>();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
lOCATIONs = sqlLOCATIONProvider.GetAllLOCATIONsForSearch(agentID, country, city, branch);
return(lOCATIONs);
}
public static bool DeleteLOCATION(int lOCATIONID)
{
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
return(sqlLOCATIONProvider.DeleteLOCATION(lOCATIONID));
}
public static bool UpdateLOCATION(LOCATION lOCATION)
{
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
return(sqlLOCATIONProvider.UpdateLOCATION(lOCATION));
}
public static int InsertLOCATION(LOCATION lOCATION)
{
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
return(sqlLOCATIONProvider.InsertLOCATION(lOCATION));
}
protected void Button1_Click(object sender, EventArgs e)
{
//Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource();
//rds.DataSourceId = "AbiMatuEnterprise_GetAllAGENTs";
//rds.Name = "dsReceipt";
//rvProducts.LocalReport.DataSources.Clear();
//rvProducts.Reset();
//rvProducts.LocalReport.Refresh();
//rvProducts.LocalReport.ReportPath = "Report.rdlc";
//rvProducts.LocalReport.DataSources.Add(rds);
//rvProducts.LocalReport.Refresh();
//Fill the datasource from DB
//AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter ta = new AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter();
//AdventureWorks.vProductAndDescriptionDataTable dt = new AdventureWorks.vProductAndDescriptionDataTable();
//ta.Fill(dt);
////Create an instance of Barcode Professional
//Neodynamic.WebControls.BarcodeProfessional.BarcodeProfessional bcp = new Neodynamic.WebControls.BarcodeProfessional.BarcodeProfessional();
////Barcode settings
//bcp.Symbology = Neodynamic.WebControls.BarcodeProfessional.Symbology.Code128;
//bcp.BarHeight = 0.25f;
////Update DataTable with barcode image
//foreach (AdventureWorks.vProductAndDescriptionRow row in dt.Rows)
//{
// //Set the value to encode
// bcp.Code = row.ProductID.ToString();
// //Generate the barcode image and store it into the Barcode Column
// row.Barcode = bcp.GetBarcodeImage(System.Drawing.Imaging.ImageFormat.Png);
//}
////Create ReportViewer
//Microsoft.Reporting.WebForms.ReportViewer viewer = new Microsoft.Reporting.WebForms.ReportViewer();
////Create Report Data Source
//Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("AdventureWorks_vProductAndDescription", dt);
//viewer.LocalReport.DataSources.Add(rptDataSource);
//viewer.LocalReport.ReportPath = Server.MapPath("BarcodeReport.rdlc");
////Export to PDF
//string mimeType;
//string encoding;
//string fileNameExtension;
//string[] streams;
//Microsoft.Reporting.WebForms.Warning[] warnings;
//byte[] pdfContent = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
////Return PDF
//this.Response.Clear();
//this.Response.ContentType = "application/pdf";
//this.Response.AddHeader("Content-disposition", "attachment; filename=BarcodeReport.pdf");
//this.Response.BinaryWrite(pdfContent);
//this.Response.End();
SqlLOCATIONProvider sqlLOCATIONProvider = new SqlLOCATIONProvider();
DataTable dt = new DataTable();
dt = sqlLOCATIONProvider.GetAllLOCATIONsForReport();
//GridView1.DataSource = dt;
//GridView1.DataBind();
//Create ReportViewer
Microsoft.Reporting.WebForms.ReportViewer viewer = new Microsoft.Reporting.WebForms.ReportViewer();
//Create Report Data Source
Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dt);
viewer.LocalReport.DataSources.Add(rptDataSource);
viewer.LocalReport.ReportPath = Server.MapPath("Report.rdlc");
}
