예제 #1
0
        private void LoadIssueList()
        {
            try
            {
                DBlayer dba            = new DBlayer();
                DataSet dsIssues       = new DataSet();
                string  ImpactedFuncs  = "";
                string  ImpactedVenues = "";

                foreach (object itemChecked in clbImpactedFuncs.CheckedItems)
                {
                    DataRowView castedItem = itemChecked as DataRowView;
                    ImpactedFuncs += castedItem["ID"].ToString() + ",";
                }
                if (ImpactedFuncs != "")
                {
                    ImpactedFuncs = ImpactedFuncs.Substring(0, ImpactedFuncs.Length - 1);
                }

                foreach (object itemChecked in clbImpactedVenues.CheckedItems)
                {
                    DataRowView castedItem = itemChecked as DataRowView;
                    ImpactedVenues += castedItem["ID"].ToString() + ",";
                }
                if (ImpactedVenues != "")
                {
                    ImpactedVenues = ImpactedVenues.Substring(0, ImpactedVenues.Length - 1);
                }

                try
                {
                    dsIssues = dba.GetIssues(UserID, UserType, chIssue.Checked, chLog.Checked, chLow.Checked, chMedium.Checked, chHigh.Checked, chNew.Checked, chInprogress.Checked, chClosed.Checked,
                                             chDashboard.Checked, chReportable.Checked, chMyList.Checked, ImpactedFuncs, ImpactedVenues, Convert.ToInt32(cbLead.SelectedValue));
                }
                catch
                {
                    dsIssues = dba.GetIssues(UserID, UserType, chIssue.Checked, chLog.Checked, chLow.Checked, chMedium.Checked, chHigh.Checked, chNew.Checked, chInprogress.Checked, chClosed.Checked,
                                             chDashboard.Checked, chReportable.Checked, chMyList.Checked, "", "", -1);
                }

                DataView dvIssues = dsIssues.Tables[0].DefaultView;
                gvIssues.DataSource = dvIssues;
            }
            catch
            {
            }
        }
