public void SaveTown()
{
string sql;
if (_town.TownID < 0)
{
sql = "INSERT INTO tbltown (fldName, fldCreationDate) VALUES (@townName, datetime('now', 'localtime')); SELECT last_insert_rowid();";
SQLiteCommand cmd = new SQLiteCommand(sql);
cmd.Parameters.AddWithValue("@townName", _town.TownName);
_town.TownID = db.GetScalarData(cmd);
}
if (_town.TownID >= 0)
{
sql = "UPDATE tbltown SET fldTownHallLevel = @townHallLevel, fldStorageLevel = @storageLevel, fldInfirmaryLevel = @infirmaryLevel, fldInnLevel = @innLevel, fldBarrackLevel = @barrackLevel, fldSanctumLevel = @sanctumLevel, fldArcheryLevel = @archeryLevel, fldGoldAmount = @gold WHERE fldID = @townID";
SQLiteCommand cmd = new SQLiteCommand(sql);
cmd.Parameters.AddWithValue("@townID", _town.TownID);
cmd.Parameters.AddWithValue("@townHallLevel", _town.TownHallLevel);
cmd.Parameters.AddWithValue("@storageLevel", _town.StorageLevel);
cmd.Parameters.AddWithValue("@infirmaryLevel", _town.InfimaryLevel);
cmd.Parameters.AddWithValue("@innLevel", _town.InnLevel);
cmd.Parameters.AddWithValue("@barrackLevel", _town.BarrackLevel);
cmd.Parameters.AddWithValue("@sanctumLevel", _town.SanctumLevel);
cmd.Parameters.AddWithValue("@archeryLevel", _town.ArcheryRangeLevel);
cmd.Parameters.AddWithValue("@gold", _town.CurrentGold);
db.ModifyData(cmd);
}
}
///Opdater Forsiden
public void redigerforside(VinoPro Pro)
{
dbDataAccess objDataAccess = new dbDataAccess();
string strSQL;
strSQL = "UPDATE TblForside SET fldForside=@Tekst WHERE fldID=@ID";
SqlCommand objCMD = new SqlCommand(strSQL);
objCMD.Parameters.AddWithValue("@Tekst", Pro.Tekst);
objCMD.Parameters.AddWithValue("@ID", Pro.ID);
objDataAccess.ModifyData(objCMD);
}
///Opdater Butikken
public void redigerViniVino2(VinoPro Pro)
{
dbDataAccess objDataAccess = new dbDataAccess();
string strSQL;
strSQL = "UPDATE tblViniVino SET fldButikken=@Tekst WHERE fldID=@ID";
SqlCommand objCMD = new SqlCommand(strSQL);
objCMD.Parameters.AddWithValue("@Tekst", Pro.Tekst);
objCMD.Parameters.AddWithValue("@ID", Pro.ID);
objDataAccess.ModifyData(objCMD);
}
///Opdater Forsiden
public void redigerforside(VinoPro Pro)
{
dbDataAccess objDataAccess = new dbDataAccess();
string strSQL;
strSQL = "UPDATE TblForside SET fldForside=@Tekst WHERE fldID=@ID";
SqlCommand objCMD = new SqlCommand(strSQL);
objCMD.Parameters.AddWithValue("@Tekst", Pro.Tekst);
objCMD.Parameters.AddWithValue("@ID", Pro.ID);
objDataAccess.ModifyData(objCMD);
}
///Opdater Vinkortet
public void redigerViniVino3(VinoPro Pro)
{
dbDataAccess objDataAccess = new dbDataAccess();
string strSQL;
strSQL = "UPDATE tblViniVino SET fldVinkortet=@Tekst WHERE fldID=@ID";
SqlCommand objCMD = new SqlCommand(strSQL);
objCMD.Parameters.AddWithValue("@Tekst", Pro.Tekst);
objCMD.Parameters.AddWithValue("@ID", Pro.ID);
objDataAccess.ModifyData(objCMD);
}
