Sort

909     public static void UpdateRpcList()
910     {
911         List additionalRpcs = new List();
912         HashSet currentRpcs = new HashSet();
913
914         var types = GetAllSubTypesInScripts(typeof(MonoBehaviour));
915
916         foreach (var mono in types)
917         {
918             MethodInfo[] methods = mono.GetMethods(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance);
919
920             foreach (MethodInfo method in methods)
921             {
922                 if (method.IsDefined(typeof(UnityEngine.RPC), false))
923                 {
924                     currentRpcs.Add(method.Name);
925
926                     if (!additionalRpcs.Contains(method.Name) && !PhotonEditor.Current.RpcList.Contains(method.Name))
927                     {
928                         additionalRpcs.Add(method.Name);
929                     }
930                 }
931             }
932         }
933
934         if (additionalRpcs.Count > 0)
935         {
936             // LIMITS RPC COUNT
937             if (additionalRpcs.Count + PhotonEditor.Current.RpcList.Count >= byte.MaxValue)
938             {
939                 if (currentRpcs.Count <= byte.MaxValue)
940                 {
941                     bool clearList = EditorUtility.DisplayDialog(CurrentLang.IncorrectRPCListTitle, CurrentLang.IncorrectRPCListLabel, CurrentLang.RemoveOutdatedRPCsLabel, CurrentLang.CancelButton);
942                     if (clearList)
943                     {
944                         PhotonEditor.Current.RpcList.Clear();
945                         PhotonEditor.Current.RpcList.AddRange(currentRpcs);
946                     }
947                     else
948                     {
949                         return;
950                     }
951                 }
952                 else
953                 {
954                     EditorUtility.DisplayDialog(CurrentLang.FullRPCListTitle, CurrentLang.FullRPCListLabel, CurrentLang.SkipRPCListUpdateLabel);
955                     return;
956                 }
957             }
958
959             additionalRpcs.Sort();
960             PhotonEditor.Current.RpcList.AddRange(additionalRpcs);
961             EditorUtility.SetDirty(PhotonEditor.Current);
962         }
963     }

39   public DataSet GetLoad(string sortfield)
40   {
41
42    System.Data.OleDb.OleDbConnection conn = GetConnection();
43    DataSet ds = new DataSet();
44
45    try
46    {
47
48     // Dim sql As String = "SELECT ID data1 as [Firstname],data2 as [Lastname],data3 as [20],data4 as [EG],data5 as [1st-10%],data6 as [50pt],data7 as [EG1],data8 as [2nd-10%],data9 as [50pts],data10 as [EG2],data11 as [20%],data12 as [100pt],data13 as [EG3],data14 as [30%],data15 as [100],data16 as [EG4],data17 as [2nd-30%],data18 as [PrelimGrade],data19 as [Remarks]FROM Table1 order by " + sortfield
49     string sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
50
51     System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
52     try
53     {
54      da.Fill(ds, "grade1");
55     }
56     finally
57     {
58      da.Dispose();
59     }
60     return ds;
61    }
62    finally
63    {
64     conn.Close();
65     conn.Dispose();
66    }
67   }

110   public DataSet SaveItem(string sortfield)
111   {
112
113    System.Data.OleDb.OleDbConnection conn = GetConnection();
114
115    try
116    {
117
118     string SQL = default(string);
119
120     SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121     System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142
143     conn.Open();
144     cmd.ExecuteNonQuery();
145     conn.Close();
146     MessageBox.Show("New data is Added!");
147
148     Form1.Default.TextBox1.Text = "";
149     Form1.Default.TextBox2.Text = "";
150     Form1.Default.TextBox3.Text = "";
151     Form1.Default.TextBox4.Text = "";
152     Form1.Default.TextBox5.Text = "";
153     Form1.Default.TextBox6.Text = "";
154     Form1.Default.TextBox7.Text = "";
155     Form1.Default.TextBox8.Text = "";
156     Form1.Default.TextBox9.Text = "";
157     Form1.Default.TextBox10.Text = "";
158     Form1.Default.TextBox11.Text = "";
159     Form1.Default.TextBox12.Text = "";
160     Form1.Default.TextBox13.Text = "";
161     Form1.Default.TextBox14.Text = "";
162     Form1.Default.TextBox15.Text = "";
163     Form1.Default.TextBox16.Text = "";
164     Form1.Default.TextBox17.Text = "";
165     Form1.Default.TextBox18.Text = "";
166     Form1.Default.TextBox19.Text = "";
167     Form1.Default.STUDID.Text = "";
168
169     RefreshDGV();
170
171    }
172    finally
173    {
174     conn.Close();
175     conn.Dispose();
176    }
177
178    return default(DataSet);
179   }

