void LoadBookings() { MWDataManager.clsDataAccess _Bookings = new MWDataManager.clsDataAccess(); _Bookings.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _Bookings.SqlStatement = " exec sp_BookingsDaily '" + editSection.EditValue + "', '" + Convert.ToDateTime(editDate.EditValue).ToShortDateString() + "' " + " \r\n"; _Bookings.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _Bookings.queryReturnType = MWDataManager.ReturnType.DataTable; _Bookings.ExecuteInstruction(); if (_Bookings.ResultsDataTable.Rows.Count > 0) { dt = _Bookings.ResultsDataTable; DataSet ds = new DataSet(); if (ds.Tables.Count > 0) { ds.Tables.Clear(); } ds.Tables.Add(dt); gcBooking.DataSource = ds.Tables[0]; gcGun.FieldName = "gun"; gcDam.FieldName = "dam"; gcBench.FieldName = "bench"; gcPlanTonnes.FieldName = "PlanTonnes"; gcHoursBooked.FieldName = "hoursbooked"; gcPlanHours.FieldName = "PlanHrs"; gcHoursVar.FieldName = "HoursVar"; gcBookTonnes.FieldName = "BookTonnes"; gcTonnesVar.FieldName = "TonnesVar"; gcBench.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; gcBench.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center; } else { if (BookingsTab.SelectedTabPageIndex == 0) { MessageBox.Show("No Planning Found.", "Insufficient information", MessageBoxButtons.OK, MessageBoxIcon.Information); } return; } }
private void SaveBtn_Click(object sender, EventArgs e) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = "Delete tbl_BCS_SafetyCapture Where ProdMonth = '" + ProdMonthTxt.Value + "' and OrgUnit = '" + OrgGrid.CurrentRow.Cells[0].Value.ToString() + "' " + "Insert into tbl_BCS_SafetyCapture values ( '" + OrgGrid.CurrentRow.Cells[0].Value.ToString() + "', '" + ProdMonthTxt.Value + "', " + " '" + txtRI.Text + "', '" + txtLti.Text + "', '" + txtFatal.Text + "' ) "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); frmMessage MsgFrm = new frmMessage(); MsgFrm.Text = "Saved"; MsgFrm.Text = "Saved Successfully"; MsgFrm.Show(); ShowBtn_Click(null, null); }
private void ucVampPlanning_Load(object sender, EventArgs e) { ProdmonthEdit.EditValue = TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth.ToString(); MWDataManager.clsDataAccess _dbMan11 = new MWDataManager.clsDataAccess(); _dbMan11.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan11.SqlStatement = "select Code code1, * from Code_Cycle_Vamps order by Code "; _dbMan11.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan11.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan11.ExecuteInstruction(); DataTable Neilzz1 = _dbMan11.ResultsDataTable; CycleCodeLstOther.Items.Clear(); foreach (DataRow r in Neilzz1.Rows) { CycleCodeLstOther.Items.Add(r["code1"].ToString() + ":" + r["description"].ToString()); } MWDataManager.clsDataAccess _dbManWP = new MWDataManager.clsDataAccess(); _dbManWP.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbManWP.SqlStatement = "Select distinct s1.ReportToSectionid+':'+s2.name Section from section s, section s1 , section s2 \r\n" + "where s.Prodmonth = s1.Prodmonth and s.ReportToSectionid = s1.SectionID \r\n" + "and s1.Prodmonth = s2.Prodmonth and s1.ReportToSectionid = s2.SectionID \r\n" + "and s.Prodmonth = '" + ProdmonthEdit.EditValue.ToString() + "' "; _dbManWP.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManWP.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManWP.ExecuteInstruction(); DataTable dt = _dbManWP.ResultsDataTable; repositoryItemComboBox2.Items.Clear(); foreach (DataRow dr in dt.Rows) { repositoryItemComboBox2.Items.Add(dr["Section"].ToString()); } }
private void ESFB() { int DaysInMonth = (System.DateTime.DaysInMonth(Convert.ToInt32(txtYear.Value), Convert.ToInt32(txtMonth.Value))); int month = Convert.ToDateTime(editProdmonth.EditValue).Month; int year = Convert.ToDateTime(editProdmonth.EditValue).Year; MWDataManager.clsDataAccess _dbMan1ESfb = new MWDataManager.clsDataAccess(); _dbMan1ESfb.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan1ESfb.SqlStatement = " Select 'ESF B' calendartypeid,calendardate,'Y' WORKINGDAY from ( \r\n" + " select distinct(calendardate) from [mineware].[dbo].tbl_bcs_caltype \r\n" + " where year(calendardate) = '" + year + "' and month(calendardate) = '" + month + "' and CALENDARDATE < GETDATE() -1 \r\n" + " and calendardate not in (SELECT CALENDARDATE \r\n" + " FROM [Mineware].[dbo].[tbl_bcs_caltype] \r\n" + " where calendarcode = 'ESF B' and year(calendardate) = '" + year + "' and month(calendardate) = '" + month + "' and CALENDARDATE < GETDATE() -1 ) \r\n" + " ) a order by calendardate"; _dbMan1ESfb.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1ESfb.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1ESfb.ExecuteInstruction(); DataTable dt = _dbMan1ESfb.ResultsDataTable; if (dt.Rows.Count > 0) { MWDataManager.clsDataAccess _dbMan1ESfbInsert = new MWDataManager.clsDataAccess(); _dbMan1ESfbInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan1ESfbInsert.SqlStatement = " select 'A' \r\n"; foreach (DataRow r in dt.Rows) { _dbMan1ESfbInsert.SqlStatement = _dbMan1ESfbInsert.SqlStatement + " insert into [Mineware].[dbo].[tbl_bcs_caltype] (calendarcode,calendardate,WORKINGDAY) \r\n" + "values('" + r["calendartypeid"].ToString() + "','" + r["calendardate"].ToString() + "' ,'Y') "; } _dbMan1ESfbInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1ESfbInsert.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1ESfbInsert.ExecuteInstruction(); } }
public void LoadOrgGrid() { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = "SELECT distinct(Orgunit) unit FROM [dbo].[tbl_Import_BCS_Personnel] .0order by Orgunit "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dtOrg = _dbMan.ResultsDataTable; bs.DataSource = dtOrg; OrgGrid.DataSource = bs; OrgGrid.Columns[0].Width = 140; OrgGrid.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable; }
private void HierLst_SelectedIndexChanged(object sender, EventArgs e) { Reporttocmd.Items.Clear(); int aa = HierLst.SelectedIndex; aa = aa; MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = _theConnection; _dbMan.SqlStatement = "select * from [tbl_Section] where prodmonth = '" + PM1lbl.Text + "' "; _dbMan.SqlStatement = _dbMan.SqlStatement + "and hierid = '" + aa + "' order by sectionid "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; int x = 0; int y = -1; foreach (DataRow dr in dt.Rows) { Reporttocmd.Items.Add(dr["sectionid"].ToString() + ':' + dr["name"].ToString()); if (dr["sectionid"].ToString() == Reptolbl.Text) { y = x; } x = x + 1; } Reporttocmd.SelectedIndex = y; if (SecIDTxt.Enabled == true) { Reporttocmd.Text = ""; if (Reporttocmd.Items.Count > 0) { Reporttocmd.SelectedIndex = 0; } } }
void LoadOrg() { OrgCombo.Items.Clear(); MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = _connection; _dbMan.SqlStatement = "Select distinct Substring(OrgUnit,1,8) as OrgUnit from BMCS_AllOrgUnits \r\n " + "Where len(OrgUnit) > 7 and OrgUnit like '" + MOCombo.Text + "%'"; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; foreach (DataRow dr in dt.Rows) { OrgCombo.Items.Add(dr["OrgUnit"].ToString()); } }
private void CalChangeBtn_Click(object sender, EventArgs e) { if (CalTypelst.SelectedIndex == -1) { MessageBox.Show("Please select a valid calendar.", "Insufficient information", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } MWDataManager.clsDataAccess _dbManDelete = new MWDataManager.clsDataAccess(); _dbManDelete.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbManDelete.SqlStatement = " delete from tbl_Calendar_SecCal where prodmonth = '" + PM1Txt.Value.ToString() + "' and sectionid = '" + Seclbl.Text + "' \r\n"; _dbManDelete.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManDelete.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManDelete.ExecuteInstruction(); MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = " insert into tbl_Calendar_SecCal "; _dbMan.SqlStatement = _dbMan.SqlStatement + " VALUES ( '" + PM1Txt.Value.ToString() + "', '" + Seclbl.Text + "', '" + CalTypelst.SelectedItem + "' "; _dbMan.SqlStatement = _dbMan.SqlStatement + ", '" + String.Format("{0:yyyy-MM-dd}", FromDate.Value) + "', '" + String.Format("{0:yyyy-MM-dd}", ToDate.Value) + "', '" + DurTxt.Text + "' ) "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); MWDataManager.clsDataAccess _dbManDelete2 = new MWDataManager.clsDataAccess(); _dbManDelete2.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbManDelete2.SqlStatement = " delete from tbl_Calendar_Days where prodmonth = '" + PM1Txt.Value.ToString() + "'\r\n" + "exec sp_Calendar_Days '" + PM1Txt.Value.ToString() + "'"; _dbManDelete2.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManDelete2.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManDelete2.ExecuteInstruction(); toastNotificationsManager1.ShowNotification(toastNotificationsManager1.Notifications[0]); LoadGrid(); }
private void SectionEdit_EditValueChanged(object sender, EventArgs e) { SSectionLbl.Text = SectionEdit.EditValue.ToString(); MWDataManager.clsDataAccess _dbManWP = new MWDataManager.clsDataAccess(); _dbManWP.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbManWP.SqlStatement = "select w.workplaceid, w.description, w.activity from VampingPreInspectionSheet wptot left outer join workplace w on wptot.workplaceid = w.description and section = '" + ExtractBeforeColon(SSectionLbl.Text) + "' " + " and auth = 'Y' and del = 'N' order by w.description "; _dbManWP.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManWP.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManWP.ExecuteInstruction(); dtWPTot = _dbManWP.ResultsDataTable; TotWpFilterTxt_TextChanged(null, null); }
public void LoadMinerListTot(string prodMonth) { MWDataManager.clsDataAccess _MinerData = new MWDataManager.clsDataAccess(); _MinerData.ConnectionString = TConnections.GetConnectionString(_theSystemDBTag, _UserCurrentInfoConnection); _MinerData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _MinerData.queryReturnType = MWDataManager.ReturnType.DataTable; _MinerData.SqlStatement = " Select SectionID, Name from Section \r\n" + " where Hierarchicalid = '5' \r\n" + " and prodmonth = '" + Prodmonth + "' \r\n" + " --and SectionID like '" + procs.ExtractBeforeColon(SecCmb.Text) + "%' \r\n" + "order by SectionID "; _MinerData.ExecuteInstruction(); SupervisorLookUp.DataSource = null; SupervisorLookUp.DataSource = _MinerData.ResultsDataTable; SupervisorLookUp.DisplayMember = "Name"; SupervisorLookUp.ValueMember = "SectionID"; SupervisorLookUp.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains; }
private void Savebtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(_theSystemDBTag, _UserCurrentInfoConnection); if (lblActionType.Text == "Normal Action") { if (cbxResolved.Checked == true) { _dbMan.SqlStatement = " " + " update tbl_Incidents set Responsible_Person_Feedback = '" + Notestxt.Text + "' , Action_Status = 'Closed' , \r\n" + " Action_Closed_By = '" + TUserInfo.UserID + "' , Action_Close_Date = getdate(),Complete_Date = getdate(),Action_Complete = '100',Action_Progress = '100' \r\n" + " where isnull([Mineware_Action_ID],'') + convert(varchar(300),isnull( [Pivot_Action_ID], '')) = '" + lblActionID.Text + "' "; } if (cbxResolved.Checked == false) { _dbMan.SqlStatement = " " + " update tbl_Incidents set Responsible_Person_Feedback = '" + Notestxt.Text + "' \r\n" + " where isnull([Mineware_Action_ID],'') + convert(varchar(300),isnull( [Pivot_Action_ID], '')) = '" + lblActionID.Text + "' "; } } if (lblActionType.Text == "Pivot Action") { _dbMan.SqlStatement = " " + " insert into tbl_Incidents_Close_Request \r\n" + " (Operation,Workplace,Pivot_Action_ID,Responsible_Person_Feedback,Action_Closed_By,Action_Close_Date) \r\n" + " values ('RE','" + lblWorkplace.Text + "','" + lblPivotActionID.Text + "','" + Notestxt.Text + "','" + TUserInfo.UserID + "',getdate()) "; } _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.longNumber; _dbMan.ExecuteInstruction(); Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Data Saved", "Action Closed", Color.CornflowerBlue); this.Close(); }
/// <summary> /// Updates the sections list for the selected production month /// </summary> public void updateSections() { CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer(); BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable; BMEBL.SetsystemDBTag = systemDBTag; BMEBL.SetUserCurrentInfo = this.UserCurrentInfo; List <string> Thelist = TProductionGlobal.getUserInfo(UserCurrentInfo.Connection).PlanBookSections; DataTable _SectionResult = new DataTable(); GetSectionsAndName theData = new GetSectionsAndName(); theData.theSystemDBTag = systemDBTag; theData.UserCurrentInfo = UserCurrentInfo; List <string> sections = TProductionGlobal.getUserInfo(UserCurrentInfo.Connection).PlanBookSections; foreach (string item in sections) { MWDataManager.clsDataAccess temp = theData.theSectionsAndName(_prodMonth, item, TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID); temp.ExecuteInstruction(); if (temp.ResultsDataTable.Rows.Count != 0) { if (_SectionResult.Columns.Count == 0) { _SectionResult = temp.ResultsDataTable.Clone(); } _SectionResult.Merge(temp.ResultsDataTable); } } tblSections = _SectionResult; //} //if (BMEBL.get_Sections(Convert.ToString(_prodMonth), TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).MOHierarchicalID.ToString()) == true) //{ // tblSections = BMEBL.ResultsDataTable.Clone(); // tblSections = BMEBL.ResultsDataTable.Copy(); //} }
private void Savebtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { Int32[] selectedRowHandles = gvMoLevel.GetSelectedRows(); if (Notestxt.Text == "") { MessageBox.Show("Please Fill in a note before saving"); return; } MWDataManager.clsDataAccess _dbManSub = new MWDataManager.clsDataAccess(); _dbManSub.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); for (int i = 0; i < selectedRowHandles.Length; i++) { int selectedRowHandle = selectedRowHandles[i]; string Workplaceid = gvMoLevel.GetRowCellValue(selectedRowHandle, gvMoLevel.Columns["WorkplaceID"]).ToString(); _dbManSub.SqlStatement = _dbManSub.SqlStatement + " insert into tbl_MoNotes values ( \r\n" + " '" + Workplaceid + "',getdate(), '" + TUserInfo.UserID + "' , '" + Notestxt.Text + "' ) \r\n\r\n"; } _dbManSub.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManSub.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManSub.ExecuteInstruction(); Notestxt.Text = ""; Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Data Saved", "Notes saved", Color.CornflowerBlue); loadWorkNoteWorkplaces(); for (int i = 0; i < selectedRowHandles.Length; i++) { int selectedRowHandle = selectedRowHandles[i]; gvMoLevel.SetMasterRowExpanded(selectedRowHandle, true); } }
private void LoadSections() { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); //_dbMan.ConnectionString = ConfigurationManager.AppSettings["SQLConnectionStr"]; _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = " Select SectionID+':'+Name SectionID " + "from Section s where s.Prodmonth = '" + THarmonyPASGlobal.ProdMonthAsString(reportSettings.Prodmonth) + "' "; _dbMan.SqlStatement += " and Hierarchicalid <= 4 "; _dbMan.SqlStatement += " order by SectionID "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); dtSections = _dbMan.ResultsDataTable; riSection.DataSource = dtSections; riSection.DisplayMember = "SectionID"; riSection.ValueMember = "SectionID"; }
public void LoadOrgUnits(string prodMonth, string sectionidMO) { MWDataManager.clsDataAccess _OrgUnitsData = new MWDataManager.clsDataAccess(); _OrgUnitsData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _OrgUnitsData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _OrgUnitsData.queryReturnType = MWDataManager.ReturnType.DataTable; _OrgUnitsData.SqlStatement = "SELECT 1 thepos,'' Crew_Org " + " UNION " + " SELECT 2 thepos,'Contractor' Crew_Org" + " UNION " + "SELECT 3 thepos,Crew_Org FROM " + TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).Bonus_Database + "dbo.Production_Orgunit_View WHERE MO_SectionID = '" + sectionidMO + "' "; _OrgUnitsData.ExecuteInstruction(); reOrgDaySelection.DataSource = _OrgUnitsData.ResultsDataTable; reOrgDaySelection.DisplayMember = "Crew_Org"; reOrgDaySelection.ValueMember = "Crew_Org"; reOrgNightSelection.DataSource = _OrgUnitsData.ResultsDataTable; reOrgNightSelection.DisplayMember = "Crew_Org"; reOrgNightSelection.ValueMember = "Crew_Org"; }
private void luEmpDetail_EditValueChanged(object sender, EventArgs e) { MWDataManager.clsDataAccess _dbMan3 = new MWDataManager.clsDataAccess(); _dbMan3.ConnectionString = _connection; _dbMan3.SqlStatement = "SELECT DISTINCT Designation, Orgunit FROM [Mineware].[dbo].[tbl_Import_BCS_Personnel_Latest] WHERE IndustryNumber = '" + luEmpDetail.Text.Substring(0, 8) + "'"; _dbMan3.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan3.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan3.ExecuteInstruction(); DataTable dtDesignation = _dbMan3.ResultsDataTable; //luDesignation.Properties.DataSource = dtDesignation; var result = dtDesignation.Rows[0][1]; tbOrgUnitOriginal.Text = result.ToString(); //luDesignation.ItemIndex = 0; = DataTable dt = _dbMan3.ResultsDataTable; tbDesignation.Text = dt.Rows[0][0].ToString(); }
private void DeActGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { if ((e.RowIndex >= 0) && (e.ColumnIndex == 4)) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = " update VampingPreInspectionSheet " + " set Del = 'N' \r\n " + //" DelPer = '" + clsUserInfo.UserName + "', \r\n " + //" DelDate = '" + String.Format("{0:yyyy-MM-dd}", DateTime.Now) + "' \r\n " + " where workplaceid = '" + DeActGrid.Rows[e.RowIndex].Cells[0].Value.ToString() + "' \r\n "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Data Saved", "Record Updated", Color.CornflowerBlue); LoadVampAuthGrid(); } }
private void LoadMiners() { MWDataManager.clsDataAccess _dbMan11 = new MWDataManager.clsDataAccess(); _dbMan11.ConnectionString = TConnections.GetConnectionString(_theSystemDBTag, _UserCurrentInfoConnection); _dbMan11.SqlStatement = "Select distinct s.SectionID+':'+s.name Section,s.SectionID+':'+s.name Description from section s, section s1 , section s2 \r\n" + "where s.Prodmonth = s1.Prodmonth and s.ReportToSectionid = s1.SectionID \r\n" + "and s1.Prodmonth = s2.Prodmonth and s1.ReportToSectionid = s2.SectionID \r\n" + "and s.Prodmonth = '" + lblprodmonth.Text + "' and s1.ReportToSectionid = '" + lblsection.Text + "' "; _dbMan11.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan11.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan11.ExecuteInstruction(); dtMiners = _dbMan11.ResultsDataTable; foreach (DataRow r in dtMiners.Rows) { lbxMiners.Items.Add(r["Section"].ToString()); } }
private void frmProblemBookCode_Load(object sender, EventArgs e) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(_theSystemDBTag, _UserCurrentInfoConnection); _dbMan.SqlStatement = "Select distinct Description,ProblemID from CODE_PROBLEM where ProblemID = '" + lblProblemID.Text + "' and activity = '" + lblAcitvity.Text + "' "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; foreach (DataRow dr in dt.Rows) { txtDescription.Text = dr["Description"].ToString(); txtProblemID.Text = dr["ProblemID"].ToString(); } }
public void loadsections() { MWDataManager.clsDataAccess _dbManCalType = new MWDataManager.clsDataAccess(); _dbManCalType.ConnectionString = TConnections.GetConnectionString(resWPAS.systemDBTag, UserCurrentInfo.Connection); _dbManCalType.SqlStatement = " select * from CODE_CALENDAR where CalendarCode = '"+ TheCalendarCode + "'"; _dbManCalType.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManCalType.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManCalType.ExecuteInstruction(); DataTable CalType = _dbManCalType.ResultsDataTable; //lkCalendarType.Properties.DataSource = CalType; //lkCalendarType.Properties.DisplayMember = "CalendarCode"; //lkCalendarType.Properties.ValueMember = "CalendarCode"; dtStartdate.EditValueChanged += dtStartdate_EditValueChanged; dtEndDate.EditValueChanged += dtEndDate_EditValueChanged; }
private void btnDelete_Click(object sender, EventArgs e) { object name = gvProcessCode.GetRowCellValue(gvProcessCode.FocusedRowHandle, gvProcessCode.Columns["Name"]); string NAME = Convert.ToString(name); if (NAME == "") { MessageBox.Show("Please select a record to be deleted.", "No record selected", MessageBoxButtons.OK); } else if (MessageBox.Show("Are you sure you want to delete record", "Delete Record", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = "delete FROM StopingProcessCodes where name='" + NAME + "'"; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); loaddata(); } }
private void LoadHeirarchOther() { MWDataManager.clsDataAccess theData = new MWDataManager.clsDataAccess(); theData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); theData.SqlStatement = " select Hierarchicalid ID, Description Occupation, Convert(Varchar(3),Hierarchicalid)+':'+Description Heir " + " from HierarchOther order by HierarchicalID "; theData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; theData.queryReturnType = MWDataManager.ReturnType.DataTable; theData.ExecuteInstruction(); //DataTable dtHierList = theData.ResultsDataTable; //cmbHierarchicalID.Properties.DataSource = dtHierList; //cmbHierarchicalID.Properties.ValueMember = "ID"; //cmbHierarchicalID.Properties.DisplayMember = "Occupation"; foreach (DataRow dr in theData.ResultsDataTable.Rows) { cmbHierarchicalID2.Items.Add(dr["Heir"].ToString()); } }
/// <summary> /// To check if there are any workplaces with no sectionID /// </summary> public void RemoveUnsavedWorkplaces() { var checkSectionID = tblPlanningData.Select("Sectionid ='-1'"); if (checkSectionID.Length > 0) { MWDataManager.clsDataAccess RemoveWorkplace = new MWDataManager.clsDataAccess(); RemoveWorkplace.ConnectionString = TConnections.GetConnectionString(systemDBTag, UserCurrentInfo.Connection); RemoveWorkplace.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; RemoveWorkplace.queryReturnType = MWDataManager.ReturnType.DataTable; sb.Clear(); foreach (var r in checkSectionID) { sb.AppendLine(String.Format("delete from PLANMONTH where Sectionid = '-1' and Prodmonth = {0} and Activity = {1}", planningSettings.ProdMonth, planningSettings.ActivityID)); } RemoveWorkplace.SqlStatement = sb.ToString(); var theResult = RemoveWorkplace.ExecuteInstruction(); } }
void Logon() { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = ConfigurationSettings.AppSettings["SQLConnectionStr"]; _dbMan.SqlStatement = "select * from tbl_Users " + "where UserID = '" + UsernameTxt.Text + "' and password = '******'"; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable SubA = _dbMan.ResultsDataTable; if (SubA.Rows.Count > 0) { SplashScreen Mainfrm; Mainfrm = (SplashScreen)this.FindForm(); Mainfrm.WindowState = FormWindowState.Minimized; //alertControl1.Show(Mainfrm, "Notification", "Record Saved Successfuly."); Classes.MainScreen MainScreen = new Classes.MainScreen(); this.Hide(); this.Close(); //Classes.MainScreen Spla = new Classes.MainScreen(); //SplashScreen.WindowState = FormWindowState.Minimized; MainScreen.labName.Text = UsernameTxt.Text; MainScreen.LocalIndLbl.Text = "N"; //SplashScreen Splash = new SplashScreen(); //Splash.WindowState = FormWindowState.Minimized; //Application.Run(new Classes.MainScreen()); //this.Hide(); MainScreen.ShowDialog(); } else { MessageBox.Show("User not found. Please try again.", "Login Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); LogonBtn.Enabled = false; } }
void UpdateGang() { try { //Updates row containing selected ZGang with dragdrop value MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess(); _dbMan1.SqlStatement = "INSERT INTO Mineware.dbo.tbl_BCS_ZGangsLink(ProdMonth, GangID, ZGangID)VALUES('" + ProductionAmplatsGlobal.ProductionAmplatsGlobal.ProdMonthAsString(Convert.ToDateTime(editPM.EditValue)) + "','" + lblGangValue.Text + "','" + lblZGangValue.Text + "') " + "DELETE FROM Mineware.dbo.tbl_BCS_ZGangsLink WHERE ProdMonth = '" + ProductionAmplatsGlobal.ProductionAmplatsGlobal.ProdMonthAsString(Convert.ToDateTime(editPM.EditValue)) + "'" + "and gangid = '' and zgangid in (SELECT zgangid FROM " + "(SELECT zgangid, count(zgangid) nn FROM Mineware.dbo.tbl_BCS_ZGangsLink WHERE ProdMonth = '" + ProductionAmplatsGlobal.ProductionAmplatsGlobal.ProdMonthAsString(Convert.ToDateTime(editPM.EditValue)) + "'" + "and gangid = '' group by zgangid) a where nn > 0)"; _dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1.ExecuteInstruction(); alertControl1.Show(null, "Information", "Record Added Successfuly"); } catch (Exception ex) { MessageBox.Show("Upload Failed!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadDuration() { if (CalTypelst.SelectedIndex == -1) { return; } MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = " select COUNT(workingday)num from dbo.tbl_Calendar_WorkingDays " + "where calendarcode = '" + CalTypelst.SelectedItem + "' " + "and calendardate >= '" + String.Format("{0:yyyy-MM-dd}", FromDate.Value) + "' " + "and calendardate <= '" + String.Format("{0:yyyy-MM-dd}", ToDate.Value) + "' and workingday = 'Y' "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; DurTxt.Text = dt.Rows[0]["num"].ToString(); }
private void AddRowEngBtn_Click(object sender, EventArgs e) { SaveHeaders(); SaveData(); MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess(); _dbMan1.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan1.SqlStatement = " insert into mineware.dbo.tbl_BCS_Eng_SurfaceIncentiveDetail Values( '" + ProductionAmplatsGlobal.ProductionAmplatsGlobal.ProdMonthAsString(Convert.ToDateTime(editProdmonth.EditValue)) + "', 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null) \r\n" + " \r\n" + " \r\n" + " \r\n" + " \r\n" + " \r\n" + " \r\n"; _dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1.ExecuteInstruction(); LoadBaseGrid(); }
private void editWorkplace_EditValueChanged(object sender, EventArgs e) { _clChnageOfPlanData.SetWorkplaceID (editWorkplace .EditValue.ToString ()); MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess(); _WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _WPData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _WPData.queryReturnType = MWDataManager.ReturnType.DataTable; _WPData.SqlStatement = "SELECT *, 1 FL FROM WORKPLACE WHERE WORKPLACEID = '" + editWorkplace.EditValue + "'"; _WPData.ExecuteInstruction(); foreach (DataRow r in _WPData.ResultsDataTable.Rows) { editFaceLength.Text = r["FL"].ToString(); } }
private void ShowBtn_Click(object sender, EventArgs e) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.SqlStatement = "Select OrgUnit, RI, LTI, Fatal from tbl_BCS_SafetyCapture " + "Where ProdMonth = '" + ProdMonthTxt.Value + "' order by orgunit "; _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); DataTable dt = _dbMan.ResultsDataTable; bs1.DataSource = dt; grid.DataSource = bs1; grid.Columns[0].Width = 100; grid.Columns[1].Width = 60; grid.Columns[2].Width = 60; grid.Columns[3].Width = 60; }
private void ucVamping_Load(object sender, EventArgs e) { tabPage1.Text = "PreInspection"; tabPage2.Text = "Authorization"; MWDataManager.clsDataAccess _dbManWPST2 = new MWDataManager.clsDataAccess(); _dbManWPST2.ConnectionString = TConnections.GetConnectionString("DBHARMONYPAS", "Doornkop"); _dbManWPST2.SqlStatement = "Select * from sysset \r\n"; _dbManWPST2.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManWPST2.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManWPST2.ExecuteInstruction(); if (_dbManWPST2.ResultsDataTable.Rows.Count > 0) { ImageDir = _dbManWPST2.ResultsDataTable.Rows[0]["REPDIR"].ToString(); } this.Cursor = Cursors.WaitCursor; LoadPreInspection(); this.Cursor = Cursors.Default; }