예제 #2
0
        private void MainWindow_Load(object sender, EventArgs e)
        {
            //lbUsername.Text = Environment.UserName;

            DBlayer dba = new DBlayer();

            try
            {
                DataSet  dsFunc = dba.GetTable("GIMfunc", 0);
                DataView dvFunc = new DataView(dsFunc.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
                clbImpactedFuncs.DataSource    = dvFunc;
                clbImpactedFuncs.DisplayMember = "FuncCode";
                clbImpactedFuncs.ValueMember   = "ID";

                DataSet dsLead = dba.GetTable("GIMfunc", 0);
                DataRow rLead  = dsLead.Tables[0].NewRow();
                rLead["ID"]       = 0;
                rLead["FuncCode"] = "";
                dsLead.Tables[0].Rows.Add(rLead);
                DataView dvLead = new DataView(dsLead.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
                cbLead.DataSource    = dvLead;
                cbLead.DisplayMember = "FuncCode";
                cbLead.ValueMember   = "ID";

                DataSet  dsVenues = dba.GetTable("GIMvenue", 0);
                DataView dvVenues = new DataView(dsVenues.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
                clbImpactedVenues.DataSource    = dvVenues;
                clbImpactedVenues.DisplayMember = "VenueCode";
                clbImpactedVenues.ValueMember   = "ID";
            }
            catch
            {
            }

            LoadIssueList();

            Timer timer = new Timer();

            timer.Interval = (120 * 1000); // 120 secs
            timer.Tick    += new EventHandler(timer_Tick);
            timer.Start();
        }
예제 #3
0
        private void btOpenIssue_Click(object sender, EventArgs e)
        {
            DBlayer dba = new DBlayer();

            try
            {
                DataSet dsIssue = dba.GetTable("GIMissue", Convert.ToInt32(tbIssueID.Text));
                if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Type"]) == 1)
                {
                    EditIssue frm = new GIM.EditIssue(Convert.ToInt32(tbIssueID.Text), UserID);
                    frm.Show();
                }
                else if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Type"]) == 2)
                {
                    AddLog fal = new AddLog(Convert.ToInt32(tbIssueID.Text), UserID);
                    fal.ShowDialog();
                }
            }
            catch { }
        }
예제 #4
0
        private void tbEnter_Click(object sender, EventArgs e)
        {
            DBlayer dba = new DBlayer();

            if (dba.IsServerConnected() == false)
            {
                MessageBox.Show("Please check your connection!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            if (dba.CheckPassword(Convert.ToInt32(cbUsers.SelectedValue), tbPass.Text))
            {
                DataSet    userDetails = dba.GetUsers(Convert.ToInt32(cbUsers.SelectedValue));
                MainWindow frm         = new MainWindow(Convert.ToInt32(cbUsers.SelectedValue), Convert.ToInt32(userDetails.Tables[0].Rows[0]["UserType"]));
                this.Visible = false;
                frm.ShowDialog();
            }
            else
            {
                MessageBox.Show("The inputed information is not correct!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #5
0
        private void EditIssue_Load(object sender, EventArgs e)
        {
            DBlayer dba = new DBlayer();

            try
            {
                DataSet  dsSeverity = dba.GetTable("GIMSeverity", 0);
                DataView dvSeverity = new DataView(dsSeverity.Tables[0], "", "ID", DataViewRowState.CurrentRows);
                cbSeverity.DataSource    = dvSeverity;
                cbSeverity.DisplayMember = "SeverityName";
                cbSeverity.ValueMember   = "ID";

                DataSet  dsStatus = dba.GetTable("GIMStatus", 0);
                DataView dvStatus = new DataView(dsStatus.Tables[0], "", "ID", DataViewRowState.CurrentRows);
                cbStatus.DataSource    = dvStatus;
                cbStatus.DisplayMember = "StatusName";
                cbStatus.ValueMember   = "ID";

                DataSet  dsLead = dba.GetTable("GIMfunc", 0);
                DataView dvLead = new DataView(dsLead.Tables[0], "", "FuncCode", DataViewRowState.CurrentRows);
                cbLeadFunc.DataSource    = dvLead;
                cbLeadFunc.DisplayMember = "FuncCode";
                cbLeadFunc.ValueMember   = "ID";

                DataSet dsLocation = dba.GetTable("GIMvenue", 0);
                DataRow rCT        = dsLocation.Tables[0].NewRow();
                rCT["ID"]        = 0;
                rCT["VenueCode"] = "";
                dsLocation.Tables[0].Rows.Add(rCT);
                DataView dvLocation = new DataView(dsLocation.Tables[0], "", "VenueCode", DataViewRowState.CurrentRows);
                cbLocation.DataSource    = dvLocation;
                cbLocation.DisplayMember = "VenueCode";
                cbLocation.ValueMember   = "ID";
            }
            catch { }

            LoadEditIssue();
        }
예제 #6
0
        private void LoadEditIssue()
        {
            try
            {
                DBlayer dba     = new DBlayer();
                DataSet dsIssue = dba.GetTable("GIMissue", IssueID);
                tbTitle.Text             = dsIssue.Tables[0].Rows[0]["Title"].ToString();
                tbDesc.Text              = dsIssue.Tables[0].Rows[0]["Description"].ToString();
                cbLocation.SelectedValue = dsIssue.Tables[0].Rows[0]["Location"];
                cbStatus.SelectedValue   = dsIssue.Tables[0].Rows[0]["IssueStatus"];
                cbSeverity.SelectedValue = dsIssue.Tables[0].Rows[0]["IssueSeverity"];
                tbLocationDesc.Text      = dsIssue.Tables[0].Rows[0]["LocationDesc"].ToString();
                cbLeadFunc.SelectedValue = dsIssue.Tables[0].Rows[0]["LeadFunction"];
                lblDoc.Text              = dsIssue.Tables[0].Rows[0]["Attachment"].ToString();

                DataSet dsUsers = dba.GetTable("GIMusers", Convert.ToInt32(dsIssue.Tables[0].Rows[0]["RaisedBy"]));
                lblRaisedBy.Text = "Raised by: " + dsUsers.Tables[0].Rows[0]["Ucode"].ToString() + " (" + dsIssue.Tables[0].Rows[0]["Creator"].ToString() + ")";

                DateTime dtOcc = Convert.ToDateTime(dsIssue.Tables[0].Rows[0]["DateOccurence"].ToString());
                tbDoccur.Text = dtOcc.Date.ToShortDateString();
                tbHour.Text   = dtOcc.Hour.ToString();
                tbMin.Text    = dtOcc.Minute.ToString();

                DateTime dtUpd = Convert.ToDateTime(dsIssue.Tables[0].Rows[0]["DateUpdated"].ToString());
                tbDupdate.Text = dtUpd.Date.ToShortDateString();
                tbHour2.Text   = dtUpd.Hour.ToString();
                tbMin2.Text    = dtUpd.Minute.ToString();

                if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["IssueStatus"]) == 4)
                {
                    if (dsIssue.Tables[0].Rows[0]["DateActualEnd"].ToString() != "")
                    {
                        DateTime dtActEnd = Convert.ToDateTime(dsIssue.Tables[0].Rows[0]["DateActualEnd"].ToString());
                        tbDactual.Text = dtActEnd.Date.ToShortDateString();
                        tbHour3.Text   = dtActEnd.Hour.ToString();
                        tbMin3.Text    = dtActEnd.Minute.ToString();
                    }
                }

                if (UserID != 1)
                {
                    if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["RaisedBy"]) != UserID)
                    {
                        btEdit.Enabled       = false;
                        btCloseIssue.Visible = false;
                    }
                }

                if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Dashboard"]) == 1)
                {
                    chDashboard.Checked = true;
                }
                else
                {
                    chDashboard.Checked = false;
                }

                if (Convert.ToInt32(dsIssue.Tables[0].Rows[0]["Reportable"]) == 1)
                {
                    chReportable.Checked = true;
                }
                else
                {
                    chReportable.Checked = false;
                }

                DataSet impFuncs      = dba.GetIssueImpcFuncs(IssueID);
                string  impactedFuncs = "";
                for (int i = 0; i < impFuncs.Tables[0].Rows.Count; i++)
                {
                    impactedFuncs += impFuncs.Tables[0].Rows[i]["FuncCode"].ToString() + ", ";
                }
                if (impactedFuncs != "")
                {
                    impactedFuncs = impactedFuncs.Substring(0, impactedFuncs.Length - 2);
                }
                tbImpactedFuncs.Text = impactedFuncs;

                DataSet impVenues      = dba.GetIssueImpcVenues(IssueID);
                string  impactedVenues = "";
                for (int i = 0; i < impVenues.Tables[0].Rows.Count; i++)
                {
                    impactedVenues += impVenues.Tables[0].Rows[i]["VenueCode"].ToString() + ", ";
                }
                if (impactedVenues != "")
                {
                    impactedVenues = impactedVenues.Substring(0, impactedVenues.Length - 2);
                }
                tbImpactedVenues.Text = impactedVenues;

                DataSet  dsUpdates = dba.GetUpdates(IssueID);
                DataView dvUpdates = dsUpdates.Tables[0].DefaultView;
                gvUpdates.DataSource = dvUpdates;
            }
            catch { }
        }