public String subjectOfferUpdate(SubjectOffer subject)
{
try
{
string strCommand = "UPDATE SubjectOffer SET section = @Section, Sub_Id = @Sub_Id, isOffer = @IsOffer, currentCapacity = @CurrentCapacity, maxCapacity = @MaxCapacity WHERE SubjectOffer_ID = @ID";
SqlCeCommand cmdInsert = new SqlCeCommand();
cmdInsert.Connection = conn;
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = strCommand;
cmdInsert.Parameters.AddWithValue("@Section", subject.ID);
cmdInsert.Parameters.AddWithValue("@Section", subject.Section);
cmdInsert.Parameters.AddWithValue("@IsOffer", subject.IsOffer);
cmdInsert.Parameters.AddWithValue("@Sub_Id", subject.Sub_ID);
cmdInsert.Parameters.AddWithValue("@CurrentCapacity", subject.CurrentCapacity);
cmdInsert.Parameters.AddWithValue("@MaxCapacity", subject.MaxCapacity);
cmdInsert.ExecuteNonQuery();
return("Successfull Added");
}
catch (SqlCeException e)
{
MessageBox.Show(e.Source + "\n" + e.Message + "\n" + e.StackTrace);
return("Fail to Add");
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
String msg = "";
SubjectOffer subjectOffer = new SubjectOffer();
subjectOffer.CurrentCapacity = Convert.ToInt16(currCapTb.Text);
subjectOffer.MaxCapacity = Convert.ToInt16(maxCapTb.Text);
subjectOffer.Sub_ID = Convert.ToInt16(subjectCb.SelectedValue.ToString());
if (offerBtn.Enabled == false)
{
subjectOffer.IsOffer = true;
}
else
{
subjectOffer.IsOffer = false;
}
subjectOffer.Section = sectionTb.Text;
if (statusLbl.Text == "Add Offer")
{
msg = myConnn.subjectOfferInsert(subjectOffer);
this.ClearTextBoxes();
}
if (statusLbl.Text == "Edit Offer")
{
subjectOffer.ID = Convert.ToInt16(idValLbl.Text);
}
subjectOfferDVG.DataSource = myConnn.getAllSubjectOffer();
}
public String subjectOfferInsert(SubjectOffer subject)
{
try
{
string strCommand = "INSERT INTO SubjectOffer(section,isOffer,Sub_Id,currentCapacity,maxCapacity) VALUES(@Section,@IsOffer,@Sub_Id,@CurrentCapacity,@MaxCapacity)";
SqlCeCommand cmdInsert = new SqlCeCommand();
cmdInsert.Connection = conn;
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = strCommand;
cmdInsert.Parameters.AddWithValue("@Section", subject.Section);
cmdInsert.Parameters.AddWithValue("@IsOffer", subject.IsOffer);
cmdInsert.Parameters.AddWithValue("@Sub_Id", subject.Sub_ID);
cmdInsert.Parameters.AddWithValue("@CurrentCapacity", subject.CurrentCapacity);
cmdInsert.Parameters.AddWithValue("@MaxCapacity", subject.MaxCapacity);
cmdInsert.ExecuteNonQuery();
return("Successfull Added");
}
catch (SqlCeException e)
{
MessageBox.Show(e.Source + "\n" + e.Message + "\n" + e.StackTrace);
return("Fail to Add");
}
}