185   public DataSet navigate(string sortfield)
186   {
187
188    System.Data.OleDb.OleDbConnection conn = GetConnection();
189    DataSet ds = new DataSet();
190
191    try
192    {
193
194     int inc;
195     int MaxRows;
196
197     string sql = "select * from table1";
198     System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
199
200     try
201     {
202      da.Fill(ds, "grade1");
203      MaxRows = ds.Tables["grade1"].Rows.Count;
204      inc = -1;
205
206
207     }
208     finally
209     {
210      da.Dispose();
211     }
212
213     return ds;
214    }
215    finally
216    {
217     conn.Close();
218     conn.Dispose();
219    }
220   }

225   public DataSet deldata(string sortfield)
226   {
227
228    System.Data.OleDb.OleDbConnection conn = GetConnection();
229    DataSet ds = new DataSet();
230
231    try
232    {
233
234     int inc;
235     int MaxRows;
236
237     //Dim sql As String = "select * from table1"
238     //Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn)
239
240     try
241     {
242
243      string sqldelete = default(string);
244      sqldelete = "DELETE * FROM table1 WHERE STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
245      System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqldelete, conn);
246
247      // Gets the records from the table and fills our adapter with those.
248      DataTable dt = new DataTable("grade1");
249      da.Fill(dt);
250      MessageBox.Show("Data has been deleted");
251      clearall();
252
253      Form1.Default.DataGridView1.DataSource = dt;
254
255      RefreshDGV();
256
257     }
258     finally
259     {
260      //da.Dispose()
261     }
262
263     return ds;
264    }
265    finally
266    {
267     conn.Close();
268     conn.Dispose();
269    }
270   }

276   public DataSet updtedata(string sortfield)
277   {
278
279    System.Data.OleDb.OleDbConnection conn = GetConnection();
280    DataSet ds = new DataSet();
281
282    try
283    {
284
285     string sqlupdate = default(string);
286
287     sqlupdate = "UPDATE Table1 set STUDENTID=@STUDENTID, data1=@data1, data2=@data2, data3=@data3, data4=@data4," + "data5=@data5, data6=@data6, data7=@data7, data8=@data8, data9=@data9, data10=@data10," + "data11=@data11, data12=@data12, data13=@data13, data14=@data14, data15=@data15, data16=@data16," + "data17=@data17, data18=@data18, data19=@data19 where STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
288     System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sqlupdate, conn);
289
290     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
291     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
292     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
293     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
294     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
295     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
296     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
297     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
298     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
299     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
300     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
301     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
302     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
303     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
304     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
305     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
306     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
307     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
308     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
309     cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
310
311     conn.Open();
312     cmd.ExecuteNonQuery();
313     conn.Close();
314     MessageBox.Show("Data Updated in the Database");
315     RefreshDGV();
316
317    }
318    finally
319    {
320    }
321    return ds;
322   }

26         public void setText(string oneline)
27         {
28             bitmapFont = new BitmapFont("Fonts/shop_font", "Fonts/shop_font_xml", label1);
29             bitmapFont.setText(oneline, 0, 15);
30             Transform[] fontTransforms = label1.GetComponentsInChildren(true);
31             for (int i = 0; i < fontTransforms.Length; i++)
32             {
33                 if (fontTransforms[i].gameObject.GetComponent() != null)
34                 {
35                     fontTransforms[i].gameObject.layer = LayerMask.NameToLayer("GUI");
36                     fontTransforms[i].gameObject.GetComponent().sortingLayerName = "GUI";
37                 }
38             }
39         }

