protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Stranke";
if (!Master.Uporabnik.Pravice.Contains("stranke"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_stranke"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "acShortTitle asc";
}
}
else
{
Session["sort_stranke"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_stranke"]) ?? "";
DataTable dt = Stranke.Get_d();
if (dt.Rows.Count > 0)
{
if (Request.QueryString["a"] == "csv")
{
Response.Clear();
byte[] csv = Encoding.Default.GetBytes(Splosno.Csv(dt, "stranke"));
Response.ContentType = "application/csv; name=Stranke.csv";
Response.AddHeader("content-transfer-encoding", "binary");
Response.AddHeader("Content-Disposition", "attachment; filename=Stranke.csv");
Response.OutputStream.Write(csv, 0, csv.Length);
Response.Flush();
Response.End();
}
else
{
r_stranke.DataSource = dt.Select("", _sort).CopyToDataTable();
r_stranke.DataBind();
}
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Aplikacije";
Master.Title = "Aplikacije";
if (!Master.Uporabnik.Pravice.Contains("naprave"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
_id = Convert.ToInt32(Request.QueryString["id"] ?? "0");
_DevID = Request.QueryString["DevID"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_naprave"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "acTitle asc";
}
}
else
{
Session["sort_naprave"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_naprave"]) ?? "";
DataTable dt = Devices.Get_d();
if (dt.Rows.Count > 0)
{
if (Request.QueryString["a"] == "csv")
{
Response.Clear();
byte[] csv = Encoding.Default.GetBytes(Splosno.Csv(dt, "Aplikacije"));
Response.ContentType = "application/csv; name=Aplikacije.csv";
Response.AddHeader("content-transfer-encoding", "binary");
Response.AddHeader("Content-Disposition", "attachment; filename=Aplikacije.csv");
Response.OutputStream.Write(csv, 0, csv.Length);
Response.Flush();
Response.End();
}
if (Request.QueryString["a"] == "batch")
{
//new Thread(Skulpture.PosljiPodatke).Start();
}
if (Request.QueryString["a"] == "pdf")
{
//DateTime datum_racuna = DateTime.Now;
//List<byte[]> pdfs = new List<byte[]>();
//int c = 0;
//foreach (DataRow r in dt.Select("", "priimek,ime"))
//{
// if (c++ > 10) break;
// if (Convert.ToBoolean(r["aktiven"]))
// {
// Response furs_response = new Response();
// string stranka_naziv = Convert.ToString(r["ime"]) + " " + Convert.ToString(r["priimek"]);
// string stranka_naslov = Convert.ToString(r["naslov"]);
// string stranka_posta = Convert.ToString(r["posta"]);
// string stranka_kraj = Convert.ToString(r["kraj"]);
// string stranka_email = Convert.ToString(r["email"]);
// int id_racun = Racuni.Izdaj(0, "gotovinski", "elektronski_racun", datum_racuna, datum_racuna, datum_racuna, "INT", "ONL", "", "", "", Master.Uporabnik.Username, Master.Uporabnik.Davcna, stranka_naziv, stranka_naslov, stranka_kraj, stranka_posta, stranka_email, "", "", new List<Racuni.Vrstica>(new Racuni.Vrstica[] { new Racuni.Vrstica("Letna dovolilnica " + Master.Date.Year, 22, 40.98, 0, "0", 1, "") }), 0, false, false, out furs_response);
// pdfs.Add(Racuni.GetPdf(id_racun, false));
// }
//}
//pdfs.Reverse();
//Response.Clear();
//byte[] pdf = (byte[])Pdf.GeneratePdf(pdfs);
//Response.ContentType = "application/csv; name=LetneDovolilnice.pdf";
//Response.AddHeader("content-transfer-encoding", "binary");
//Response.AddHeader("Content-Disposition", "attachment; filename=LetneDovolilnice.pdf");
//Response.OutputStream.Write(pdf, 0, pdf.Length);
//Response.Flush();
//Response.End();
}
else
{
r_naprave.DataSource = dt.Select("", _sort).CopyToDataTable();
r_naprave.DataBind();
}
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
// POST api/<controller>
public HttpResponseMessage Post(HttpRequestMessage request)
{
var response = Request.CreateResponse(HttpStatusCode.OK);
string lresponse = "";
HttpSessionState s = null;
try
{
string lx = request.Content.ReadAsStringAsync().Result;
byte[] data = Convert.FromBase64String(lx);
JObject j_req = JObject.Parse(Encoding.UTF8.GetString(data));
string _req_type = j_req["req_type"].ToString().ToUpper();
if (_req_type == "LOGIN")
{
string _req_data = "";
string lUserName = "";
string lPassword = "";
string lDeviceID = "";
int lForceLogin = 0;
try
{
_req_data = j_req["req_data"].ToString();
if (!String.IsNullOrEmpty(_req_data))
{
JObject jo = JObject.Parse(_req_data);
lUserName = Convert.ToString(jo["acUserName"]);
lPassword = Convert.ToString(jo["acPassword"]);
lDeviceID = Convert.ToString(jo["acDevID"]);
lForceLogin = Convert.ToInt32(jo["anForceLogin"]);
}
Uporabnik lUporabnik = new Uporabnik();
string lRsp = lUporabnik.login(lUserName, lPassword, lDeviceID, lForceLogin, 0, "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lRsp));
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, 99999, exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
response.Content = new StringContent(lresponse, Encoding.UTF8, "application/json");
}
else if (_req_type == "LOGOUT")
{
string _req_data = j_req["req_data"].ToString();
int lUserID = 0;
string lSessionID = "";
string lDeviceID = "";
int lForceLogin = 0;
if (!String.IsNullOrEmpty(_req_data))
{
JObject jo = JObject.Parse(_req_data);
lUserID = Convert.ToInt32(jo["anUserID"]);
lSessionID = Convert.ToString(jo["acSessionID"]);
lDeviceID = Convert.ToString(jo["acDevID"]);
}
Uporabnik lUporabnik = new Uporabnik();
lUporabnik.logout(lUserID, lSessionID, s, lDeviceID);
lUporabnik.Dispose();
String lRsp = Splosno.AddHeadDataToResponseData(0, 0, "", "");
string ldata = Convert.ToBase64String(Encoding.UTF8.GetBytes(lRsp));
response.Content = new StringContent(ldata, Encoding.UTF8, "application/json");
}
else if (_req_type == "REGISTRATION")
{
string _req_data = "";
string lUserName = "";
string lPassword = "";
string lDeviceID = "";
string lName = "";
string lEmail = "";
string lUserRights = "";
try
{
_req_data = j_req["req_data"].ToString();
if (!String.IsNullOrEmpty(_req_data))
{
JObject jo = JObject.Parse(_req_data);
lUserName = Convert.ToString(jo["acUserName"]);
lPassword = Convert.ToString(jo["acPassword"]);
lDeviceID = Convert.ToString(jo["acDevID"]);
lName = Convert.ToString(jo["acName"]);
lEmail = Convert.ToString(jo["acEmail"]);
lUserRights = Convert.ToString(jo["acUserRights"]);
}
Uporabnik lUporabnik = new Uporabnik();
string lRsp = lUporabnik.Registration(lUserName, lPassword, lDeviceID, lName, lEmail, lUserRights, 0, "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lRsp));
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, 99999, exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
response.Content = new StringContent(lresponse, Encoding.UTF8, "application/json");
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotImplemented);
}
}
catch (Exception exception)
{
response = Request.CreateResponse(HttpStatusCode.ExpectationFailed);
}
return(response);
}
public void SetMessage(string title, string message, string type, string js)
{
if (!string.IsNullOrEmpty(title) || !string.IsNullOrEmpty(message))
{
_js += "dialog(\"" + title.Replace("\n", "<br />").Replace("\r", "") + "\",\"" + Splosno.JsSafe(message) + "\",\"" + type + "\");" + js;
}
}
// POST api/<controller>
public HttpResponseMessage Post(HttpRequestMessage request)
{
var response = Request.CreateResponse(HttpStatusCode.OK);
string lresponse = "";
try
{
string lx = request.Content.ReadAsStringAsync().Result;
byte[] data = Convert.FromBase64String(lx);
JObject j_req = JObject.Parse(Encoding.UTF8.GetString(data));
string _req_type = j_req["req_type"].ToString().ToUpper();
if (_req_type == "GET")
{
string _req_data = "";
int anID = 0;
string lDeviceID = "";
try
{
_req_data = j_req["req_data"].ToString();
if (!String.IsNullOrEmpty(_req_data))
{
JObject jo = JObject.Parse(_req_data);
anID = Convert.ToInt32(jo["anID"]);
lDeviceID = Convert.ToString(jo["acDevID"]);
}
List <Devices.Device> lDevices;
if (anID > 0)
{
lDevices = Devices.Get(anID, "");
}
else
{
lDevices = Devices.Get(0, lDeviceID);
}
string ldata = JsonConvert.SerializeObject(lDevices);
lresponse = Splosno.AddHeadDataToResponseData(0, 0, "", ldata);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, 99999, exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
response.Content = new StringContent(lresponse, Encoding.UTF8, "application/json");
}
else if (_req_type == "POST")
{
string _req_data = "";
try
{
JObject jo = null;
_req_data = j_req["req_data"].ToString();
if (!String.IsNullOrEmpty(_req_data))
{
jo = JObject.Parse(_req_data);
Devices.Device lDevice = new Devices.Device
{
Id = 0,
acDevID = (string)jo["acDevID"],
acTitle = (string)jo["acTitle"],
adInsetDate = DateTime.Now,
anUserIns = 99999,
acBT_Name = (string)jo["acBT_Name"],
acEmail = Convert.ToString(jo["acEmail"]),
adModificationDate = DateTime.Now,
anUserMod = 99999
};
Devices.Upload(lDevice);
lresponse = Splosno.AddHeadDataToResponseData(0, 0, "", "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
else
{
lresponse = Splosno.AddHeadDataToResponseData(0, Convert.ToInt32(HttpStatusCode.BadRequest), "BadRequest", "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, 99999, exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
response.Content = new StringContent(lresponse, Encoding.UTF8, "application/json");
}
else if (_req_type == "DELETE")
{
string _req_data = "";
int anID = 0;
try
{
_req_data = j_req["req_data"].ToString();
if (!String.IsNullOrEmpty(_req_data))
{
JObject jo = JObject.Parse(_req_data);
anID = Convert.ToInt32(jo["anID"]);
List <Devices.Device> lDevices = Devices.Get(anID, "");
if (lDevices.Count > 0)
{
Devices.Delete(lDevices[0]);
}
lresponse = Splosno.AddHeadDataToResponseData(0, 0, "", "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
else
{
lresponse = Splosno.AddHeadDataToResponseData(0, Convert.ToInt32(HttpStatusCode.BadRequest), "BadRequest", "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, 99999, exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
}
else
{
lresponse = Splosno.AddHeadDataToResponseData(0, Convert.ToInt32(HttpStatusCode.NotImplemented), "NotImplemented", "");
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
}
catch (Exception exception)
{
lresponse = Splosno.AddHeadDataToResponseData(0, Convert.ToInt32(HttpStatusCode.ExpectationFailed), exception.ToString(), lresponse);
lresponse = Convert.ToBase64String(Encoding.UTF8.GetBytes(lresponse));
}
return(response);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
HttpCookie c = Request.Cookies["hash"];
using (Uporabnik user = new Uporabnik(Session))
{
string action = Request.QueryString["action"] ?? "";
#region logout
if (action == "logout")
{
if (c != null)
{
Response.Cookies["hash"].Expires = DateTime.Now.AddDays(-1);
}
user.logout(user.Id, null, Session, "");
Response.Redirect("Default.aspx", true);
}
#endregion
if (!user.LoggedIn && (Request.HttpMethod == "POST" || c != null))
{
string u = username.Text.Trim();
string p = password.Text.Trim();
bool r = remember.Checked;
_ForceLogin = 1;
if (Request.HttpMethod != "POST")
{
#region cookie
string c_username = "";
string c_password = "";
if (c != null && !string.IsNullOrEmpty(c.Value))
{
try
{
string[] c_hash = Varnost.DecryptAES256(c.Value).Split(new string[] { "@-|@|-@" }, StringSplitOptions.None);
if (c_hash.Length == 3 && c_hash[2] == ConfigurationManager.AppSettings["EncryptKey"])
{
c_username = c_hash[0].Trim();
c_password = c_hash[1].Trim();
}
else
{
throw new Exception();
}
}
catch
{
Response.Cookies["hash"].Expires = DateTime.Now.AddDays(-1);
Response.Redirect("Default.aspx", true);
}
}
if (string.IsNullOrEmpty(u))
{
u = c_username;
}
if (string.IsNullOrEmpty(p))
{
p = c_password;
}
#endregion
}
if (string.IsNullOrEmpty(u) || string.IsNullOrEmpty(p))
{
_error = "Uporabniško ime in geslo ne smejo biti prazni";
}
else
{
int lLoginResp = Uporabnik.login(u, p, Session, "", 1);
if (lLoginResp == 0)
{
if (r)
{
Response.Cookies["hash"].Value = Varnost.EncryptAES256(u + "@-|@|-@" + p + "@-|@|-@" + ConfigurationManager.AppSettings["EncryptKey"]);
Response.Cookies["hash"].Expires = DateTime.Now.AddDays(30);
}
else if (Request.HttpMethod == "POST" && c != null)
{
Response.Cookies["hash"].Expires = DateTime.Now.AddDays(-1);
}
using (Uporabnik uporabnik = new Uporabnik(Session))
{
if (uporabnik.Pravice.Contains("pregled"))
{
Response.Redirect("Pregled.aspx", true);
}
else if (uporabnik.Pravice.Contains("ostalo"))
{
Response.Redirect("Ostalo.aspx", true);
}
else
{
Response.Redirect("Osebno.aspx", true);
}
}
}
else
{
_error = Splosno.GetTranslateByID(lLoginResp);
}
}
}
else if (user.LoggedIn)
{
Response.Redirect("Pregled.aspx", true);
}
}
}
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 = "Nastavitve";
if (!Master.Uporabnik.Pravice.Contains("nastavitve"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
if (IsPostBack)
{
try
{
naziv.Text = naziv.Text.Trim();
naziv_dolg.Text = naziv_dolg.Text.Trim();
telefon.Text = telefon.Text.Trim();
email.Text = email.Text.Trim();
naslov.Text = naslov.Text.Trim();
spletna_stran.Text = spletna_stran.Text.Trim();
izdajatelj.Text = izdajatelj.Text.Trim();
davcna.Text = davcna.Text.Trim();
trr.Text = trr.Text.Trim();
banka.Text = banka.Text.Trim();
klen_uporabnik.Text = klen_uporabnik.Text.Trim();
klen_geslo.Text = klen_geslo.Text.Trim();
List <string> l_obvescanje = new List <string>();
if (!string.IsNullOrWhiteSpace(obvescanje.Text))
{
foreach (var item in obvescanje.Text.Split(','))
{
string s_obvescanje = Splosno.OnlyNumeric(item);
s_obvescanje = "+386" + s_obvescanje.Substring(s_obvescanje.Length - 8);
if (!l_obvescanje.Contains(s_obvescanje))
{
l_obvescanje.Add(s_obvescanje);
}
}
}
obvescanje.Text = string.Join(",", l_obvescanje);
List <string> l_povzetek = new List <string>();
if (!string.IsNullOrWhiteSpace(povzetek.Text))
{
foreach (var item in povzetek.Text.Split(','))
{
string s_povzetek = Splosno.OnlyNumeric(item);
s_povzetek = "+386" + s_povzetek.Substring(s_povzetek.Length - 8);
if (!l_povzetek.Contains(s_povzetek))
{
l_povzetek.Add(s_povzetek);
}
}
}
povzetek.Text = string.Join(",", l_povzetek);
List <string> l_promet = new List <string>();
if (!string.IsNullOrWhiteSpace(promet.Text))
{
foreach (var item in promet.Text.Split(','))
{
string s_promet = Splosno.OnlyNumeric(item);
s_promet = "+386" + s_promet.Substring(s_promet.Length - 8);
if (!l_promet.Contains(s_promet))
{
l_promet.Add(s_promet);
}
}
}
promet.Text = string.Join(",", l_promet);
List <string> l_kvote = new List <string>();
if (!string.IsNullOrWhiteSpace(kvote.Text))
{
foreach (var item in kvote.Text.Split(','))
{
string s_kvote = Splosno.OnlyNumeric(item);
s_kvote = "+386" + s_kvote.Substring(s_kvote.Length - 8);
if (!l_kvote.Contains(s_kvote))
{
l_kvote.Add(s_kvote);
}
}
}
kvote.Text = string.Join(",", l_kvote);
if (string.IsNullOrWhiteSpace(naziv.Text))
{
throw new Exception("Polje Naziv ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(naziv_dolg.Text))
{
throw new Exception("Polje Dolgi naziv ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(naslov.Text))
{
throw new Exception("Polje Naslov ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(telefon.Text))
{
throw new Exception("Polje Telefon ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(email.Text))
{
throw new Exception("Polje Elektronska pošta ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(spletna_stran.Text))
{
throw new Exception("Polje Spletna stran ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(izdajatelj.Text))
{
throw new Exception("Polje Glava računa ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(trr.Text))
{
throw new Exception("Polje TRR ne sme biti prazno");
}
if (string.IsNullOrWhiteSpace(banka.Text))
{
throw new Exception("Polje Banka ne sme biti prazno");
}
if (davcna.Text.Length != 8)
{
throw new Exception("Polje Davcna mora biti dolga 8 znakov");
}
int i_davcna;
if (!int.TryParse(davcna.Text, out i_davcna))
{
throw new Exception("Polje Davcna mora biti številka");
}
//string _klen_geslo = Convert.ToString(Nastavitve.Get().Rows[0]["klen_geslo"]);
//if (!string.IsNullOrWhiteSpace(klen_geslo.Text)) _klen_geslo = klen_geslo.Text;
//if (string.IsNullOrWhiteSpace(klen_uporabnik.Text)) _klen_geslo = "";
Nastavitve.Naziv = naziv.Text;
Nastavitve.NazivDolg = naziv_dolg.Text;
Nastavitve.Telefon = telefon.Text;
Nastavitve.EmailFrom = email.Text;
Nastavitve.Naslov = naslov.Text;
Nastavitve.SpletnaStran = spletna_stran.Text;
Nastavitve.Zavezanec = zavezanec.Checked ? 1:0;
Nastavitve.Trr = trr.Text;
Nastavitve.Banka = banka.Text;
Nastavitve.Davcna = davcna.Text;
Nastavitve.Osvezevanje = osvezevanje.Checked ? 1:0;
Response.Redirect("Nastavitve.aspx?msg=" + HttpUtility.UrlEncode("Podatki shranjeni"));
}
catch (Exception er)
{
msg = er.Message + "<br />";
}
}
naziv.Text = Nastavitve.Naziv;
naziv_dolg.Text = Nastavitve.NazivDolg;
telefon.Text = Nastavitve.Telefon;
email.Text = Nastavitve.EmailFrom;
naslov.Text = Nastavitve.Naslov;
spletna_stran.Text = Nastavitve.SpletnaStran;
zavezanec.Checked = Nastavitve.Zavezanec == 1;
trr.Text = Nastavitve.Trr;
banka.Text = Nastavitve.Banka;
davcna.Text = Nastavitve.Davcna;
// obvescanje.Text = Nastavitve.Obvescanje == 1;
osvezevanje.Checked = Nastavitve.Osvezevanje == 1;
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
