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));
}
