public List <Den> GetListDenByParentId(string denId, int tableType) { List <Den> listDen = null; try { string sql = "Select * from Den Where STTParent='" + denId + "' and IdCatalogTable=" + tableType; dt = dbclass.TruyVan_TraVe_DataTable(sql); if (dt != null && dt.Rows.Count > 0) { listDen = new List <Den>(); foreach (DataRow row in dt.Rows) { Den den = new Den(); den.Color = row["Color"].ToString(); den.STT = row["STT"].ToString(); int valueFrom = 0; int.TryParse(row["ValueFrom"].ToString(), out valueFrom); den.ValueFrom = valueFrom; int valueTo = 0; int.TryParse(row["ValueTo"].ToString(), out valueTo); den.ValueTo = valueTo; int maMauDen = 0; int.TryParse(row["MaMauDen"].ToString(), out maMauDen); den.MaMauDen = maMauDen; listDen.Add(den); } } } catch (Exception ex) { throw ex; } return(listDen); }
void Update() { if (Den.Noc()) { Material.SetFloat("_Magnitude", 0.4f); } else if (Den.Vecer()) { Material.SetFloat("_Magnitude", 0.65f); } else if (Den.Odpoledne()) { Material.SetFloat("_Magnitude", 0.85f); } else { Material.SetFloat("_Magnitude", 1f); } // Konec dne! if (Den.Pulnoc()) { GameState.Instance.NastavKonecDne(); } }
public static DenViewModel getDenViewModel(DateTime datum, DB context) { DenViewModel vm = new DenViewModel(); Den d = new Den(); d.datum = datum; vm.terminy = context.seznamTerminu.Include(t => t.jazyk).Include(t => t.mistnost).Include(t => t.skoleni).Where(t => t.terminKonani.Equals(d.datum)).ToList(); var idTerminu = vm.terminy.Select(tm => tm.idTerminu).ToList(); var seznamId = string.Join(",", idTerminu.Select(n => n.ToString()).ToArray()); d.zaznamy = context.seznamZaznamu.Include(z => z.termin).Where(a => seznamId.Contains(a.idTerminu.ToString())).ToList(); vm.d = d; //vm.seznam = new List<Den>(); //for (int i = 1; i < 32; i++) //{ // Den d = new Den(); // d.datum = new System.DateTime(2018, 12, 20); // d.zaznamy = new List<Polozka>(); // d.zaznamy.Add(new Polozka() { poradi = 1, jmeno = "Kobliha Karel", osCislo = 111111, nadrizeny = "Dvořák Petr", stredisko = 515251 }); // d.zaznamy.Add(new Polozka() { poradi = 4, jmeno = "Foltinová Blanka", osCislo = 32, nadrizeny = "Dvořák Petr", stredisko = 515251 }); // d.zaznamy.Add(new Polozka() { poradi = 5, jmeno = "Fišer Patrik", osCislo = 4590, nadrizeny = "Černáš Petr", stredisko = 515103 }); // vm.seznam.Add(d); //} return(vm); }
/// <summary> /// Tato metoda je vyvolana v pripade, ze dany den ma byt vyucovano podle jineho rozvrhoveho dne. /// </summary> /// <param name="datumAkce"></param> /// <param name="index"></param> /// <param name="den"></param> /// <param name="DenLichy"></param> /// <param name="denSudy"></param> public void PridejJinyRozvrhDleHarmonogramu(DateTime datumAkce, int index, Den den, string DenLichy, string denSudy) { Uzivatel.Harmonogram[index].Zpracovano = true; //pridat na tenhle datum vse z rozvrhNeL ci neS ci neK List <int> indexy; bool obsahuje = Uzivatel.indexyDnu.TryGetValue(den, out indexy); if (!obsahuje) { return; } foreach (int i in indexy) { bool chciLichDny = Uzivatel.Harmonogram[index].Udalost.Equals(Uzivatel.Harmonogram[index].Udalost.Equals(DenLichy)); bool chciSudDny = Uzivatel.Harmonogram[index].Udalost.Equals(Uzivatel.Harmonogram[index].Udalost.Equals(denSudy)); bool mamSudDny = Uzivatel.RozvrhoveAkce[i].Tyden.Equals(Tyden.Sudý); bool mamLichDny = Uzivatel.RozvrhoveAkce[i].Tyden.Equals(Tyden.Lichý); bool mamKazdeDny = Uzivatel.RozvrhoveAkce[i].Tyden.Equals(Tyden.Každý); //kontroluju zda plati, ze pokud mam akci, ktera je vyucavana v liche dny, a dle harmonogramu mam chtit liche dny nebo zda pokud mam sude dny a dle harmonogramu mam chtit zrovna ty nebo pripadne pokud mam kazdy den, tak je to jedno if ((chciLichDny && mamLichDny) || (chciSudDny && mamSudDny) || mamKazdeDny) { DateTime zacatek = datumAkce.AddHours(Uzivatel.RozvrhoveAkce[i].HodinaOd).AddMinutes(Uzivatel.RozvrhoveAkce[i].MinutaOd); DateTime konec = datumAkce.AddHours(Uzivatel.RozvrhoveAkce[i].HodinaDo).AddMinutes(Uzivatel.RozvrhoveAkce[i].MinutaDo); DateTime platnostAkceZacatek = Uzivatel.RozvrhoveAkce[i].PocatecniDen; DateTime platnostAkceKonec = Uzivatel.RozvrhoveAkce[i].KonecnyDen; if (zacatek >= platnostAkceZacatek && konec <= platnostAkceKonec) { Zaznam zaznam = new Zaznam(zacatek, konec, Uzivatel.RozvrhoveAkce[i]); Uzivatel.ZaznamyProGoogleKalendar.Add(zaznam); } } } }
private void cboTentyle_SelectedIndexChanged(object sender, EventArgs e) { if (cboTentyle.DataSource != null) { Den den = (Den)cboTentyle.SelectedItem; chiTietTyLe(den.STT); } }
public override int GetHashCode() { int result = 17; result += 31 * result + Nom.GetHashCode(); result += 31 * result + Den.GetHashCode(); return(result); }
internal override T1 Multiply <T1>(T1 other) { if (!(other is Rational <T> c)) { throw new IncorrectSetException(GetType(), "multiplied", other.GetType()); } T num = Num.Multiply(c.Num); T den = Den.Multiply(c.Den); return((T1)(GroupMember) (NumberSettings.FactorFractions ? new Rational <T>(num, den).Factor() : new Rational <T>(num, den))); }
void Update() { _rucickaCasovace.transform.localPosition = new Vector3(_rucickaCasovace.transform.localPosition.x, _horniMezRucicky - (GameState.Instance.ProcentoDne() * _rozsahRucicky), _rucickaCasovace.transform.localPosition.z); // Konec dne! if (Den.Pulnoc()) { _rucickaCasovace.transform.localPosition = new Vector3(_rucickaCasovace.transform.localPosition.x, _horniMezRucicky, _rucickaCasovace.transform.localPosition.z); } }
public virtual Rational <T> Factor() { List <T> matchedFactors = Num.Factors <T>().Intersect(Den.Factors <T>()).ToList(); T num = Num; T den = Den; foreach (var t in matchedFactors) { num = num.Without(t); den = den.Without(t); } return(new Rational <T>(num, den)); }
public new Fraction Factor() { List <Integer> matchedFactors = Num.Factors <Integer>().Intersect(Den.Factors <Integer>()).ToList(); Integer num = Num; Integer den = Den; foreach (var t in matchedFactors) { num = num.Without(t); den = den.Without(t); } return(new Fraction(num, den)); }
private void loadDSTyLe() { cboTentyle.DataSource = null; //cboTentyle.Items.Clear(); cboTentyle.Refresh(); dgTenTyLe.DataSource = null; chuyenDAO = new ChuyenDAO(); dtDStyle.Clear(); listDen.Clear(); listDen_PhanCong.Clear(); string sql = ""; if (idTable == "1") { sql = "select STT, Color from Den where IdCatalogTable =1 and STTParent Is NULL"; } else if (idTable == "2") { sql = "select STT, Color from Den where IdCatalogTable =2 and STTParent Is NULL"; } else { MessageBox.Show("Lỗi: bạn chưa gán hoặc gán sai id bảng trong file config. Cần kiểm tra lại thông tin.", "Lỗi cấu hình", MessageBoxButtons.OK, MessageBoxIcon.Error); } dtDStyle = dbclass.TruyVan_TraVe_DataTable(sql); listDen_PhanCong.Add(new Den { STT = "0", Color = "Chọn tỷ lệ đèn" }); if (dtDStyle.Rows.Count > 0) { for (int i = 0; i < dtDStyle.Rows.Count; i++) { Den den = new Den { STT = dtDStyle.Rows[i][0].ToString(), Color = dtDStyle.Rows[i][1].ToString() }; listDen.Add(den); listDen_PhanCong.Add(den); } } cboTentyle.DataSource = listDen; cboTentyle.DisplayMember = "Color"; cboTentyle.ValueMember = "STT"; cboTentyle.Refresh(); dgTenTyLe.DataSource = listDen_PhanCong; dgTenTyLe.DisplayMember = "Color"; dgTenTyLe.ValueMember = "STT"; }
public static DenViewModel getDenViewModel() { DenViewModel vm = new DenViewModel(); vm.seznam = new List <Den>(); for (int i = 1; i < 32; i++) { Den d = new Den(); d.datum = new System.DateTime(2018, 12, 20); d.zaznamy = new List <Zaznam>(); vm.seznam.Add(d); } return(vm); }
public int SuaThongTinDen(Den den) { int kq = 0; try { string sql = "update Den set ValueFrom='" + den.ValueFrom + "' , ValueTo='" + den.ValueTo + "' where STT = '" + den.STT + "'"; kq = dbclass.TruyVan_XuLy(sql); return(kq); } catch (Exception) { MessageBox.Show("Lỗi: Không thể thay đổi thông tin mặt hàng dưới CSDL", "Lỗi truy vấn CSDL", MessageBoxButtons.OK, MessageBoxIcon.Error); return(kq); } }
public void ZkontrolujCrop() { if (JeZasazeno()) { Transform napoveda = transform.Find("NapovedaCrop"); if (napoveda) { Destroy(napoveda.gameObject); } if ((GameState.Instance.Den() - DenZasazeni == 1) && (Den.Ted() == CasZasazeni)) { State = 2; } else if ((GameState.Instance.Den() - DenZasazeni >= 2) && (Den.Ted() == CasZasazeni)) { State = 3; } } }
private void butDeleteTyLe_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Bạn có muốn xoá tỷ lệ đèn được chọn không?", "Xoá tỷ lệ đèn", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Den den = (Den)cboTentyle.SelectedItem; int kq = denDAO.XoaTyLeDen(den.STT); if (kq > 0) { loadDSTyLe(); EnableButton2(); cboTentyle.SelectedIndex = 0; cboTentyle.Text = ((Den)cboTentyle.SelectedItem).Color; } } } catch (Exception) { } }
public void BuildRoom(RoomType _type, int _position) { if (m_rooms[_position] != null) { Logger.Log("Can't build new room in slot " + _position + ": Already taken"); return; } Room room = null; int roomCost = 0; switch (_type) { case RoomType.Den: { room = new Den(_position); roomCost = m_balance.denCost; } break; case RoomType.Portal: { room = new Portal(_position); roomCost = m_balance.portalCost; } break; default: break; } AddMoney(-roomCost); m_rooms[_position] = room; m_objects.Add(room); if (OnRoomBuilt != null) { OnRoomBuilt(room); } Logger.Log("Built \"" + room.GetName() + "\" for " + roomCost + "$"); }
public void ZasadNeboSklid() { if (!JeZasazeno()) { DenZasazeni = GameState.Instance.Den(); CasZasazeni = Den.Ted(); State = 1; } else { if (State == 3) { GameState.Instance.Inventar.PridejDoVolnehoSlotu(Materialy.Slunecnice, 1); var rnd = new System.Random(); int index = rnd.Next(_sounds.Count - 1); var sound = _sounds[index]; GameState.Instance.AudioManager.ZahrajZvuk(sound); Destroy(gameObject); _hrac.GetComponent <PlayerController>().ZrusCil(); } } }
public int ThemTTDen(Den den) { int kq = 0; try { string sql = ""; if (den.STTParent != null) { sql = "insert into Den(Color, ValueFrom, ValueTo, IdCatalogTable, STTParent, MaMauDen) values(N'" + den.Color + "','" + den.ValueFrom + "','" + den.ValueTo + "','" + den.IdCatalogTable + "'," + den.STTParent + ",'" + den.MaMauDen + "')"; } else { sql = "insert into Den(Color, ValueFrom, ValueTo, IdCatalogTable) values(N'" + den.Color + "','" + den.ValueFrom + "','" + den.ValueTo + "','" + den.IdCatalogTable + "')"; } kq = dbclass.TruyVan_XuLy(sql); return(kq); } catch (Exception) { MessageBox.Show("Lỗi: Không thể thêm thông tin mới vào CSDL", "Lỗi truy vấn CSDL", MessageBoxButtons.OK, MessageBoxIcon.Error); return(kq); } }
private static void generuj(DenViewModel vm, int idMesice, int idRoku, List <Termin> terminy) { var prvniDen = new DateTime(idRoku, idMesice, 1); vm.aktualniRok = idRoku; int denTydne = (int)prvniDen.DayOfWeek; // doplneni prazdnych bloku if (denTydne == 0) { for (int i = 1; i < 7; i++) { vm.seznam.Add(new Den() { nic = true }); } } else { for (int i = 1; i < denTydne; i++) { vm.seznam.Add(new Den() { nic = true }); } } // ostatni dny for (int i = 1; i <= DateTime.DaysInMonth(DateTime.Now.Year, idMesice); i++) { var den = new Den(); den.datum = prvniDen; denTydne = (int)prvniDen.DayOfWeek; if (denTydne == 0 || denTydne == 6 || prvniDen < DateTime.Now) { den.prazdny = true; } else { var t = terminy.Where(x => x.terminKonani.Equals(den.datum)).ToList(); if (t.Count > 0) { den.prazdny = false; den.terminy = t; foreach (var x in t) { den.pocetVolnychMist += x.mistnost.kapacita; //den.pocetVolnychMist -= prihlasky.Where(a => a.termin.id == x.id).ToList().Count; } } else { den.prazdny = true; den.pocetVolnychMist = 0; } } den.denTydne = (int)prvniDen.DayOfWeek; vm.seznam.Add(den); prvniDen = prvniDen.AddDays(1); } vm.aktualniMesic = mesice[idMesice - 1].ToString(); // *** predchozi mesic if (idMesice == 1) { vm.predchoziRok = vm.aktualniRok - 1; vm.predchoziMesic = mesice[11] + " (" + (vm.predchoziRok) + ")"; vm.idPredchoziMesic = 12; } else { vm.predchoziRok = vm.aktualniRok; vm.predchoziMesic = mesice[idMesice - 2].ToString(); vm.idPredchoziMesic = idMesice - 1; } // *** nasledujici mesic if (idMesice == 12) { vm.nasledujiciRok = vm.aktualniRok + 1; vm.nasledujiciMesic = mesice[0] + " (" + (vm.nasledujiciRok) + ")"; vm.idNasledujiciMesic = 1; } else { vm.nasledujiciRok = vm.aktualniRok; vm.nasledujiciMesic = mesice[idMesice].ToString(); vm.idNasledujiciMesic = idMesice + 1; } }
public IEnumerable <Scout> GetScouts(Den den) { return(context.Scouts.Where(s => s.Den == den).AsEnumerable()); }
private void butLuutyle_Click(object sender, EventArgs e) { Den den; if (eventclick == "update") { try { string STT; foreach (DataGridViewRow item in dgThongtintyle.Rows) { STT = ""; try { STT = item.Cells[0].Value.ToString(); } catch (Exception) { } if (STT != "") { den = new Den { STT = STT, ValueFrom = int.Parse(item.Cells[2].Value.ToString()), ValueTo = int.Parse(item.Cells[3].Value.ToString()) }; int kq = denDAO.SuaThongTinDen(den); } } EnableButton2(); } catch (Exception) { } } else { try { string Name = cboTentyle.Text; if (Name != "") { string IdTest = denDAO.TestName(Name); if (IdTest == "") { int kq = 0; if (idTable == "2") { den = new Den { Color = Name, ValueFrom = 0, ValueTo = 0, IdCatalogTable = "2", STTParent = null }; kq = denDAO.ThemTTDen(den); } else if (idTable == "1") { den = new Den { Color = Name, ValueFrom = 0, ValueTo = 0, IdCatalogTable = "1", STTParent = null }; kq = denDAO.ThemTTDen(den); } if (kq > 0) { string STT = denDAO.FindToFinalId(); if (STT != "") { foreach (DataGridViewRow item in dgThongtintyle.Rows) { try { if (item.Cells[1].Value != null) { if (idTable == "2") { den = new Den { Color = item.Cells[1].Value.ToString(), ValueFrom = int.Parse(item.Cells[2].Value.ToString()), ValueTo = int.Parse(item.Cells[3].Value.ToString()), IdCatalogTable = "2", STTParent = STT, MaMauDen = int.Parse(item.Cells[4].Value.ToString()) }; kq = denDAO.ThemTTDen(den); } else if (idTable == "1") { den = new Den { Color = item.Cells[1].Value.ToString(), ValueFrom = int.Parse(item.Cells[2].Value.ToString()), ValueTo = int.Parse(item.Cells[3].Value.ToString()), IdCatalogTable = "1", STTParent = STT, MaMauDen = int.Parse(item.Cells[4].Value.ToString()) }; kq = denDAO.ThemTTDen(den); } } } catch (Exception) { } } loadDSTyLe(); EnableButton2(); } else { MessageBox.Show("Lỗi: Không tìm thấy id tên tỷ lệ!", "Lỗi xử lý", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("Lỗi: Tên loại tỷ lệ đã tồn tại vui lòng chọn tên tỉ lệ khác!", "Lỗi thao tác", MessageBoxButtons.OK, MessageBoxIcon.Error); cboTentyle.Text = ""; cboTentyle.Focus(); } } else { MessageBox.Show("Lỗi: Tên loại tỷ lệ không được để trống.", "Lỗi thao tác", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception) { } } }
public IEnumerable <Scout> GetScouts(Den den) { return(repository.GetScouts(den)); }
public string ToString(string format) { return($"{Num.ToString(format)}/{Den.ToString(format)}"); }
private static void generuj(DenViewModel vm, int idMesice, int idRoku) { var prvniDen = new DateTime(idRoku, idMesice, 1); vm.aktualniRok = idRoku; int denTydne = (int)prvniDen.DayOfWeek; // doplneni prazdnych bloku if (denTydne == 0) { for (int i = 1; i < 7; i++) { vm.seznam.Add(new Den() { nic = true }); } } else { for (int i = 1; i < denTydne; i++) { vm.seznam.Add(new Den() { nic = true }); } } // ostatni dny for (int i = 1; i <= DateTime.DaysInMonth(DateTime.Now.Year, idMesice); i++) { var den = new Den(); denTydne = (int)prvniDen.DayOfWeek; if (denTydne == 0 || denTydne == 6 || prvniDen < DateTime.Now) { den.prazdny = true; } den.datum = prvniDen; den.denTydne = (int)prvniDen.DayOfWeek; vm.seznam.Add(den); prvniDen = prvniDen.AddDays(1); } vm.aktualniMesic = mesice[idMesice - 1].ToString(); // *** predchozi mesic if (idMesice == 1) { vm.predchoziRok = vm.aktualniRok - 1; vm.predchoziMesic = mesice[11] + " (" + (vm.predchoziRok) + ")"; vm.idPredchoziMesic = 12; } else { vm.predchoziRok = vm.aktualniRok; vm.predchoziMesic = mesice[idMesice - 2].ToString(); vm.idPredchoziMesic = idMesice - 1; } // *** nasledujici mesic if (idMesice == 12) { vm.nasledujiciRok = vm.aktualniRok + 1; vm.nasledujiciMesic = mesice[0] + " (" + (vm.nasledujiciRok) + ")"; vm.idNasledujiciMesic = 1; } else { vm.nasledujiciRok = vm.aktualniRok; vm.nasledujiciMesic = mesice[idMesice].ToString(); vm.idNasledujiciMesic = idMesice + 1; } }