protected void btn_insertM_Click(object sender, EventArgs e)
{
if (tb_Mname.Text.TrimStart().TrimEnd() == "")
{
lb_msgM.Text = "You are required to fill Material textbox";
}
else
{
con.Open();
cmd.CommandText = "SELECT * FROM Materials WHERE MName=@MName";
cmd.Parameters.AddWithValue("@MName", tb_Mname.Text);
reader = cmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
lb_msg.Text = "Sorry bro material name already exists!";
}
else
{
reader.Close();
cmd.CommandText = "INSERT INTO Materials (MName,LID,notes) VALUES (@MName3,@LID,@notes3)";
cmd.Parameters.AddWithValue("@MName3", tb_Mname.Text);
cmd.Parameters.AddWithValue("@LID", ddl_Lec.SelectedValue);
cmd.Parameters.AddWithValue("@notes3", tb_MNotes.Text);
cmd.ExecuteNonQuery();
lb_msgM.Text = "The name of the Material is now added to database";
GridView_Materials.DataBind();
}
con.Close();
}
}
protected void btn_insertM_Click(object sender, EventArgs e)
{
if (tb_Mname.Text.TrimStart().TrimEnd() == "")
{
lb_msgM.Text = "Please enter Material information in the field!";
}
else
{
con.Open();
cmd.CommandText = "SELECT Id FROM Materials WHERE MName=@MName";
cmd.Parameters.AddWithValue("@MName", tb_Mname.Text);
reader = cmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
lb_msgM.Text = " The material you are trying to add has already been added, " +
"please add new materials!";
}
else
{
reader.Close();
cmd.CommandText = "INSERT INTO Materials (MName,LID,Notes) VALUES (@MNameP,@LID,@MnotesP)";
cmd.Parameters.AddWithValue("@MNameP", tb_Mname.Text);
cmd.Parameters.AddWithValue("@LID", ddl_Lec.SelectedValue);
cmd.Parameters.AddWithValue("@MNotesP", tb_MNotes.Text);
cmd.ExecuteNonQuery();
lb_msgM.Text = "Material Content added Successfully";
GridView_Materials.DataBind();
}
con.Close();
}
}
