protected void Page_Load(object sender, EventArgs e)
{
#if !DEBUG
if (!DB_Access.IsCurrentUserInGroup("Administrators"))
{
Response.Redirect("../NoAccess.htm");
}
#endif
if (!IsPostBack)
{
Label lblControl = (Label)Master.FindControl("lblPageName");
if (lblControl != null)
{
lblControl.Text = "Modifier Classes Existantes!!!";
}
RemplirClasses();
RemplirProfesseur();
RemplirJourRencontre();
RemplirHeures();
// RemplirSessions() Doit être exécuté en dernier
RemplirSessions();
}
}
/// <summary>
/// GetDiskUsage
/// </summary>
/// <param name="sender">Websocket object</param>
public void GetCpuAlerts(object sender)
{
HandlerParameters parameter = (HandlerParameters)sender;
try
{
//LogMessage("StartMonitoring Method Started.", ((NativeWebSocket)parameter.Sender));
DB_Access sqldb = new DB_Access();
DataSet alerts = sqldb.getCPUAlerts(parameter.Args.RequestInfo.Parameters["from"], parameter.Args.RequestInfo.Parameters["to"]);
Hashtable cpuAlerts = new Hashtable();
cpuAlerts.Add("cpuAlerts", alerts);
Dictionary <string, Hashtable> response = new Dictionary <string, Hashtable>();
response.Add("GetCpuAlerts", cpuAlerts);
bool successMessage = false;
if (cpuAlerts.Count > 0)
{
successMessage = true;
}
Response res = parameter.Args.RequestInfo.GenerateResponse(successMessage, response);
((NativeWebSocket)parameter.Sender).SendResponse(res);
}
catch (Exception ex)
{
//LogMessage(ex.Message + " Exception in ILETSNetLib.validateQuality() " + ex.StackTrace, ((NativeWebSocket)parameter.Sender));
}
}
public static Tire GetTireById(int id)
{
Tire ruota = new Tire();
ruota = new DB_Access(connectionDB).GetSingleTire(id);
return(ruota);
}
public static List <Media> GetMedia()
{
var medias = new List <Media>();
try
{
medias = new DB_Access(connectionDB).GetTodos(); //MANCA GESTIONE ERRORI
//foreach (Media x in mediasDB)
//{
// var med = new MediaBL();
// med.id = x.id;
// med.name = x.name;
// med.timer = x.timer;
// med.format = (type)x.format;
// med.create_date = x.create_date;
// med.path = x.path;
// med.ListaID = x.listid;
// med.description = x.description;
// medias.Add(med);
//}
//return medias;
return(medias);
}
catch (Exception)
{
return(medias);
}
}
//----------------------------------------------------------------------------//
//public static List<Media> GetVideosByCategory(int id)
//{
// List<Media> listavideo = new List<Media>();
// listavideo = new DB_Access(connectionDB).GetVideosById(id);
// return listavideo;
//}
//public static Media GetVideosByName(string name)
//{
// Media media = new Media();
// media = new DB_Access(connectionDB).GetVideoByName(name);
// return media;
//}
//---------------------------------------------------------------------------//
public static Car GetCarAndTires(int id)
{
Car auto = new Car();
auto = new DB_Access(connectionDB).GetCarsAndTires(id);
return(auto);
}
//public static bool EliminaSlide(int id)
//{
// return new DB_Access(connectionDB).DeleteMedia(id);
//}
//public static bool DeleteCategory(int id)
//{
// return new DB_Access(connectionDB).DeleteCategory(id);
//}
public static List <Media> GetAllVideos()
{
List <Media> listavideo = new List <Media>();
listavideo = new DB_Access(connectionDB).GetVideos();
return(listavideo);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
DB_Access acc = new DB_Access();
DataTable dt = acc.getTable("ViewBooks");
DDLBooks.DataSource = dt;
DDLBooks.DataValueField = "BookID";
DDLBooks.DataTextField = "Tittle";
DDLBooks.DataBind();
DataTable dat = acc.getTable("ViewAuthor");
DDLAuthors.DataSource = dat;
DDLAuthors.DataValueField = "AuthorID";
DDLAuthors.DataTextField = "FirstName";
DDLAuthors.DataBind();
}
LabelSQ.Visible = false;
txtQID.Enabled = false;
LabelUQ.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
LabelSB.Visible = false;
LabelUB.Visible = false;
txtBID.Enabled = false;
DB_Access acc = new DB_Access();
DataTable dat = acc.getTable("ViewAuthor");
DDLAuthor.DataSource = dat;
DDLAuthor.DataValueField = "AuthorID";
DDLAuthor.DataTextField = "FirstName";
DDLAuthor.DataBind();
DataTable dt = acc.getTable("ViewTopic");
DDLTopic.DataSource = dt;
DDLTopic.DataValueField = "TopicID";
DDLTopic.DataTextField = "Topic";
DDLTopic.DataBind();
}
}
public ActionResult Index()
{
ExcelImporter importer = new ExcelImporter();
//importer.ImportDataFromExcel(@"C:\_Dev\Zoo Data.xlsx");
importer.ImportDataFromExcel(@"C:\Users\ng1e16\Downloads\Zoo Data.xlsx");
access = new DB_Access();
var zooData = access.GetDataset("ZooData");
//manager = new LearningManager(zooData);
return(View());
}
public static Entities GetInstance()
{
lock (mutex)
{
if (Instance == null)
{
Instance = new Entities();
if (!Instance.Database.Exists())
{
DB_Access.GetInstatce().CreateNew(); Instance = new Entities();
}
}
initDatabase();
return(Instance);
}
}
public IDB DoConfig()
{
IDB Config = null;
if (String.IsNullOrEmpty(txt_Path.Text))
{
SetError(txt_Path, "文件路径不能为空");
return(Config);
}
if (!String.IsNullOrEmpty(txt_UserID.Text))
{
if (String.IsNullOrEmpty(txt_Pwd.Text))
{
SetError(txt_Pwd, "密码不能为空");
return(Config);
}
}
DB_Access tmp = new DB_Access()
{
DataSource = txt_Path.Text,
UserID = txt_UserID.Text,
Password = txt_Pwd.Text
};
try
{
var fac = System.Data.Common.DbProviderFactories.GetFactory(tmp.ProviderName);
using (var conn = fac.CreateConnection())
{
conn.ConnectionString = tmp.GetConnectionStr();
conn.Open();
conn.Close();
Config = tmp;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(Config);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
txtTID.Enabled = false;
LabelUT.Visible = false;
DB_Access acc = new DB_Access();
DataTable dt = acc.getTable("ViewTopic");
ddlTopic.DataSource = dt;
ddlTopic.DataValueField = "TopicID";
ddlTopic.DataTextField = "Topic";
ddlTopic.DataBind();
}
}
public ExcelImporter()
{
dbAccess = new DB_Access();
}
private void execute <Object>(Object obj)
{
string st = obj as string;
switch (st)
{
case "DatabasePath":
{
TB_DatabasePath = F_File.browserFile("Database | *.FDB;");
C_Variables.DB_.file = TB_DatabasePath;
}
break;
case "Save":
{
C_Setting_DB.SaveConfigDatabase();
}
break;
case "Test":
{
if (T_Helper.IsNull())
{
DialogError.Error();
}
else
{
DialogInformation.OK();
}
}
break;
case "Shutdown":
{
if (DB_Access.GetInstatce().Shutdown())
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "Backup":
{
if (DB_Access.GetInstatce().Backup() == "")
{
DialogError.Error();
}
else
{
DialogInformation.OK();
}
}
break;
case "Restore":
{
string p = F_File.browserFile("Database | *.FBK;");
if (p == "")
{
DialogError.Error(); break;
}
if (DB_Access.GetInstatce().Restore(p))
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "CreateNew":
{
if (DB_Access.GetInstatce().CreateNew())
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "Default":
{
C_Setting_DB.set_db_Default();
TB_DatabaseDataSource = C_Variables.DB_.host;
TB_DatabasePath = C_Variables.DB_.file;
TB_DatabasePort = C_Variables.DB_.Port;
TB_DatabaseUserID = C_Variables.DB_.UserID;
TB_DatabasePassword = C_Variables.DB_.Password;
ComboBoxSelected = C_Variables.DB_.type == 0 ? "Default" : "Embedded";
}
break;
case "Embedded":
{
C_Setting_DB.set_db_Embedded();
TB_DatabaseDataSource = C_Variables.DB_.host;
TB_DatabasePath = C_Variables.DB_.file;
TB_DatabasePort = C_Variables.DB_.Port;
TB_DatabaseUserID = C_Variables.DB_.UserID;
TB_DatabasePassword = C_Variables.DB_.Password;
ComboBoxSelected = C_Variables.DB_.type == 0 ? "Default" : "Embedded";
}
break;
default: break;
}
}
