public Image GetMobileImageView(MobileView MobileVI) { //var Name = MobileDB.Brand.; var connect = Connection.SqlConnectionObject; connect.Open(); //string Query = String.Format("SELECT FROM " + //"dbo.Mobile LEFT JOIN dbo.MobileImage ON dbo.Mobile.Id = dbo.MobileImage.MobileId LEFT JOIN " + //"dbo.Image ON dbo.MobileImage.ImageId = dbo.Image.Id where dbo.Mobile.Id = {0}", MobileDB.Id); string Query = string.Format("select * from dbo.MobileImageView where Id={0};", MobileVI.Id); SqlCommand command = new SqlCommand(Query, connect); var rd = command.ExecuteReader(); Image ImageQ = new Image(); //MobileQ.ImageC = new Image(); while (rd.Read()) { ImageQ.Id = int.Parse(rd["ImageId"].ToString()); ImageQ.ImageAddress = rd["ImageAddress"].ToString(); } connect.Close(); return(ImageQ); }
public static (int Width, int Height) ReturnMobileViewDimensions(MobileView dimensions) { switch (dimensions) { case MobileView.GalaxyS5: return(360, 640); case MobileView.iPad: return(768, 1024); case MobileView.iPadMini: return(768, 1024); case MobileView.iPadPro: return(1024, 1024); case MobileView.iPhone5_SE: return(360, 640); case MobileView.iPhone6_7_8: return(375, 667); case MobileView.iPhoneX: return(375, 812); case MobileView.Nexus5X: return(412, 732); case MobileView.Nexus6P: return(412, 732); case MobileView.Pixel2: return(411, 731); case MobileView.Pixel2XL: return(411, 823); case MobileView.iPhone6_7_8Plus: return(414, 736); default: throw new Exception($"Dimension '{dimensions}' is not mapped"); } }
private void TablePanelOnClick(object sender, EventArgs args) { MobileView mobileView = MobileView.GetInstance(); PictureBox pictureBox = (PictureBox)sender; Table table = (Table)pictureBox.Tag; mobileView.LoadView(new TableControlsView(table), "Tafel " + table.Number); }
public Network GetMobileNetworkView(MobileView MobileVI) { //var Name = MobileDB.Brand.; var connect = Connection.SqlConnectionObject; connect.Open(); string Query = String.Format("SELECT dbo.Mobile.Id as Id , dbo.NetworkMobile.Network_Id as NetworkId, dbo.Network.NetworkType as NetworkType" + " FROM dbo.Mobile left JOIN dbo.NetworkMobile ON dbo.Mobile.Id = dbo.NetworkMobile.Mobile_Id left JOIN dbo.Network ON dbo.NetworkMobile.Network_Id = dbo.Network.Id " + " where dbo.Mobile.Id ={0} ;", MobileVI.Id); //string Query = String.Format(" SELECT dbo.MobileReportView.MobileId as Id , dbo.NetworkMobile.Network_Id as NewtorkId, dbo.Network.NetworkType as NetworkType " + // " FROM dbo.MobileReportView Left JOIN dbo.NetworkMobile ON dbo.MobileReportView.MobileId = dbo.NetworkMobile.Id Left JOIN dbo.Network ON dbo.NetworkMobile.Network_Id = dbo.Network.Id " + // "where dbo.MobileReportView.MobileId = {0}", MobileVI.Id ); SqlCommand command = new SqlCommand(Query, connect); var rd = command.ExecuteReader(); //List<Network> Networklist = new List<Network>(); Network NetworkMod = new Network(); NetworkMod.Networks = new NetworkEnum?[3]; while (rd.Read()) { int s = 0; if (int.TryParse(rd["NetworkId"].ToString(), out s)) { NetworkMod.Id = int.Parse(rd["NetworkId"].ToString()); } if (rd["NetworkType"].ToString() != null) { string X = rd["NetworkType"].ToString(); if (X == "G2") { NetworkMod.Networks[0] = GetNetworkEnum(rd["NetworkType"].ToString()); } else if (X == "G3") { NetworkMod.Networks[1] = GetNetworkEnum(rd["NetworkType"].ToString()); } else if (X == "G4") { NetworkMod.Networks[2] = GetNetworkEnum(rd["NetworkType"].ToString()); } } } connect.Close(); return(NetworkMod); }
public List <MobileView> GetMobileListView(int UserId) { var connect = Connection.SqlConnectionObject; connect.Open(); string Query = "select * from dbo.[MobileReportView] where UserId = @val1;"; SqlCommand command = new SqlCommand(Query, connect); command.Parameters.AddWithValue("@val1", UserId); var rd = command.ExecuteReader(); SqlQueryBrand SQBRand = new SqlQueryBrand(); List <MobileView> MobileLi = new List <MobileView>(); while (rd.Read()) { MobileView MobileModel = new MobileView(); MobileModel.Id = int.Parse(rd["MobileId"].ToString()); MobileModel.Name = rd["Name"].ToString(); MobileModel.BrandN = SQBRand.GetBrandEnum(rd["Brand"].ToString()); MobileModel.ProductionDate = Convert.ToDateTime(rd["ProductionDate"].ToString()); MobileModel.Weight = Convert.ToInt32(rd["Weight"].ToString()); MobileModel.Otg = Convert.ToBoolean(rd["Otg"].ToString()); MobileModel.UserId = int.Parse(rd["UserId"].ToString()); MobileModel.UserName = rd["UserName"].ToString(); //MobileModel.Image = rd["ImageAddress"].ToString(); SqlQueryNetworkMobile SQNetworkView = new SqlQueryNetworkMobile(); var Network = SQNetworkView.GetMobileNetworkView(MobileModel); MobileModel.Networks = Network.Networks; SqlQueryMobileImage SQImageView = new SqlQueryMobileImage(); var Image = SQImageView.GetMobileImageView(MobileModel); MobileModel.Image = Image.ImageAddress; MobileLi.Add(MobileModel); } return(MobileLi); }
public void AddRowItem(MobileView item) { dataGridView1.Rows.Add(item.Name, item.BrandN, item.ProductionDate, item.Weight, item.Otg, string.Format(" {0} {1} {2} ", item.Networks[0], item.Networks[1], item.Networks[2]), item.Image, item.UserName); }
public void WhenUserInputSpecificDimensionsFor(MobileView dimensions) { var(Width, Height) = CommonUtils.ReturnMobileViewDimensions(dimensions); Driver.Manage().Window.Size = new Size(Width, Height); }
public static string GetPageView(string templateSuffix, string themeName, string pageTitle, string headerTitle, string helpUrl, string afterAction) { #region Variables bool enableMobileAddress = false; int dataIndex = 0; #endregion #region Get JQ Js/Css Resources string cssResourcesLink = ""; string jsResourcesLink = ""; string currentThemeName = MobileTheme.Default.ToString(); if (string.IsNullOrEmpty(themeName) == false) { currentThemeName = themeName; } MobileView.GetMobileHeaderResource(enableMobileAddress, currentThemeName, out cssResourcesLink, out jsResourcesLink); #endregion #region Set Mobile Page Header Html string htmlMobilePageHeader = ""; //"<h2>InfoList Manager</h2>"; #endregion #region Get Mobile Page Security Html string htmlMobilePageSecure = ""; htmlMobilePageSecure = SecurityView.GetView(dataIndex, templateSuffix, headerTitle, helpUrl, afterAction, ""); #endregion #region Get Mobile Page Content Html string htmlMobilePageContent = ""; if ((UtilsGeneric.ForceLogin == false) || (UtilsSecurity.IsAuthenticated() == true)) { if (UtilsSecurity.HaveAdminRole() == true) { string infoCategoryView = InfoCategoryView.GetView(dataIndex, templateSuffix); htmlMobilePageContent += infoCategoryView; } string pageView = InfoPageView.GetView(dataIndex + 1, templateSuffix); htmlMobilePageContent += pageView; } #endregion #region Get Mobile Page Html string htmlMobilePage = MobileView.GetView(templateSuffix, htmlMobilePageHeader, htmlMobilePageSecure, htmlMobilePageContent, ""); #endregion #region Get IndexPage Header Html string htmlPageHeader = ""; #endregion #region Get IndexPage Content Html string htmlPageContent = htmlMobilePage; #endregion #region Get IndexPage Footer Html string htmlPageFooter = ""; #endregion #region Get IndexPage Html string htmlText = GenericView.GetView(templateSuffix, pageTitle, cssResourcesLink, jsResourcesLink, htmlPageHeader, htmlPageContent, htmlPageFooter, enableMobileAddress, true); #endregion return(htmlText); }