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;
}
