public void EditStudent(sr_register std) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { mst_sessionMain sess = new mst_sessionMain(); string session = sess.findActive_finalSession(); string query1 = @"select std_pickup_id from sr_register where sr_number = @sr_number"; int pick_id = con.Query <int>(query1, new { sr_number = std.sr_number }).SingleOrDefault(); query1 = @"select class_id from mst_std_class where sr_num = @sr_number and session = @session"; int class_id = con.Query <int>(query1, new { sr_number = std.sr_number, session = session }).SingleOrDefault(); query1 = @"select section_id from mst_std_section where sr_num = @sr_number and session = @session"; int sec_id = con.Query <int>(query1, new { sr_number = std.sr_number, session = session }).SingleOrDefault(); query1 = @"SELECT std_active FROM sr_register WHERE sr_number = @sr_number"; string old_active_status = con.Query <string>(query1, new { sr_number = std.sr_number }).SingleOrDefault(); string query = @"UPDATE sr_register SET std_first_name = @std_first_name ,std_last_name = @std_last_name ,std_father_name = @std_father_name ,std_mother_name = @std_mother_name ,std_address = @std_address ,std_address1 = @std_address1 ,std_address2 = @std_address2 ,std_district = @std_district ,std_state = @std_state ,std_country = @std_country ,std_pincode = @std_pincode ,std_contact = @std_contact ,std_contact1 = @std_contact1 ,std_contact2 = @std_contact2 ,std_email = @std_email ,std_father_occupation = @std_father_occupation ,std_mother_occupation = @std_mother_occupation ,std_blood_gp = @std_blood_gp ,std_house_income = @std_house_income ,std_nationality = @std_nationality ,std_category = @std_category ,std_cast = @std_cast ,std_dob = @std_dob ,std_sex = @std_sex ,std_last_school = @std_last_school ,std_admission_date = @std_admission_date ,std_house = @std_house ,std_remark = @std_remark ,std_active = @std_active ,std_pickup_id = @std_pickup_id ,std_admission_class = @std_admission_class ,std_aadhar = @std_aadhar ,adm_form_link = @adm_form_link WHERE sr_number = @sr_number"; con.Execute(query, std); if (!std.active && old_active_status == "Y") { out_standingMain otsd = new out_standingMain(); otsd.markStdNSO(std.sr_number); DashboardHub hub = new DashboardHub(); hub.DashboardSchoolStrength(); } else { if (old_active_status != std.std_active) { var p = new DynamicParameters(); p.Add("@sr_num", std.sr_number); p.Add("@from_month_no", std.from_month_no); con.Execute("StdMidSessionTransportChange", p, commandType: System.Data.CommandType.StoredProcedure); DashboardHub hub = new DashboardHub(); hub.DashboardSchoolStrength(); p = new DynamicParameters(); p.Add("@sr_num", std.sr_number); con.Execute("stdMidSessionMonthlyCharge", p, commandType: System.Data.CommandType.StoredProcedure); string query2 = @"UPDATE sr_register SET nso_date = NULL WHERE sr_number = @sr_num"; con.Execute(query2, new { sr_num = std.sr_number }); } else { if (pick_id != std.std_pickup_id && std.std_active == "Y") { //call procedure to change the pickup point var p = new DynamicParameters(); p.Add("@sr_num", std.sr_number); p.Add("@from_month_no", std.from_month_no); con.Execute("StdMidSessionTransportChange", p, commandType: System.Data.CommandType.StoredProcedure); DashboardHub hub = new DashboardHub(); hub.DashboardSchoolStrength(); } if (class_id != std.class_id) { //call procedure to change the class query = @"UPDATE `mst_std_class` SET `class_id` = @class_id WHERE `session` = @session AND `sr_num` = @sr_num"; con.Execute(query, new { class_id = std.class_id, session = session, sr_num = std.sr_number }); if (std.std_active == "Y") { var p = new DynamicParameters(); p.Add("@sr_num", std.sr_number); con.Execute("stdMidSessionMonthlyCharge", p, commandType: System.Data.CommandType.StoredProcedure); } } if (sec_id != std.std_section_id) { query = @"UPDATE `mst_std_section` SET `section_id` = @section_id WHERE `session` = @session AND `sr_num` = @sr_num"; con.Execute(query, new { section_id = std.std_section_id, session = session, sr_num = std.sr_number }); query = @"DELETE FROM `mst_rollnumber` WHERE session = @session and sr_num = @sr_num"; con.Execute(query, new { sr_num = std.sr_number, session = session }); } } } } } catch (Exception ex) { throw ex; } }