public ActionResult produzi(int id)
{
mssql s = new mssql();
Ugovor u = s.Ugovor.SingleOrDefault(x => x.Id == id);
u.produzenje = true;
u.boja = "crimson";
s.SaveChanges();
Produzenja p = new Produzenja();
p.UgovorId = id;
p.DatumZahtjeva = p.DatumRealizacije = DateTime.Now;
s.Produzenja.Add(p);
s.SaveChanges();
var user = Session["admin"] as Admin;
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.AdminId = user.Id;
l.Poruka = "Ugovor id: " + u.Id + ", Produzen";
s.AdminLog.Add(l);
s.SaveChanges();
return(RedirectToAction("KlijentPanel", "Klijent"));
}
public ActionResult VpsPaketiDodaj()
{
mssql s = new mssql();
ViewData["s"] = s.Serveri.ToList();
return(View("VpsPaketiDodaj"));
}
public ActionResult DostupneIPDodaj()
{
mssql s = new mssql();
ViewData["IP"] = s.DostupneIP.ToList();
return(View("DostupneIPDodaj"));
}
public ActionResult Aktiviraj(int id)
{
mssql s = new mssql();
Ugovor u = s.Ugovor.SingleOrDefault(x => x.Id == id);
u.DatumOdobrenja = DateTime.Now;
if (u.VpsPaketiId != null || u.DedicatedPaketiId != null)
{
u.DatumVazenja = DateTime.Now.AddMonths(1);
}
else
{
u.DatumVazenja = DateTime.Now.AddYears(1);
}
u.StatusId = 3;
u.boja = "aqua";
s.SaveChanges();
var user = Session["admin"] as Admin;
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.AdminId = user.Id;
l.Poruka = "Ugovor id: " + u.Id + ", Aktiviran ";
s.AdminLog.Add(l);
s.SaveChanges();
return(RedirectToAction("Index", "ugovor"));
}
public ActionResult Dodaj()
{
mssql s = new mssql();
ViewData["g"] = s.Grad.ToList();
return(View("Dodaj"));
}
public ActionResult Provjera(string username, string password)
{
mssql s = new mssql();
Admin a = s.Admin.SingleOrDefault(x => x.Email == username && x.Password == password && x.Izbrisan == false);
if (a == null)
{
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.Poruka = "Logiranje ne postoji korisnik username: "******", password: "******"Login"));
}
else
{
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.AdminId = a.Id;
l.Poruka = "Logiranje.";
s.AdminLog.Add(l);
s.SaveChanges();
Session["admin"] = new Admin()
{
Ime = a.Ime, Prezime = a.Prezime, Id = a.Id, AdminHead = a.AdminHead
};
return(RedirectToAction("Index"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["userInfo"] == null)
{
Response.Redirect("/Home/Login");
}
if (!IsPostBack)
{
int idPokupi = Int32.Parse(Request.QueryString["id"]);
mssql s = new mssql();
List <UlazSkidanje> u = s.UlazSkidanje.Where(x => x.Id == idPokupi).ToList();
List <UlazSkidanjeProizvodVM> usp = s.UlazSkidanjeProizvod.Include("Proizvod").Include("Proizvod.Klasa").Where(x => x.UlazSkidanjeId == idPokupi).Select(x => new UlazSkidanjeProizvodVM()
{
Datum = x.Datum,
Id = x.Id,
Kolicina = x.Kolicina,
PlaniranaKolicina = x.PlaniranaKolicina,
Debljina = x.Proizvod.Visina.ToString(),
Sirina = x.Proizvod.Sirina.ToString(),
Duzina = x.Proizvod.Duzina.ToString(),
Klasa = x.Proizvod.Klasa.Naziv,
Naziv = x.Proizvod.Naziv
}).ToList();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet", u));
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", usp));
ReportViewer1.LocalReport.ReportPath = Server.MapPath("") + "/RadniNalog.rdlc";
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
public ActionResult RackDodaj()
{
mssql s = new mssql();
ViewData["r"] = s.Rack.ToList();
return(View("RackDodaj"));
}
// GET: Log
public ActionResult Index()
{
mssql sql = new mssql();
ViewData["logs"] = sql.log.OrderByDescending(x => x.Id).Take(100).ToList();
return(View());
}
public ActionResult ServeriSnimi(string Paket, string CPU, string RAM, string HDD, string On, int IP, int Rack)
{
mssql s = new mssql();
Serveri srv = new Serveri();
srv.Naziv = Paket;
srv.CPU = CPU;
srv.RAM = RAM;
srv.HDD = HDD;
if (On == "On")
{
srv.OnOf = true;
}
else
{
srv.OnOf = false;
}
srv.DostupneIPId = IP;
srv.RackId = Rack;
s.Serveri.Add(srv);
s.SaveChanges();
return(RedirectToAction("index", "Admin"));
}
public ActionResult pregled()
{
mssql s = new mssql();
ViewData["d"] = s.DedicatedPaketi.Where(x => x.Deaktivirano == false).ToList();
return(View("pregled"));
}
public ActionResult DedicatedPaketiSnimi(string Paket, string CPU, string RAM, string HDD, string SHDD, string OS, string Promet, string IPV4, string IPV6, string Nadogradnja, double Cijena, int Server)
{
mssql s = new mssql();
DedicatedPaketi d = new DedicatedPaketi();
d.Naziv = Paket;
d.CPU = CPU;
d.Ram = RAM;
d.HDDPrimar = HDD;
d.HDDSekundar = SHDD;
d.OS = OS;
d.Promet = Promet;
d.IPv4 = IPV4;
d.IPv6 = IPV6;
if (Nadogradnja == "on")
{
d.Nadogradnja = true;
}
else
{
d.Nadogradnja = false;
}
d.ServeriId = Server;
d.Cijena = Cijena;
s.DedicatedPaketi.Add(d);
s.SaveChanges();
return(RedirectToAction("index", "Admin"));
}
public ActionResult FizickoDodaj(string Domena, int?DomenePaketiId, int?sslid, int?vpsid, int?did, int?hid)
{
mssql s = new mssql();
ViewData["g"] = s.Grad.ToList();
if (DomenePaketiId != null)
{
ViewData["Domena"] = Domena;
ViewData["DomenePaketiId"] = DomenePaketiId;
}
if (sslid != null)
{
ViewData["Domena"] = Domena;
ViewData["sslid"] = sslid;
}
if (vpsid != null)
{
ViewData["vpsid"] = vpsid;
}
if (did != null)
{
ViewData["did"] = did;
}
if (hid != null)
{
ViewData["hid"] = hid;
ViewData["Domena"] = Domena;
}
return(View("FizickoLice"));
}
public ActionResult DomenePaketiDodaj()
{
mssql s = new mssql();
ViewData["d"] = s.Domena.Where(x => x.Deaktiviran == false).ToList();
return(View("DomenePaketiDodaj"));
}
public ActionResult ProduziUslugu(int id)
{
mssql s = new mssql();
Ugovor u = s.Ugovor.SingleOrDefault(x => x.Id == id);
u.produzenje = false;
u.boja = "aqua";
if (u.VpsPaketiId != null || u.DedicatedPaketiId != null)
{
u.DatumVazenja = DateTime.Now.AddMonths(1);
}
else
{
u.DatumVazenja = DateTime.Now.AddYears(1);
}
s.SaveChanges();
Produzenja p = s.Produzenja.Where(x => x.UgovorId == id).OrderByDescending(x => x.Id).First();
p.DatumRealizacije = DateTime.Now;
s.SaveChanges();
var user = Session["admin"] as Admin;
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.AdminId = user.Id;
l.Poruka = "Ugovor id: " + u.Id + ", Produzenje";
s.AdminLog.Add(l);
s.SaveChanges();
return(RedirectToAction("Index", "Admin"));
}
public ActionResult editSSL(int id)
{
mssql m = new mssql();
ViewData["ssl"] = m.SSLPaketi.SingleOrDefault(x => x.Id == id);
return(View("edit"));
}
// GET: Korisnik
public ActionResult Index()
{
mssql sql = new mssql();
ViewData["usr"] = sql.User.ToList();
return(View());
}
public ActionResult HostingPaketiSnimi(string Paket, string Prostor, string Promet, string Baza, string EmailAdresa, string Cijena, string IPV4, string IPV6, int AddonDomena, int ParkedDomena, string FTPNalog, string PodDomena, int Server)
{
mssql s = new mssql();
HostingPaketi h = new HostingPaketi();
h.NazivPaketa = Paket;
h.Prostor = Prostor;
h.Promet = Promet;
h.Baza = Baza;
h.EmailAdresa = EmailAdresa;
h.Cijena = Cijena;
h.IPv4 = IPV4;
h.IPv6 = IPV6;
h.AddonDomene = AddonDomena;
h.ParkedDomene = ParkedDomena;
h.FTPNaloga = FTPNalog;
h.PodDomena = PodDomena;
h.ServeriId = Server;
h.Aktivan = true;
s.HostingPaketi.Add(h);
s.SaveChanges();
return(RedirectToAction("index", "Admin"));
}
public ActionResult GradDodaj()
{
mssql s = new mssql();
ViewData["k"] = s.Kanton.ToList();
return(View("GradDodaj"));
}
public ActionResult Kreiraj(TiketiEditViewModel tevm)
{
if (!ModelState.IsValid)
{
return(View("Novi", tevm));
}
var user = Session["user"] as Klijenti;
mssql s = new mssql();
Tiketi t = new Tiketi();
t.Naslov = tevm.Naslov;
t.Datum = DateTime.Now;
t.KlijentiId = user.Id;
t.Zavrsen = false;
t.Odgovoreno = false;
s.Tiketi.Add(t);
s.SaveChanges();
Poruke p = new Poruke();
p.Datum = DateTime.Now;
p.Sadrzaj = tevm.Poruka;
p.TiketiId = s.Tiketi.Single(x => x.Naslov == tevm.Naslov && x.KlijentiId == user.Id && x.Zavrsen == false).Id;
s.Poruke.Add(p);
s.SaveChanges();
return(View("Novi"));
}
public ActionResult KantonDodaj()
{
mssql s = new mssql();
ViewData["d"] = s.Drzave.ToList();
return(View("KantonDodaj"));
}
public ActionResult Promjeni(int uid, int status)
{
mssql s = new mssql();
Ugovor u = s.Ugovor.SingleOrDefault(x => x.Id == uid);
u.StatusId = status;
if (status == 2)
{
u.boja = "coral";
}
if (status == 4)
{
u.boja = "indianred";
}
s.SaveChanges();
var user = Session["admin"] as Admin;
AdminLog l = new AdminLog();
l.Datum = DateTime.Now;
l.Hidden = false;
l.IP = Request.UserHostAddress + " " + Request.UserHostName + " " + Request.Browser.Browser;
l.AdminId = user.Id;
l.Poruka = "Ugovor id: " + u.Id + ", status " + u.Status.Naziv;
s.AdminLog.Add(l);
s.SaveChanges();
return(RedirectToAction("Index", "ugovor"));
}
public ActionResult Pretraga(string I, string P)
{
mssql s = new mssql();
ViewData["status"] = s.Status.ToList();
if (I != "" && P != "")
{
List <Ugovor> u = new List <Ugovor>(s.Ugovor.Where(x => x.Hidden == false && x.Klijenti.Ime == I && x.Klijenti.Prezime == P).OrderByDescending(x => x.DatumKreiranjaZahtjeva)
.Include(x => x.Klijenti)
.Include(x => x.Status)
.Include(x => x.SSLPaketi)
.Include(x => x.HostingPaketi)
.Include(x => x.DedicatedPaketi)
.Include(x => x.VpsPaketi)
.Include(x => x.Domena)
.Include(x => x.Domena.Domena)
.OrderBy(x => x.DatumVazenja)
);
ViewData["u"] = u;
return(View("index"));
}
if (I == "" && P != "")
{
List <Ugovor> u = new List <Ugovor>(s.Ugovor.Where(x => x.Hidden == false && x.Klijenti.Prezime == P).OrderByDescending(x => x.DatumKreiranjaZahtjeva)
.Include(x => x.Klijenti)
.Include(x => x.Status)
.Include(x => x.SSLPaketi)
.Include(x => x.HostingPaketi)
.Include(x => x.DedicatedPaketi)
.Include(x => x.VpsPaketi)
.Include(x => x.Domena)
.Include(x => x.Domena.Domena)
.OrderBy(x => x.DatumVazenja)
);
ViewData["u"] = u;
return(View("index"));
}
if (I != "" && P == "")
{
List <Ugovor> u = new List <Ugovor>(s.Ugovor.Where(x => x.Hidden == false && x.Klijenti.Ime == I).OrderByDescending(x => x.DatumKreiranjaZahtjeva)
.Include(x => x.Klijenti)
.Include(x => x.Status)
.Include(x => x.SSLPaketi)
.Include(x => x.HostingPaketi)
.Include(x => x.DedicatedPaketi)
.Include(x => x.VpsPaketi)
.Include(x => x.Domena)
.Include(x => x.Domena.Domena)
.OrderBy(x => x.DatumVazenja)
);
ViewData["u"] = u;
return(View("index"));
}
if (I == "" && P == "")
{
return(RedirectToAction("index"));
}
return(RedirectToAction("index"));
}
public ActionResult pregled()
{
mssql m = new mssql();
List <SSLPaketi> sslp = m.SSLPaketi.Where(x => x.Deaktivirano == false).ToList();
ViewData["s"] = sslp;
return(View("pregled"));
}
public ActionResult edit(int id)
{
mssql s = new mssql();
ViewData["h"] = s.HostingPaketi.SingleOrDefault(x => x.Id == id);
ViewData["s"] = s.Serveri.ToList();
return(View("edit"));
}
public ActionResult pregled()
{
mssql m = new mssql();
List <HostingPaketi> h = m.HostingPaketi.Where(x => x.Aktivan == true).ToList();
ViewData["h"] = h;
return(View());
}
public ActionResult Edit(int id)
{
mssql sql = new mssql();
serveriPonuda sp = sql.serveriPonuda.Single(x => x.Id == id);
ViewData["sp"] = sp;
return(View("Edit"));
}
public ActionResult Pregled()
{
mssql sql = new mssql();
List <serveriPonuda> srv = sql.serveriPonuda.ToList();
ViewData["srv"] = srv;
return(View("Pregled"));
}
public ActionResult pregled()
{
mssql m = new mssql();
List <VpsPaketi> v = m.VpsPaketi.Where(x => x.Deaktiviran == false).ToList();
ViewData["v"] = v;
return(View("pregled"));
}
public ActionResult DodajPristupnePodatke(int id)
{
mssql s = new mssql();
ViewData["u"] = s.Ugovor.SingleOrDefault(x => x.Id == id);
return(View("DodajPristupnePodatke"));
}
