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