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;
}
}
