private void LoadTheData(string Template, string Section, string ProdMonth, string Activity, string WorkPlace) { bool Readonly = false; MWDataManager.clsDataAccess _Access = new MWDataManager.clsDataAccess(); _Access.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _Access.SqlStatement = "SELECT * FROM dbo.PlanProt_ProfileAccess PPPA WHERE PPPA.TemplateID = " + Template + " AND DepartmentID = '" + TUserInfo.DepartmentID + "'"; _Access.queryReturnType = MWDataManager.ReturnType.DataTable; _Access.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _Access.ExecuteInstruction(); // Setup security to allow lock and unlock of data foreach (DataRow r in _Access.ResultsDataTable.Rows) { if (r["AccessLevel"].ToString() != "True") { Readonly = true; } else { Readonly = false; }// change back btnLockData.enabled to false } // Setup secutity to allow lock of data _Access.SqlStatement = "SELECT DISTINCT Name_4,Name_3 ,Name_2 FROM dbo.SECTION_COMPLETE WHERE SECTIONID_2 = '" + barSetion.EditValue.ToString() + "' AND PRODMONTH = " + ProdMonth; _Access.ExecuteInstruction(); string theUnit = ""; string theShaft = ""; string theSection = ""; foreach (DataRow r in _Access.ResultsDataTable.Rows) { theUnit = r["Name_4"].ToString(); // the new unit theShaft = r["Name_3"].ToString(); // the new shaft theSection = r["Name_2"].ToString(); // the new section } _Access.SqlStatement = "SELECT * FROM dbo.PlanProt_ApproveUsers WHERE ((Unit = '" + theUnit + "' and Section = 'NONE' and Section = 'NONE') OR (Unit = '" + theUnit + "' and Shaft = '" + theShaft + "' and Section = 'NONE') OR (Unit = '" + theUnit + "' and Shaft = '" + theShaft + "' and Section = '" + theSection + "')) AND TemplateID = " + Template; _Access.ExecuteInstruction(); btnLockData.Enabled = true; foreach (DataRow r in _Access.ResultsDataTable.Rows) { if (TUserInfo.UserID == r["User1"].ToString() || TUserInfo.UserID == r["User2"].ToString()) { btnLockData.Enabled = true; break; } else { btnLockData.Enabled = false; } //change back btnLockData.Enabled to false } string WorkplacesID; if (WorkPlace == "") { WorkplacesID = "0"; } else { WorkplacesID = WorkPlace; } ucPlanProtDataView = new ucPlanProtDataView { theSystemDBTag = this.theSystemDBTag, UserCurrentInfo = this.UserCurrentInfo }; ucPlanProtDataView.Dock = DockStyle.Fill; ucPlanProtDataView.Parent = clientPanel; ucPlanProtDataView.loadTemplateData(Convert.ToInt32(ProdMonth), Section, Convert.ToInt32(Template), WorkplacesID, Convert.ToInt32(Activity), captureOption, Readonly); if (ucPlanProtDataView.mainData.Rows.Count == 0) { ucPlanProtDataView.Visible = false; rpCapture.Visible = false; rpSettings.Visible = true; _sysMessagesClass.viewMessage(Global.MessageType.Info, "ERROR LOADING DATA", this.theSystemTag, "Template", "loadTemplateData", "No Data available for selected settings", Global.ButtonTypes.OK, Global.MessageDisplayType.FullScreen); // MessageBox.Show("No Data available for selected settings", "", MessageBoxButtons.OK); // frmPlanProtCpature abc = new frmPlanProtCpature(); //abc.Show(); } }
private void btnApprove_Click(object sender, EventArgs e) { //foreach (DataRow r in distinctValuesWorkplace.Rows) //{ // editProdMonth.Text = r["PRODMONTH"].ToString(); // editSection.Text = r["SECTIONID"].ToString(); // editTemplateName.Text = r["TemplateName"].ToString(); // listWorkplace.Items.Add(r["WPDESCRIPTION"].ToString()); //} if (theapproveType == "APPROVE") { //MWDataManager.clsDataAccess _SaveData = new MWDataManager.clsDataAccess(); //_SaveData.ConnectionString = TUserInfo.ConnectionString; //_SaveData.SqlStatement = "spPlanProt_ApproveData"; //_SaveData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure; string text = ""; string separator = ""; foreach (DataRow r in distinctValuesWorkplace.Rows) { string textCMB = text; MWDataManager.clsDataAccess _RequiredData = new MWDataManager.clsDataAccess(); _RequiredData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _RequiredData.SqlStatement = "sp_RequiredCountOfDataApproval"; _RequiredData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure; if (Convert.ToBoolean(r["canApprove"].ToString()) == true) { SqlParameter[] _paramCollection1 = { _RequiredData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["PRODMONTH"].ToString())), _RequiredData.CreateParameter("@SectionID ", SqlDbType.VarChar, 50, r["SECTIONID"].ToString()), _RequiredData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 50, r["WORKPLACEID"]), _RequiredData.CreateParameter("@TemplateID", SqlDbType.Int, 0, r["TemplateID"]), // _RequiredData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0,TUserInfo.UserID), _RequiredData.CreateParameter("@ActivityType", SqlDbType.Int, 0, r["ActivityType"]), // _SaveData.CreateParameter("@ApproveItem", SqlDbType.VarChar, 0,"YES"), }; _RequiredData.ParamCollection = _paramCollection1; _RequiredData.queryReturnType = MWDataManager.ReturnType.DataTable; _RequiredData.ExecuteInstruction(); DataTable dt = new DataTable(); dt = _RequiredData.ResultsDataTable; foreach (DataRow dr in dt.Rows) { if (Convert.ToInt32(dr["FIELDCOUNT"]) > 0) { text += separator + r["DESCRIPTION"]; separator = ","; // textCMB += text; string ss = string.Join(",", r["DESCRIPTION"]); } // } else { MWDataManager.clsDataAccess _SaveData = new MWDataManager.clsDataAccess(); _SaveData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); // _SaveData.SqlStatement = "spPlanProt_ApproveData"; _SaveData.SqlStatement = "sp_PlanProt_ApproveData"; _SaveData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure; // if (Convert.ToBoolean(r["canApprove"].ToString()) == true) // { SqlParameter[] _paramCollection = { _SaveData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["PRODMONTH"].ToString())), _SaveData.CreateParameter("@SectionID ", SqlDbType.VarChar, 50, r["SECTIONID"].ToString()), _SaveData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 50, r["WORKPLACEID"]), _SaveData.CreateParameter("@TemplateID", SqlDbType.Int, 0, r["TemplateID"]), _SaveData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0, TUserInfo.UserID), _SaveData.CreateParameter("@ActivityType", SqlDbType.Int, 0, r["ActivityType"]), _SaveData.CreateParameter("@ApproveItem", SqlDbType.VarChar, 0, "YES"), }; //foreach (DataRow s in mainData .Rows ) //{ // if (s["FieldRe // bool result = false; // var ind = 0; // DataRow s; foreach (DataRow s in mainData.Rows) { if (s["WORKPLACEID"].ToString() == r["WORKPLACEID"].ToString()) //else { s["Approved"] = "YES"; } } _SaveData.ParamCollection = _paramCollection; _SaveData.queryReturnType = MWDataManager.ReturnType.longNumber; clsDataResult result = _SaveData.ExecuteInstruction(); if (result.success == false) { MessageBox.Show(result.Message); } dt.AcceptChanges(); ucPlanProtDataView ucp = new ucPlanProtDataView(); ucp.Refresh(); ucp.Update(); ucp.gridPlanProtData.RefreshData(); ucp.gridPlanProtData.Update(); } } } } if (text == ",") { MessageBox.Show("Please provide all data required for the Workplaces " + text, "Cannot approve the Workplace", MessageBoxButtons.OK); } else { } mainData.Select(""); Close(); } if (theapproveType == "UNAPPROVE") { MWDataManager.clsDataAccess _SaveData = new MWDataManager.clsDataAccess(); _SaveData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection); _SaveData.SqlStatement = "sp_PlanProt_ApproveData"; _SaveData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure; foreach (DataRow r in distinctValuesWorkplace.Rows) { if (Convert.ToBoolean(r["canApprove"].ToString()) == true) { SqlParameter[] _paramCollection = { _SaveData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["PRODMONTH"].ToString())), _SaveData.CreateParameter("@SectionID ", SqlDbType.VarChar, 50, r["SECTIONID"].ToString()), _SaveData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 50, r["WORKPLACEID"]), _SaveData.CreateParameter("@TemplateID", SqlDbType.Int, 0, r["TemplateID"]), _SaveData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0, TUserInfo.UserID), _SaveData.CreateParameter("@ActivityType", SqlDbType.Int, 0, r["ActivityType"]), _SaveData.CreateParameter("@ApproveItem", SqlDbType.VarChar, 0, "NO"), }; foreach (DataRow s in mainData.Rows) { if (s["WORKPLACEID"].ToString() == r["WORKPLACEID"].ToString()) { s["Approved"] = "NO"; } } _SaveData.ParamCollection = _paramCollection; _SaveData.queryReturnType = MWDataManager.ReturnType.longNumber; _SaveData.ExecuteInstruction(); } } } mainData.Select(""); Close(); // } }