// Use this for initialization
void Start()
{
Floor = GameObject.Find("StairsText").GetComponent <StairsText>();
Move = GameObject.Find("Moving").GetComponent <Moving>();
PS = GameObject.Find("PlayerStatus").GetComponent <PlayerStatus>();
EXP = GameObject.Find("EXPText").GetComponent <EXPText>();
}
// Use this for initialization
void Start()
{
Movement = GameObject.Find("Moving").GetComponent <Moving>();
PS = GameObject.Find("PlayerStatus").GetComponent <PlayerStatus>();
EXP = GameObject.Find("EXPText").GetComponent <EXPText>();
ES = GameObject.Find("EventScene").GetComponent <EventScene>();
}
// Use this for initialization
void Awake()
{
MSScript = GameObject.Find("EventScene").GetComponent <EventScene>();
ReceiveFlag = GameObject.Find("EventScene").GetComponent <EventScene>();
PS = GameObject.Find("PlayerStatus").GetComponent <PlayerStatus>();
EXPText = GameObject.Find("EXPText").GetComponent <EXPText>();
}
// Use this for initialization
void Awake()
{
//プレイヤーステータスの設定
//プレイヤーのステータスを参照
PlayerLEVEL = GameObject.Find("LEVELText").GetComponent <LEVELText>();
PlayerHP = GameObject.Find("HPText").GetComponent <HPText>();
PlayerATK = GameObject.Find("ATKText").GetComponent <ATKText>();
PlayerSPD = GameObject.Find("SPDText").GetComponent <SPDText>();
PlayerEXP = GameObject.Find("EXPText").GetComponent <EXPText>();
}
private void OFSaveButton_Click(object sender, EventArgs e)
{
string query = ""; int DepartmentKey = ((KeyValuePair <int, string>)DeptcomboBox.SelectedItem).Key;
String DepartmentValue = ((KeyValuePair <int, string>)DeptcomboBox.SelectedItem).Value;
String DesignationValue = ((KeyValuePair <int, string>)DesigcomboBox.SelectedItem).Value;
String BloodValue = ((KeyValuePair <int, string>)BloodcomboBox.SelectedItem).Value;
String StatusValue = ((KeyValuePair <int, string>)Statuscombo.SelectedItem).Value;
string que = ""; int DesignationKey = ((KeyValuePair <int, string>)DesigcomboBox.SelectedItem).Key;
string qu = ""; int BloodKey = ((KeyValuePair <int, string>)BloodcomboBox.SelectedItem).Key;
string q = ""; int StatusKey = ((KeyValuePair <int, string>)Statuscombo.SelectedItem).Key;
if (StaftextBox.Text == "")
{
query = "SELECT Count(*) AS Count FROM Official_Info";
int rowsCount = DbAccess.NumberOfRecords(query) + 1;
stfID = Convert.ToInt32(DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + rowsCount.ToString());
}
if (StaffNatext.Text.Trim() == "")
{
MessageBox.Show("Please Enter Staff Name");
StaffNatext.Focus();
return;
}
if (DepartmentKey < 1)
{
MessageBox.Show("Please Enter Department");
DeptcomboBox.Focus();
return;
}
if (DesignationKey < 1)
{
MessageBox.Show("Please Enter designation");
DesigcomboBox.Focus();
return;
}
if (EXPText.Text.Trim() == "")
{
MessageBox.Show("Please Enter Experience");
EXPText.Focus();
return;
}
if (BloodKey < 1)
{
MessageBox.Show("Please Enter BloodGroup");
BloodcomboBox.Focus();
return;
}
if (joindateTimePicker.Text.Trim() == "")
{
MessageBox.Show("Please Enter Time");
joindateTimePicker.Focus();
return;
}
if (NationaText.Text.Trim() == "")
{
MessageBox.Show("Please Enter Nationality");
NationaText.Focus();
return;
}
if (StatusKey < 1)
{
MessageBox.Show("Please Enter Status");
Statuscombo.Focus();
return;
}
try
{
if (StaftextBox.Text == "")
{
query = "INSERT INTO Official_Info(StaffID,StaffName,Department,Designation,AgeExp,BloodGroup,JoiningDate,Nationality,Status ) VALUES(" + stfID + ", '" + StaffNatext.Text + "', '" + DepartmentValue + "', '" + DesignationValue + "', " + Convert.ToInt32(EXPText.Text) + ", '" + BloodValue + "' , '" + joindateTimePicker.Value.ToString("yyyy/MM/dd") + "', '" + NationaText.Text + "', '" + StatusValue + "' )";
}
else
{
query = "UPDATE Official_Info SET StaffName = '" + StaffNatext.Text + "' ,Department = '" + DepartmentValue + "', Designation = '" + DesignationValue + "', AgeExp= '" + Convert.ToInt32(EXPText.Text) + "',BloodGroup = '" + BloodValue + "', JoiningDate = '" + joindateTimePicker.Value.ToString("yyyy/MM/dd") + "',Nationality = '" + NationaText.Text + "',Status = '" + StatusValue + "' WHERE StaffID = " + Convert.ToInt32(StaftextBox.Text);
}
if (DbAccess.ExecuteToDB(query))
{
if (stfID != 0)
{
MessageBox.Show("Saved Successfully!!!");
}
else
{
MessageBox.Show("Updated Successfully!!!");
}
}
else
{
MessageBox.Show("Failed To Save!!!");
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