41         public void setText(string line1, string line2)
42         {
43             bitmapFont = new BitmapFont("Fonts/shop_font", "Fonts/shop_font_xml", label1);
44             bitmapFont.setText(line1, 0, 15);
45             Transform[] fontTransforms = label1.GetComponentsInChildren(true);
46             for (int i = 0; i < fontTransforms.Length; i++)
47             {
48
49                 if (fontTransforms[i].gameObject.GetComponent() != null)
50                 {
51                     fontTransforms[i].gameObject.layer = LayerMask.NameToLayer("GUI");
52                     fontTransforms[i].gameObject.GetComponent().sortingLayerName = "GUI";
53                 }
54             }
55
56             BitmapFont bitmapFont2 = new BitmapFont(bitmapFont, label2);
57             bitmapFont2.setText(line2, 0, 15);
58             Transform[] fontTransforms2 = label2.GetComponentsInChildren(true);
59             for (int i = 0; i < fontTransforms2.Length; i++)
60             {
61                 if (fontTransforms2[i].gameObject.GetComponent() != null)
62                 {
63                     fontTransforms2[i].gameObject.layer = LayerMask.NameToLayer("GUI");
64                     fontTransforms2[i].gameObject.GetComponent().sortingLayerName = "GUI";
65                 }
66             }
67         }

129         private void createStars(Vector3 position, int starIndex)
130         {
131             for (int i = 0; i < 20; i++)
132             {
133                 GameObject starObject = new GameObject("StarFly");
134                 starObject.layer = LayerMask.NameToLayer("GUI");
135                 starObject.transform.parent = gameObject.transform;
136                 starObject.transform.localPosition = new Vector3(position.x, position.y, -3);
137                 starObject.AddComponent().sprite = starSprite;
138                 starObject.GetComponent().sortingLayerName = "GUI";
139                 starObject.transform.localScale = new Vector3(0.5f, 0.5f, starObject.transform.localScale.z);
140
141                 starObject.AddComponent().addAction(new ActionParallel(
142                     new ActionRotateBy(720, 2),
143                     new ActionScaleTo(0, 0, 1.5f)
144                     ));
145
146                 if (starIndex == 0)
147                 {
148                     starObject.AddComponent().setBezier(-1,
149                         new Vector2(position.x, position.y),
150                         new Vector2(position.x, Random.Range(1f, 2f)),
151                         new Vector2(position.x - Random.Range(2f, 3f), Random.Range(1f, 2f)),
152                         new Vector2(position.x - Random.Range(2f, 5.5f), Random.Range(-2f, -1f))
153                         );
154                 }
155                 else if (starIndex == 1)
156                 {
157                     starObject.AddComponent().setBezier(-1,
158                         new Vector2(position.x, position.y),
159                         new Vector2(position.x, Random.Range(1f, 2f)),
160                         new Vector2(Random.Range(-1f, 1f), Random.Range(1f, 2f)),
161                         new Vector2(Random.Range(-2f, 2f), Random.Range(-4f, -2f))
162                         );
163                 }
164                 else if (starIndex == 2)
165                 {
166                     starObject.AddComponent().setBezier(-1,
167                         new Vector2(position.x, position.y),
168                         new Vector2(position.x, Random.Range(1f, 2f)),
169                         new Vector2(position.x + Random.Range(2f, 3f), Random.Range(1f, 2f)),
170                         new Vector2(position.x + Random.Range(2f, 5.5f), Random.Range(-4f, -2f))
171                         );
172                 }
173                 Destroy(starObject, 2);
174             }
175         }

82         private void createShadow()
83         {
84             if (animalIndex != 0) return;
85             shadowCreateTime += Time.deltaTime;
86             if (shadowCreateTime >= 0.05f)
87             {
88                 shadowCreateTime = 0;
89                 GameObject shadowObject = new GameObject("Shadow");
90                 shadowObject.transform.parent = gameScreen.shadowLayer.transform;
91                 shadowObject.layer = LayerMask.NameToLayer("AnimalStand");
92                 shadowObject.transform.localPosition = transform.localPosition + new Vector3(0, 0.3f, 0);
93                 shadowObject.AddComponent().sprite = shadowSprite;
94                 shadowObject.GetComponent().sortingLayerName = "MapObject";
95                 shadowObject.GetComponent().color = new Color(1, 1, 1, 0.8f);
96                 shadowObject.AddComponent().addAction(new ActionSequence(
97                     new ActionColorTo(0, 0, 0, 0, 0.5f),
98                     new ActionRunnable(delegate ()
99                 {
100                     Destroy(shadowObject);
101                 })
102                 ));
103             }
104         }