private void button1_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == pin)
{
con.Open();
cmd = new SqlCommand("select * from regtb where UserId='" + id + "' and Password='******' ", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
MessageBox.Show("Login Successfully!");
UserHome uu = new UserHome();
uu.accno = dr["Accno"].ToString();
uu.bal = dr["Balance"].ToString();
uu.Show();
}
else
{
MessageBox.Show("Pin Incorrect!");
}
con.Close();
}
else
{
MessageBox.Show("Pin Incorrect!");
}
}
private void HandlerBtnLogin(object sender, EventArgs e)
{
String user = this.inputNombre.Text;
String password = this.InputPassword.Text;
if (user == "user")
{
UserHome userView = new UserHome(user);
userView.Show();
this.Hide();
}
else if (user == "admin")
{
AdminHome adminView = new AdminHome(user);
adminView.Show();
this.Hide();
}
else
{
MessageBox.Show("Usuarios validos: user, admin", "Ingreso al sistema");
}
//MessageBox.Show($"{user} - {password}", "Ingreso al sistema");
Console.WriteLine("User: "******"Password: " + password);
Application.Exit();
}
public async Task <ActionResult <UserHome> > PostUserHome(UserHome userHome)
{
_context.UserHomes.Add(userHome);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserHome", new { id = userHome.Id }, userHome));
}
public async Task <IActionResult> PutUserHome(long id, UserHome userHome)
{
if (id != userHome.Id)
{
return(BadRequest());
}
_context.Entry(userHome).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserHomeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void BeforeScenario()
{
_driver = new ChromeDriver(_helpers.GetChromeDriverPath());
_driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(_helpers.GetTimeout());
_signIn = new SignIn(_driver);
_home = new Home(_driver);
_userHome = new UserHome(_driver);
}
private void Login_Click(object sender, RoutedEventArgs e)
{
//string username = "******";
//string password = "******";
string username = tbUsername.Text;
string password = pbPassword.Password;
bool successful = _loginService.Login(username, password);
if (successful)
{
_loginService.GetCurrentUser(username, password);
if (CurrentUser.user.Admin == true)
{
HomeMenu home = new HomeMenu();
home.Show();
Window.GetWindow(this).Close();
}
else
{
UserHome home = new UserHome();
home.Show();
Window.GetWindow(this).Close();
}
}
else
{
try
{
if (_userdb.Load().FirstOrDefault(u => u.Username == username) != null)
{
throw new IncorrectPasswordException("Fel lösenord för användaren: ", tbUsername.Text);
}
else
{
MessageBox.Show(_errorMsg);
this.pbPassword.Clear();
this.tbUsername.Clear();
}
}
catch (IncorrectPasswordException ex)
{
MessageBox.Show(ex.Message + ex.UserName);
this.pbPassword.Clear();
}
}
}
private void openFormWithRole(string role)
{
if (String.Compare(role.Trim(), "employee", true) == 0)
{
UserHome userHome = new UserHome(homeController.getAccountLoggedIn());
userHome.ShowDialog();
isLoginAdready(true, userName);
}
else if (String.Compare(role.Trim(), "manage", true) == 0)
{
AdminHome adminHome = new AdminHome(homeController.getAccountLoggedIn());
adminHome.ShowDialog();
isLoginAdready(true, userName);
}
else
{
laNotice.Text = "Sai tài khoản hoặc mật khẩu";
}
}
// GET: User
public ActionResult Index()
{
//if (Session["userId"] == null || Session["userId"].ToString() == "")
if (Session["userId"] == null || Session["userId"].ToString() == "" || Session["roleId"].ToString() != "2")
{
return(RedirectToAction("Index", "Home"));
}
string email = Session["userId"].ToString();
ModelContext db = new ModelContext();
List <UserHome> list = new List <UserHome>();
List <User_Service> USList = db.User_Services.ToList();
foreach (var us in USList)
{
if (us.EmailId == email)
{
string sid = us.ServiceId;
List <Service_Course> SCList = db.Service_Courses.ToList();
foreach (var sc in SCList)
{
if (sc.ServiceId == sid)
{
UserHome userHome = new UserHome();
userHome.Id = email;
userHome.CourseCode = sc.CourseId;
userHome.CourseName = db.Courses.Find(userHome.CourseCode).Name;
userHome.Servicename = db.Services.Find(sid).Name;
userHome.StartDate = db.Services.Find(sid).StartDate.ToString();
userHome.EndDate = db.Services.Find(sid).StartDate.AddMonths(db.Services.Find(sid).Duration).ToString();
userHome.Detail = db.Courses.Find(userHome.CourseCode).Detail;
list.Add(userHome);
}
}
}
}
return(View(list));
//return Content("hvshdu"+USList.Count);
}
/// <summary>
/// 主界面的初始化
/// </summary>
private void MainRenderInitialization()
{
//将所有的子集控件添加进去
/*******************************************************************************
*
* 例如此处展示了文件控件是如何添加进去的
* 1.先进行实例化，赋值初始参数
* 2.添加进项目
* 3.显示
*
*******************************************************************************/
//UIControls_Files = new UIControls.ShareFilesRender()
//{
// Visible = false,
// Parent = panel_main,//决定了放在哪个界面显示，此处示例
// Dock = DockStyle.Fill,
//};
//all_main_render.Add(UIControls_Files);
UIControls_Chat = new UserChat((m) =>
{
net_socket_client.Send(CommonHeadCode.MultiNetHeadCode.留言版消息, m);
});
all_main_render.Add(UIControls_Chat);
UIControl_Home = new UserHome();
all_main_render.Add(UIControl_Home);
UIControl_Palette = new UserPaletteSelector()
{
DataContext = new PaletteSelectorViewModel()
};
all_main_render.Add(UIControl_Palette);
UIControl_Files = new UserFileRender("ShareFiles", "", "");
all_main_render.Add(UIControl_Files);
}
public async Task <IActionResult> Index()
{
var res = new UserHome();
res.Histories = await _context.Contents.Where(c => c.Type == 1 && c.Deleted != 1)
.OrderBy(c => c.Year).ToListAsync();
res.Courses = await _context.Courses.Where(c => c.Deleted != 1)
.OrderByDescending(c => c.EndDate).Take(3).ToListAsync();
res.Faculties = await _context.Faculties.Where(c => c.Deleted != 1).Take(5).ToListAsync();
res.Event = await _context.Contents.Where(c => c.Type == 2 && c.Deleted != 1)
.OrderByDescending(c => c.UpdatedAt).Take(3).ToListAsync();
res.TotalStudent = _context.Students.Where(s => s.Deleted != 1 && s.Status == 1).Count();
res.TotalCourse = _context.Courses.Where(s => s.Deleted != 1).Count();
if (res.Histories != null && res.Histories.Any())
{
res.Year = DateTime.Now.Year - (int)res.Histories.Min(h => h.Year);
}
return(View(res));
}
public ActionResult Search(string searching)
{
if (Session["userId"] == null || Session["userId"].ToString() == "")
{
return(RedirectToAction("Index", "Home"));
}
string email = Session["userId"].ToString();
ModelContext db = new ModelContext();
List <Service> services = db.Services.Where(a => a.Name.Contains(searching)).ToList();
List <Course> courses = db.Courses.Where(a => a.Name.Contains(searching)).ToList();
List <UserHome> list = new List <UserHome>();
List <User_Service> USList = db.User_Services.ToList();
if (services.Count > 0)
{
foreach (Service service in services)
{
foreach (var us in USList)
{
if (us.EmailId == email && service.ServiceId == us.ServiceId)
{
string sid = us.ServiceId;
List <Service_Course> SCList = db.Service_Courses.ToList();
foreach (var sc in SCList)
{
if (sc.ServiceId == sid)
{
UserHome userHome = new UserHome();
userHome.Id = email;
userHome.CourseCode = sc.CourseId;
userHome.CourseName = db.Courses.Find(userHome.CourseCode).Name;
userHome.Servicename = db.Services.Find(sid).Name;
userHome.StartDate = db.Services.Find(sid).StartDate.ToString();
userHome.EndDate = db.Services.Find(sid).StartDate.AddMonths(db.Services.Find(sid).Duration).ToString();
userHome.Detail = db.Courses.Find(userHome.CourseCode).Detail;
list.Add(userHome);
//}
}
}
}
}
}
}
else
{
foreach (var us in USList)
{
if (us.EmailId == email)
{
string sid = us.ServiceId;
List <Service_Course> SCList = db.Service_Courses.ToList();
foreach (Course course in courses)
{
foreach (var sc in SCList)
{
if (sc.ServiceId == sid && course.CourseId == sc.CourseId)
{
UserHome userHome = new UserHome();
userHome.Id = email;
userHome.CourseCode = sc.CourseId;
userHome.CourseName = db.Courses.Find(userHome.CourseCode).Name;
userHome.Servicename = db.Services.Find(sid).Name;
userHome.StartDate = db.Services.Find(sid).StartDate.ToString();
userHome.EndDate = db.Services.Find(sid).StartDate.AddMonths(db.Services.Find(sid).Duration).ToString();
userHome.Detail = db.Courses.Find(userHome.CourseCode).Detail;
list.Add(userHome);
//}
}
}
}
}
}
}
return(View("Index", list));
}
