public static void Login(string cpf, string senha, tipoUsuario tipo)
{
switch (tipo)
{
case tipoUsuario.ADMIN:
Console.WriteLine("Bem-Vindo ao Sistema de Leilão");
DashboardAdmin.Dashboard();
break;
case tipoUsuario.NORMAL:
var listaUsuarios = DAOUsuario.BuscarTodosUsuarios();
var usuarioEncontrado = listaUsuarios.Exists(x => x.CPF == cpf && x.Senha == senha);
if (usuarioEncontrado)
{
Console.WriteLine("Bem-Vindo ao Sistema de Leilão");
DashboardCliente.Dashboard(cpf);
}
else
{
Console.WriteLine("Senha inválida");
}
break;
}
}
private List <HistoryShipping> GetHistoryShippingList()
{
List <HistoryShipping> HSList = new List <HistoryShipping>();
DashboardAdmin DA = new DashboardAdmin();
//count
var query = db.HistoryShippings.Where(x => x.Shipping.Id.Equals(x.Shipping_Id)).ToList();
var query2 = from hs in db.HistoryShippings
from s in db.Shippings
from ss in db.StatusShippings
from e in db.Employees
from b in db.Branchs
from w in db.Warehouses
from pa in db.Packages
from c in db.Categories
select new { hs, s, ss, e, b, w, pa, c };
var query2list = query2.ToList();
int count = 0;
foreach (var sid in query)
{
count = count + 1;
}
ViewBag.HSCount = count;
return(HSList);
}
public ActionResult Index()
{
DashboardAdmin mymodel = new DashboardAdmin();
mymodel.VMProvince = GetProvinceList();
mymodel.VMRegency = GetRegencyList();
mymodel.VMDistrict = GetDistrictList();
mymodel.VMVillage = GetVillageList();
mymodel.VMShipping = GetShippingList();
mymodel.VMHistoryShipping = GetHistoryShippingList();
mymodel.VMCategory = GetCategoryList();
mymodel.VMPackage = GetPackageList();
mymodel.VMStatusShipping = GetStatusShippingList();
mymodel.VMEmployee = GetEmployeeList();
mymodel.VMWarehouse = GetWarehouseList();
mymodel.VMBranch = GetBranchList();
return(View(mymodel));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
String username = txtUsername.Text;
string password = txtPassword.Password;
byte[] theBytes = Encoding.UTF8.GetBytes(password);
if (username.Equals("") || password.Equals(""))
{
MessageBox.Show(Settings.Default.MensajeCamposVacios);
}
else
{
/**
* Consulta para encontrar el usuario
*/
using (DBEntities db = new DBEntities())
{
try
{
var user = db.Usuarios.Where(b => b.username.Equals(username) && b.password == theBytes).FirstOrDefault();
if (user != null)
{
/**
* De acuerdo al rol, entra al apartado del sistema correspondiente
*/
switch (user.idRol)
{
case 5:
DashboardAdmin dashboard_Admin = new DashboardAdmin(user);
dashboard_Admin.WindowStartupLocation = WindowStartupLocation.CenterScreen;
dashboard_Admin.Show();
closeWindow();
break;
case 6:
Dashboard_Capturista dashboard_Capturista = new Dashboard_Capturista(user);
dashboard_Capturista.WindowStartupLocation = WindowStartupLocation.CenterScreen;
dashboard_Capturista.Show();
closeWindow();
break;
case 7:
Dashboard_Gestor dashboard_Gestor = new Dashboard_Gestor();
dashboard_Gestor.WindowStartupLocation = WindowStartupLocation.CenterScreen;
dashboard_Gestor.Show();
closeWindow();
break;
case 8:
Dashboard_AnalistaC dashboard_AnalistaC = new Dashboard_AnalistaC(user);
dashboard_AnalistaC.WindowStartupLocation = this.WindowStartupLocation;
dashboard_AnalistaC.Show();
closeWindow();
break;
}
this.Close();
}
else
{
MessageBox.Show(Settings.Default.MensajeNoEncontrado);
}
}
catch (Exception ex)
{
MessageBox.Show(Settings.Default.MensajeErrorBD);
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
}
}
private void userSubmit_Click(object sender, RoutedEventArgs e)
{
MD5 md5 = MD5.Create();
//create an array of ascii encoding of password
byte[] bytes = System.Text.ASCIIEncoding.ASCII.GetBytes(userPassword.Password);
// create hash of created array element
byte[] hash = md5.ComputeHash(bytes);
// when hash is computed then create a string of encrypted password using string builder class and append the values created to make a full string encrypted message
StringBuilder sb = new StringBuilder();
for (int b = 0; b < hash.Length; b++)
{
// created hex encrypted md5 password in string format
sb.Append(hash[b].ToString("X2"));
}
var password = sb.ToString();
//insert data to database
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into Advantic_Users(empNo,empName,userDesignation,userOpteam,password)values(@empNo,@empName,@userDesignation,@userOpteam,@password)";
cmd.Connection = con;
cmd.Parameters.AddWithValue("empNo", UserEmpNo.Text);
cmd.Parameters.AddWithValue("empName", UserEmpName.Text);
cmd.Parameters.AddWithValue("userDesignation", UserDesignation.Text);
cmd.Parameters.AddWithValue("userOpteam", UserOpteam.Text);
cmd.Parameters.AddWithValue("password", password);
cmd.ExecuteNonQuery();
DashboardAdmin dash = new DashboardAdmin();
//dash.DataGridUserInfoSection
/* try
* {
* con.Open();
* if (this.userPassword.Password == this.txtConfirmPword.Password)
* {
* reader = cmd.ExecuteReader();
* MessageBox.Show("Saved");
* }
* else
* {
* MessageBox.Show("Your password should be matched");
* // MessagePwConfirm.Visibility(Visual);
* }
*
* }
* catch (Exception ex)
* {
* Console.WriteLine(ex);
* }*/
this.Close();
}
public ActionResult Index()
{
if (Session["Authent"] != null)
{
DashboardAdmin dtoAdmin = new DashboardAdmin();
DashBoardChuKs dtoChuKs = new DashBoardChuKs();
using (var client = new HttpClient())
{
//Passing service base url
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", Session["Authent"].ToString());
//Define request data format
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
Task task = Task.Run(async() =>
{
HttpResponseMessage Res = await client.GetAsync($"/manager/dashboard/info");
if (Res.IsSuccessStatusCode)
{
//Storing the response details recieved from web api
var EmpResponse = Res.Content.ReadAsStringAsync().Result;
JavaScriptSerializer serializer = new JavaScriptSerializer();
var jsonObject = serializer.Deserialize <dynamic>(EmpResponse)["data"];
int role = Convert.ToInt32(Session["role"]);
if (role == 2 || role == 3 || role == 4 || role == 5)
{
dtoAdmin.total_user = jsonObject["total_user"];
dtoAdmin.total = Convert.ToDouble(jsonObject["total"]);
dtoAdmin.total_month = Convert.ToDouble(jsonObject["total_month"]);
dtoAdmin.total_apartment = jsonObject["total_apartment"];
dtoAdmin.total_booking = jsonObject["total_booking"];
dtoAdmin.total_booking_finish = jsonObject["total_booking_finish"];
}
if (role == 1)
{
dtoChuKs.total_good_review = jsonObject["total_good_review"];
dtoChuKs.total_review = jsonObject["total_review"];
dtoChuKs.total_apartment_rented = jsonObject["total_apartment_rented"];
dtoChuKs.total = jsonObject["total"];
dtoChuKs.total_month = jsonObject["total_month"];
dtoChuKs.total_apartment = jsonObject["total_apartment"];
dtoChuKs.total_booking = jsonObject["total_booking"];
dtoChuKs.total_booking_finish = jsonObject["total_booking_finish"];
}
}
});
task.Wait();
if (Convert.ToInt32(Session["role"]) == 1)
{
return(View("HomeChuKs", dtoChuKs));
}
else
{
return(View(dtoAdmin));
}
}
}
return(RedirectToAction("Login", "Account"));
}
private void loginMainWindow_Click(object sender, RoutedEventArgs e)
{
if (UserNameLogin.Text == "" || PasswordLogin.Password == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
con.Open();
try
{
//Create SqlConnection
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select userOpteam from Advantic_Users where empNo=@username and password=@password";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@username", UserNameLogin.Text);
//cmd.Parameters.AddWithValue("@password", PasswordTextLogin.Password)
cmd.Parameters.AddWithValue("@password", CommonFunctions.sha256_hash(PasswordLogin.Password));
Console.WriteLine("Password is" + CommonFunctions.sha256_hash(PasswordLogin.Password));
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
// DataSet ds = new DataSet();
DataTable ds = new DataTable();
adapt.Fill(ds);
if (ds.Rows.Count == 1)
{
// Dashboard fm = new Dashboard();
//fm.Show();
//int count = ds.Tables[0].Rows.Count;
if (ds.Rows[0][0].ToString() == "Supervisor")
{
DashboardAdmin supervisorModule = new DashboardAdmin();
supervisorModule.Show();
}
//UploadCSV uploadCsv = new UploadCSV();
//uploadCsv.uploadCsv();
else if (ds.Rows[0][0].ToString() == "Administrator")
{
DashboardAdmin dashboardAdmin = new DashboardAdmin();
dashboardAdmin.Show();
}
else
{
MessageBox.Show("Invalid");
}
}
else
{
MessageBox.Show("Please check your Username and Password");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Console.WriteLine(ex);
}
//connection should be closed
finally
{
con.Close();
}
}
