public void EditFees(mst_fees mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = @"UPDATE mst_fees SET fees_amount = @fees_amount, bl_onetime = @bl_onetime, bl_apr = @bl_apr, bl_may = @bl_may, bl_jun = @bl_jun, bl_jul = @bl_jul, bl_aug = @bl_aug, bl_sep = @bl_sep, bl_oct = @bl_oct, bl_nov = @bl_nov, bl_dec = @bl_dec, bl_jan = @bl_jan, bl_feb = @bl_feb, bl_mar = @bl_mar WHERE class_id = @class_id AND acc_id = @acc_id AND session = (SELECT session FROM mst_session WHERE session_active = 'Y')"; con.Execute(query, mst); } } catch (Exception ex) { throw ex; } }
public void AddFees(mst_fees mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = @"SELECT session FROM mst_session where session_active = 'Y'"; string session = con.Query <string>(query).SingleOrDefault(); query = @"INSERT INTO mst_fees (session ,class_id ,acc_id ,fees_amount ,bl_onetime ,bl_apr ,bl_may ,bl_jun ,bl_jul ,bl_aug ,bl_sep ,bl_oct ,bl_nov ,bl_dec ,bl_jan ,bl_feb ,bl_mar) VALUES (@session, @class_id, @acc_id, @fees_amount, @bl_onetime, @bl_apr, @bl_may, @bl_jun, @bl_jul, @bl_aug, @bl_sep, @bl_oct, @bl_nov, @bl_dec, @bl_jan, @bl_feb, @bl_mar)"; mst.session = session; con.Execute(query, new { mst.session, mst.class_id, mst.acc_id, mst.fees_amount, mst.bl_onetime, mst.bl_apr, mst.bl_may, mst.bl_jun, mst.bl_jul, mst.bl_aug, mst.bl_sep, mst.bl_oct, mst.bl_nov, mst.bl_dec, mst.bl_jan, mst.bl_feb, mst.bl_mar }); } } catch (Exception ex) { throw ex; } }