protected void shrani_Click(object sender, EventArgs e)
{
try
{
username.Text = username.Text.Trim();
password.Text = password.Text.Trim();
email.Text = email.Text.Trim();
ime.Text = ime.Text.Trim();
priimek.Text = priimek.Text.Trim();
if (string.IsNullOrWhiteSpace(username.Text))
{
throw new Exception("Polje Uporabniško ime ne sme biti prazno");
}
if ((!string.IsNullOrWhiteSpace(password.Text) || _id == 0) && password.Text.Length < 4)
{
throw new Exception("Polje Geslo ne sme biti krajše od 4 znakov");
}
if (ViewState["vrstice"] != null)
{
vrstice = JsonConvert.DeserializeObject <List <string> >(ViewState["vrstice"].ToString());
}
//List<int> l_davcne = new List<int>();
//int i_davcna = Convert.ToInt32(davcna.Text);
//l_davcne.Add(i_davcna);
//foreach (var item in davcne.Text.Split(','))
//{
// i_davcna = Convert.ToInt32(item);
// if (!l_davcne.Contains(i_davcna)) l_davcne.Add(i_davcna);
//}
//if (_id == 0) _id = Uporabniki.Dodaj(username.Text, password.Text, ime.Text, priimek.Text, email.Text, davcna.Text, string.Join(",", vrstice), prodajalec.Checked, poslovni_prostor.SelectedValue, elektronska_naprava.SelectedValue, skupine.Text, oznaka.Text, racuni.Checked, popravljanje.Checked, revirji.Text, reprezentanca.Checked, string.Join(",", l_davcne), tiskalnik.Text);
//else Uporabniki.Popravi(_id, username.Text, password.Text, ime.Text, priimek.Text, email.Text, davcna.Text, string.Join(",", vrstice), prodajalec.Checked, s_poslovni_prostor, s_elektronska_naprava, skupine.Text, oznaka.Text, racuni.Checked, popravljanje.Checked, revirji.Text, reprezentanca.Checked, string.Join(",", l_davcne), tiskalnik.Text, null);
if (_id == 0)
{
_id = Uporabniki.Add(username.Text, password.Text, ime.Text, priimek.Text, true, string.Join(",", vrstice), email.Text, "", anAdmin.Checked, Master.Uporabnik.Id);
}
else
{
Uporabniki.Edit(_id, username.Text, password.Text, ime.Text, priimek.Text, true, anAdmin.Checked, string.Join(",", vrstice), null, email.Text, "", Master.Uporabnik.Id);
}
Response.Redirect("Uporabnik.aspx?id=" + _id + "&msg=" + HttpUtility.UrlEncode("Podatki shranjeni"));
}
catch (Exception er)
{
Master.SetMessage(er.Message);
}
}
protected void shrani_Click(object sender, EventArgs e)
{
try
{
password.Text = password.Text.Trim();
password_new1.Text = password_new1.Text.Trim();
password_new2.Text = password_new2.Text.Trim();
email.Text = email.Text.Trim();
ime.Text = ime.Text.Trim();
priimek.Text = priimek.Text.Trim();
if (string.IsNullOrWhiteSpace(ime.Text))
{
throw new Exception("Polje Ime ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(priimek.Text))
{
throw new Exception("Polje Priimek ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(email.Text))
{
throw new Exception("Polje Email ne sme biti prazno");
}
if (!string.IsNullOrWhiteSpace(password.Text) && password.Text.Length < 4)
{
throw new Exception("Polje Geslo ne sme biti krajše od 4 znakov");
}
if (!string.IsNullOrWhiteSpace(password_new1.Text) && password_new1.Text.Length < 4)
{
throw new Exception("Polje Novo geslo ne sme biti krajše od 4 znakov");
}
if (!string.IsNullOrWhiteSpace(password_new2.Text) && password_new2.Text.Length < 4)
{
throw new Exception("Polje Novo geslo (ponovi) ne sme biti krajše od 4 znakov");
}
if (password_new1.Text != password_new2.Text)
{
throw new Exception("Polji Novo geslo in Novo geslo (ponovi) nista enaki");
}
Uporabniki.Edit(Master.Uporabnik.Id, Master.Uporabnik.Username, password_new1.Text, ime.Text, priimek.Text, true, true, string.Join(",", Master.Uporabnik.Pravice), Session, email.Text, "", Master.Uporabnik.Id);
Response.Redirect("Osebno.aspx?msg=" + HttpUtility.UrlEncode("Podatki shranjeni"));
}
catch (Exception er)
{
Master.SetMessage(er.Message);
}
}
private void pravice()
{
List <string> obstojece = new List <string>(Request.QueryString["s"].Trim(',').Split(','));
List <string> pravice = new List <string>();
foreach (DataRow r in Uporabniki.Get().Rows)
{
foreach (string pravica in Convert.ToString(r["pravice"]).Split(','))
{
if (!obstojece.Contains(pravica) && !pravice.Contains(pravica))
{
pravice.Add(pravica);
}
}
}
pravice.Sort();
Response.Write(JsonConvert.SerializeObject(pravice));
}
public HttpResponseMessage Delete([FromBody] Uporabniki uporabniki)
{
CRUDService service = new CRUDService();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
Entities db = new Entities();
try
{
service.Delete(uporabniki, db.Uporabnikis);
}
catch (ApplicationException ex)
{
response = Request.CreateResponse(HttpStatusCode.InternalServerError, ex);
}
return(response);
}
private void btnBrisi_Click(object sender, RoutedEventArgs e)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:31207/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
string sMessageBoxText = "Ali res želite izbrisati izbrane uporabnike?";
string sCaption = "Uporabniki";
var rsltMessageBox = Windows.winMessageBox.Show(sCaption, sMessageBoxText, MessageBoxButton.YesNo, MessageBoxImage.Warning);
switch (rsltMessageBox)
{
case MessageBoxResult.Yes:
foreach (var data in grdUporabniki.SelectedItems)
{
Uporabniki upo = data as Uporabniki;
var response = client.PostAsJsonAsync("api/uporabniki/delete/", upo).Result;
if (!response.IsSuccessStatusCode)
{
MessageBox.Show("Error Code" + response.StatusCode + " : Message - " + response.ReasonPhrase);
}
}
using (new ucWaitCursor())
{
winCRU wc = (winCRU)Application.Current.Windows.OfType <Window>().SingleOrDefault(x => x.IsActive);
ucClass.ucNavigate(wc.mainContent, new ucUporabniki());
}
break;
case MessageBoxResult.No:
/* ... */
break;
case MessageBoxResult.Cancel:
/* ... */
break;
}
}
//create new SessionToken
private static string GetNewSessionToken(string userName)
{
string SessionAuthToken = Guid.NewGuid().ToString();
Uporabniki Uporabnik = DAOService.GetUporabnik(userName);
AuthSession authSession = new AuthSession()
{
SessionToken = SessionAuthToken,
UporabnikKLJ = Uporabnik.UporabnikKLJ,
SessionTimeOut = 1800,
Issued = DateTime.Now,
Expired = DateTime.Now.AddSeconds(1800)
};
DAOService.SaveNewSession(authSession);
return(SessionAuthToken);
}
public static Uporabniki GetUporabnik(string UserName)
{
Uporabniki response = new Uporabniki();
try
{
using (Entities db = new Entities())
{
response = db.Uporabnikis.Where(b => b.UporabnikID == UserName).FirstOrDefault();
}
}
catch (Exception ex)
{
Log.Error("Napaka pri branju Uporabnikov /" + ex);
throw new ApplicationException("Napaka pri branju Uporabnikov /" + ex);
}
return(response);
}
public async Task <IActionResult> OnPostAsync(string returnUrl = null)
{
returnUrl = returnUrl ?? Url.Content("~/");
ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList();
if (ModelState.IsValid)
{
var zapView = new ZaposlenViewModel {
Ime = Input.Ime, Priimek = Input.Priimek, Naslov = Input.Naslov, Telefon = Input.Telefon, DatumRojstva = Input.DatumRojstva, Spol = Input.Spol, Slika = Input.Slika
};
string uniqueFileName = UploadedFile(zapView);
var zapTmp = new Zaposlen {
Ime = Input.Ime, Priimek = Input.Priimek, Naslov = Input.Naslov, Telefon = Input.Telefon, DatumRojstva = Input.DatumRojstva, Spol = Input.Spol, PhotoPath = uniqueFileName, Kadrovanje = Input.Kadrovska
};
var user = new Uporabniki {
UserName = Input.Email, Email = Input.Email, Zaposlen = zapTmp
};
var result = await _userManager.CreateAsync(user, Input.Password);
if (Input.Kadrovska)
{
var roleResult = await _userManager.AddToRoleAsync(user, "Manager");
}
else
{
var roleResult = await _userManager.AddToRoleAsync(user, "Worker");
}
if (result.Succeeded)
{
_logger.LogInformation("User created a new account with password.");
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code));
var callbackUrl = Url.Page(
"/Account/ConfirmEmail",
pageHandler: null,
values: new { area = "Identity", userId = user.Id, code = code, returnUrl = returnUrl },
protocol: Request.Scheme);
await _emailSender.SendEmailAsync(Input.Email, "Confirm your email",
$"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>.");
if (_userManager.Options.SignIn.RequireConfirmedAccount)
{
return(RedirectToPage("RegisterConfirmation", new { email = Input.Email, returnUrl = returnUrl }));
}
else
{
await _signInManager.SignInAsync(user, isPersistent : false);
return(LocalRedirect(returnUrl));
}
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
// If we got this far, something failed, redisplay form
return(Page());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (Uporabnik up = new Uporabnik(Session))
{
up.logout(Session);
}
string u = "";
string p = "";
try
{
string[] hash = Varnost.DecryptAES256(Convert.ToBase64String(HttpServerUtility.UrlTokenDecode(Request.QueryString["hash"]))).Split(new string[] { "@-|@|-@" }, StringSplitOptions.None);
if (hash.Length == 3 && hash[2] == ConfigurationManager.AppSettings["EncryptKey"])
{
u = hash[0].Trim();
p = hash[1].Trim();
}
else
{
throw new Exception();
}
}
catch
{
Response.Redirect("Default.aspx", true);
}
if (Uporabnik.login(u, p, Session, "", 1) == 0)
{
using (Uporabnik uporabnik = new Uporabnik(Session))
{
try
{
username.Text = uporabnik.Username;
if (IsPostBack)
{
password_new1.Text = password_new1.Text.Trim();
password_new2.Text = password_new2.Text.Trim();
if (!string.IsNullOrWhiteSpace(password_new1.Text) && password_new1.Text.Length < 6)
{
throw new Exception("Polje Novo geslo ne sme biti krajše od 6 znakov");
}
if (!string.IsNullOrWhiteSpace(password_new2.Text) && password_new2.Text.Length < 6)
{
throw new Exception("Polje Novo geslo (ponovi) ne sme biti krajše od 6 znakov");
}
if (password_new1.Text != password_new2.Text)
{
throw new Exception("Polji Novo geslo in Novo geslo (ponovi) nista enaki");
}
Uporabniki.Edit(uporabnik.Id, uporabnik.Username, password_new1.Text, uporabnik.Ime, uporabnik.Priimek, uporabnik.Active, uporabnik.Admin, string.Join(",", uporabnik.Pravice), Session, uporabnik.Email, uporabnik.Gsm, uporabnik.Id);
_js = "dialog('Geslo uspešno spremenjeno', 'Sedaj se lahko prijavite z novim geslom.', 'i');";
_js += "$('#dialog').dialog('option', 'buttons', { Ok: function () { $(this).dialog('close'); window.location='Default.aspx';}});";
}
}
catch (Exception er)
{
throw er;
}
finally
{
uporabnik.logout(Session);
}
}
}
else
{
_error = "Podatki v povezavi so nepravilni";
}
}
catch (Exception er)
{
_error = "Prišlo je do programske napake<br /><i style=\"font-size:0.8em;\">" + er.Message + "</i>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Uporabnik";
if (!Master.Uporabnik.Pravice.Contains("uporabniki"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
int.TryParse(Request.QueryString["id"], out _id);
if (IsPostBack)
{
#region
msg = "";
Master.SetMessage(msg);
string vrstica = Request.Form["vrstica"];
if (!string.IsNullOrWhiteSpace(vrstica))
{
string[] vs = vrstica.Split('-');
if (vs.Length == 2)
{
int idx = Convert.ToInt32(vs[1]);
if (ViewState["vrstice"] != null)
{
vrstice = JsonConvert.DeserializeObject <List <string> >(ViewState["vrstice"].ToString());
}
if (vs[0] == "u")
{
u_roles.Text = vrstice[idx];
}
vrstice.RemoveAt(idx);
ViewState["vrstice"] = JsonConvert.SerializeObject(vrstice);
}
}
#endregion
}
else
{
#region
if (u_roles.Items.Count == 0)
{
foreach (DataRow r in Uporabniki.Get_URoles().Select("anActive = 1"))
{
u_roles.Items.Add(new ListItem(r["acRoleName"].ToString(), Convert.ToString(r["acRoleID"])));
}
}
DataTable dt = Uporabniki.Get(_id);
if (dt.Rows.Count > 0)
{
username.Text = Convert.ToString(dt.Rows[0]["acUserName"]);
email.Text = Convert.ToString(dt.Rows[0]["acEmail"]);
ime.Text = Convert.ToString(dt.Rows[0]["acFirstName"]);
priimek.Text = Convert.ToString(dt.Rows[0]["acLastName"]);
anAdmin.Checked = Convert.ToInt32(dt.Rows[0]["anAdmin"]) == 1 ? true : false;
brisi.Visible = true;
vrstice = new List <string>();
foreach (DataRow r in Uporabniki.Get_UserRoles(Convert.ToString(dt.Rows[0]["acUserName"])).Rows)
{
vrstice.Add(r["acRoleID"].ToString());
}
ViewState["vrstice"] = JsonConvert.SerializeObject(vrstice);
}
else
{
password.CssClass = "req";
//elektronske_naprave(poslovni_prostor.SelectedValue);
}
password.Text = "";
#endregion
}
vrstice_izpis();
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
protected void brisi_Click(object sender, EventArgs e)
{
Uporabniki.Delete(_id);
Response.Redirect("Uporabniki.aspx?msg=" + HttpUtility.UrlEncode("Izbrisano"));
}
public static void Initialize(EkadriContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Zaposleni.Any())
{
return; // DB has been seeded
}
var adminRole = new IdentityRole {
Name = "Admin", NormalizedName = "ADMIN"
};
context.Roles.Add(adminRole);
var managerRole = new IdentityRole {
Name = "Manager", NormalizedName = "MANAGER"
};
context.Roles.Add(managerRole);
var workerRole = new IdentityRole {
Name = "Worker", NormalizedName = "WORKER"
};
context.Roles.Add(workerRole);
context.SaveChanges();
var zaposleni = new Zaposlen[]
{
new Zaposlen {
Ime = "Miha", Priimek = "Žnidar", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Klemen", Priimek = "Štefe", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Marjan", Priimek = "Kovač", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Janez", Priimek = "Pegam", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Florjan", Priimek = "Gasilec", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Cene", Priimek = "Novak", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
new Zaposlen {
Ime = "Mirjan", Priimek = "Salam", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž"
},
};
foreach (Zaposlen zaposlen in zaposleni)
{
context.Zaposleni.Add(zaposlen);
}
context.SaveChanges();
var delovnaMesta = new DelovnaMesta[] {
new DelovnaMesta {
DelovnaMestaID = 420, Oddelek = "IT", Lokacija = "Kranj", NazivDelovnegaMesta = "Programer"
},
new DelovnaMesta {
DelovnaMestaID = 123, Oddelek = "Proizvodnja", Lokacija = "Ljubljana", NazivDelovnegaMesta = "Upravljalec stroja"
},
new DelovnaMesta {
DelovnaMestaID = 690, Oddelek = "Proizvodnja", Lokacija = "Kranj", NazivDelovnegaMesta = "Čistilka"
},
new DelovnaMesta {
DelovnaMestaID = 231, Oddelek = "Komerciala", Lokacija = "Kranj", NazivDelovnegaMesta = "Komercialist"
},
new DelovnaMesta {
DelovnaMestaID = 222, Oddelek = "Komerciala", Lokacija = "Kranj", NazivDelovnegaMesta = "Šef"
},
new DelovnaMesta {
DelovnaMestaID = 666, Oddelek = "IT", Lokacija = "Ljubljana", NazivDelovnegaMesta = "Programer"
},
};
foreach (DelovnaMesta mesto in delovnaMesta)
{
context.DelovnaMesta.Add(mesto);
}
context.SaveChanges();
var zaposlitve = new Zaposlitve[] {
new Zaposlitve {
ZaposlenID = 1, DelovnaMestaID = 420, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 2, DelovnaMestaID = 123, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 3, DelovnaMestaID = 420, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 4, DelovnaMestaID = 231, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 5, DelovnaMestaID = 666, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 6, DelovnaMestaID = 222, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
new Zaposlitve {
ZaposlenID = 7, DelovnaMestaID = 420, DatumZaposlitve = DateTime.Parse("2019-09-01")
},
};
foreach (Zaposlitve zap in zaposlitve)
{
context.Zaposlitve.Add(zap);
}
context.SaveChanges();
var hasher = new PasswordHasher <Uporabniki>();
Zaposlen zapAdmin = new Zaposlen {
Ime = "admin", Priimek = "admin", Naslov = "Cesta pod goro 69", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž", Kadrovanje = true
};
String pass = hasher.HashPassword(null, "Admin123!");
context.Zaposleni.Add(zapAdmin);
Uporabniki upoAdmin = new Uporabniki {
UserName = "******", NormalizedUserName = "******", NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", PasswordHash = pass, Zaposlen = zapAdmin
};
context.Users.Add(upoAdmin);
Zaposlen zapWorker = new Zaposlen {
Ime = "Jaka", Priimek = "Novak", Naslov = "Tvoja mt planina", Telefon = 420420420, DatumRojstva = DateTime.Parse("2019-09-01"), Spol = "Ž", Kadrovanje = false
};
String pass2 = hasher.HashPassword(null, "Admin123!");
context.Zaposleni.Add(zapWorker);
Uporabniki upoWorker = new Uporabniki {
UserName = "******", NormalizedUserName = "******", NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", PasswordHash = pass2, Zaposlen = zapWorker
};
context.Users.Add(upoWorker);
var roleAdmin = new IdentityUserRole <string> {
UserId = upoAdmin.Id, RoleId = adminRole.Id
};
var roleWorker = new IdentityUserRole <string> {
UserId = upoWorker.Id, RoleId = workerRole.Id
};
context.UserRoles.Add(roleAdmin);
context.UserRoles.Add(roleWorker);
context.SaveChanges();
}
