public List <income> incomeData()
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=inventorymgt;password=password;allowuservariables=True");
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM income", con);
var model = new List <income>();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
DateTime dt = System.DateTime.Parse(rdr["date"].ToString());
var income = new income();
income.id = int.Parse(rdr["id"].ToString());
income.date = dt.ToString("yyyy-MM-dd");
income.category = rdr["category"].ToString();
income.cash = Double.Parse(rdr["cash"].ToString());
income.pos = Double.Parse(rdr["pos"].ToString());
income.total = Double.Parse(rdr["amount"].ToString());
model.Add(income);
}
return(model);
}
public void deleteIncome(income income)
{
MySqlCommand cmd = new MySqlCommand("delete from income where id = @id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", income.id);
cmd.ExecuteNonQuery();
}
public void deleteIncome(income income)
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=inventorymgt;password=password;allowuservariables=True");
con.Open();
MySqlCommand cmd = new MySqlCommand("delete from income where id = @id", con);
cmd.Parameters.AddWithValue("@id", income.id);
cmd.ExecuteNonQuery();
}
public void incomeInsert(income income)
{
MySqlCommand cmd = new MySqlCommand("INSERT INTO income (date, category, cash, pos, amount) VALUES (@date, @category, @cash, @pos, @total)", con);
con.Open();
cmd.Parameters.AddWithValue("@date", income.date);
cmd.Parameters.AddWithValue("@category", income.category);
cmd.Parameters.AddWithValue("@cash", income.cash);
cmd.Parameters.AddWithValue("@pos", income.pos);
cmd.Parameters.AddWithValue("@total", income.total);
cmd.ExecuteNonQuery();
}
public void incomeEdit(income income)
{
MySqlCommand cmd = new MySqlCommand("UPDATE income SET date = @date, category = @category, cash = @cash, pos = @pos, amount = @total WHERE id = @id", con);
con.Open();
cmd.Parameters.AddWithValue("@date", income.date);
cmd.Parameters.AddWithValue("@category", income.category);
cmd.Parameters.AddWithValue("@cash", income.cash);
cmd.Parameters.AddWithValue("@pos", income.pos);
cmd.Parameters.AddWithValue("@total", income.total);
cmd.Parameters.AddWithValue("@id", income.id);
cmd.ExecuteNonQuery();
}
public void incomeInsert(income income)
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=inventorymgt;password=password;allowuservariables=True");
con.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO income (date, category, cash, pos, amount) VALUES (@date, @category, @cash, @pos, @total)", con);
cmd.Parameters.AddWithValue("@date", income.date);
cmd.Parameters.AddWithValue("@category", income.category);
cmd.Parameters.AddWithValue("@cash", income.cash);
cmd.Parameters.AddWithValue("@pos", income.pos);
cmd.Parameters.AddWithValue("@total", income.total);
cmd.ExecuteNonQuery();
}
public void incomeEdit(income income)
{
MySqlConnection con = new MySqlConnection("server=localhost;user id=root;database=inventorymgt;password=password;allowuservariables=True");
con.Open();
MySqlCommand cmd = new MySqlCommand("UPDATE income SET date = @date, category = @category, cash = @cash, pos = @pos, amount = @total WHERE id = @id", con);
cmd.Parameters.AddWithValue("@date", income.date);
cmd.Parameters.AddWithValue("@category", income.category);
cmd.Parameters.AddWithValue("@cash", income.cash);
cmd.Parameters.AddWithValue("@pos", income.pos);
cmd.Parameters.AddWithValue("@total", income.total);
cmd.Parameters.AddWithValue("@id", income.id);
cmd.ExecuteNonQuery();
}
public List <income> incomeData()
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM income", con);
var model = new List <income>();
con.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
DateTime dt = System.DateTime.Parse(rdr["date"].ToString());
var income = new income();
income.id = int.Parse(rdr["id"].ToString());
income.date = dt.ToString("yyyy-MM-dd");
income.category = rdr["category"].ToString();
income.cash = Double.Parse(rdr["cash"].ToString());
income.pos = Double.Parse(rdr["pos"].ToString());
income.total = Double.Parse(rdr["amount"].ToString());
model.Add(income);
}
return(model);
}
