internal ReferenceObj find(string invoice_id, string document_id)
{
string txtQuery = string.Format("SELECT * FROM {0} WHERE invoice_id = @invoice_id and document_id = @document_id limit 1", this.tableName);
try
{
ReferenceObj data = new ReferenceObj();
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@invoice_id", invoice_id);
cmd.Parameters.AddWithValue("@document_id", document_id);
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
data.id = Convert.ToInt32(dr["id"]);
data.invoiceId = dr["invoice_id"].ToString();
data.documentId = dr["document_id"].ToString();
data.documentDate = dr["document_date"].ToString();
data.typeCode = dr["type_code"].ToString();
}
}
}
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Equals(ReferenceObj obj)
{
if (this.number != obj.number)
{
return(false);
}
if (this.documentId != obj.documentId)
{
return(false);
}
if (this.documentDate != obj.documentDate)
{
return(false);
}
if (this.typeCode != obj.typeCode)
{
return(false);
}
if (this.typeCodeObj.code != obj.typeCodeObj.code)
{
return(false);
}
if (this.typeCodeObj.description != obj.typeCodeObj.description)
{
return(false);
}
return(true);
}
void Start()
{
PlayerScript.Reset();
Time.timeScale = 1f;
GameObject lastLevelData = GameObject.FindGameObjectWithTag("AlwaysThere");
ReferenceObj reference = lastLevelData.GetComponent <ReferenceObj> ();
Data data = Data.GetInstance();
//Level_mX_XX
string lastLevelName = reference.GetReferenceByName("LastLevelName").ToString();
lastLevel = int.Parse(lastLevelName.Substring(9));
completion = ((int)reference.GetReferenceByName("Completion")) + 1;
world = int.Parse(lastLevelName.ToCharArray() [7].ToString());
if (data.completedLevels [world - 1, lastLevel - 1] < completion)
{
data.completedLevels [world - 1, lastLevel - 1] = completion;
Data.SetInstance(data);
}
Data.CheckForWorldAndPowerUnlocking();
Destroy(lastLevelData);
GameObject bg = new GameObject("Background");
bg.transform.position = Vector3.zero;
bg.transform.localScale = new Vector3(P.pocSGame(1f, Side.W), P.pocSGame(1f, Side.H), 1f);
SpriteRenderer srBg = bg.AddComponent <SpriteRenderer> ();
srBg.sortingOrder = -100;
srBg.sprite = Resources.Load <Sprite> ("pixel");
if (completion - 1 == (int)Completion.DIED)
{
srBg.color = Color.black;
}
else
{
srBg.color = Color.white;
mainText.text = "LEVEL COMPLETE";
textButton1.text = "Next";
mainText.color = Color.black;
textButton1.color = Color.black;
textButton2.color = Color.black;
for (int i = 0; i < borders.Length; i++)
{
borders [i].color = Color.black;
}
}
mainText.canvasRenderer.SetAlpha(0f);
mainText.CrossFadeAlpha(1f, 0.8f, true);
StartCoroutine("go");
if ((completion - 1 != (int)Completion.DIED) && lastLevel == 20 && world == WorldSelectBanner.maxWorld)
{
Destroy(but1Click);
textButton1.text = "No next lvl";
}
}
public static void CreateEndLevelObj(string lastLevelName, Completion completion)
{
GameObject g = new GameObject("LastLevelData");
ReferenceObj r = g.AddComponent <ReferenceObj> ();
r.names = new string[] { "LastLevelName", "Completion" };
r.objects = new object[] { lastLevelName, completion };
g.tag = "AlwaysThere";
DontDestroyOnLoad(g);
}
internal void save(ReferenceObj obj)
{
string txtQuery = string.Empty;
if (obj.id == 0)
{
txtQuery = string.Format("INSERT INTO {0} (invoice_id,document_id,document_date,type_code) VALUES ", this.tableName);
string values = string.Format("(@invoice_id,@document_id,@document_date,@type_code)");
txtQuery = txtQuery + values;
}
else
{
txtQuery = string.Format("UPDATE {0} SET ", this.tableName);
string values = string.Format("invoice_id=@invoice_id,document_id=@document_id,document_date=@document_date,type_code=@type_code ");
string condition = string.Format("WHERE id=@id");
txtQuery = txtQuery + values + condition;
}
using (SQLiteConnection c = new SQLiteConnection(sqlite.ConnectionString))
{
c.Open();
using (SQLiteCommand cmd = new SQLiteCommand(txtQuery, c))
{
cmd.Parameters.AddWithValue("@invoice_id", obj.invoiceId);
cmd.Parameters.AddWithValue("@document_id", obj.documentId);
if (obj.documentDate.Length > 0)
{
cmd.Parameters.AddWithValue("@document_date", obj.documentDate);
}
else
{
cmd.Parameters.AddWithValue("@document_date", DateTime.Now.ToString("yyyy-MM-dd H:mm:ss", new System.Globalization.CultureInfo("th-TH")));
}
cmd.Parameters.AddWithValue("@type_code", obj.typeCode);
if (obj.id != 0)
{
cmd.Parameters.AddWithValue("@id", obj.id);
}
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
}
}
public void StartLevel()
{
if (SquareClick.windowOut && SquareClick.canMove)
{
print("Level_m" + mondeActuel + "_" + SquareClick.selectedLvl);
CheckBox checkEasy = GameObject.FindGameObjectWithTag("ValidEasy").GetComponent <CheckBox> ();
CheckBox checkCoop = GameObject.FindGameObjectWithTag("ValidCoop").GetComponent <CheckBox>();
GameObject p = new GameObject("Params");
p.tag = "Params";
DontDestroyOnLoad(p);
ReferenceObj r = p.AddComponent <ReferenceObj> ();
r.names = new string[] { "isEasy", "isCoop" };
r.objects = new object[] { checkEasy.isChecked, checkCoop.isChecked };
UnityEngine.SceneManagement.SceneManager.LoadScene("Level_m" + mondeActuel + "_" + SquareClick.selectedLvl);
}
}
private void setRef1()
{
if (docIdTb.Text != "")
{
ReferenceObj ref1 = refList.FirstOrDefault(s => s.number == 1);
if (ref1 == null)
{
refList.Add(new ReferenceObj(1));
}
ref1 = refList.FirstOrDefault(s => s.number == 1);
ref1.documentId = docIdTb.Text;
ref1.documentDate = docDateTb.Text;
ref1.typeCode = REF_TYPE;
ref1.invoiceId = this.invoiceID;
ref1.typeCodeObj = new TypeCodeObj(REF_TYPE, REF_NAME);
}
}
private void setRef1()
{
if (docIdTb.Text != "" && is_replace.IsChecked.Value)
{
ReferenceObj ref1 = refList.FirstOrDefault(s => s.number == 1);
if (ref1 == null)
{
//refList.Add(new ReferenceObj(1, this.invoiceID, docIdTb.Text, docDateTb.Text, REF_TYPE,new TypeCodeObj(REF_TYPE,"ใบกำกับภาษี")));
refList.Add(new ReferenceObj(1));
}
ref1 = refList.FirstOrDefault(s => s.number == 1);
ref1.invoiceId = this.invoiceID;
ref1.documentId = docIdTb.Text;
ref1.documentDate = docDateTb.Text;
ref1.typeCode = REF_TYPE;
ref1.typeCodeObj = new TypeCodeObj(REF_TYPE, REF_NAME);
}
}
private bool isChange()
{
ReferenceObj ref1 = refList.FirstOrDefault(s => s.number == 1);
if (documentId1.Text.Length > 0 != (ref1 != null))
{
return(true);
}
else
{
if (ref1 != null)
{
if (!ref1.Equals(new ReferenceObj(1, this.invoiceId, documentId1.Text, documentDate1.Text, typeCode1.Text, (TypeCodeObj)typeCode1.SelectedItem)))
{
return(true);
}
}
}
ReferenceObj ref2 = refList.FirstOrDefault(s => s.number == 2);
if (documentId2.Text.Length > 0 != (ref2 != null))
{
return(true);
}
else
{
if (ref2 != null)
{
if (!ref2.Equals(new ReferenceObj(2, this.invoiceId, documentId2.Text, documentDate2.Text, typeCode2.Text, (TypeCodeObj)typeCode2.SelectedItem)))
{
return(true);
}
}
}
ReferenceObj ref3 = refList.FirstOrDefault(s => s.number == 3);
if (documentId3.Text.Length > 0 != (ref3 != null))
{
return(true);
}
else
{
if (ref3 != null)
{
if (!ref3.Equals(new ReferenceObj(3, this.invoiceId, documentId3.Text, documentDate3.Text, typeCode3.Text, (TypeCodeObj)typeCode3.SelectedItem)))
{
return(true);
}
}
}
ReferenceObj ref4 = refList.FirstOrDefault(s => s.number == 4);
if (documentId4.Text.Length > 0 != (ref4 != null))
{
return(true);
}
else
{
if (ref4 != null)
{
if (!ref4.Equals(new ReferenceObj(4, this.invoiceId, documentId4.Text, documentDate4.Text, typeCode4.Text, (TypeCodeObj)typeCode4.SelectedItem)))
{
return(true);
}
}
}
ReferenceObj ref5 = refList.FirstOrDefault(s => s.number == 5);
if (documentId5.Text.Length > 0 != (ref5 != null))
{
return(true);
}
else
{
if (ref5 != null)
{
if (!ref5.Equals(new ReferenceObj(5, this.invoiceId, documentId5.Text, documentDate5.Text, typeCode5.Text, (TypeCodeObj)typeCode5.SelectedItem)))
{
return(true);
}
}
}
return(false);
}
void Awake()
{
P.init(); //init the magic number for screen scaling
Time.timeScale = 1f; //just in case it had been changed
WorldSelectBanner.Reset();
SquareClick.Reset();
//create the boundary at the screen's size
GameObject boundary = new GameObject();
boundary.name = "Boundary";
boundary.tag = "Boundary";
BoxCollider2D boundaryColl = boundary.AddComponent <BoxCollider2D> ();
boundaryColl.isTrigger = true;
boundaryColl.size = new Vector2(P.pocP(2f, Side.W), P.pocP(2f, Side.H));
//background
GameObject bg = new GameObject("Background");
bg.transform.position = Vector3.zero;
bg.transform.localScale = new Vector3(P.pocSGame(1f, Side.W), P.pocSGame(1f, Side.H), 1f);
SpriteRenderer srBg = bg.AddComponent <SpriteRenderer> ();
srBg.sortingOrder = -100;
srBg.sprite = Resources.Load <Sprite> ("pixel");
//Level_mX_XX
try{
switch (UnityEngine.SceneManagement.SceneManager.GetActiveScene().name.ToCharArray() [7])
{
case '1':
srBg.color = new Color(0.22352941176470588235294117647059f, 0.32549019607843137254901960784314f, 0.64313725490196078431372549019608f, 1f);
break;
case '2':
srBg.color = new Color(0.64705882352941176470588235294118f, 0.21568627450980392156862745098039f, 0.21568627450980392156862745098039f, 1f);
break;
case '3':
srBg.color = new Color(0.23529411764705882352941176470588f, 0.18039215686274509803921568627451f, 0.11372549019607843137254901960784f, 1f);
break;
default:
srBg.color = new Color(1f, 0f, 0f, 1f);
break;
}
}catch (Exception) {
srBg.color = new Color(1f, 0f, 0f, 1f);
}
//params
GameObject para = GameObject.FindGameObjectWithTag("Params");
if (para != null)
{
ReferenceObj refe = para.GetComponent <ReferenceObj> ();
easyMode = (bool)refe.GetReferenceByName("isEasy");
coopMode = (bool)refe.GetReferenceByName("isCoop");
Destroy(para);
}
//player
if (coopMode)
{
GameObject player1 = Instantiate(playerPrefab) as GameObject;
GameObject player2 = Instantiate(playerPrefab) as GameObject;
player1.name = "player1";
player2.name = "player2";
// Destroy (player1.GetComponent<PlayerScript> ());
// Destroy (player2.GetComponent<PlayerScript> ());
PlayerCoopScript pScript1 = player1.AddComponent <PlayerCoopScript> ();
PlayerCoopScript pScript2 = player2.AddComponent <PlayerCoopScript> ();
PlayerCoopScript.LinkPlayers(pScript1, pScript2);
player1.transform.position = new Vector2(0, P.pocP(-0.7f, Side.HEIGHT));
player2.transform.position = new Vector2(0, P.pocP(0.7f, Side.HEIGHT));
mat = player1.GetComponent <MeshRenderer> ().material;
contourColor = mat.color;
playerInstance = pScript1;
}
else
{
GameObject player = Instantiate(playerPrefab) as GameObject;
player.transform.position = new Vector2(0, P.pocP(-0.7f, Side.HEIGHT));
mat = player.GetComponent <MeshRenderer> ().material;
playerInstance = player.AddComponent <PlayerScript> ();
contourColor = mat.color;
}
PlayerScript.afterColorChange += OnColorChange;
//obstacles
GameObject[] obs = GameObject.FindGameObjectsWithTag("Obstacle");
obstacles.AddRange(obs);
StartCoroutine(Enabler());
startTime = Time.time;
foreach (object g in obstacles)
{
((GameObject)g).SetActive(false);
if (((GameObject)g).GetComponent <GameObstacle> ().startAtTime < timeOffset)
{
Destroy((GameObject)g);
}
}
//setup UI
Data data = Data.GetInstance();
GameObject ui = Instantiate(Resources.Load <GameObject> ("PowerIcons/PowerButtons")) as GameObject;
if (easyMode)
{
ui.transform.FindChild("LifeCount").gameObject.SetActive(true);
}
for (int i = 0; i < 4; i++)
{
GameObject powUi = ui.transform.FindChild("Power" + (i + 1)).gameObject;
PowerScript powScript = powUi.GetComponent <PowerScript> ();
Slider slider = powUi.GetComponent <Slider> ();
PowerAttribut attrib = data.GetPowerAttribut(data.selectedPowers [i]);
Power pow = Power.GetInstance(data.selectedPowers [i], slider);
if (data.selectedPowers [i] == Powers.Null)
{
powUi.SetActive(false);
}
else
{
pow.SetAttribut(attrib);
powScript.power = pow;
powUi.transform.FindChild("Icon").GetComponent <Image> ().sprite = pow.icon;
}
}
}
