private void button1_Click(object sender, EventArgs e)
{
String program = txt_program.Text;
String language = txt_language.Text;
if (String.IsNullOrEmpty(program) || String.IsNullOrEmpty(language))
{
MessageBox.Show("Please provide full information");
}
else
{
Programs programs = new Programs()
{
program_name = program,
language = language
};
ProgramDAO pro = new ProgramDAO();
int done = pro.Insert(programs);
if (done != 0)
{
MessageBox.Show("New Program Created" + " " + done);
load_programs();
}
}
}
private void button3_Click(object sender, EventArgs e)
{
ProgramDAO us = new ProgramDAO();
OracleDataAdapter data = us.GetPrograms();
DataTable dataset = new DataTable();
data.Fill(dataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dataset;
Program_grid.DataSource = bsource;
data.Update(dataset);
}
public void load_programs()
{
ProgramDAO us = new ProgramDAO();
OracleDataAdapter data = us.GetPrograms();
DataTable dataset = new DataTable();
data.Fill(dataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dataset;
Program_table.DataSource = bsource;
data.Update(dataset);
}
private void btn_assign_Click(object sender, EventArgs e)
{
ProgramDAO pro = new ProgramDAO();
pa = new ProgramAuthors()
{
program_id = program_id,
user_id = user_id
};
int insert = pro.AssignUsers(pa);
if (insert != 0)
{
MessageBox.Show("Author Added");
}
}
public static List <Program> GetProByTypeID(int id)
{
return(ProgramDAO.GetProByTypeID(id));
}
public static bool DelPro(int id)
{
return(ProgramDAO.DelPro(id));
}
public static bool UpdatePro(Program p)
{
return(ProgramDAO.UpdatePro(p));
}
public static List <Program> GetProHide()
{
return(ProgramDAO.GetProHide());
}
public static List <Program> GetProDisplay()
{
return(ProgramDAO.GetProDisplay());
}
public static Program GetProgramByID(int id)
{
return(ProgramDAO.GetProgramByID(id));
}
public static bool CreateProgram(Program p)
{
return(ProgramDAO.CreateProgram(p));
}
public static List <Program> GetAllPro()
{
return(ProgramDAO.GetAllPro());
}
public static List <Program> GetPros(int take)
{
return(ProgramDAO.GetPros(take));
}
