protected override void BuildModuleSpecificFilter()
{
// need to filter if requesting by status type
if (Status_Type != ParaEnums.TicketStatusType.All)
{
_QueryFilters.Add("_status_type_=" + Status_Type.ToString().ToLower());
}
if (MyTickets == true)
{
_QueryFilters.Add("_my_tickets_=true");
}
// Checking if this is a view request.
if (View > 0)
{
_QueryFilters.Add("_view_=" + View.ToString());
}
}
public StatusPage(string jobNo, string partNo, string customer, string type)
{
InitializeComponent();
this.jobNo = jobNo;
this.partNo = partNo;
this.customer = customer;
if (type.Equals("Contract Review"))
{
this.type = Status_Type.ContractReview;
}
else if (type.Equals("Quick Release"))
{
this.type = Status_Type.QuickRelease;
}
else
{
this.type = Status_Type.None;
}
}
public Scroll(Scroll s)
: base(s.get_my_IDno(), s.get_my_gold_value(), s.get_my_name())
{
//Enums
my_sType = s.get_spell_type();
spell_dmg_type = s.get_damage_type();
my_prjType = s.get_assoc_projectile();
my_specAnim = s.get_spec_impact_anim();
myBufforDebuff = s.get_status_effect();
//Ints
scroll_tier = s.get_tier();
aoe_size = s.get_aoe_size();
max_range = s.get_range();
min_damage = s.get_specific_damage(false);
max_damage = s.get_specific_damage(true);
total_impacts = s.get_t_impacts();
mana_cost = s.get_manaCost();
buffDebuff_duration = s.get_duration();
//Bools
destroys_walls = s.spell_destroys_walls();
melee_range = s.is_melee_range_spell();
}
public Scroll(int IDno, int goldVal, string myName, int stier, int smana, int srange, int sAoe, int minDmg, int maxDmg, bool meleeSpell,
Atk_Area_Type s_spell_type, Projectile.projectile_type s_prj_type, Attack.Damage dmg_type, bool destroyWalls, int t_impacts,
Status_Type s_buffDebuff, int spell_duration, Projectile.special_anim s_prj_special_anim)
: base(IDno, goldVal, myName)
{
//Enums
my_sType = s_spell_type;
spell_dmg_type = dmg_type;
my_prjType = s_prj_type;
my_specAnim = s_prj_special_anim;
myBufforDebuff = s_buffDebuff;
//Ints
scroll_tier = stier;
aoe_size = sAoe;
max_range = srange;
min_damage = minDmg;
max_damage = maxDmg;
total_impacts = t_impacts;
mana_cost = smana;
buffDebuff_duration = spell_duration;
//Bools
destroys_walls = destroyWalls;
melee_range = meleeSpell;
}
// submits a new workflow to the db with no
private void createWorkflowButton_Click(object sender, EventArgs e)
{
string type = string.Empty;
if (customer.Equals("HONDA AERO"))
{
int next_ID = 0;
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
// first get next Worflow ID
string query =
"SELECT MAX(Workflow_ID)\n" +
"FROM ATI_Workflow.dbo.StatusData\n" +
"WHERE Job = '" + jobNo + "';";
OdbcCommand comm = new OdbcCommand(query, conn);
OdbcDataReader reader = comm.ExecuteReader();
// check if you can load one row
if (reader.Read() && !reader.IsDBNull(0))
{
// increase the workflow ID by 1
next_ID = reader.GetInt32(0) + 1;
}
}
HondaPOReview poReview = new HondaPOReview(jobNo, false, next_ID);
poReview.ShowDialog();
type = poReview.type;
}
else if (customer.Equals("ROLLS"))
{
RollsRoycePOReview poReview = new RollsRoycePOReview(jobNo, false);
poReview.ShowDialog();
type = poReview.type;
}
// in case form was closed prematurely
if (type.Equals("Invalid"))
{
return;
}
// submit an insert query
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
// first get next Worflow ID
string query =
"SELECT MAX(Workflow_ID)\n" +
"FROM ATI_Workflow.dbo.StatusData\n" +
"WHERE Job = '" + jobNo + "';";
OdbcCommand comm = new OdbcCommand(query, conn);
OdbcDataReader reader = comm.ExecuteReader();
// check if you can load one row
if (reader.Read() && !reader.IsDBNull(0))
{
// increase the workflow ID by 1
int next_ID = reader.GetInt32(0) + 1;
query =
"INSERT INTO [ATI_Workflow].[dbo].[StatusData]\n" +
"([Job]\n" +
",[Workflow_ID]\n" +
",[Type]\n" +
",[LastUpdated]\n" +
",[POReview_Status]\n" +
",[POReview_UserName]\n" +
",[POReview_TimeStamp])\n" +
"VALUES\n" +
"('" + jobNo + "',\n" +
next_ID + ",\n" +
"'" + type + "',\n" +
"'" + DateTime.Now + "',\n" +
"'Complete',\n" +
"'" + Globals.userName + "',\n" +
"'" + DateTime.Now + "');";
comm = new OdbcCommand(query, conn);
int rows = comm.ExecuteNonQuery();
// check data was submitted succesfully
if (rows != 1)
{
MessageBox.Show("Data submitted was invaldi");
return;
}
// add new workflow to list and select
workflowListBox.Items.Add(next_ID);
workflowListBox.SelectedIndex = workflowListBox.FindString(next_ID.ToString());
}
else
{
MessageBox.Show(Globals.generic_IT_error);
}
}
}
private void UpdateFromDB(int workflowID)
{
// once layout is updated pull info
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
string query =
"SELECT [Job]\n" +
",[Type]\n" +
",[LastUpdated]\n" +
",[POReview_Status]\n" +
",[POReview_UserName]\n" +
",[POReview_TimeStamp]\n" +
",[QuickRelease_Engineering_Status]\n" +
",[QuickRelease_Engineering_UserName]\n" +
",[QuickRelease_Engineering_TimeStamp]\n" +
",[QuickRelease_Quality_Status]\n" +
",[QuickRelease_Quality_UserName]\n" +
",[QuickRelease_Quality_TimeStamp]\n" +
",[ContractReview_ME_Status]\n" +
",[ContractReview_ME_UserName]\n" +
",[ContractReview_ME_TimeStamp]\n" +
",[ContractReview_QA_Status]\n" +
",[ContractReview_QA_UserName]\n" +
",[ContractReview_QA_TimeStamp]\n" +
",[ContractReview_QE_Status]\n" +
",[ContractReview_QE_UserName]\n" +
",[ContractReview_QE_TimeStamp]\n" +
"FROM[ATI_Workflow].[dbo].[StatusData]\n" +
"WHERE Job = '" + jobNo + "' AND Workflow_ID = '" + workflowID + "';";
OdbcCommand com = new OdbcCommand(query, conn);
OdbcDataReader reader = com.ExecuteReader();
try
{
if (reader.Read())
{
// double check that type matches current type
// find index of type
int type_index = reader.GetOrdinal("Type");
// update layout first
if (!reader.IsDBNull(type_index))
{
if (reader.GetString(type_index).Equals("Contract Review"))
{
type = Status_Type.ContractReview;
}
else if (reader.GetString(type_index).Equals("Quick Release"))
{
this.type = Status_Type.QuickRelease;
}
else if (reader.GetString(type_index).Equals("None"))
{
this.type = Status_Type.None;
}
UpdateLayout();
}
// first fill in PO which all will have
this.step1UserName.Text = reader.IsDBNull(reader.GetOrdinal("POReview_UserName")) ? "Username" : reader.GetString(reader.GetOrdinal("POReview_UserName"));
this.step1TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("POReview_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("POReview_TimeStamp"));
this.step1Status.Text = reader.IsDBNull(reader.GetOrdinal("POReview_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("POReview_Status"));
// load info accordingly based on type
switch (this.type)
{
case Status_Type.ContractReview:
// step 2
this.step2UserName.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_ME_Status")) ? "Username" : reader.GetString(reader.GetOrdinal("ContractReview_ME_UserName"));
this.step2TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_ME_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("ContractReview_ME_TimeStamp"));
this.step2Status.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_ME_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("ContractReview_ME_Status"));
// step 3
this.step3UserName.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QA_UserName")) ? "Username" : reader.GetString(reader.GetOrdinal("ContractReview_QA_UserName"));
this.step3TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QA_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("ContractReview_QA_TimeStamp"));
this.step3Status.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QA_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("ContractReview_ME_Status"));
// step 4
this.step4UserName.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QE_UserName")) ? "Username" : reader.GetString(reader.GetOrdinal("ContractReview_QE_UserName"));
this.step4TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QE_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("ContractReview_QE_TimeStamp"));
this.step4Status.Text = reader.IsDBNull(reader.GetOrdinal("ContractReview_QE_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("ContractReview_QE_Status"));
break;
case Status_Type.QuickRelease:
// step 2
this.step2UserName.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Engineering_UserName")) ? "Username" : reader.GetString(reader.GetOrdinal("QuickRelease_Engineering_UserName"));
this.step2TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Engineering_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("QuickRelease_Engineering_TimeStamp"));
this.step2Status.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Engineering_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("QuickRelease_Engineering_Status"));
// step 3
this.step3UserName.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Quality_UserName")) ? "Username" : reader.GetString(reader.GetOrdinal("QuickRelease_Quality_UserName"));
this.step3TimeStamp.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Quality_TimeStamp")) ? "TimeStamp" : reader.GetString(reader.GetOrdinal("QuickRelease_Quality_TimeStamp"));
this.step3Status.Text = reader.IsDBNull(reader.GetOrdinal("QuickRelease_Quality_Status")) ? "Status" : reader.GetString(reader.GetOrdinal("QuickRelease_Quality_Status"));
break;
}
}
else
{
MessageBox.Show("Error updating layout. Please contact IT support.");
}
}
catch (IndexOutOfRangeException)
{
MessageBox.Show("Error getting type data from DB Server. Please contact IT suport.");
}
catch (OdbcException)
{
MessageBox.Show("Error connecting to database. Please contact IT support.");
}
}
}
