protected void BT_Guardar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_ruta _Ruta = new E_ruta(); _Ruta.Ruta = TB_Ruta.Text; E_ruta _ruta = new DAO_Admin().getRuta(TB_Ruta.Text); try { if (_ruta.Ruta == TB_Ruta.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('La ruta ya existe');</script>"); return; } } catch (NullReferenceException) { } new DAO_Admin().addRuta(_Ruta); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('La ruta ha sido registrada');</script>"); TB_Ruta.Text = String.Empty; }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString.Count > 0) { E_user e_user = new DAO_Admin().getTokenUser(Request.QueryString[0] == null ? "" : Request.QueryString[0]); if (e_user == null) { this.RegisterStartupScript("mensaje", "<script type='text/javascript'>alert('El Token es invalido. Genere uno nuevo');window.location=\"PrimerFormulario.aspx\"</script>"); } else if (e_user.EndToken < DateTime.Now) { this.RegisterStartupScript("mensaje", "<script type='text/javascript'>alert('El Token esta vencido. Genere uno nuevo');window.location=\"PrimerFormulario.aspx\"</script>"); } else { Session["user_id"] = e_user; } } else { Response.Redirect("~/View/Login.aspx"); } }
public ActionResult Login(doan_htttdn.FF.Admin_Article objUser) { if (ModelState.IsValid) // kiem tra rong { var dao = new DAO_Admin(); var obj = dao.Login(objUser.IDAdmin.ToString(), Encryptor.MD5Hash(objUser.Pass).ToString()); if (obj == 1) { var userSession = new UserLogin(); userSession.IDuser = objUser.IDAdmin; Session.Add(CommonConstant.USER_SESSION, userSession.IDuser); return(RedirectToAction("Index", "Rigistration")); } else if (obj == 0) { ModelState.AddModelError("", "Tài Khoản Không Tồn Tại"); } else if (obj == -1) { ModelState.AddModelError("", "Tài Khoản Đang bị Khóa"); } else if (obj == -2) { ModelState.AddModelError("", "Mật Khẩu Không Đúng"); } else { ModelState.AddModelError("", "Đăng Nhập Không Đúng"); } } return(View("Index")); }
protected infoMedicos obtenerInforme() { DataRow fila; DataTable informacionMedico = new DataTable(); infoMedicos medico = new infoMedicos(); informacionMedico = medico.Tables["medicos"]; DAO_Admin admin = new DAO_Admin(); DataTable intermedio = admin.obtenermedicos(); for (int i = 0; i < intermedio.Rows.Count; i++) { fila = informacionMedico.NewRow(); fila["apellidos"] = intermedio.Rows[i]["apellidos"].ToString(); fila["nombres"] = intermedio.Rows[i]["nombres"].ToString(); fila["identificacion"] = Int64.Parse(intermedio.Rows[i]["identificacion"].ToString()); fila["email"] = intermedio.Rows[i]["email"].ToString(); fila["especialidad"] = intermedio.Rows[i]["especialidad"].ToString(); fila["foto"] = obtenerImagen(intermedio.Rows[i]["url"].ToString()); informacionMedico.Rows.Add(fila); } return(medico); }
public static void PrevPage_teacher(DataGridView gridView, ConnectionStringSettings conStrSettings, System.Windows.Forms.Label lbPage_teacher, string Information, RadioButton radioButton_TchName, RadioButton radioButton_TchGrade) { if (Page > 1) { DAO_Admin.PrevPage_teacher(gridView, conStrSettings, lbPage_teacher, ref n, ref Page, ref Count, ref NOP, Information, radioButton_TchName, radioButton_TchGrade); } }
public static void PrevPage_student(DataGridView gridView, ConnectionStringSettings conStrSettings, System.Windows.Forms.Label lbPage_student, string Information, RadioButton radioButton_StdName, RadioButton radioButton_StdClass) { if (Page > 1) { DAO_Admin.PrevPage_student(gridView, conStrSettings, lbPage_student, ref n, ref Page, ref Count, ref NOP, Information, radioButton_StdName, radioButton_StdClass); } }
public static void ImportTeacher(string Path, DataGridView gridView) { Microsoft.Office.Interop.Excel.Application xlApp; Microsoft.Office.Interop.Excel.Workbook xlWorkBook; Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet; Microsoft.Office.Interop.Excel.Range xlRange; if (Path != string.Empty) { xlApp = new Microsoft.Office.Interop.Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(Path); xlWorkSheet = xlWorkBook.Worksheets["Sheet1"]; xlRange = xlWorkSheet.UsedRange; gridView.DataSource = null; gridView.ColumnCount = xlRange.Columns.Count; int n = 0; for (int i = 1; i < gridView.ColumnCount; i++) { gridView.Columns[n].Name = xlRange.Cells[1, i].Text; n++; } for (int i = 2; i <= xlRange.Rows.Count; i++) { gridView.Rows.Add(xlRange.Cells[i, 1].Text.ToString(), xlRange.Cells[i, 2].Text.ToString(), xlRange.Cells[i, 3].Text.ToString(), xlRange.Cells[i, 4].Text.ToString(), xlRange.Cells[i, 5].Text.ToString(), xlRange.Cells[i, 6].Text.ToString(), xlRange.Cells[i, 7].Text.ToString(), xlRange.Cells[i, 8].Text.ToString(), xlRange.Cells[i, 9].Text.ToString()); DAO_Admin.InsertTeacherWithExcel(xlRange, i); } xlWorkBook.Close(); xlApp.Quit(); } }
protected void BT_Enviar_Click(object sender, EventArgs e) { E_driver _driver = new E_driver(); _driver.Empresa = TB_Empresa.Text; ClientScriptManager cm = this.ClientScript; E_driver driver = new DAO_Admin().getEmpresa(TB_Empresa.Text); try { if (driver.Empresa == TB_Empresa.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('La ruta ya existe');</script>"); return; } } catch (NullReferenceException) { } new DAO_Admin().addEmpresa(_driver); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('La ruta ha sido registrada');</script>"); TB_Empresa.Text = String.Empty; }
protected void BT_Mostrar_Click(object sender, EventArgs e) { E_reportes rep = new DAO_Admin().getIdReporte(int.Parse(DropDownList1.SelectedValue)); var parseJson = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JsonHelper> >(File.ReadAllText(rep.Path)); GridView1.DataSource = parseJson; GridView1.DataBind(); }
public static void UpdateTeacher(Giao_Vienn Teacher, string Teacher_User_Account) { if (Teacher.Tai_Khoan == Teacher_User_Account) { DAO_Admin.UpdateTeacher(Teacher); MessageBox.Show("Update Success"); } MessageBox.Show("You Can't Change The Name Account Of User!"); }
protected void B_RegistrarMedico_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; string nombreArchivo = System.IO.Path.GetFileName(FU_medico.PostedFile.FileName); string extension = System.IO.Path.GetExtension(FU_medico.PostedFile.FileName); string saveLocation = "~\\Archivos"; if ((extension.Equals(".jpg") || extension.Equals(".gif") || extension.Equals(".jpge") || extension.Equals(".png"))) { saveLocation = saveLocation + "\\imagenes\\" + nombreArchivo; } else { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El formato del archivo es invalido');</script>"); return; } if (System.IO.File.Exists(Server.MapPath(saveLocation))) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ya existe un archivo en el servidor con ese nombre');</script>"); return; } try { FU_medico.PostedFile.SaveAs(Server.MapPath(saveLocation)); E_DatosUser user = new E_DatosUser(); DAO_Admin medico = new DAO_Admin(); user.Foto = nombreArchivo; user.Url = saveLocation; user.Apellidos = TB_Apellidos.Text.ToString(); user.Nombres = TB_Nombres.Text.ToString(); user.Numid = int.Parse(TB_identificacion.Text.ToString()); user.Email = TB_email.Text.ToString(); user.Clave = TB_Clave.Text.ToString(); user.Especializacion1 = DDL_Especialidad.SelectedItem.ToString(); user.Rol = 2; user.Session = Session.SessionID; user.Estado = 1; medico.CrearMedico(user); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('MEDICO REGISTRADO');", true); TB_Apellidos.Text = ""; TB_Nombres.Text = ""; TB_identificacion.Text = ""; TB_email.Text = ""; TB_Clave.Text = ""; } catch (Exception exc) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Error: ');</script>"); } /**CODIGO CORRECTO**/ }
protected void B_CrearEspecialidad_Click(object sender, EventArgs e) { string espe; string sesion; DAO_Admin especialidad = new DAO_Admin(); espe = TB_CrearEspecialidad.Text.ToString(); sesion = Session.SessionID; especialidad.CrearEspecialidad(espe, sesion); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('ESPECILIDAD REGISTRADA');", true); TB_CrearEspecialidad.Text = ""; }
public static void UpdateStudent(Hoc_Sinhh Student, string Student_User_Account) { if (Student.Tai_Khoan == Student_User_Account) { DAO_Admin.UpdateStudent(Student); MessageBox.Show("Update Success"); } else { MessageBox.Show("You Can't Change The Name Account Of User!"); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex]; var st = row.Cells[0].Text; E_cambioPasaportes e_Cambio = new E_cambioPasaportes(); E_user hell = new DAO_Admin().getUserId(int.Parse(st)); e_Cambio.Session = ((E_user)Session["validUser"]).User_name; e_Cambio.ChangeDate = DateTime.Now; e_Cambio.User_name = hell.User_name; e_Cambio.PasaportesAmount = hell.Pasaporte_numero; new DAO_Admin().pasaportesCambio(e_Cambio); }
public static void NextPage_teacher(DataGridView gridView, ConnectionStringSettings conStrSettings, System.Windows.Forms.Label lbPage_teacher, string Information, RadioButton radioButton_TchName, RadioButton radioButton_TchGrade) { if (Page <= NOP) { if (Count + 10 > n) { DAO_Admin.NextPage_teacher_last(gridView, conStrSettings, lbPage_teacher, ref n, ref Page, ref Count, ref NOP, Information, radioButton_TchName, radioButton_TchGrade); } else { DAO_Admin.NextPage_teacher(gridView, conStrSettings, lbPage_teacher, ref n, ref Page, ref Count, ref NOP, Information, radioButton_TchName, radioButton_TchGrade); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["validUser"] != null && ((E_user)Session["validUser"]).Id_rol == 3) { } else { Response.Redirect("~/View/Login.aspx"); } E_user e_user = new E_user(); string num = ((E_user)Session["validUser"]).Id_driver.ToString(); E_driver ps = new DAO_Admin().getNoPasaportes(int.Parse(num)); LB_Nombre.Text = ((E_user)Session["validUser"]).Name; LB_Apellido.Text = ((E_user)Session["validUser"]).Last_name; LB_Bonos.Text = ps.Total_pasaporte.ToString(); }
protected Beneficiario infoReport() { Beneficiario informe = new Beneficiario(); List <E_user> listBeneficiario = new DAO_Admin().getUserBeneficiario(); DataTable data = informe.UsersBenef; DataRow fila; foreach (E_user registro in listBeneficiario) { fila = data.NewRow(); fila["ID"] = registro.Id; fila["Nombre"] = registro.Name; fila["Apellido"] = registro.Last_name; fila["Ruta"] = registro.Name_ruta; fila["Pasaportes"] = registro.Pasaporte_numero; data.Rows.Add(fila); } return(informe); }
protected void btnSave_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; DateTime dob = DateTime.Parse(Request.Form[TextBox1.UniqueID]); E_reunion reu = new E_reunion(); reu.Fecha = dob; new DAO_Admin().addReunion(reu); List <E_user> mail_user = new DAO_Admin().getUserMail(); Send_Mail mail = new Send_Mail(); foreach (E_user mails in mail_user) { mail.sendMail(mails.Mail, "", "", "", "Se ha registrado una nueva reunion: " + dob.ToString()); } cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Se ha programado la reunion y se ha informado a los usuarios');</script>"); }
protected void B_Generar_Click(object sender, EventArgs e) { E_user e_user = new DAO_Admin().getMailUser(TB_Correo.Text); ClientScriptManager cm = this.ClientScript; if (e_user == null) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Correo No Ecnontrado');</script>"); return; } e_user.Pass = ""; e_user.State_Id = 2; e_user.Token = encrypt(JsonConvert.SerializeObject(e_user)); e_user.EndToken = DateTime.Now.AddDays(1); e_user.Sesion = e_user.Sesion = "Sistema"; new Send_Mail().sendMail(e_user.Mail, e_user.Token, "", "", ""); new DAO_Admin().editUser(e_user); }
protected void B_Cambiar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user e_user = new DAO_Admin().getUserLogin(((E_user)Session["validUser"]).User_name); if (TB_Pass.Text == TB_Repeat.Text) { e_user.Pass = TB_Pass.Text; new DAO_Admin().editUser(e_user); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Su contraseña ha sido cambiada con exito');</script>"); Send_Mail mail = new Send_Mail(); mail.sendMail(e_user.Mail, "", e_user.User_name, e_user.Pass, "Su contraseña se ha actualizado"); TB_Pass.Text = String.Empty; TB_Repeat.Text = String.Empty; } else { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Las contraseñas no coinciden');</script>"); return; } }
protected void BT_Enviar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; string fileName = System.IO.Path.GetFileName(FU_Acta.PostedFile.FileName); string extension = System.IO.Path.GetExtension(FU_Acta.PostedFile.FileName); string saveLocation = Server.MapPath("~\\View\\Reports\\ActasReunion\\") + DateTime.Now.ToFileTime().ToString() + extension; if (!(extension.Equals(".pdf"))) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Tipo de archivo no es PDF o no subio archivo');</script>"); return; } if (System.IO.File.Exists(saveLocation)) { File.Delete(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ya existe un archivo en el servidor con ese nombre');</script>"); return; } try { FU_Acta.PostedFile.SaveAs(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El archivo ha sido cargado');</script>"); } catch (Exception exc) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Error: ');</script>"); return; } E_reunion ren = new DAO_Admin().getDateActa(int.Parse(DropDownList1.SelectedValue)); ren.Acta = saveLocation; new DAO_Admin().editEmpresaActa(ren); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Error2: ');</script>"); }
public void scan(string result) { ClientScriptManager cm = this.ClientScript; E_user e_User = new DAO_Admin().getQrUser(result); if (result == null || result == "") { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario no existe o el codigo no funciona');</script>"); return; } else if (e_User == null) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario no existe');</script>"); return; } else { LB_Name.Text = e_User.Name; LB_LastName.Text = e_User.Last_name; LB_Code.Text = result; LB_Bonos.Text = e_User.Pasaporte_numero.ToString(); if (e_User.Pasaporte_numero <= 0) { e_User.Pasaporte_numero = 0; cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('No tiene pasaportes disponibles');</script>"); return; } else { e_User.Pasaporte_numero = e_User.Pasaporte_numero - 1; } string num = ((E_user)Session["validUser"]).Id_driver.ToString(); E_driver ps = new DAO_Admin().getNoPasaportes(int.Parse(num)); ps.Total_pasaporte = ps.Total_pasaporte + 1; cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El pasaporte se ha cobrado');</script>"); new DAO_Admin().editUser(e_User); new DAO_Admin().editPasaportesCobrados(ps); } File.Delete(AppDomain.CurrentDomain.BaseDirectory.Insert(AppDomain.CurrentDomain.BaseDirectory.Length, "Captures/qr_code.png")); }
protected void BT_Enviar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; E_user e_user = new E_user(); e_user.Id_rol = 3; e_user.Name = TB_Nombre.Text; e_user.Last_name = TB_Apellido.Text; e_user.User_name = TB_User.Text; e_user.Pass = TB_Pass.Text; e_user.Mail = TB_Correo.Text; e_user.Id_ruta = int.Parse(DDL_NumRuta.SelectedValue); e_user.Id_driver = int.Parse(DDL_IdeConductor.SelectedValue); //---------------------------------// E_user euser = new DAO_Admin().getUserLogin(TB_User.Text); try { if (euser.User_name == TB_User.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ya existe');</script>"); return; } } catch (NullReferenceException) { } E_user euser_mail = new DAO_Admin().getMailUser(TB_Correo.Text); try { if (euser_mail.Mail == TB_Correo.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El correo ya existe');</script>"); return; } } catch (NullReferenceException) { } //----------------------------------// e_user.LastModified = DateTime.Now; e_user.Sesion = ((E_user)Session["validUser"]).User_name; //---------------------------------// Send_Mail mail = new Send_Mail(); mail.sendMail(e_user.Mail, e_user.Token, "Su usuario: " + e_user.User_name, "Su contraseña: " + e_user.Pass, "Bienvenido señor conductor al programa."); new DAO_Admin().addUser(e_user); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ha sido registrado');</script>"); //-------------------------------// TB_Pass.Text = String.Empty; TB_Nombre.Text = String.Empty; TB_Correo.Text = String.Empty; TB_Apellido.Text = String.Empty; TB_User.Text = String.Empty; }
public static void RestoreDataBase(string Path, ConnectionStringSettings conStrSettings) { DAO_Admin.RestoreDataBase(Path, conStrSettings); }
public static void BackupDataBase(string Path, ConnectionStringSettings conStrSettings) { DAO_Admin.BackupDataBase(Path, conStrSettings); }
public static string findGradeByID(string ClassID) { return(DAO_Admin.findGradeByID(ClassID)); }
protected void BT_Enviar_Click(object sender, EventArgs e) { ClientScriptManager cm = this.ClientScript; string fileName = System.IO.Path.GetFileName(FU_Foto.PostedFile.FileName); string extension = System.IO.Path.GetExtension(FU_Foto.PostedFile.FileName); string saveLocation = Server.MapPath("~\\Images\\ProfilePictures\\") + DateTime.Now.ToFileTime().ToString() + extension; E_user e_user = new E_user(); e_user.Id_rol = 2; e_user.Name = TB_Nombre.Text; e_user.Last_name = TB_Apellido.Text; e_user.User_name = TB_User.Text; e_user.Pass = TB_Pass.Text; e_user.Mail = TB_Correo.Text; e_user.Id_ruta = int.Parse(DDL_NumRuta.SelectedValue); e_user.Activo = CB_Activo.Checked; e_user.Profile_pic = saveLocation; //---------------------------------// E_user euser = new DAO_Admin().getUserLogin(TB_User.Text); try { if (euser.User_name == TB_User.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ya existe');</script>"); return; } } catch (NullReferenceException) { } E_user euser_mail = new DAO_Admin().getMailUser(TB_Correo.Text); try { if (euser_mail.Mail == TB_Correo.Text) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El correo ya existe');</script>"); return; } }catch (NullReferenceException) { } //---------------------------------// if (!(extension.Equals(".jpg") || extension.Equals(".jpeg") || extension.Equals(".png"))) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Tipo de archivo no valido o no subio archivo');</script>"); return; } if (System.IO.File.Exists(saveLocation)) { File.Delete(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Ya existe un archivo en el servidor con ese nombre');</script>"); return; } try { FU_Foto.PostedFile.SaveAs(saveLocation); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El archivo ha sido cargado');</script>"); } catch (Exception exc) { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('Error: ');</script>"); return; } try { if (e_user.Profile_pic == " ") { cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('No ha subido ninguna foto');</script>"); return; } } catch (NullReferenceException) { } //---------------------------------// e_user.LastModified = DateTime.Now; e_user.Sesion = ((E_user)Session["validUser"]).User_name; e_user.Pasaporte_numero = 0; //---------------------------------// //Generador de usuario ahora en User/QRCode.aspx.cs e_user.Qr_hash = RNG_Gen.RNG_gen(); Send_Mail mail = new Send_Mail(); mail.sendMail(e_user.Mail, e_user.Token, "Su usuario: " + e_user.User_name, "Su contraseña: " + e_user.Pass, "Bienvenido al programa."); new DAO_Admin().addUser(e_user); cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('El usuario ha sido registrado');</script>"); //-------------------------------// TB_Pass.Text = String.Empty; TB_Nombre.Text = String.Empty; TB_Correo.Text = String.Empty; TB_Apellido.Text = String.Empty; TB_User.Text = String.Empty; }
private void btnSignIn_Click(object sender, EventArgs e) { int a = _Client.checkClientLogin(cmbClient.Checked, txtUsername.Text, txtPassword.Text); try { if (a == 0) { MessageBox.Show("Not Registred !", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else if (a == 1) { _Client.fillCurentClient(txtUsername.Text, CurrentClient); fillUserProfile(CurrentClient); DataView dv = new DataView(_Cars.getAllCars()); cmbMark.DataSource = dv.ToTable(true, "Mark"); cmbMark.DisplayMember = "Mark"; cmbModel.DataSource = dv.ToTable(true, "Model"); cmbModel.DisplayMember = "Model"; cmbPrices.DataSource = dv.ToTable(true, "PriceForDay"); cmbPrices.DisplayMember = "PriceForDay"; FillCarsdtg(); dtgmyOrders.DataSource = _Orders.getOrdersByUser(CurrentClient.UserName); dv = new DataView(Connection.ds.Tables["tbl_Messages"]); dv.RowFilter = "username='******'"; lbMessages.DataSource = dv; lbMessages.DisplayMember = "messagecontext"; lbMessages.ValueMember = "username"; cardClientSpace.BringToFront(); } else if (a == -1) { int m = _Manager.checkManagerLogin(cmbManager.Checked, txtUsername.Text, txtPassword.Text); if (m == 1) { _Manager.fillCurentManager(txtUsername.Text, CurrentManager); dtgClients.DataSource = Connection.ds.Tables["tbl_Clients"]; dtgManagerCars.DataSource = Connection.ds.Tables["tbl_Cars"]; fillUserManagerProfile(CurrentManager); cardManagerPanel.BringToFront(); } else if (m == -1) { DAO_Admin _Admin = new DAO_Admin(); if (_Admin.checkAdminLogin(cmbAdmin.Checked, txtUsername.Text, txtPassword.Text) == 1) { dtgClientsAdminSpace.DataSource = Connection.ds.Tables["tbl_Clients"]; dtgManagerAdminspace.DataSource = Connection.ds.Tables["tbl_Managers"]; txtUsenmaeAdmin.Text = txtUsername.Text; txtPasswordAdmin.Text = txtPassword.Text; cardAdmin.BringToFront(); } else { MessageBox.Show("Not Registred !", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } } catch (Exception) { throw; // MessageBox.Show("Not Registred !", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
public static List <Ket_Qua_Thi> GetExaminationResultWithAccount(string taiKhoan) { return(DAO_Admin.GetExaminationResult(taiKhoan)); }
public static List <Ket_Qua_Thi> GetExaminationResultWithGrade(string maKhoi) { return(DAO_Admin.GetExaminationResultForTeacher(maKhoi)); }