private void LoadCalendar()
{
yearCalendar.RemoveAllBoldedDates();
using (var dates = new StaticRS($"Select DIA from general..calendario_laboral where year(DIA)='{cboYear.Text}' and COD3='{cboCOD3.Text}'", conn))
{
dates.Open();
dates.ToList().ForEach(r =>
{
DateTime elDia = (DateTime)r["DIA"];
yearCalendar.AddBoldedDate(elDia);
});
};
}
public static void FillServers(string pCOD3)
{
using (var _RS = new StaticRS("select COD3,ServerDB,ServerShare,zone,UserShare,PasswordShare,servershareip,ServerDBIP from general..sedes", Values.gDatos))
{
_RS.Open();
_RS.ToList().ForEach(r =>
{
Values.DBServerList.Add(new cServer()
{
Resolve = false,
HostName = r[pCOD3 == "OUT" ? "ServerDBIP" : "ServerDB"].ToString(),
IP = IPAddress.Parse(r["ServerDBIP"].ToString()), COD3 = r["COD3"].ToString(),
Type = ServerTypes.DATABASE,
User = Values.User,
Password = Values.Password
});
Values.ShareServerList.Add(new cServer()
{
Resolve = false,
HostName = r[pCOD3 == "OUT" ? "ServerShareIP" : "ServerShare"].ToString(),
IP = IPAddress.Parse(r["ServerShareIP"].ToString()),
COD3 = r["COD3"].ToString(),
Type = ServerTypes.DATABASE,
User = r["UserShare"].ToString(),
Password = r["PasswordShare"].ToString()
});
if (r["COD3"].ToString() == pCOD3)
{
Values.COD3 = r["COD3"].ToString();
Values.DBServerList.Add(new cServer()
{
HostName = r["ServerDB"].ToString(), COD3 = "LOC", Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password
});
Values.DBServerList.Add(new cServer()
{
HostName = "DB01.local", COD3 = "OUT", Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password
});
Values.DBServerList.Add(new cServer()
{
HostName = "MASTERDB.local", COD3 = "GLO", Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password
});
}
});
/*
* while (!_RS.EOF)
* {
* Values.DBServerList.Add(new cServer() { Resolve=false, HostName = _RS[pCOD3 == "OUT" ? "ServerDBIP" : "ServerDB"].ToString(),IP = IPAddress.Parse(_RS["ServerDBIP"].ToString()), COD3 = _RS["COD3"].ToString(), Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password });
* Values.ShareServerList.Add(new cServer()
* {
* Resolve=false,
* HostName = _RS[pCOD3 == "OUT"? "ServerShareIP":"ServerShare"].ToString(),
* IP = IPAddress.Parse(_RS["ServerShareIP"].ToString()),
* COD3 = _RS["COD3"].ToString(),
* Type = ServerTypes.DATABASE,
* User = _RS["UserShare"].ToString(),
* Password = _RS["PasswordShare"].ToString()
* });
* if (_RS["COD3"].ToString() == pCOD3)
* {
* Values.COD3 = _RS["COD3"].ToString();
* Values.DBServerList.Add(new cServer() { HostName = _RS["ServerDB"].ToString(), COD3 = "LOC", Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password });
* Values.DBServerList.Add(new cServer() { HostName = "DB01.local", COD3 = "OUT", Type = ServerTypes.DATABASE, User = Values.User, Password = Values.Password });
* }
* _RS.MoveNext();
* }*/
}
}
