public void AddHead(mst_acc_head mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = @"INSERT INTO mst_acc_head (session ,acc_id ,acc_name) VALUES (@session ,@acc_id ,@acc_name)"; string maxid = "select ifnull(MAX(acc_id),0)+1 from mst_acc_head where session = @session"; mst_sessionMain sess = new mst_sessionMain(); string ses = sess.findActive_Session(); int id = con.ExecuteScalar <int>(maxid, new { session = ses }); mst.acc_id = id; mst.session = ses; con.Execute(query, new { mst.acc_id, mst.acc_name, mst.session }); } } catch (Exception ex) { throw ex; } }
public void EditAccount(mst_acc_head mst) { try { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { mst_sessionMain sess = new mst_sessionMain(); string ses = sess.findActive_Session(); mst.session = ses; string query = "UPDATE mst_acc_head SET acc_name = @acc_name WHERE acc_id = @acc_id and session = @session"; con.Execute(query, mst); } } catch (Exception ex) { throw ex; } }