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