private static void ClearItemsList()
{
Countrys.Clear();
Citys.Clear();
Bitrate.Clear();
Genres.Clear();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Ostalo";
if (!Master.Uporabnik.Pravice.Contains("ostalo"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
//_prihodkiodhodki_znesek = Convert.ToDouble(PrihodkiOdhodki.GetSkupaj(Master.Date).Rows[0]["znesek"]);
//_osnovnasredstva_znesek = OsnovnaSredstva.GetSkupaj(Master.Date);
_uporabniki_stetje = Uporabniki.Get().Rows.Count;
_countrys_stetje = Countrys.Get_d().Rows.Count;
_posts_stetje = Posts.Get_d().Rows.Count;
_stranke_stetje = Stranke.Get_d().Rows.Count;
//_artikli_stetje = Artikli.Get("").Rows.Count;
_subtypes_stetje = SubTypes.Get_d().Rows.Count;
//_sporocila_stetje = Sporocila.Get().Rows.Count;
//_posi_stetje = Posi.Get().Rows.Count;
//poslovni_prostori_stetje = PoslovniProstori.Get().Rows.Count;
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
private static void FillAllItemsList()
{
ClearItemsList();
foreach (var s in CounList)
{
var item = new ListItem {
AdditionalProperties = { [NAME] = s }
};
item.SetLabel("Name", "[Country." + s + "]");
if (SelectedCountrys.Contains(s))
{
item.Selected = true;
}
Countrys.Add(item);
}
Refresh(Countrys);
foreach (var s in CityList)
{
var item = new ListItem {
AdditionalProperties = { [NAME] = s }
};
item.SetLabel("Name", s);
if (SelectedCitys.Contains(s))
{
item.Selected = true;
}
Citys.Add(item);
}
Refresh(Citys);
foreach (var s in BitrList)
{
var item = new ListItem {
AdditionalProperties = { [NAME] = Convert.ToInt32(s) + " kbps" }
};
item.SetLabel("Name", Convert.ToInt32(s) + " kbps");
if (SelectedBitrate.Contains(Convert.ToInt32(s) + " kbps"))
{
item.Selected = true;
}
Bitrate.Add(item);
}
Refresh(Bitrate);
foreach (var s in GenrList)
{
var item = new ListItem {
AdditionalProperties = { [NAME] = s }
};
item.SetLabel("Name", s);
if (SelectedGenres.Contains(s))
{
item.Selected = true;
}
Genres.Add(item);
}
Refresh(Genres);
}
protected void brisi_Click(object sender, EventArgs e)
{
var lData = Countrys.Get(_id)[0];
Countrys.Delete(lData);
Response.Redirect("Countrys.aspx?msg=" + HttpUtility.UrlEncode("Izbrisano"));
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Države";
if (!Master.Uporabnik.Pravice.Contains("drzave"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_countrys"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "acTitle asc";
}
}
else
{
Session["sort_countrys"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_countrys"]) ?? "";
DataTable dt = Countrys.Get_d();
if (dt.Rows.Count > 0)
{
if (Request.QueryString["a"] == "csv")
{
Response.Clear();
byte[] csv = Encoding.Default.GetBytes(Splosno.Csv(dt, "drzave"));
Response.ContentType = "application/csv; name=Stranke.csv";
Response.AddHeader("content-transfer-encoding", "binary");
Response.AddHeader("Content-Disposition", "attachment; filename=Drzave.csv");
Response.OutputStream.Write(csv, 0, csv.Length);
Response.Flush();
Response.End();
}
else
{
r_countrys.DataSource = dt.Select("", _sort).CopyToDataTable();
r_countrys.DataBind();
}
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
private void sifrant_tip_zavezanca(string acTypeID)
{
if ((acTypeID == "K") || (String.IsNullOrEmpty(acTypeID)))
{
id_za_ddv.Text = "";
}
else
{
var lc = Countrys.Get(Convert.ToInt32(drzava.SelectedValue))[0];
id_za_ddv.Text = lc.acISOCode;
}
}
public ListViewSampleViewModel(INavigationService navigationService) : base(navigationService)
{
_countrys = new Model();
_countrys.Add("satoru");
_countrys.Add("naruko");
var prop = _countrys.ObserveProperty(m => m.IsNoCountry).ToReactiveProperty();
Console.WriteLine("1 value is {0}", prop.Value);
_countrys.Del("satoru");
_countrys.Del("naruko");
Console.WriteLine("2 value is {0}", prop.Value);
_countrys.Add("satoru");
_countrys.Add("naruko");
AddCommand = new ReactiveCommand <string>();
AddCommand.Subscribe(x => Countrys.Add(x));
}
public void Seed(MoviesShopContext db)
{
//Проверка на существование БД
if ((db.Database.EnsureCreated()))
{
Countrys Country1 = new Countrys()
{
NameOfTheCountry = "Austria"
};
Countrys Country2 = new Countrys()
{
NameOfTheCountry = "USA"
};
Countrys Country3 = new Countrys()
{
NameOfTheCountry = "Russia"
};
Countrys Country4 = new Countrys()
{
NameOfTheCountry = "Germany"
};
Countrys Country5 = new Countrys()
{
NameOfTheCountry = "Great Britain"
};
Countrys Country6 = new Countrys()
{
NameOfTheCountry = "Australia "
};
db.Country.AddRange(new Countrys[] { Country1, Country2, Country3, Country4, Country5, Country6 });
db.SaveChanges();
Genre Genre1 = new Genre()
{
Title = "Драма"
};
Genre Genre2 = new Genre()
{
Title = "Боевик "
};
Genre Genre3 = new Genre()
{
Title = "Экшн"
};
Genre Genre4 = new Genre()
{
Title = "Супергеройский фильм"
};
Genre Genre5 = new Genre()
{
Title = "Комедия"
};
Genre Genre6 = new Genre()
{
Title = "Фэнтези"
};
Genre Genre7 = new Genre()
{
Title = "Триллер"
};
db.Genre.AddRange(new Genre[] { Genre1, Genre2, Genre3, Genre4, Genre5, Genre6, Genre7 });
db.SaveChanges();
Actor Actor1 = new Actor()
{
Name = "Морган Фриман", BirthDay = new System.DateTime(1986, 05, 30), Country = Country2
};
Actor Actor2 = new Actor()
{
Name = "Аль Пачино", BirthDay = new System.DateTime(1956, 04, 22), Country = Country6
};
Actor Actor3 = new Actor()
{
Name = "Кристиан Бейл", BirthDay = new System.DateTime(1937, 03, 14), Country = Country4
};
Actor Actor4 = new Actor()
{
Name = "Брэд Питт", BirthDay = new System.DateTime(1977, 02, 16), Country = Country2
};
db.Actor.AddRange(new Actor[] { Actor1, Actor2, Actor3, Actor4 });
db.SaveChanges();
User User1 = new User()
{
Loggin = "GoOd_MeN", Password = "******", Name = "Tom", Age = 25
};
User User2 = new User()
{
Loggin = "Mr*PoZitiV4iK", Password = "******", Name = "Den", Age = 15
};
User User3 = new User()
{
Loggin = "Vinni_пыххх", Password = "******", Name = "Greg", Age = 52
};
User User4 = new User()
{
Loggin = "~Master~ ", Password = "******", Name = "Tim", Age = 10
};
db.User.AddRange(new User[] { User1, User2, User3, User4 });
db.SaveChanges();
Film Film1 = new Film()
{
Title = "Побег из Шоушенка", Year = 1995, Countrys = Country2
};
Film Film2 = new Film()
{
Title = "Крёстный отец", Year = 1985, Countrys = Country1
};
Film Film3 = new Film()
{
Title = "Тёмный рыцарь", Year = 2005, Countrys = Country1
};
Film Film4 = new Film()
{
Title = "Криминальное чтиво", Year = 2001, Countrys = Country4
};
Film Film5 = new Film()
{
Title = "Властелин колец: Возвращение короля", Year = 2003, Countrys = Country5
};
Film Film6 = new Film()
{
Title = "Джокер", Year = 2019, Countrys = Country6
};
Film Film7 = new Film()
{
Title = "Бойцовский клуб", Year = 2011, Countrys = Country2
};
db.Film.AddRange(new Film[] { Film1, Film2, Film3, Film4, Film5, Film6, Film7 });
db.SaveChanges();
#region Заполнение промежиточной таблицы UserFilm
Film1.UserFilm.Add(new UserFilm {
FilmId = Film1.Id
});
Film1.UserFilm.Add(new UserFilm {
FilmId = Film2.Id
});
Film1.UserFilm.Add(new UserFilm {
FilmId = Film4.Id
});
Film2.UserFilm.Add(new UserFilm {
FilmId = Film3.Id
});
Film2.UserFilm.Add(new UserFilm {
FilmId = Film2.Id
});
Film3.UserFilm.Add(new UserFilm {
FilmId = Film1.Id
});
Film4.UserFilm.Add(new UserFilm {
FilmId = Film4.Id
});
Film5.UserFilm.Add(new UserFilm {
FilmId = Film3.Id
});
Film6.UserFilm.Add(new UserFilm {
FilmId = Film1.Id
});
Film6.UserFilm.Add(new UserFilm {
FilmId = Film4.Id
});
Film7.UserFilm.Add(new UserFilm {
FilmId = Film3.Id
});
db.SaveChanges();
#endregion
#region Заполнение промежиточной таблицы FilmActor
Film1.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
Film1.FilmActor.Add(new FilmActor {
FilmId = Film3.Id
});
Film2.FilmActor.Add(new FilmActor {
FilmId = Film2.Id
});
Film2.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
Film3.FilmActor.Add(new FilmActor {
FilmId = Film4.Id
});
Film3.FilmActor.Add(new FilmActor {
FilmId = Film2.Id
});
Film3.FilmActor.Add(new FilmActor {
FilmId = Film3.Id
});
Film4.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
Film5.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
Film5.FilmActor.Add(new FilmActor {
FilmId = Film4.Id
});
Film5.FilmActor.Add(new FilmActor {
FilmId = Film2.Id
});
Film5.FilmActor.Add(new FilmActor {
FilmId = Film3.Id
});
Film6.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
Film6.FilmActor.Add(new FilmActor {
FilmId = Film4.Id
});
Film7.FilmActor.Add(new FilmActor {
FilmId = Film1.Id
});
db.SaveChanges();
#endregion
#region Заполнение промежиточной таблицы FilmGener
Genre1.FilmGenre.Add(new FilmGenre {
GenreId = Genre1.Id
});
Genre2.FilmGenre.Add(new FilmGenre {
GenreId = Genre1.Id
});
Genre3.FilmGenre.Add(new FilmGenre {
GenreId = Genre2.Id
});
Genre3.FilmGenre.Add(new FilmGenre {
GenreId = Genre3.Id
});
Genre3.FilmGenre.Add(new FilmGenre {
GenreId = Genre4.Id
});
Genre4.FilmGenre.Add(new FilmGenre {
GenreId = Genre2.Id
});
Genre4.FilmGenre.Add(new FilmGenre {
GenreId = Genre5.Id
});
Genre5.FilmGenre.Add(new FilmGenre {
GenreId = Genre6.Id
});
Genre5.FilmGenre.Add(new FilmGenre {
GenreId = Genre3.Id
});
Genre5.FilmGenre.Add(new FilmGenre {
GenreId = Genre1.Id
});
Genre6.FilmGenre.Add(new FilmGenre {
GenreId = Genre7.Id
});
Genre6.FilmGenre.Add(new FilmGenre {
GenreId = Genre4.Id
});
Genre6.FilmGenre.Add(new FilmGenre {
GenreId = Genre1.Id
});
Genre7.FilmGenre.Add(new FilmGenre {
GenreId = Genre1.Id
});
Genre7.FilmGenre.Add(new FilmGenre {
GenreId = Genre7.Id
});
Genre7.FilmGenre.Add(new FilmGenre {
GenreId = Genre3.Id
});
db.SaveChanges();
#endregion
#region Заполнение таблицы Actors
////В 1-ой стране Актёр 1
//List<Actor> list1 = new List<Actor>();
//list1.AddRange(new Actor[] { Actor1 });
////В 2-ой стране Актёры 2 и 3
//List<Actor> list2 = new List<Actor>();
//list2.AddRange(new Actor[] { Actor2, Actor3 });
////В 3-й стране Актёр 4
//List<Actor> list3 = new List<Actor>();
//list3.AddRange(new Actor[] { Actor4 });
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Tip Zavezanca";
if (!Master.Uporabnik.Pravice.Contains("tipi_zavezancev"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_subtype"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "datum desc";
}
}
else
{
Session["sort_subtype"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_subtype"]) ?? "";
//int.TryParse(Request.QueryString["id"], out _id);
_id = Request.QueryString["id"];
if (IsPostBack)
{
#region
msg = "";
Master.SetMessage(msg);
#endregion
}
else
{
#region
foreach (var c in Countrys.Get(0))
{
drzava.Items.Add(new ListItem(c.acTitle, Convert.ToString(c.anCountryID)));
}
var lc = new List <SubTypes.SubType>();
if (!String.IsNullOrEmpty(_id))
{
lc = SubTypes.Get(0, _id);
}
if (lc.Count > 0)
{
var lData = lc[0];
naziv.Text = lData.acTitle;
TypeID.Text = (lData.acTypeID);
drzava.SelectedValue = Convert.ToString(lData.anCountryID);
brisi.Visible = true;
TypeID.ReadOnly = true;
}
else
{
TypeID.ReadOnly = false;
}
#endregion
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Stranka";
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_stranka"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "datum desc";
}
}
else
{
Session["sort_stranka"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_stranka"]) ?? "";
int.TryParse(Request.QueryString["id"], out _id);
if (IsPostBack)
{
#region
msg = "";
Master.SetMessage(msg);
#endregion
}
else
{
#region
foreach (var c in Countrys.Get(0))
{
drzava.Items.Add(new ListItem(c.acTitle, Convert.ToString(c.anCountryID)));
}
var ls = new List <Stranke.Customer>();
if (_id > 0)
{
ls = Stranke.Get(_id);
}
if (ls.Count > 0)
{
var lStranka = ls[0];
naziv.Text = lStranka.acTitle;
k_naziv.Text = lStranka.acShortTitle;
email.Text = lStranka.aceMaile;
naslov.Text = lStranka.acAddress;
drzava.SelectedValue = Convert.ToString(lStranka.anCountryID);
drzava_SelectedIndexChanged(drzava, null);
posta.SelectedValue = Convert.ToString(lStranka.anPostID);
customerCode.Text = Convert.ToString(lStranka.anCustomerID);
tip_zavezanca.SelectedValue = lStranka.acVATTypeID;
id_za_ddv.Text = lStranka.acVATPrefix;
davcna.Text = lStranka.acVATNumber;
contact.Text = lStranka.acContactName;
telefon.Text = lStranka.acTelephone;
note.Text = lStranka.acNote;
active.Checked = Convert.ToInt32(lStranka.anActive) == 1 ? true : false;
brisi.Visible = true;
//string stranka_naziv = naziv.Text;
//DataTable dt_transakcije = Stranke.GetTransakcije(stranka_naziv.ToLower());
if (Request.QueryString["a"] == "csv")
{
//Response.Clear();
//byte[] csv = Encoding.Default.GetBytes(Splosno.Csv(dt_transakcije, "stranka"));
//Response.ContentType = "application/csv; name=Stranka.csv";
//Response.AddHeader("content-transfer-encoding", "binary");
//Response.AddHeader("Content-Disposition", "attachment; filename=Stranka.csv");
//Response.OutputStream.Write(csv, 0, csv.Length);
//Response.Flush();
//Response.End();
}
else
{
for (int i = 2014; i <= DateTime.Today.Year; i++)
{
_sel_leto += "<option value=\".le" + i + "\">" + i + "</option>";
}
// r_transakcije.DataSource = dt_transakcije;
// r_transakcije.DataBind();
}
}
else
{
// For new customer
drzava.SelectedValue = "206";
drzava_SelectedIndexChanged(drzava, null);
active.Checked = true;
}
#endregion
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Pošta";
if (!Master.Uporabnik.Pravice.Contains("poste"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_post"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "datum desc";
}
}
else
{
Session["sort_post"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_post"]) ?? "";
int.TryParse(Request.QueryString["id"], out _id);
if (IsPostBack)
{
#region
msg = "";
Master.SetMessage(msg);
#endregion
}
else
{
#region
foreach (var c in Countrys.Get(0))
{
drzava.Items.Add(new ListItem(c.acTitle, Convert.ToString(c.anCountryID)));
}
var lc = new List <Posts.Post>();
if (_id > 0)
{
lc = Posts.Get(0, _id);
}
if (lc.Count > 0)
{
var lData = lc[0];
naziv.Text = lData.acTitle;
postCode.Text = Convert.ToString(lData.anPostID);
iso_code.Text = lData.acISOCode;
code.Text = lData.acCode;
drzava.SelectedValue = Convert.ToString(lData.anCountryID);
brisi.Visible = true;
}
else
{
}
#endregion
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
private void set_iso_code(string anCountryID)
{
var lc = Countrys.Get(Convert.ToInt32(anCountryID))[0];
iso_code.Text = lc.acISOCode;
}
protected void shrani_Click(object sender, EventArgs e)
{
try
{
naziv.Text = naziv.Text.Trim();
iso_code.Text = iso_code.Text.Trim();
currency.Text = currency.Text.Trim();
VATCodePrefix.Text = VATCodePrefix.Text.Trim();
if (string.IsNullOrWhiteSpace(naziv.Text))
{
throw new Exception("Polje Naziv ne sme biti prazno!");
}
if (string.IsNullOrWhiteSpace(iso_code.Text))
{
throw new Exception("Polje ISO koda ne sme biti prazno!");
}
if (string.IsNullOrWhiteSpace(currency.Text))
{
throw new Exception("Polje Valuta ne sme biti prazno!");
}
if (string.IsNullOrWhiteSpace(VATCodePrefix.Text))
{
throw new Exception("Polje Davčna predpona ne sme biti prazno!");
}
if (_id == 0)
{
var lData = new Countrys.Country(0,
Countrys.Get_MaxID() + 1,
naziv.Text,
iso_code.Text,
currency.Text,
VATCodePrefix.Text,
(isEU.Checked) ? 1 : 0,
DateTime.Now,
Master.Uporabnik.Id,
0);
Countrys.Insert(lData);
_id = lData.anCountryID;
}
else
{
var lData = Countrys.Get(_id)[0];
lData.acTitle = naziv.Text;
lData.acCurrency = currency.Text;
lData.acISOCode = iso_code.Text;
lData.acVATCodePrefix = VATCodePrefix.Text;
lData.adModificationDate = DateTime.Now;
lData.anIsEU = (isEU.Checked) ? 1 : 0;
lData.anUserMod = Master.Uporabnik.Id;
Countrys.Update(lData);
}
Response.Redirect("Country.aspx?id=" + _id + "&msg=" + HttpUtility.UrlEncode("Podatki shranjeni"));
}
catch (Exception er)
{
Master.SetMessage(er.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Master.SelectedBox = "Ostalo";
Master.Title = "Država";
if (!Master.Uporabnik.Pravice.Contains("drzave"))
{
throw new Exception("Nimate pravice!");
}
msg = Request.QueryString["msg"] ?? "";
_sort = Request.QueryString["sort"] ?? "";
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = Convert.ToString(Session["sort_country"]);
if (string.IsNullOrWhiteSpace(_sort))
{
_sort = "datum desc";
}
}
else
{
Session["sort_country"] = _sort;
}
_persistence = Convert.ToString(Session["persistence_country"]) ?? "";
int.TryParse(Request.QueryString["id"], out _id);
if (IsPostBack)
{
#region
msg = "";
Master.SetMessage(msg);
#endregion
}
else
{
#region
var lc = new List <Countrys.Country>();
if (_id > 0)
{
lc = Countrys.Get(_id);
}
if (lc.Count > 0)
{
var lData = lc[0];
naziv.Text = lData.acTitle;
countryCode.Text = Convert.ToString(lData.anCountryID);
iso_code.Text = lData.acISOCode;
currency.Text = lData.acCurrency;
VATCodePrefix.Text = lData.acVATCodePrefix;
isEU.Checked = Convert.ToInt32(lData.anIsEU) == 1 ? true : false;
//brisi.Visible = true;
}
else
{
}
#endregion
}
if (!string.IsNullOrWhiteSpace(msg))
{
Master.SetMessage(msg);
}
}
catch (Exception ee)
{
Master.SetMessage(ee);
}
}
