private void btnEditSelected_Click(object sender, EventArgs e)
{
// data row: title, condition, count, id, holds, price
if (dgvData.SelectedRows.Count > 0)
{
string title = dgvData.SelectedCells[0].Value.ToString();
string id = dgvData.SelectedCells[3].Value.ToString();
string condition = dgvData.SelectedCells[1].Value.ToString();
int count = int.Parse(dgvData.SelectedCells[2].Value.ToString());
double price = double.Parse(dgvData.SelectedCells[5].Value.ToString());
Console.WriteLine(title);
Console.WriteLine(condition);
Console.WriteLine(count.ToString());
Console.WriteLine(id);
frmInfo info = new Postro2.frmInfo(title, Poster.StringToCondition(condition), id, count, price);
if (info.ShowDialog() != DialogResult.OK)
{
return;
}
Poster poster = info._Poster;
Console.WriteLine(poster.ToString());
// PosterTitle, Condition, Count, ID, Holds, Price
DatabaseManager.Command(string.Format("UPDATE Posters SET PosterTitle=\"{0}\", Condition=\"{1}\", Count={2}, Price={4} WHERE ID=\"{3}\";",
poster.Title, Poster.ConditionToString(poster.PosterCondition), poster.Count, poster.ID, (poster.Pricing * 100)));
DisplayAllRows();
}
}
// =======================================================================================================
// PROPRIETARY DATABASE MANAGER STUFF INVOLVING POSTERS
// =======================================================================================================
public bool AddPosterToDB(Poster poster)
{
try
{
Command(string.Format("INSERT INTO Posters (PosterTitle, Condition, Count, ID, Holds, Price) VALUES ('{0}', '{1}', {2}, '{3}', {4}, {5});", poster.Title, Poster.ConditionToString(poster.PosterCondition), poster.Count.ToString(), poster.ID, poster.Holds.ToString(), poster.Pricing * 100));
}
catch (Exception)
{
return(false);
}
return(true);
}
private void btnAddNew_Click(object sender, EventArgs e)
{
if (connected)
{
frmInfo infoWindow = new frmInfo();
var result = infoWindow.ShowDialog();
Poster poster = infoWindow._Poster;
if ((poster = infoWindow._Poster) == null && result != DialogResult.OK)
{
return;
}
DatabaseManager.AddPosterToDB(poster);
DisplayAllRows();
}
}
