private void button7_Click(object sender, EventArgs e)
{
label9.Visible = false;
string code = textBox1.Text;
DateTime date = dateTimePicker1.Value;
if (code.Length < 2)
{
label9.Text = "Please Fill All The Field.";
label9.Visible = true;
return;
}
DataSets.intake intakeInfo = new DataSets.intake();
intakeInfo.code = code;
intakeInfo.date = date;
DataBaseManager dbm = new DataBaseManager();
if (dbm.addIntake(intakeInfo))
{
MessageBox.Show("The New Intake Has Been Added Successfuly.");
this.Dispose();
}
else
{
label9.Text = "The Intake Is Already Exist";
label9.Visible = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSets.intake intakeInfo = new DataSets.intake();
intakeInfo.code = comboBox1.SelectedItem.ToString();
intakeInfo.date = dateTimePicker1.Value;
dbm.DeleteIntake(intakeInfo);
MessageBox.Show("The Intake Has Been Deleted Successfully.");
this.Dispose();
}
public void updateIntake(DataSets.intake intakeInfo)
{
m_dbConnection.Open();
string sql = "UPDATE INTAKE SET date='" + intakeInfo.date + "' WHERE code='" + intakeInfo.code + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
m_dbConnection.Close();
}
public void DeleteIntake(DataSets.intake intakeInfo)
{
m_dbConnection.Open();
string sql = "DELETE FROM INTAKE WHERE code='" + intakeInfo.code + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
m_dbConnection.Close();
}
public List <DataSets.intake> getIntakes()
{
List <DataSets.intake> retVal = new List <DataSets.intake>();
m_dbConnection.Open();
string sql = "SELECT * FROM INTAKE";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DataSets.intake temp = new DataSets.intake();
temp.code = reader.GetString(0);
temp.date = DateTime.Parse(reader.GetString(1));
retVal.Add(temp);
}
reader.Close();
m_dbConnection.Close();
return(retVal);
}
public bool addIntake(DataSets.intake intakeInfo)
{
bool retVal = false;
m_dbConnection.Open();
string sql = "SELECT * FROM INTAKE WHERE code='" + intakeInfo.code + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
if (!reader.Read())
{
reader.Close();
retVal = true;
sql = "insert into INTAKE (code,date) values('" + intakeInfo.code + "','" + intakeInfo.date + "')";
command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
return(retVal);
}
reader.Close();
m_dbConnection.Close();
return(retVal);
}
