الكود بعرض الزمن لعدة مدن المشكلة ان شغال علي System date وانا عاوز اشتغل علي GMT
ارجو المساعدة
مشكورين
nsaspxcs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Globalization;
using System.Runtime.InteropServices;
using Microsoft.Win32;
using System.Threading;
using System.Drawing;
public partial class ns : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
{
DateTime dt1 = DateTime.Now;
if (
dt1 >= new DateTime(dt1.Year, dt1.Month, dt1.Day, 22, 0, 0) ||
dt1 <= new DateTime(dt1.Year, dt1.Month, dt1.Day, 7, 0, 0))
{
TextBox18.Text = "Open";
TextBox18.ForeColor = System.Drawing.Color.Green;
TextBox18.BackColor = System.Drawing.Color.White;
}
else
{
TextBox18.Text = "Closed";
TextBox18.ForeColor = System.Drawing.Color.Red;
TextBox18.BackColor = System.Drawing.Color.Black;
}
DateTime dt2 = DateTime.Now;
if (dt2 <= new DateTime(dt2.Year, dt1.Month, dt2.Day, 19, 0, 0) || dt2 >= new DateTime(dt2.Year, dt2.Month, dt2.Day, 3, 0, 0))
{
TextBox19.Text = "Closed";
TextBox19.ForeColor = System.Drawing.Color.Red;
TextBox19.BackColor = System.Drawing.Color.Black;
}
else
{
TextBox19.Text = "Open";
TextBox19.ForeColor = System.Drawing.Color.Green;
TextBox19.BackColor = System.Drawing.Color.White;
}
DateTime dt3 = DateTime.Now;
if (dt3 <= new DateTime(dt3.Year, dt3.Month, dt3.Day, 3, 0, 0) || dt3 >= new DateTime(dt3.Year, dt3.Month, dt3.Day, 11, 0, 0))
{
TextBox20.Text = "Closed";
TextBox20.ForeColor = System.Drawing.Color.Red;
TextBox20.BackColor = System.Drawing.Color.Black;
}
else
{
TextBox20.Text = "Open";
TextBox20.ForeColor = System.Drawing.Color.Green;
TextBox20.BackColor = System.Drawing.Color.White;
}
DateTime dt4 = DateTime.Now;
if (dt4 <= new DateTime(dt4.Year, dt4.Month, dt4.Day, 2, 0, 0) || dt4 >= new DateTime(dt4.Year, dt4.Month, dt4.Day, 10, 0, 0))
{
TextBox21.Text = "Closed";
TextBox21.ForeColor = System.Drawing.Color.Red;
TextBox21.BackColor = System.Drawing.Color.Black;
}
else
{
TextBox21.Text = "Open";
TextBox21.ForeColor = System.Drawing.Color.Green;
TextBox21.BackColor = System.Drawing.Color.White;
}
DateTime dt5 = DateTime.Now;
if (dt5 <= new DateTime(dt5.Year, dt5.Month, dt5.Day, 8, 0, 0) || dt5 >= new DateTime(dt5.Year, dt5.Month, dt5.Day, 17, 0, 0))
{
TextBox22.Text = "Closed";
TextBox22.ForeColor = System.Drawing.Color.Red;
TextBox22.BackColor = System.Drawing.Color.Black;
}
else
{
TextBox22.Text = "Open";
TextBox22.ForeColor = System.Drawing.Color.Green;
TextBox22.BackColor = System.Drawing.Color.White;
}
}
{
TextBox17.Text = DateTime.Now.ToString(" dd MMMM yyyy");
}
{
TextBox2.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "AUS Eastern Standard Time").ToString("hh:mm:ss tt "));
}
{
TextBox3.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "AUS Eastern Standard Time").ToString("dd MMMM yyyy"));
}
{
TextBox4.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "Tokyo Standard Time").ToString("hh:mm tt"));
}
{
TextBox5.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "Tokyo Standard Time").ToString("dd MMMM yyyy"));
}
{
TextBox6.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "GMT Standard Time").ToString("hh:mm tt"));
}
{
TextBox7.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "GMT Standard Time").ToString("dd MMMM yyyy"));
}
{
TextBox8.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "W. Europe Standard Time").ToString("hh:mm tt"));
}
{
TextBox9.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "W. Europe Standard Time").ToString("dd MMMM yyyy"));
}
{
TextBox10.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "Eastern Standard Time").ToString("hh:mm tt"));
}
{
TextBox11.Text = (TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.Now, "Eastern Standard Time").ToString("dd MMMM yyyy"));
}
System.Data.DataView dv = (System.Data.DataView)AccessDataSource19.Select(DataSourceSelectArguments.Empty);
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("fldCurr", typeof(string));
dt.Columns.Add("Impact", typeof(string));
dt.Columns.Add("Previous", typeof(string));
dt.Columns.Add("Forecast", typeof(string));
dt.Columns.Add("Actual", typeof(string));
dt.Columns.Add("fldSellBuy", typeof(string));
dt.Columns.Add("fldABC", typeof(string));
dt.Columns.Add("fldABCColor", typeof(string));
dt.Columns.Add("fldWave", typeof(string));
dt.Columns.Add("fldWaveColor", typeof(string));
dt.Columns.Add("fldShow", typeof(string));
dt.Columns.Add("fldInput1", typeof(string));
dt.Columns.Add("fldInput2", typeof(string));
dt.Columns.Add("fldInput3", typeof(string));
dt.Columns.Add("fldDateTime", typeof(string));
System.Data.DataRow drt = null;
foreach (DataRow dr in dv.Table.Rows)
{
drt = dt.NewRow();
drt["fldCurr"] = dr["fldCurr"].ToString();
if (dr["Impact"].ToString() == "STRONG/قوي")
{
drt["Impact"] = Server.HtmlDecode("<font color='red'>" + dr["Impact"].ToString() + "</font>");
}
else
{
drt["Impact"] = Server.HtmlDecode("<font color='green'>" + dr["Impact"].ToString() + "</font>");
}
if (dr["Previous"].ToString() == "BAD /سيئ")
{
drt["Previous"] = Server.HtmlDecode("<font color='red'>" + dr["Previous"].ToString() + "</font>");
}
else
{
drt["Previous"] = Server.HtmlDecode("<font color='blue'>" + dr["Previous"].ToString() + "</font>");
}
if (dr["Forecast"].ToString() == "BAD /سيئ")
{
drt["Forecast"] = Server.HtmlDecode("<font color='red'>" + dr["Forecast"].ToString() + "</font>");
}
else
{
drt["Forecast"] = Server.HtmlDecode("<font color='blue'>" + dr["Forecast"].ToString() + "</font>");
}
if (dr["Actual"].ToString() == "BAD /سيئ")
{
drt["Actual"] = Server.HtmlDecode("<font color='red'>" + dr["Actual"].ToString() + "</font>");
}
else
{
drt["Actual"] = Server.HtmlDecode("<font color='blue'>" + dr["Actual"].ToString() + "</font>");
}
if (dr["fldSellBuy"].ToString() == "SELL/ بيع")
{
drt["fldSellBuy"] = Server.HtmlDecode("<font color='red'>" + dr["fldSellBuy"].ToString() + "</font>");
}
else
{
drt["fldSellBuy"] = Server.HtmlDecode("<font color='blue'>" + dr["fldSellBuy"].ToString() + "</font>");
}
drt["fldABC"] = Server.HtmlDecode("<font color='" + dr["fldABCColor"].ToString() + "'>" + dr["fldABC"].ToString() + "</font>");
drt["fldWave"] = Server.HtmlDecode("<font color='" + dr["fldWaveColor"].ToString() + "'>" + dr["fldWave"].ToString() + "</font>");
drt["fldInput1"] = dr["fldInput1"].ToString();
drt["fldInput2"] = dr["fldInput2"].ToString();
drt["fldInput3"] = dr["fldInput3"].ToString();
dt.Rows.Add(drt);
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox2_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox3_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox4_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox5_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox6_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox7_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox8_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox9_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox10_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox11_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox12_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox13_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox14_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox15_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox16_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox17_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox18_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox19_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox20_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox21_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox22_TextChanged(object sender, EventArgs e)
{
}
}
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
nsaspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ns.aspx.cs" Inherits="ns" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<script type="text/javascript">
function ShowTime() {
var dt = new Date();
document.getElementById("<%= TextBox1.ClientID %>").value = dt.toLocaleTimeString();
window.setTimeout("ShowTime()", 1000);
}
</script>
<script type="text/javascript">
// a startup script to put everything in motion
window.setTimeout("ShowTime()", 1000);
</script>
<title>Untitled Page</title>
<meta http-equiv="refresh" content="300"/>
<style type="text/css">
.style1
{
width: 100%;
height: 140px;
}
#form1
{
height: 800px;
}
</style>
</head>
<body bgcolor="#990033">
<form id="form1" runat="server">
<div align="center"
style="border: medium groove #990033; width: 783px; height: 711px;">
<asp:Label ID="Label1" runat="server" BorderColor="#990033"
BorderStyle="Groove" Font-Size="Larger" ForeColor="#99FF66"
Text=" تحت إشراف/ عمرو عابد"></asp:Label>
<br />
<asp:Label ID="Label2" runat="server" BorderColor="#990033"
BorderStyle="Groove" Font-Size="Larger" ForeColor="#99FF66"
Text="Supervised By/ Amr Abed"></asp:Label>
<br />
<table class="style1" align="center" style="border: thick groove #990033">
<tr align="center">
<td align="center" style="text-align: center">
<asp:TextBox ID="TextBox18" runat="server" Height="22px"
ontextchanged="TextBox18_TextChanged" ReadOnly="True" Width="128px"
style="text-align: center" Font-Size="Medium"
BorderStyle="Groove" ForeColor="White" ></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox19" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox19_TextChanged"
BorderStyle="Groove" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox20" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox20_TextChanged"
BorderStyle="Groove" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox21" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox21_TextChanged"
BorderStyle="Groove" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox22" runat="server" Height="22px"
ontextchanged="TextBox22_TextChanged" ReadOnly="True" Width="128px"
style="text-align: center" Font-Size="Medium"
BorderStyle="Groove" ForeColor="White"></asp:TextBox>
</td>
</tr>
<tr align="center">
<td align="center" style="text-align: center">
<asp:TextBox ID="TextBox12" runat="server" Height="22px"
ontextchanged="TextBox12_TextChanged" ReadOnly="True" Width="128px"
style="text-align: center" Font-Size="Medium" BorderColor="#990033"
BorderStyle="Groove" BackColor="#990033" ForeColor="White" >Australia/أستراليا</asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox13" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox13_TextChanged" BorderColor="#990033"
BorderStyle="Groove" BackColor="#990033" ForeColor="White">Asia /آسيا</asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox14" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox14_TextChanged" BorderColor="#990033"
BorderStyle="Groove" BackColor="#990033" ForeColor="White">Greenwich/غرينتش</asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox15" runat="server" Height="22px" ReadOnly="True"
Width="128px" style="text-align: center" Font-Size="Medium"
ontextchanged="TextBox15_TextChanged" BorderColor="#990033"
BorderStyle="Groove" BackColor="#990033" ForeColor="White">Europe/أوروبا</asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox16" runat="server" Height="22px"
ontextchanged="TextBox16_TextChanged" ReadOnly="True" Width="128px"
style="text-align: center" Font-Size="Medium" BorderColor="#990033"
BorderStyle="Groove" BackColor="#990033" ForeColor="White">America/أمريكا</asp:TextBox>
</td>
</tr>
<tr align="center">
<td align="center" style="text-align: center">
<asp:TextBox ID="TextBox2" runat="server" ontextchanged="TextBox2_TextChanged"
ReadOnly="True" Height="22px" Width="100px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox4" runat="server" ontextchanged="TextBox4_TextChanged"
ReadOnly="True" Height="22px" Width="100px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox6" runat="server" ontextchanged="TextBox6_TextChanged"
ReadOnly="True" Height="22px" Width="100px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox8" runat="server" ontextchanged="TextBox8_TextChanged"
ReadOnly="True" Height="22px" Width="100px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox10" runat="server" ontextchanged="TextBox10_TextChanged"
ReadOnly="True" Height="22px" Width="100px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:TextBox ID="TextBox3" runat="server" ontextchanged="TextBox3_TextChanged"
ReadOnly="True" Height="22px" Width="112px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox5" runat="server" ontextchanged="TextBox5_TextChanged"
ReadOnly="True" Height="22px" Width="112px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox7" runat="server" ontextchanged="TextBox7_TextChanged"
ReadOnly="True" Height="22px" Width="112px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox9" runat="server" ontextchanged="TextBox9_TextChanged"
ReadOnly="True" Height="22px" Width="112px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox11" runat="server" ontextchanged="TextBox11_TextChanged"
ReadOnly="True" Height="22px" Width="112px" style="text-align: center"
Font-Size="Small" BorderColor="#990033" BorderStyle="Groove"
BackColor="#990033" ForeColor="White"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="5" align="center"
style="border: thick groove #990033; font-size: large; color: #FFFFFF">
<asp:TextBox ID="TextBox1" runat="server" BackColor="#FFFF99" ontextchanged="TextBox1_TextChanged"
ReadOnly="True" Height="20px" Width="183px" style="text-align: center"
Font-Size="Medium" BorderStyle="Groove"></asp:TextBox>
<br />
<asp:TextBox ID="TextBox17" runat="server" BackColor="#FFFF99" ontextchanged="TextBox1_TextChanged"
ReadOnly="True" Height="21px" Width="183px" style="text-align: center"
Font-Size="Medium" BorderStyle="Groove"></asp:TextBox>
<br />
Your local time/وقت بلدك </td>
</tr>
</table>
<tr>
<td width="480" style="border: 1px solid #999999;">
<iframe frameborder="0"
name="wind" scrolling="no"
src="http://www.forexsignallive.com/market_times_8/market_hours.html"
style="border: thick groove #990033; width: 492px; margin-left: 0px; height: 197px;"></iframe></td>
</tr>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellPadding="4" ForeColor="Black" Width="776px"
CellSpacing="2" BackColor="#CCCCCC" BorderColor="#999999"
BorderStyle="Solid" BorderWidth="3px" Height="176px">
<RowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="fldCurr" HeaderText="CURRENCY العمله"
SortExpression="fldCurr" />
<asp:BoundField DataField="fldInput1" HeaderText="EVENT الخبر"
SortExpression="fldInput1" >
<ItemStyle Width="300px" />
</asp:BoundField>
<asp:BoundField DataField="fldInput2" HeaderText="TIME الوقت"
SortExpression="fldInput2" />
<asp:BoundField DataField="fldInput3" HeaderText="DATE التاريخ"
SortExpression="fldInput3" />
<asp:BoundField DataField="Impact" HeaderText="Impact التأثير"
HtmlEncode="False" />
<asp:BoundField DataField="Previous" HeaderText="Forecast التوقع"
HtmlEncode="False" />
<asp:BoundField DataField="Actual" HeaderText="Actual الفعلي"
HtmlEncode="False" />
<asp:BoundField DataField="fldSellBuy" HeaderText="Technically فنياً"
HtmlEncode="False" />
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:GridView>
</div>
<asp:AccessDataSource ID="AccessDataSource19" runat="server"
DataFile="~/App_Data/Database19.mdb"
SelectCommand="SELECT [fldCurr], [Impact], [Previous], [Forecast], [Actual], [fldSellBuy], [fldABC], [fldABCColor], [fldWave], [fldWaveColor], [fldInput1], [fldInput2], [fldInput3], [fldShow], [fldDateTime] FROM [tblCurr] WHERE (((tblCurr.fldShow)=Yes));">
</asp:AccessDataSource>
</form>
</body>
</html>ال