public bool SaveUserSettings(DataTable userInfo, string userID) { bool theResult = false; TheData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; TheData.queryReturnType = MWDataManager.ReturnType.DataTable; TheData.ConnectionString = TConnections.GetConnectionString(resWPAS.systemDBTag, this.UserCurrentInfo.Connection); TheData.SqlStatement = "SELECT * FROM USERS WHERE UserID = '" + userID + "'"; TheData.ExecuteInstruction(); string _wpproduction; string _wpsurface; string _wpunderground; string _wpeditname; string _wpeditattribute; string _wpclassify; if (TheData.ResultsDataTable.Rows.Count == 1) { sb.Clear(); foreach (DataRow dr in userInfo.Rows) { _wpproduction = "N"; _wpsurface = "N"; _wpunderground = "N"; _wpeditname = "N"; _wpeditattribute = "N"; _wpclassify = "N"; if (Convert.ToBoolean(dr["WPProduction"].ToString()) == true) { _wpproduction = "Y"; } if (Convert.ToBoolean(dr["WPSurface"].ToString()) == true) { _wpsurface = "Y"; } if (Convert.ToBoolean(dr["WPUnderGround"].ToString()) == true) { _wpunderground = "Y"; } if (Convert.ToBoolean(dr["WPEditName"].ToString()) == true) { _wpeditname = "Y"; } if (Convert.ToBoolean(dr["WPEditAttribute"].ToString()) == true) { _wpeditattribute = "Y"; } if (Convert.ToBoolean(dr["WPClassify"].ToString()) == true) { _wpclassify = "Y"; } try { sb.AppendLine("UPDATE [dbo].[USERS]"); sb.AppendLine(" SET [BackDateBooking] = " + dr["BackDateBooking"].ToString()); sb.AppendLine(" ,[DaysBackdate] = " + dr["DaysBackdate"].ToString()); sb.AppendLine(" ,[WPProduction] = '" + _wpproduction + "' "); sb.AppendLine(" ,[WPSurface] = '" + _wpsurface + "' "); sb.AppendLine(" ,[WPUnderGround] = '" + _wpunderground + "' "); sb.AppendLine(" ,[WPEditName] = '" + _wpeditname + "' "); sb.AppendLine(" ,[WPEditAttribute] = '" + _wpeditattribute + "' "); sb.AppendLine(" ,[WPClassify] = '" + _wpclassify + "' "); sb.AppendLine(" WHERE [UserID] = '" + userID + "'"); TheData.SqlStatement = sb.ToString(); TheData.ExecuteInstruction(); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER SETTINGS", userID, UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER BACK DATED BOOKINGS", userID + " : " + dr["BackDateBooking"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER WP PRODUCTION", userID + " : " + dr["WPProduction"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER WP SURFACE", userID + " : " + dr["WPSurface"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER WP UNDERGROUND", userID + " : " + dr["WPUnderGround"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER WP EDIT NAME", userID + " : " + dr["WPEditName"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER WP EDIT ATTRIBUTE", userID + " : " + dr["WPEditAttribute"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER CLASSIFY", userID + " : " + dr["WPClassify"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER ALLOW BACKDATED BOOKINGS", userID + " : " + dr["BackDateBooking"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "EDIT USER ALLOW DAYS BACKDATED BOOKINGS", userID + " : " + dr["DaysBackdate"].ToString(), UserCurrentInfo.Connection); theResult = true; } catch (Exception e) { myMessage.viewMessage(MessageType.Error, "Error Saving User", resWPAS.systemName, "DL_Users", "SaveUserSettings", e.Message, ButtonTypes.OK, MessageDisplayType.FullScreen); theResult = false; } } } // update else { sb.Clear(); foreach (DataRow dr in userInfo.Rows) { _wpproduction = "N"; _wpsurface = "N"; _wpunderground = "N"; _wpeditname = "N"; _wpeditattribute = "N"; _wpclassify = "N"; if (Convert.ToBoolean(dr["WPProduction"].ToString()) == true) { _wpproduction = "Y"; } if (Convert.ToBoolean(dr["WPSurface"].ToString()) == true) { _wpsurface = "Y"; } if (Convert.ToBoolean(dr["WPUnderGround"].ToString()) == true) { _wpunderground = "Y"; } if (Convert.ToBoolean(dr["WPEditName"].ToString()) == true) { _wpeditname = "Y"; } if (Convert.ToBoolean(dr["WPEditAttribute"].ToString()) == true) { _wpeditattribute = "Y"; } if (Convert.ToBoolean(dr["WPClassify"].ToString()) == true) { _wpclassify = "Y"; } sb.AppendLine("INSERT INTO [dbo].[USERS]"); sb.AppendLine(" ([UserID]"); sb.AppendLine(" ,[BackDateBooking]"); sb.AppendLine(" ,[DaysBackdate]"); sb.AppendLine(" ,[WPProduction]"); sb.AppendLine(" ,[WPSurface]"); sb.AppendLine(" ,[WPUnderGround]"); sb.AppendLine(" ,[WPEditName]"); sb.AppendLine(" ,[WPEditAttribute]"); sb.AppendLine(" ,[WPClassify])"); sb.AppendLine(" VALUES"); sb.AppendLine(" ('" + userID + "'"); sb.AppendLine(" ," + dr["BackDateBooking"].ToString()); sb.AppendLine(" ," + dr["DaysBackdate"].ToString()); sb.AppendLine(" ,'" + _wpproduction + "' "); sb.AppendLine(" ,'" + _wpsurface + "' "); sb.AppendLine(" ,'" + _wpunderground + "' "); sb.AppendLine(" ,'" + _wpeditname + "' "); sb.AppendLine(" ,'" + _wpeditattribute + "' "); sb.AppendLine(" ,'" + _wpclassify + "') "); TheData.SqlStatement = sb.ToString(); try { TheData.ExecuteInstruction(); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER SETTINGS", userID, UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER BACK DATED BOOKINGS", userID + " : " + dr["BackDateBooking"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER ALLOW BACKDATED BOOKINGS", userID + " : " + dr["BackDateBooking"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP PRODUCTION", userID + " : " + dr["WPProduction"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP SURFACE", userID + " : " + dr["WPSurface"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP UNDERGRUND", userID + " : " + dr["WPUnderGround"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP EDIT NAME", userID + " : " + dr["WPEditName"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP EDIT ATTRIBUTE", userID + " : " + dr["WPEditAttribute"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "NEW USER WP CLASSIFY", userID + " : " + dr["WPClassify"].ToString(), UserCurrentInfo.Connection); theResult = true; } catch (Exception e) { myMessage.viewMessage(MessageType.Error, "Error Adding User", Production.resWPAS.systemName, "clsUserProductionSettings", "SaveUserSettings", e.Message, ButtonTypes.OK, MessageDisplayType.FullScreen); theResult = false; } } // insert } return(theResult); }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { StringBuilder sb = new StringBuilder(); if (activity.EditValue.ToString() == "0") { Stopping.PostEditor(); Stopping.UpdateCurrentRow(); foreach (DataRow r in dt.Rows) { string auth; if (r["Auth"].ToString() != "") { if (Convert.ToBoolean(r["Auth"].ToString()) == true) { auth = "Y"; } else { auth = "N"; } } else { auth = "N"; } if (r.RowState == DataRowState.Modified) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); sb.AppendLine("update PLANMONTH SET Locked='" + r["locked"].ToString() + "',"); sb.AppendLine(" Auth = '" + auth + "'"); sb.AppendLine(" WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "' "); _dbMan.SqlStatement = sb.ToString(); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " LOCKED: " + r["locked"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " AUTH: " + r["Auth"].ToString(), UserCurrentInfo.Connection); } } } if (activity.EditValue.ToString() == "1") { Development.PostEditor(); Development.UpdateCurrentRow(); foreach (DataRow r in dt.Rows) { string auth; if (r["Auth"].ToString() == "" || Convert.ToBoolean(r["Auth"].ToString()) == false) { auth = "N"; } else { auth = "Y"; } bool locked; var descript = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["description"]); string DESCRIPT = Convert.ToString(descript); var LOCKED = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["locked"]); if (LOCKED == null || LOCKED is DBNull || LOCKED == "") { LOCKED = "False"; locked = Convert.ToBoolean(LOCKED); } else { locked = Convert.ToBoolean(LOCKED); } bool Lock; if (r["locked"].ToString() == "") { Lock = false; } else { Lock = Convert.ToBoolean(r["locked"].ToString()); } var ab10 = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["Topend"]); string ab101 = Convert.ToString(ab10); string workplcid; string prmonth; dt.AcceptChanges(); DataRow[] df = dt.Select("description='" + DESCRIPT + "'"); prmonth = df[0]["prodmonth"].ToString(); workplcid = df[0]["workplaceid"].ToString(); MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.SqlStatement = ""; //_dbMan.SqlStatement = "update PLANMONTH SET Auth = '" + auth + "', cmkgt = " + r["Lcmkgt"].ToString() + ", Locked=" + Convert.ToInt16(Lock).ToString() + ",metresadvance=" + r["lM"].ToString() + ",ReefAdv=" + r["Lock_On_M"].ToString() + ",WasteAdv=" + r["Lock_Off_M"].ToString() + " WHERE prodmonth=" + prmonth + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan.SqlStatement = "update PLANMONTH SET Auth = '" + auth + "',Locked=" + Convert.ToInt16(Lock).ToString() + " WHERE prodmonth=" + prmonth + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); rpReplanning.Visible = true; rpPreplanning.Visible = false; gcLockPlan.Visible = true; TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " LOCKED: " + r["locked"].ToString(), UserCurrentInfo.Connection); TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " AUTH: " + r["Auth"].ToString(), UserCurrentInfo.Connection); } gcLockPlan.Visible = false; rpPreplanning.Visible = true; rpReplanning.Visible = false; panelControl1.Visible = false; //Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Data Saved", "Development Lock Plan Data was saved successfully", Color.CornflowerBlue); } if (activity.EditValue.ToString() == "2") { Sundry.PostEditor(); Sundry.UpdateCurrentRow(); foreach (DataRow r in dt.Rows) { bool Auth; if (r["Auth"].ToString() == "") { Auth = false; } else { Auth = Convert.ToBoolean(r["Auth"].ToString()); } bool Lock; if (r["Locked"].ToString() == "") { Lock = false; } else { Lock = Convert.ToBoolean(r["Locked"].ToString()); } if (Convert.ToBoolean(r["hasChanged"].ToString()) == true) // only save data that changed { MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess(); _dbMan1.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1.SqlStatement = ""; _dbMan1.SqlStatement = "select * from PLANMONTH_SUNDRYMINING WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and SMID='" + r["SMID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1.ExecuteInstruction(); DataTable SNDRY = new DataTable(); SNDRY.Clear(); SNDRY = _dbMan1.ResultsDataTable; if (SNDRY.Rows.Count == 0) { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1.SqlStatement = ""; _dbMan.SqlStatement = " insert into PLANMONTH_SUNDRYMINING values(" + r["prodmonth"].ToString() + ",'" + r["SectionID"].ToString() + "','" + r["Workplaceid"].ToString() + "',2,'" + r["SMID"].ToString() + "','LP'," + " '" + r["OrgunitDay"].ToString() + "', " + " '" + r["OrgunitNight"].ToString() + "', '" + Convert.ToInt32(r["Units"]) + "','','',0,0.000," + Convert.ToInt16(Lock).ToString() + "," + Convert.ToInt16(Auth).ToString() + ",'') "; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); rpReplanning.Visible = true; rpPreplanning.Visible = false; gcLockPlan.Visible = true; } else { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.SqlStatement = ""; _dbMan.SqlStatement = "update PLANMONTH_SUNDRYMINING SET Locked= " + Convert.ToInt16(Lock).ToString() + " , Auth= " + Convert.ToInt16(Auth).ToString() + " WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' AND SMID= '" + r["SMID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); rpReplanning.Visible = true; rpPreplanning.Visible = false; gcLockPlan.Visible = true; panelControl1.Visible = true; } } } } if (activity.EditValue.ToString() == "8") { foreach (DataRow r in dt.Rows) { if (Convert.ToBoolean(r["hasChanged"].ToString()) == true) // only save data that changed { // test if WP was saved MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess(); _dbMan1.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan1.SqlStatement = ""; _dbMan1.SqlStatement = "select * from PlanMonth_Oldgold WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' AND OGID= '" + r["OGID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan1.ExecuteInstruction(); DataTable oldgold = new DataTable(); oldgold.Clear(); oldgold = _dbMan1.ResultsDataTable; SweepsVamps.PostEditor(); SweepsVamps.UpdateCurrentRow(); bool Auth; if (r["Auth"].ToString() == "") { Auth = false; } else { Auth = Convert.ToBoolean(r["Auth"].ToString()); } bool Lock; if (r["Locked"].ToString() == "") { Lock = false; } else { Lock = Convert.ToBoolean(r["Locked"].ToString()); } if (oldgold.Rows.Count == 0) // add { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.SqlStatement = ""; _dbMan.SqlStatement = " insert into PLANMONTH_OLDGOLD values(" + r["prodmonth"].ToString() + ",'" + r["SectionID"].ToString() + "','" + r["workplaceid"].ToString() + "',8,'LP','" + r["OGID"].ToString() + "'," + " '" + Convert.ToInt32(r["Units"]) + "',0,0.00,0,'" + r["OrgunitDay"].ToString() + "','" + r["OrgunitAfterNoon"].ToString() + "', " + " '" + r["OrgunitNight"].ToString() + "',0," + Convert.ToInt16(Lock).ToString() + "," + Convert.ToInt16(Auth).ToString() + ",'') "; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); } else // update { MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess(); _dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbMan.SqlStatement = ""; _dbMan.SqlStatement = "update PlanMonth_Oldgold SET Locked= " + Convert.ToInt16(Lock).ToString() + " , Auth= " + Convert.ToInt16(Auth).ToString() + " WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' AND OGID= '" + r["OGID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'"; _dbMan.queryReturnType = MWDataManager.ReturnType.DataTable; _dbMan.ExecuteInstruction(); } } } } Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Success", "Data Saved", System.Drawing.Color.CornflowerBlue); ribbonMenu.Minimized = false; }