private void ListView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
var item = e.SelectedItem as PagMenuMenuItem;
if (item.Id == 3)
{
ConfigDAO.DeleteConfig();
Session.Navigation = new NavigationPage(new Views.Login()
{
Title = "Indique Aí",
BackgroundColor = Color.White,
});
Application.Current.MainPage = Session.Navigation;
return;
}
if (item == null)
{
return;
}
var page = (Page)Activator.CreateInstance(item.TargetType);
page.Title = item.Title;
Session.Navigation = new NavigationPage(page);
Detail = Session.Navigation;
//MasterPage.ListView.SelectedItem = null;
IsPresented = false;
}
public ActionResult Copiar()
{
Sessao.ExisteSessao();
if (ModelState.IsValid)
{
string item = Request.Form["item"];
string destino = string.Empty;
string[] a_item = item.Split(',');
ConfigDAO readXML = new ConfigDAO();
var data = readXML.ListConfig();
foreach (var z in data)
{
foreach (var j in a_item)
{
destino = j.Replace(z.origem, z.destino);
CopiarDAO fls = new CopiarDAO();
fls.Copiar(j, destino);
}
}
return(RedirectToAction("Index"));
}
return(View());
}
private void btnSimilaire_Click(object sender, EventArgs e)
{
try {
List <Config> configs = new ConfigDAO(connection).SelectSimilaire(this.GetIntervals());
if (configs.Count() > 0)
{
axesSimilsaires = new List <Axe>();
foreach (Config cfg in configs)
{
cfg.Axe.CurrValue = cfg.Valeur;
axesSimilsaires.Add(cfg.Axe);
}
showSimilaire = true; this.Refresh();
ResultSimilar rs = new ResultSimilar(connection, configs);
rs.Show();
}
else
{
throw new Exception("Il n'existe aucune graphe qui ressemble a celle-ci !");
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1 && e.RowIndex + 1 != tabPatients.Rows.Count)
{
String nom = tabPatients.SelectedCells[0].Value.ToString();
Patient pt = new PatientDAO(connection).Select("WHERE nom = '" + nom + "'").First();
List <Config> configs = new ConfigDAO(connection).Select("WHERE patient = '" + pt.Id + "'");
this.DrawCmp(configs);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try {
Patient patient = new Patient("", DateTime.Now, this.GetNom(), this.GetGender(), this.GetAge());
PatientDAO ptdao = new PatientDAO(connection);
ptdao.Insert(patient);
List <Config> cfs = this.GetConfigs(patient);
ConfigDAO cfdao = new ConfigDAO(connection);
cfdao.InsertAll(cfs);
this.AddRowTabPatients(patient);
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public ActionResult Config()
{
Sessao.ExisteSessao();
ConfigDAO readXML = new ConfigDAO();
var data = readXML.ListConfig();
string txt_origem = string.Empty;
foreach (var item in data)
{
txt_origem = item.origem;
}
return(View(data.ToList()));
}
private async void BtnEntrar_OnClicked(object sender, EventArgs e)
{
var login = new LoginVM()
{
Email = TxtEmail.Text,
Senha = TxtSenha.Text
};
Scroll.IsEnabled = false;
Act.IsVisible = true;
try
{
var result = await ParceiroWS.Login(login);
if (result.Success)
{
//TODO: Adicionar login
Xamarin.Forms.Device.BeginInvokeOnMainThread(() =>
{
ConfigDAO.InsertConfig(new Config()
{
CodParceiro = result.Content.CodParceiro
});
ParceiroDAO.InsertConfig(result.Content);
Session.Master = new PagMenu();
Application.Current.MainPage = Session.Master;
//Util.Navigation.AddToNavigation(Navigation, new Menu());
//Navigation.RemovePage(this);
});
}
else
{
DisplayAlert("Erro", "E-mail ou senha inválido", "OK");
}
}
catch (Exception exception)
{
Util.Error.FilterException(this, exception);
}
finally
{
Scroll.IsEnabled = true;
Act.IsVisible = false;
}
}
public ActionResult DiretorioOrigem()
{
Sessao.ExisteSessao();
ConfigDAO readXML = new ConfigDAO();
var data = readXML.ListConfig();
string txt_origem = string.Empty;
foreach (var item in data)
{
txt_origem = item.origem;
}
string[] diretorios = Directory.GetDirectories(txt_origem);
List <Diretorio> listaDiretorio = new List <Diretorio>();
foreach (string dir in diretorios)
{
Diretorio diretorio = new Diretorio();
diretorio.pasta = dir.ToString();
diretorio.pasta_nome = dir.Replace(txt_origem, "").ToString();
listaDiretorio.Add(diretorio);
}
DirectoryInfo Dir = new DirectoryInfo(txt_origem);
FileInfo[] Files = Dir.GetFiles("*");
foreach (FileInfo File in Files)
{
Diretorio diretorio2 = new Diretorio();
diretorio2.arquivo = File.FullName;
diretorio2.arquivo_nome = File.FullName.Replace(txt_origem, "").ToString();
listaDiretorio.Add(diretorio2);
}
return(View(listaDiretorio.ToList()));
}
public App()
{
try
{
if (ConfigDAO.Get() != null)
{
Session.Master = new PagMenu();
MainPage = Session.Master;
}
else
{
Session.Navigation = new NavigationPage(new Views.Login()
{
Title = "Indique Aí",
BackgroundColor = Color.White,
});
MainPage = Session.Navigation;
}
}
catch (Exception e)
{
throw e;
}
}
public ConfigBO()
{
acessoDados = new ConfigDAO();
}
public static void SaveConfig(ConfigDTO cfgDto)
{
ConfigDAO.SaveConfig(cfgDto);
}
public static ConfigDTO GetConfig()
{
return(ConfigDAO.GetConfig());
}
/// <summary>
/// Hàm sửa cấu hình quyền SQL Server
/// </summary>
/// <param name="config"></param>
public static void SQLSeverAuthentication(Config config)
{
ConfigDAO.ChangeConnectionString(string.Format(ConnectionStrSQLServer, config.ServerName, config.DatabaseName, config.UserName, config.Password));
}
private void BtnSair_OnClicked(object sender, EventArgs e)
{
ConfigDAO.DeleteConfig();
Application.Current.MainPage = new Login();
}
public Config GetAllConfig(string language)
{
ConfigDAO configDAO = new ConfigDAO();
return(configDAO.GetAllConfig(language));
}
private void btnKetNoi_Click(object sender, EventArgs e)
{
if (cmbDatabase.SelectedValue == null)
{
MessageBox.Show("Vui lòng chọn một CSDL");
return;
}
string connectionString = null;
if (cmbAuthentication.SelectedIndex == 0)
{
connectionString = @"Data Source=" + name + ";Initial Catalog=" + cmbDatabase.SelectedValue.ToString() + ";Integrated Security=True";
}
else
{
connectionString = @"Data Source=" + name + ";Initial Catalog=" + cmbDatabase.SelectedValue.ToString() + ";User ID=" + txtUserName.Text.Trim() + ";password="******"KIEMTRA_TABLE", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader ren = cmd.ExecuteReader();
bool flag = false;
while (ren.Read())
{
string ca = ren[0].ToString();
if (ren[0].ToString().Equals("True"))
{
flag = true;
}
break;
}
connection.Close();
if (flag)
{
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
connectionStringsSection.ConnectionStrings["QL_DocGiaThuVien.Properties.Settings.QL_ThuVienConnectionString"].ConnectionString = connectionString;
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("QL_DocGiaThuVien.Properties.Settings.QL_ThuVienConnectionString");
ConfigDAO.setConfig(connectionString);
string c = Properties.Settings.Default.QL_ThuVienConnectionString;
MessageBox.Show("Kết nối CSDL thành công !");
frm_CauHinh frm_dangnhap = new frm_CauHinh();
frm_dangnhap.Hide();
}
else
{
MessageBox.Show("Ket noi CSDL that bai!\n Chon lai DataBase nhe!");
}
}
catch (Exception ex)
{
connection.Close();
//MessageBox.Show(ex.Message);
MessageBox.Show("Chon sai DataBase! Hay chon CSDL phu hop voi phan mem!!!");
return;
}
}
public void UpdateConfig(Config config)
{
ConfigDAO configDAO = new ConfigDAO();
configDAO.UpdateConfig(config);
}
/// <summary>
/// Hàm sửa cấu hình quyền Windows
/// </summary>
/// <param name="config"></param>
public static void WindowsAuthentication(Config config)
{
ConfigDAO.ChangeConnectionString(string.Format(ConnectionStrWindows, config.ServerName, config.DatabaseName));
}
