/// <summary>
/// Ziska data o psovi s danym ID, upravi je a zpet ulozi.
/// </summary>
/// <param name="id"></param>
/// <param name="newData"></param>
public void Edit(int id, Pes newData)
{
Pes oldData = this.GetPesById(id);
oldData.Jmeno = newData.Jmeno;
oldData.Plemeno = newData.Plemeno;
oldData.Pohlavi = newData.Pohlavi;
oldData.Fci = newData.Fci;
oldData.Datum = newData.Datum;
oldData.Licence = newData.Licence;
oldData.Majitel = newData.Majitel;
oldData.Skupina = newData.Skupina;
oldData.StartBeh1 = newData.StartBeh1;
oldData.StartBeh2 = newData.StartBeh2;
oldData.ZavodLicence = newData.ZavodLicence;
oldData.Platba = newData.Platba;
oldData.Doplatit = newData.Doplatit;
oldData.Poznamka = newData.Poznamka;
oldData.Diskval = newData.Diskval;
oldData.AgilityA0 = newData.AgilityA0;
oldData.SpeedA0 = newData.SpeedA0;
oldData.EnduranceA0 = newData.EnduranceA0;
oldData.EnthusiasmA0 = newData.EnthusiasmA0;
oldData.IntelligenceA0 = newData.IntelligenceA0;
oldData.AgilityA1 = newData.AgilityA1;
oldData.SpeedA1 = newData.SpeedA1;
oldData.EnduranceA1 = newData.EnduranceA1;
oldData.EnthusiasmA1 = newData.EnthusiasmA1;
oldData.IntelligenceA1 = newData.IntelligenceA1;
oldData.Body1 = newData.Body1;
oldData.AgilityB0 = newData.AgilityB0;
oldData.SpeedB0 = newData.SpeedB0;
oldData.EnduranceB0 = newData.EnduranceB0;
oldData.EnthusiasmB0 = newData.EnthusiasmB0;
oldData.IntelligenceB0 = newData.IntelligenceB0;
oldData.AgilityB1 = newData.AgilityB1;
oldData.SpeedB1 = newData.SpeedB1;
oldData.EnduranceB1 = newData.EnduranceB1;
oldData.EnthusiasmB1 = newData.EnthusiasmB1;
oldData.IntelligenceB1 = newData.IntelligenceB1;
oldData.Body2 = newData.Body2;
oldData.Barva0 = newData.Barva0;
oldData.Barva1 = newData.Barva1;
oldData.Dvojice0 = newData.Dvojice0;
oldData.Dvojice1 = newData.Dvojice1;
}
public Skupina(Pes iPes1, Pes iPes2)
{
this.id = iPes1.Id;
this.pes1name = iPes1.Jmeno;
this.pes2name = iPes2.Jmeno;
this.pes1plemeno = iPes1.Plemeno;
this.pes2plemeno = iPes2.Plemeno;
this.pes1barva = "červená";
this.pes2barva = "bílá";
}
public Skupina(Pes iPes1, Pes iPes2, Pes iPes3)
{
this.id = iPes1.Id; // WTF?! proč ID prvniho psa ?!
this.pes1name = iPes1.Jmeno;
this.pes2name = iPes2.Jmeno;
this.pes3name = iPes3.Jmeno;
this.pes1plemeno = iPes1.Plemeno;
this.pes2plemeno = iPes2.Plemeno;
this.pes3plemeno = iPes3.Plemeno;
this.pes1barva = "červená";
this.pes2barva = "bílá";
this.pes3barva = "modrá";
}
public Pes(Pes aPes)
{
InitVar(aPes.GetDictionary);
}
/// <summary>
/// Prida zakaznika do databaze
/// </summary>
/// <param name="newPes"></param>
public void Add(Pes newPes)
{
this.psi.Add(newPes);
}
public void read_excel_table_temp(Majitele dataM, Psi dataP, string sourceFile, Int32 list)
{
Int32 tmp = 0;
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook;
Excel.Worksheet worksheet;
Excel.Range range;
string databasePath = sourceFile;
workbook = excelApp.Workbooks.Open(databasePath);
worksheet = (Excel.Worksheet)workbook.Sheets.get_Item(list);
Majitel temp_majitel = new Majitel();
Pes temp_pes = new Pes();
Int32 row = 0;
range = worksheet.UsedRange;
DataTable dt = new DataTable();
String temp = null;
for (row = 2; row <= range.Rows.Count; row++)
{
DataRow dr = dt.NewRow();
temp = (range.Cells[row, 1] as Excel.Range).Value2;
if (temp != null) // excel sloupec clenstvi
{
string tempStr = temp.ToString();
if (tempStr[0] == 'N')
{
temp_majitel.clen = "ne"; // neni clenem klubu
}
else
{
temp_majitel.clen = "ano"; // je clenem klubu
}
}
else
{
temp_majitel.clen = "ano"; // policko by melo byt prazdne - mozna NULL ?!
}
//temp = (range.Cells[row, 2] as Excel.Range).Value2;
temp_pes.ZavodLicence = SetTempFromExcel(range, row, 2); // excel sloupec zavod-licence-trening
temp_pes.Jmeno = SetTempFromExcel(range, row, 3); // excel sloupec jmeno psa
temp_pes.Plemeno = SetTempFromExcel(range, row, 4); // excel sloupec plemeno
temp_pes.Poznamka = SetTempFromExcel(range, row, 5); // excel sloupec poznamka ZAVODNI SKUPINA !!!!
temp_pes.Pohlavi = SetTempFromExcel(range, row, 6).ToLower(); // excel sloupec pohlavi
temp_pes.Platba = SetTempIntFromExcel(range, row, 8); // excel sloupec platba
temp_pes.Licence = SetTempFromExcel(range, row, 11); // excel sloupec licence
temp = (range.Cells[row, 14] as Excel.Range).Value.ToShortDateString();
if (temp != null) // excel sloupec datum narozeni
{
temp_pes.Datum = DateTime.ParseExact(temp, Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern, Thread.CurrentThread.CurrentCulture);
}
else
{
temp_pes.Datum = DateTime.ParseExact(DateTime.MinValue.ToShortDateString(), Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern, Thread.CurrentThread.CurrentCulture);
}
temp_majitel.firstName = SetTempFromExcel(range, row, 15); // excel sloupec jmeno
temp_majitel.narodnost = SetTempFromExcel(range, row, 17); // excel sloupec národnost
temp_majitel.telefon = SetTempFromExcel(range, row, 18); // excel sloupec telefon
temp_majitel.email = SetTempFromExcel(range, row, 19); // excel sloupec email
temp_pes.Doplatit = 0;
temp_majitel.id = dataM.GetNewId(); // přiřzení ID majiteli
temp_majitel.penize = temp_pes.Platba + temp_pes.Doplatit; // součet zaplatil a má zaplatit
temp_majitel.potvrzeni = "--"; // implicitně nastaven jako nezaplaceno
temp_majitel.pocet_psu = 1;
temp_pes.Id = dataP.GetNewId();
temp_pes.Majitel = temp_majitel.id;
temp_pes.MajitelJmeno = temp_majitel.firstName;
temp_pes.Skupina = 0;
temp_pes.StartBeh1 = 0;
temp_pes.StartBeh1 = 0;
temp_pes.Diskval = "---";
temp_pes.AgilityA0 = 0;
temp_pes.AgilityA1 = 0;
temp_pes.SpeedA0 = 0;
temp_pes.SpeedA1 = 0;
temp_pes.EnduranceA0 = 0;
temp_pes.EnduranceA1 = 0;
temp_pes.EnthusiasmA0 = 0;
temp_pes.EnthusiasmA1 = 0;
temp_pes.IntelligenceA0 = 0;
temp_pes.IntelligenceA1 = 0;
temp_pes.AgilityB0 = 0;
temp_pes.AgilityB1 = 0;
temp_pes.SpeedB0 = 0;
temp_pes.SpeedB1 = 0;
temp_pes.EnduranceB0 = 0;
temp_pes.EnduranceB1 = 0;
temp_pes.EnthusiasmB0 = 0;
temp_pes.EnthusiasmB1 = 0;
temp_pes.IntelligenceB0 = 0;
temp_pes.IntelligenceB1 = 0;
temp_pes.Body1 = 0;
temp_pes.Body2 = 0;
temp_pes.Dvojice0 = 0;
temp_pes.Dvojice1 = 0;
temp_pes.Barva0 = "";
temp_pes.Barva1 = "";
tmp = dataM.FindSame(temp_majitel.firstName, temp_majitel.lastName, temp_majitel.email);
if (tmp < 0)
{
dataM.Add(new Majitel(temp_majitel));
}
else
{
Majitel editmajitel = dataM.GetMajitelById(tmp);
editmajitel.penize += temp_majitel.penize; // přičtení majiteli platbu za dalšího psa
editmajitel.pocet_psu++;
dataM.Edit(tmp, editmajitel);
temp_pes.Majitel = tmp;
}
dataP.Add(new Pes(temp_pes));
}
workbook.Close(true, Missing.Value, Missing.Value);
excelApp.Quit();
}
