public void Insert(REF_EnrollCourse oREF_EnrollCourse)
{
DBConnecton db;
db = new DBConnecton();
string sqlQuery;
SqlCommand oSqlCommand;
try
{
sqlQuery = "INSERT INTO `tblenrollcourse` (`ID`, `CusID`, `CourseID`, `Status`, `OfferID`, `offer_prices`, `Course_price`, `Total`)" +
"VALUES (NULL, '" + oREF_EnrollCourse.CusID + "', '" + oREF_EnrollCourse.CourseID + "', '0', '" + oREF_EnrollCourse.OfferID + "', '" + oREF_EnrollCourse.offer_prices + "', '" + oREF_EnrollCourse.Course_price + "', '" + oREF_EnrollCourse.Total + "');";
//open connection
if (db.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(sqlQuery, db.getConnetion());
//Execute command
cmd.ExecuteNonQuery();
//close connection
db.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnsubmitoffers_Click(object sender, EventArgs e)
{
DAC_EnrollCourse oDAC_EnrollCourse = new DAC_EnrollCourse();
REF_EnrollCourse oREF_EnrollCourse = new REF_EnrollCourse();
oREF_EnrollCourse.CusID = dropCusotmer.Value;
oREF_EnrollCourse.CourseID = dropCourse.Value;
oREF_EnrollCourse.OfferID = dropoffers.Value;
DataTable dt;
DAV_Offers oDAV_Offers = new DAV_Offers();
REF_Offers oREF_Offers = new REF_Offers();
oREF_Offers.ID = Convert.ToInt32(dropoffers.Value);
dt = oDAV_Offers.SelectOffersByID(oREF_Offers);
Double OfferPrice = Double.Parse(dt.Rows[0][6].ToString());
oREF_EnrollCourse.offer_prices = dt.Rows[0][6].ToString();
DAV_Cources oDAV_Cources = new DAV_Cources();
REF_Course oREF_Course = new REF_Course();
oREF_Course.ID = Convert.ToInt32(dropCourse.Value);
dt = oDAV_Cources.SelectCourseByID(oREF_Course);
Double CoursePrice = Double.Parse(dt.Rows[0][4].ToString());
Double Total = CoursePrice - OfferPrice;
oREF_EnrollCourse.Course_price = dt.Rows[0][3].ToString();
oREF_EnrollCourse.Total = Total.ToString();
oDAC_EnrollCourse.Insert(oREF_EnrollCourse);
LoadData();
}