private void btnNewOption_Click(object sender, EventArgs e)
{
MWDataManager.clsDataAccess _theData = new MWDataManager.clsDataAccess();
_theData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_theData.SqlStatement = "sp_HRStdNorm_AddOption";
_theData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_theData.queryReturnType = MWDataManager.ReturnType.DataTable;
SqlParameter[] _paramCollection =
{
_theData.CreateParameter("@TargetID", SqlDbType.Int, 0, theTargetID),
_theData.CreateParameter("@Activity", SqlDbType.VarChar, 150, theActivity),
};
_theData.ParamCollection = _paramCollection;
_theData.ExecuteInstruction();
saveData();
switch (theActivity)
{
case 0:
buildStoping();
break;
case 1:
buildDev();
break;
}
LoadData(theTargetID);
}
private void createReport(Object theReportSettings)
{
string _act = "";
if (reportSettings.Activity == "Stoping")
{
_act = "0";
}
else if (reportSettings.Activity == "Development")
{
_act = "1";
}
MWDataManager.clsDataAccess _plathondWallRoomReportData = new MWDataManager.clsDataAccess();
_plathondWallRoomReportData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_plathondWallRoomReportData.SqlStatement = "sp_PlathondWallRoom";
_plathondWallRoomReportData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_plathondWallRoomReportData.ResultsTableName = "PlathondWallRoomData";
SqlParameter[] _DevparamCollection =
{
_plathondWallRoomReportData.CreateParameter("@Prodmonth", SqlDbType.VarChar, 6, THarmonyPASGlobal.ProdMonthAsString(reportSettings.Prodmonth)),
_plathondWallRoomReportData.CreateParameter("@Section", SqlDbType.VarChar, 50, reportSettings.NAME),
_plathondWallRoomReportData.CreateParameter("@Activity", SqlDbType.VarChar, 1, _act),
};
_plathondWallRoomReportData.ParamCollection = _DevparamCollection;
_plathondWallRoomReportData.queryReturnType = MWDataManager.ReturnType.DataTable;
clsDataResult result = _plathondWallRoomReportData.ExecuteInstruction();
if (!result.success)
{
throw new ApplicationException("Report Section:MODailyStopeData:" + result.Message);
}
DataSet repDataSet = new DataSet();
repDataSet.Tables.Add(_plathondWallRoomReportData.ResultsDataTable);
theReport.RegisterData(repDataSet);
theReport.Load(TGlobalItems.ReportsFolder + "\\PlathondWallRoom.frx");
theReport.SetParameterValue("Banner", THarmonyPASGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).Mine);
theReport.SetParameterValue("Prodmonth", THarmonyPASGlobal.ProdMonthAsString(reportSettings.Prodmonth));
theReport.SetParameterValue("SectionName", reportSettings.NAME);
theReport.SetParameterValue("TheDate", reportSettings.Activity);
theReport.SetParameterValue("logo", TGlobalItems.ClientLogo);
theReport.SetParameterValue("logoMineware", TGlobalItems.CompanyLogo);
if (TParameters.DesignReport)
{
theReport.Design();
}
theReport.Prepare();
ActiveReport.SetReport = theReport;
ActiveReport.isDone = true;
}
private void GetPlanningData()
{
MWDataManager.clsDataAccess _PrePlanningData = new MWDataManager.clsDataAccess();
_PrePlanningData.ConnectionString = TConnections.GetConnectionString(systemDBTag,
UserCurrentInfo.Connection);
_PrePlanningData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_PrePlanningData.queryReturnType = MWDataManager.ReturnType.DataTable;
_PrePlanningData.SqlStatement = "sp_Load_Planning";
SqlParameter[] _paramCollection =
{
_PrePlanningData.CreateParameter("@ProdMonth",
SqlDbType.Int,
0,
Convert.ToInt32(planningSettings.ProdMonth)),
_PrePlanningData.CreateParameter("@Sectionid_2",
SqlDbType.VarChar,
20,
planningSettings.MOSectionID),
_PrePlanningData.CreateParameter("@Activity", SqlDbType.Int,0, planningSettings.ActivityID),
};
_PrePlanningData.ParamCollection = _paramCollection;
var result = _PrePlanningData.ExecuteInstruction();
_PrePlanningData.ResultsDataTable.Columns["OrgUnitNight"].DataType = typeof(string);
tblPlanningData = _PrePlanningData.ResultsDataTable.Copy();
_PrePlanningData.Dispose();
_PrePlanningData = null;
}
/// <summary>
/// Run when importing data from previous month
/// </summary>
private void ImportPreviousMonthData()
{
MWDataManager.clsDataAccess _PrePlanningData = new MWDataManager.clsDataAccess();
_PrePlanningData.ConnectionString = TConnections.GetConnectionString(systemDBTag,
UserCurrentInfo.Connection);
_PrePlanningData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_PrePlanningData.queryReturnType = MWDataManager.ReturnType.DataTable;
_PrePlanningData.SqlStatement = "sp_preplanning_save_previus_month";
SqlParameter[] _paramCollection =
{
_PrePlanningData.CreateParameter("@ProdMonth",
SqlDbType.Int,
0,
Convert.ToInt32(planningSettings.ProdMonth)),
_PrePlanningData.CreateParameter("@Sectionid_2",
SqlDbType.VarChar,
20,
planningSettings.MOSectionID),
_PrePlanningData.CreateParameter("@Activity", SqlDbType.Int,0, planningSettings.ActivityID),
};
_PrePlanningData.ParamCollection = _paramCollection;
var result = _PrePlanningData.ExecuteInstruction();
}
public DataTable get_sICDetail(string _prodmonth, string _sectionid, string _workplaceid, string _activity)
{
theData.SqlStatement = "[sp_Report_SIC_Detail]";
theData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
theData.ResultsTableName = "SIC_Detail";
SqlParameter[] _paramCollection =
{
theData.CreateParameter("@ProdMonth", SqlDbType.VarChar, 6, _prodmonth),
theData.CreateParameter("@SectionID", SqlDbType.Text, 20, _sectionid),
theData.CreateParameter("@WorkplaceID", SqlDbType.Text, 12, _workplaceid),
theData.CreateParameter("@Activity", SqlDbType.Text, 1, _activity),
};
theData.ParamCollection = _paramCollection;
theData.queryReturnType = MWDataManager.ReturnType.DataTable;
clsDataResult errorMsg = theData.ExecuteInstruction();
if (errorMsg.success == false)
{
return(theData.ResultsDataTable);
}
else
{
return(theData.ResultsDataTable);
}
}
public void Decline(int ApproveRequestID, string ChangeType, string WPName)
{
theApproveRequestID = ApproveRequestID;
Text = "DECLINE";
labelControl1.Text = ChangeType + ": " + WPName;
ShowDialog();
if (canceledAction == false)
{
// theresult = canceledAction;
MWDataManager.clsDataAccess _SaveData = new MWDataManager.clsDataAccess();
_SaveData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_SaveData.SqlStatement = "[sp_RevisedPlanning_ApproveDecline]";
_SaveData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_SaveData.CreateParameter("@ApproveRequestID", SqlDbType.Int, 0, Convert.ToInt32(theApproveRequestID)),
_SaveData.CreateParameter("@RequestStauts", SqlDbType.Int, 0, Convert.ToInt32(2)),
_SaveData.CreateParameter("@UserID", SqlDbType.VarChar, 50, TUserInfo.UserID),
_SaveData.CreateParameter("@Comments", SqlDbType.VarChar, 255, editComments.Text),
};
_SaveData.ParamCollection = _paramCollection;
_SaveData.queryReturnType = MWDataManager.ReturnType.longNumber;
_SaveData.ExecuteInstruction();
//ucRequeststatus ucreq = new ucRequeststatus();
}
else
{
//theresult = canceledAction;
}
}
//public void loadRequestList()
//{
//}
public void loadTemplateData(int ProdMonth, string section, int TemplateID, int ActivityType)
{
gcRequestList.Refresh();
gvRequestList.RefreshData();
// GlobalVar.ActivityType = ActivityType;
//// GlobalVar.captureOption = captureOption;
// GlobalVar.ProdMonth = ProdMonth;
//// GlobalVar.Readonly = Readonly;
// GlobalVar.section = section;
// GlobalVar.TemplateID = TemplateID;
// GlobalVar.WorkPlaceID = WorkPlaceID;
MWDataManager.clsDataAccess _RequestList = new MWDataManager.clsDataAccess();
_RequestList.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RequestList.SqlStatement = "sp_PlanProt_WorkplaceListTobeApproved";
_RequestList.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
//_RequestList.ConnectionString = TUserInfo.ConnectionString;
//_RequestList.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
//_RequestList.queryReturnType = MWDataManager.ReturnType.DataTable;
//_RequestList.SqlStatement = "spUNAPPROVALWorkplaceLIST '";// + TUserInfo.UserID + "'";
//_RequestList.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
// _RequestList.ExecuteInstruction();
SqlParameter[] _paramCollection =
{
_RequestList.CreateParameter("@ProdMonth", SqlDbType.Int, 7, ProdMonth),
_RequestList.CreateParameter("@SectionID ", SqlDbType.VarChar, 10, section),
_RequestList.CreateParameter("@TemplateID", SqlDbType.Int, 0, TemplateID),
_RequestList.CreateParameter("@ActivityType", SqlDbType.Int, 0, ActivityType),
// _RequestList.CreateParameter("@ActivityType", SqlDbType.VarChar , 50,captureOption),
// _RequestList.CreateParameter("@WorkplaceID", SqlDbType.Int, 0,WorkPlaceID),
};
_RequestList.ParamCollection = _paramCollection;
_RequestList.queryReturnType = MWDataManager.ReturnType.DataTable;
_RequestList.ExecuteInstruction();
if (_RequestList.ResultsDataTable.DefaultView.Count == 0)
{
//if(_RequestList .ResultsDataTable .Columns
Visible = false;
// ucplantrotdataview.DoApproveData("APPROVE");
}
else
{
gcRequestList.DataSource = _RequestList.ResultsDataTable;
abc = _RequestList.ResultsDataTable;
ShowDialog();
frmLockUnlockData frmunlc = new frmLockUnlockData();
frmunlc.Visible = false;
}
}
private void saveData()
{
foreach (DataRow r in theMainData.Rows)
{
MWDataManager.clsDataAccess _theData = new MWDataManager.clsDataAccess();
_theData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_theData.SqlStatement = "sp_HRStdNorm_UpdateData";
_theData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_theData.queryReturnType = MWDataManager.ReturnType.DataTable;
SqlParameter[] _paramCollection =
{
_theData.CreateParameter("@StdAndNormID", SqlDbType.Int, 0, r["StdAndNormID"]),
_theData.CreateParameter("@NightShift", SqlDbType.Bit, 0, r["NightShift"]),
_theData.CreateParameter("@PanelLengthMin", SqlDbType.Decimal, 0, r["PanelLengthMin"]),
_theData.CreateParameter("@PanelLengthMax", SqlDbType.Decimal, 0, r["PanelLengthMax"]),
_theData.CreateParameter("@SWMin", SqlDbType.Decimal, 0, r["SWMin"]),
_theData.CreateParameter("@SWMax", SqlDbType.Decimal, 0, r["SWMax"]),
_theData.CreateParameter("@NumWinch", SqlDbType.Int, 0, r["NumWinch"]),
_theData.CreateParameter("@NumberOfEnds", SqlDbType.Int, 0, r["NumberOfEnds"]),
_theData.CreateParameter("@RiggTypeID", SqlDbType.Int, 0, r["RiggTypeID"]),
_theData.CreateParameter("@TippingDistance", SqlDbType.Int, 0, r["TippingDistance"]),
};
_theData.ParamCollection = _paramCollection;
_theData.ExecuteInstruction();
foreach (DataRow rr in selectedDesignationsData.Rows)
{
if (theMainData.Columns.Contains(rr["Designation"].ToString()) == true)
{
MWDataManager.clsDataAccess _saveDesignationsData = new MWDataManager.clsDataAccess();
_saveDesignationsData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_saveDesignationsData.SqlStatement = "sp_HRStdNorm_UpdateDesignationData";
_saveDesignationsData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_saveDesignationsData.queryReturnType = MWDataManager.ReturnType.longNumber;
SqlParameter[] _paramCollection2 =
{
_saveDesignationsData.CreateParameter("@StdAndNormID", SqlDbType.Int, 0, r["StdAndNormID"]),
_saveDesignationsData.CreateParameter("@Designation", SqlDbType.VarChar, 150, rr["Designation"]),
_saveDesignationsData.CreateParameter("@Day", SqlDbType.Int, 0, r[rr["Designation"] + " Day"]),
_saveDesignationsData.CreateParameter("@Night", SqlDbType.Int, 0, r[rr["Designation"] + " Night"]),
};
_saveDesignationsData.ParamCollection = _paramCollection2;
_saveDesignationsData.ExecuteInstruction();
}
}
}
}
private void AddWorkplace(string WPDesc)
{
MWDataManager.clsDataAccess _NewWorkPlace = new MWDataManager.clsDataAccess();
_NewWorkPlace.ConnectionString = TConnections.GetConnectionString(systemDBTag, UserCurrentInfo.Connection);
_NewWorkPlace.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_NewWorkPlace.queryReturnType = MWDataManager.ReturnType.DataTable;
// _NewWorkPlace.SqlStatement = "spAddPrePlanningWorkPlace";
_NewWorkPlace.SqlStatement = "sp_PrePlanning_AddWorkplace";
SqlParameter[] _paramCollection =
{
_NewWorkPlace.CreateParameter("@Prodmonth", SqlDbType.Int, 0, Convert.ToInt32(PlanningSettings.ProdMonth)),
_NewWorkPlace.CreateParameter("@Sectionid_2", SqlDbType.VarChar, 20, PlanningSettings.MOSectionID),
_NewWorkPlace.CreateParameter("@WPDESCRIPTION", SqlDbType.VarChar, 100, WPDesc),
_NewWorkPlace.CreateParameter("@ActivityCode", SqlDbType.Int, 0, PlanningSettings.ActivityID),
};
_NewWorkPlace.ParamCollection = _paramCollection;
clsDataResult exr = _NewWorkPlace.ExecuteInstruction();
if (exr.success == false)
{
MessageBox.Show(exr.Message);
}
if (_NewWorkPlace.ResultsDataTable.Rows.Count != 0)
{
CPMBusinessLayer.clsBusinessLayer BMEBL = new CPMBusinessLayer.clsBusinessLayer();
BMEBL._queryReturnType = CPMBusinessLayer.ReturnType.DataTable;
BMEBL.SetsystemDBTag = systemDBTag;
BMEBL.SetUserCurrentInfo = this.UserCurrentInfo;
// DataTable theDates = new DataTable();
if (BMEBL.get_BeginEndDates(PlanningSettings.MOSectionID, PlanningSettings.ProdMonth) == true)
{
theDates = BMEBL.ResultsDataTable;
}
if (_NewWorkPlace.ResultsDataTable.Rows.Count > 0)
{
foreach (DataRow r in _NewWorkPlace.ResultsDataTable.Rows)
{
tblPlanningData.ImportRow(r);
}
}
}
}
private void btnSendMessage_Click(object sender, EventArgs e)
{
foreach (var item in cbcTemplateList.CheckedItems)
{
int items = Convert.ToInt32((item as DataRowView)["TemplateID"].ToString());
MWDataManager.clsDataAccess _GetData = new MWDataManager.clsDataAccess();
_GetData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_GetData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_GetData.queryReturnType = MWDataManager.ReturnType.DataTable;
_GetData.SqlStatement = "SELECT d1.TemplateID,d1.User1,d1.TemplateName from( " +
"SELECT PPT.TemplateID,PPT.TemplateName,PPAU.User1,PPAU.User2 FROM dbo.PlanProt_Template PPT " +
"INNER JOIN dbo.PlanProt_ApproveUsers PPAU ON " +
"PPT.TemplateID = PPAU.TemplateID " +
"INNER JOIN vw_Section_from_MO SC ON " +
"(SC.Name_3 = PPAU.Shaft OR " +
"SC.Name_4 = PPAU.Shaft) AND " +
"SC.SECTIONID_2 = '" + _SectionID_2 + "' " +
"WHERE PPT.TemplateID = '" + Convert.ToString(items) + "' AND " +
" PPT.Activity = " + Convert.ToString(_Activity) + " AND " +
" SC.PRODMONTH = " + Convert.ToString(TProductionGlobal.ProdMonthAsInt(_Prodmonth)) + " ) d1 " +
" where d1.User1<>'' GROUP BY TemplateID,User1,TemplateName";
_GetData.ExecuteInstruction();
foreach (DataRow r in _GetData.ResultsDataTable.Rows)
{
MWDataManager.clsDataAccess _SendMail = new MWDataManager.clsDataAccess();
_SendMail.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_SendMail.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_SendMail.queryReturnType = MWDataManager.ReturnType.longNumber;
_SendMail.SqlStatement = "sp_MailRequestDataApprovalNew";
SqlParameter[] _paramCollection =
{
_SendMail.CreateParameter("@Prodmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(_Prodmonth)),
_SendMail.CreateParameter("@SectionID_2", SqlDbType.VarChar, 20, _SectionID_2),
_SendMail.CreateParameter("@TemplateID", SqlDbType.Int, 0, Convert.ToInt32(r["TemplateID"].ToString())),
_SendMail.CreateParameter("@toUserName", SqlDbType.VarChar, 20, r["User1"].ToString()),
_SendMail.CreateParameter("@theMessage", SqlDbType.NVarChar, 0, memoMessage.Text),
};
_SendMail.ParamCollection = _paramCollection;
_SendMail.ExecuteInstruction();
}
}
MessageBox.Show("Message(s) was successfully sent.");
//_SendMail.ExecuteInstruction();
}
private void loadData(int TargetID)
{
MWDataManager.clsDataAccess _theAvalibalData = new MWDataManager.clsDataAccess();
_theAvalibalData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_theAvalibalData.SqlStatement = "sp_HR_Designations";
_theAvalibalData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_theAvalibalData.queryReturnType = MWDataManager.ReturnType.DataTable;
SqlParameter[] _paramCollection =
{
_theAvalibalData.CreateParameter("@TargetID", SqlDbType.VarChar, 10, TargetID.ToString()),
};
_theAvalibalData.ParamCollection = _paramCollection;
_theAvalibalData.ExecuteInstruction();
theAvalibalData = _theAvalibalData.ResultsDataTable.Copy();
gcAvalibalData.DataSource = theAvalibalData;
MWDataManager.clsDataAccess _theSelectedData = new MWDataManager.clsDataAccess();
_theSelectedData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_theSelectedData.SqlStatement = "SELECT Designation FROM HRSTDNORMDESIGNATION WHERE TargetID = " + TargetID.ToString();
_theSelectedData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_theSelectedData.queryReturnType = MWDataManager.ReturnType.DataTable;
gcSelectedData.DataSource = _theSelectedData.ResultsDataTable;
_theSelectedData.ExecuteInstruction();
theSelectedData = _theSelectedData.ResultsDataTable.Copy();
gcSelectedData.DataSource = theSelectedData;
}
private void LoadData(int TargetID)
{
MWDataManager.clsDataAccess _theData = new MWDataManager.clsDataAccess();
_theData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_theData.SqlStatement = "sp_HRStdNorm_GetData";
_theData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_theData.queryReturnType = MWDataManager.ReturnType.DataTable;
SqlParameter[] _paramCollection =
{
_theData.CreateParameter("@TargetID", SqlDbType.Int, 0, TargetID),
};
_theData.ParamCollection = _paramCollection;
_theData.ExecuteInstruction();
//theMainData = _theData.ResultsDataTable.Clone();
theMainData = _theData.ResultsDataTable.Copy();
vgcOptions.DataSource = theMainData;
_theData.SqlStatement = "SELECT * FROM HRSTDNORMDESIGNATION WHERE TargetID = " + TargetID.ToString();
_theData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_theData.queryReturnType = MWDataManager.ReturnType.DataTable;
_theData.ExecuteInstruction();
selectedDesignationsData = _theData.ResultsDataTable.Copy();
foreach (DataRow r in selectedDesignationsData.Rows)
{
if (theMainData.Columns.Contains(r["Designation"].ToString()) == false)
{
addDesignationsCol(r["Designation"].ToString());
}
if (theMainData.Columns.Contains(r["Designation"].ToString()) == true)
{
foreach (DataRow rr in theMainData.Rows)
{
_theData.SqlStatement = "SELECT *FROM [HRSTDNORMDESIGNATIONDATA] " +
"WHERE StdAndNormID = " + rr["StdAndNormID"].ToString() + " and " +
"Designation = '" + r["Designation"].ToString() + "'";
_theData.ExecuteInstruction();
if (_theData.ResultsDataTable.Rows.Count == 1)
{
foreach (DataRow rrr in _theData.ResultsDataTable.Rows)
{
rr[r["Designation"] + " Day"] = rrr["Day"];
rr[r["Designation"] + " Night"] = rrr["Night"];
}
}
}
}
}
}
private void createReport(Object theReportSettings)
{
try
{
ActiveReport.reportType = Global.ReportsControls.SharedItems.reportTypes.AsposeExcel;
clsDuplicateSampleReportSettings currentReportSettings = theReportSettings as clsDuplicateSampleReportSettings;
string designerFile = TGlobalItems.ReportsFolder + "\\DuplicateSampleData.Xlsx";
MWDataManager.clsDataAccess _courseBlankData = new MWDataManager.clsDataAccess();
_courseBlankData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_courseBlankData.SqlStatement = "sp_DuplicateSampleReport";
_courseBlankData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_courseBlankData.ResultsTableName = "DuplicateSampleData";
SqlParameter[] _paramCollection =
{
_courseBlankData.CreateParameter("@Shaft", SqlDbType.VarChar, 50, reportSettings.Shaft.ToString())
};
_courseBlankData.ParamCollection = _paramCollection;
_courseBlankData.queryReturnType = MWDataManager.ReturnType.DataTable;
_courseBlankData.ExecuteInstruction();
DataSet repDataSet = new DataSet();
repDataSet.Tables.Add(_courseBlankData.ResultsDataTable);
ActiveReport.SetReport = designerFile;
ActiveReport.SetReportData(repDataSet);
ActiveReport.isDone = true;
}
catch (Exception _exception)
{
Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Exception Error", _exception.Message, Color.Red);
}
}
public void LoadDetails(int ChangeRequestID)
{
MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess();
_WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_WPData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_WPData.queryReturnType = MWDataManager.ReturnType.DataTable;
_WPData.SqlStatement = "[sp_prePlanning_data]";
SqlParameter[] _paramCollectionS =
{
_WPData.CreateParameter("@ChangeRequestID", SqlDbType.Int, 0, Convert.ToString(ChangeRequestID))
};
_WPData.ParamCollection = _paramCollectionS;
_WPData.ExecuteInstruction();
foreach (DataRow r in _WPData.ResultsDataTable.Rows)
{
editFL.Text = r["FL"].ToString();
editMiningMethod.Properties.NullText = r["Description"].ToString();
editSection.Text = r["Name_2"].ToString();
textEdit2.Text = r["ProdMonth"].ToString();
editToWorkplace.Properties.NullText = r["WPDesc"].ToString();
memoEdit1.Text = r["Comments"].ToString();
loadManageValues(r["OldWorkplaceID"].ToString(), Convert.ToInt32(r["ProdMonth"].ToString()), r["SectionID"].ToString(), r["SectionID_2"].ToString(), true);
}
}
private void btnShow_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
rpReplanning.Visible = true;
rpPreplanning.Visible = false;
MainGrid.Visible = true;
panelControl1.Visible = true;
LoadOrgUnits(prodmonth1.EditValue.ToString(), section.EditValue.ToString());
LoadMinerList(prodmonth1.EditValue.ToString(), section.EditValue.ToString());
editProdmonth.Text = prodmonth1.EditValue.ToString();
MWDataManager.clsDataAccess _MOSection = new MWDataManager.clsDataAccess();
_MOSection.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_MOSection.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_MOSection.queryReturnType = MWDataManager.ReturnType.DataTable;
_MOSection.SqlStatement = "SELECT DISTINCT NAME_2,Name_2 FROM dbo.SECTION_COMPLETE " +
"WHERE PRODMONTH = '" + prodmonth1.EditValue.ToString() + "' AND " +
"SECTIONID_2 = '" + section.EditValue.ToString() + "'";
_MOSection.ExecuteInstruction();
editMoSectionID.Text = section.EditValue.ToString();
foreach (DataRow r in _MOSection.ResultsDataTable.Rows)
{
editMoSection.Text = r["Name_2"].ToString();
}
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.SqlStatement = "[SP_SundryMiningMeasurements]";
int prodmonth = Convert.ToInt32(prodmonth1.EditValue);
string desc = section.EditValue.ToString();
int activ = Convert.ToInt32(activity.EditValue);
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@prodmonth", SqlDbType.Int, 0, Convert.ToInt32(prodmonth)),
_dbMan.CreateParameter("@sectionid", SqlDbType.VarChar, 50, section.EditValue.ToString()),
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.ExecuteInstruction();
dt = _dbMan.ResultsDataTable;
MainGrid.DataSource = dt;
}
public void LoadPlanningCycle()
{
try
{
MWDataManager.clsDataAccess _PrePlanningCycleData = new MWDataManager.clsDataAccess();
_PrePlanningCycleData.ConnectionString = TConnections.GetConnectionString(systemDBTag,
UserCurrentInfo.Connection);
_PrePlanningCycleData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_PrePlanningCycleData.queryReturnType = MWDataManager.ReturnType.DataTable;
_PrePlanningCycleData.SqlStatement = "sp_LoadPlanningCycle";
SqlParameter[] _paramCollection =
{
_PrePlanningCycleData.CreateParameter("@sectionid",
SqlDbType.VarChar,
20,
(planningSettings.MOSectionID)),
_PrePlanningCycleData.CreateParameter("@sectionidMO",
SqlDbType.VarChar,
20,
planningSettings.MOSectionID),
_PrePlanningCycleData.CreateParameter("@ProdMonth",
SqlDbType.Int,
0,
Convert.ToInt32(planningSettings.ProdMonth)),
_PrePlanningCycleData.CreateParameter("@Activity",
SqlDbType.Int,
0,
planningSettings.ActivityID)
};
_PrePlanningCycleData.ParamCollection = _paramCollection;
var result = _PrePlanningCycleData.ExecuteInstruction();
tblPlanningCycleData = _PrePlanningCycleData.ResultsDataTable.Copy();
planningCycle.LoadPlanningCycleData(tblPlanningCycleData);
_PrePlanningCycleData.Dispose();
_PrePlanningCycleData = null;
}
catch (Exception)
{
}
}
public void AddCyclePlan(string workplaceID, string sectionid, string sectionidMO, string ProdMonth, int Activity, double FL)
{
MWDataManager.clsDataAccess _NewCyclePlan = new MWDataManager.clsDataAccess();
_NewCyclePlan.ConnectionString = TConnections.GetConnectionString(systemDBTag, UserCurrentInfo.Connection);
_NewCyclePlan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_NewCyclePlan.queryReturnType = MWDataManager.ReturnType.DataTable;
// _NewWorkPlace.SqlStatement = "spAddPrePlanningWorkPlace";
_NewCyclePlan.SqlStatement = "sp_LoadPlanningCycleWP";
SqlParameter[] _paramCollection =
{
_NewCyclePlan.CreateParameter("@workplaceID", SqlDbType.VarChar, 12, workplaceID),
_NewCyclePlan.CreateParameter("@sectionid", SqlDbType.VarChar, 20, sectionid),
_NewCyclePlan.CreateParameter("@sectionidMO", SqlDbType.VarChar, 100, sectionidMO),
_NewCyclePlan.CreateParameter("@ProdMonth", SqlDbType.Int, 0, ProdMonth),
_NewCyclePlan.CreateParameter("@Activity", SqlDbType.Int, 0, Activity),
_NewCyclePlan.CreateParameter("@FL", SqlDbType.Int, 0, FL),
};
_NewCyclePlan.ParamCollection = _paramCollection;
clsDataResult exr = _NewCyclePlan.ExecuteInstruction();
if (exr.success)
{
planningCycle.LoadPlanningCycleData(_NewCyclePlan.ResultsDataTable);
}
}
private SqlParameter[] SetParamters(string WORKPLACEID, Int32 PRODMONTH, string SectionID_2, int ActicityCode, string sectionID)
{
MWDataManager.clsDataAccess theData = new MWDataManager.clsDataAccess();
SqlParameter[] _paramCollection =
{
theData.CreateParameter("@Prodmonth", SqlDbType.Int, 0, PRODMONTH.ToString()),
theData.CreateParameter("@SectionID", SqlDbType.VarChar, 20, sectionID),
theData.CreateParameter("@Sectionid_2", SqlDbType.VarChar, 20, SectionID_2),
theData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 20, WORKPLACEID),
theData.CreateParameter("@Activity", SqlDbType.Int, 0, ActicityCode),
theData.CreateParameter("@UserID", SqlDbType.VarChar, 50, TUserInfo.UserID),
theData.CreateParameter("@NetworkID", SqlDbType.VarChar, 100, System.Environment.UserName),
theData.CreateParameter("@MachineID", SqlDbType.VarChar, 100, System.Environment.MachineName),
};
return(_paramCollection);
}
public void LoadDetails(int ChangeRequestID)
{
MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess();
_WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_WPData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_WPData.queryReturnType = MWDataManager.ReturnType.DataTable;
_WPData.SqlStatement = "[sp_prePlanning_data]";
SqlParameter[] _paramCollectionS =
{
_WPData.CreateParameter("@ChangeRequestID", SqlDbType.Int, 0, Convert.ToString(ChangeRequestID))
};
_WPData.ParamCollection = _paramCollectionS;
_WPData.ExecuteInstruction();
foreach (DataRow r in _WPData.ResultsDataTable.Rows)
{
txtSection.Text = r["Name_2"].ToString();
txtProdMonth.Text = r["ProdMonth"].ToString();
txtWorkplaceID.Text = r["WorkplaceID"].ToString();
txtWorkplaceName.Text = r["WPDesc"].ToString();
editSNewCube.Text = r["CubicMeters"].ToString();
editSNewOffRSQM.Text = r["WasteSQM"].ToString();
editSNewOnRSQM.Text = r["ReefSQM"].ToString();
editNewDevCube.Text = r["CubicMeters"].ToString();
editDevNewOffRM.Text = r["MetersWaste"].ToString();
editDevNewOnRM.Text = r["Meters"].ToString();
memoReason.Text = r["Comments"].ToString();
dateStop.DateTime = Convert.ToDateTime(r["StopDate"].ToString());
try
{
DeleteBooking.Checked = Convert.ToBoolean(r["DeleteBookings"].ToString());
}
catch
{
DeleteBooking.Checked = false;
}
dateStop.Properties.ReadOnly = true;
memoReason.Properties.ReadOnly = true;
loadCurrentValues(r["WorkplaceID"].ToString(), Convert.ToInt32(r["ProdMonth"].ToString()), r["SectionID"].ToString(), r["SectionID_2"].ToString(), true);
}
}
public void LoadDetails(int ChangeRequestID)
{
MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess();
_WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_WPData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_WPData.queryReturnType = MWDataManager.ReturnType.DataTable;
_WPData.SqlStatement = "[sp_prePlanning_data]";
SqlParameter[] _paramCollectionS =
{
_WPData.CreateParameter("@ChangeRequestID", SqlDbType.Int, 0, Convert.ToString(ChangeRequestID))
};
_WPData.ParamCollection = _paramCollectionS;
_WPData.ExecuteInstruction();
foreach (DataRow r in _WPData.ResultsDataTable.Rows)
{
txtSection.Text = r["Name_2"].ToString();
txtProdMonth.Text = r["ProdMonth"].ToString();
txtWorkplaceID.Text = r["WorkplaceID"].ToString();
txtWorkplaceName.Text = r["WPDesc"].ToString();
txtOnReefSQMNewC.Text = r["ReefSQM"].ToString();
txtOffReefSQMNewC.Text = r["WasteSQM"].ToString();
txtCubicMeterNEWs.Text = r["CubicMeters"].ToString();
spinFLNew.Text = r["FL"].ToString();
txtOnReefMetersNewC.Text = r["Meters"].ToString();
txtOffReefMetersNewC.Text = r["MetersWaste"].ToString();
txtCubicMeterNEW.Text = r["CubicMeters"].ToString();
memoReson.Text = r["Comments"].ToString();
memoReson.Properties.ReadOnly = true;
theActivity = Convert.ToInt32(r["Activity"]);
loadCurrentValues(r["WorkplaceID"].ToString(), Convert.ToInt32(r["ProdMonth"].ToString()), r["SectionID"].ToString(), r["SectionID_2"].ToString(), true);
}
}
public void LoadDetails(int ChangeRequestID)
{
MWDataManager.clsDataAccess _WPData = new MWDataManager.clsDataAccess();
_WPData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_WPData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_WPData.queryReturnType = MWDataManager.ReturnType.DataTable;
_WPData.SqlStatement = "[sp_prePlanning_data]";
SqlParameter[] _paramCollectionS =
{
_WPData.CreateParameter("@ChangeRequestID", SqlDbType.Int, 0, Convert.ToString(ChangeRequestID))
};
_WPData.ParamCollection = _paramCollectionS;
_WPData.ExecuteInstruction();
foreach (DataRow r in _WPData.ResultsDataTable.Rows)
{
txtSection.Text = r["Name_2"].ToString();
txtProdMonth.Text = r["ProdMonth"].ToString();
txtWorkplace.Text = r["WPDesc"].ToString();
editMiner1.Properties.NullText = r["Name"].ToString();
editDay1.Properties.NullText = "";
editNight1.Properties.NullText = "";
editRoming1.Properties.NullText = "";
editAfternoon1.Properties.NullText = "";
memoReason.Text = r["Comments"].ToString();
theActivity = Convert.ToInt32(r["Activity"]);
loadManageValues(r["WorkplaceID"].ToString(), Convert.ToInt32(r["ProdMonth"].ToString()), r["SectionID"].ToString(), r["SectionID_2"].ToString(), true);
}
}
private void loadingData()
{
cmbType.Items.Add("Stoping");
cmbType.Items.Add("Development");
userList.DataSource = getUserList("", TempID);
userList.ValueMember = "USERID";
userList.DisplayMember = "NAME";
//gridControl1.ForceInitialize();
// Add new template
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "[spUpdate_PlanningTemplate_UserSecurity_Table]";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@Prodmonth", SqlDbType.Int, 7, TProductionGlobal.getSystemSettingsProductioInfo(UserCurrentInfo.Connection).CurrentProductionMonth),
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.longNumber;
_dbMan.ExecuteInstruction();
SqlDataAdapter oleDBAdapter1 = new SqlDataAdapter("SELECT TemplateID, TemplateName FROM PlanProt_Template WHERE TemplateID = " + TempID.ToString(), TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection));
SqlDataAdapter oleDBAdapter2 = new SqlDataAdapter("SELECT * FROM PlanProt_ApproveUsers WHERE SEction = 'NONE' and Shaft <> 'NONE' ORDER BY Shaft ", TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection));
SqlDataAdapter oleDBAdapter3 = new SqlDataAdapter("SELECT * FROM PlanProt_ApproveUsers WHERE SEction <> 'NONE' ORDER BY Section ", TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection));
SqlDataAdapter oleDBAdapter4 = new SqlDataAdapter("SELECT DISTINCT * FROM PlanProt_ApproveUsers WHERE SEction = 'NONE' and Shaft = 'NONE' ORDER BY Shaft,Unit ", TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection));
oleDBAdapter1.Fill(dsTemplateSecurity.theTemplates);
oleDBAdapter2.Fill(dsTemplateSecurity.theShaft);
oleDBAdapter3.Fill(dsTemplateSecurity.theSection);
oleDBAdapter4.Fill(dsTemplateSecurity.theUnits);
if (formAction == currentAction.caAdd)
{
// Load all User Profiles in CPM
MWDataManager.clsDataAccess _dbManLastMonthWP = new MWDataManager.clsDataAccess();
_dbManLastMonthWP.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManLastMonthWP.SqlStatement = "SELECT USERPROFILEID ProfileName,CAST(FullAccess AS BIT) FullAccess,CAST(ReadOnlyAccess AS BIT) ReadOnlyAccess FROM (SELECT USERPROFILEID,0 FullAccess,1 ReadOnlyAccess FROM dbo.USERPROFILES) theProfile";
_dbManLastMonthWP.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManLastMonthWP.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManLastMonthWP.ExecuteInstruction();
using (DataTableReader reader = new DataTableReader(_dbManLastMonthWP.ResultsDataTable))
{
dtProfileInfo.Clear();
dtProfileInfo.Load(reader);
}
gridSecurity.DataSource = dtProfileInfo; // Populate grid
MWDataManager.clsDataAccess _dbManTemplate = new MWDataManager.clsDataAccess();
_dbManTemplate.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManTemplate.SqlStatement = "select MAX(TemplateID) TemplateID from PlanProt_Template";
_dbManTemplate.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManTemplate.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManTemplate.ExecuteInstruction();
using (DataTableReader readerTemplate = new DataTableReader(_dbManTemplate.ResultsDataTable))
{
tableTemplate.Load(readerTemplate);
}
foreach (DataRow Temp in tableTemplate.Rows)
{
if (Temp["TemplateID"].ToString() == "")
{
TempID = 1;
}
else
{
TempID = Convert.ToInt32(Temp["TemplateID"].ToString()) + 1;
}
}
}
else
if (formAction == currentAction.caEdit)
{
MWDataManager.clsDataAccess _dbManTemplateDetail = new MWDataManager.clsDataAccess();
_dbManTemplateDetail.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManTemplateDetail.SqlStatement = "Select * from PLANPROT_TEMPLATE where TemplateID = '" + TempID + "'";
_dbManTemplateDetail.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManTemplateDetail.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManTemplateDetail.ExecuteInstruction();
_dbApproveUsers.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbApproveUsers.SqlStatement = "SELECT TemplateID,Shaft,User1,User2 FROM dbo.PLANPROT_APPROVEUSERS WHERE TemplateID = '" + TempID + "'";
_dbApproveUsers.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbApproveUsers.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbApproveUsers.ExecuteInstruction();
cmbType.Enabled = false;
txtDescription.Enabled = false;
// gcApproveData.DataSource = _dbApproveUsers.ResultsDataTable;
using (DataTableReader readerTempDetail = new DataTableReader(_dbManTemplateDetail.ResultsDataTable))
{
tableTemplate.Load(readerTempDetail);
}
foreach (DataRow dr in tableTemplate.Rows)
{
if (dr["Activity"].ToString() == "0")
{
cmbType.SelectedIndex = 0;
}
else
{
cmbType.SelectedIndex = 1;
}
txtDescription.Text = dr["TemplateName"].ToString();
string edit1;
if (dr["ApprovalRequired"].ToString() == "True")
{
rgReqApproval.SelectedIndex = 0;
}
else
{
rgReqApproval.SelectedIndex = 1;
}
}
DataTable CPMProfiles = new DataTable();
MWDataManager.clsDataAccess _dbManLastMonthWP = new MWDataManager.clsDataAccess();
_dbManLastMonthWP.ConnectionString = TConnections.GetConnectionString("SystemSettings", UserCurrentInfo.Connection);
//_dbManLastMonthWP.SqlStatement = "SELECT USERPROFILEID FROM USERPROFILES ";
_dbManLastMonthWP.SqlStatement = "SELECT DepartmentID,Description FROM tblDepartments ";
_dbManLastMonthWP.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManLastMonthWP.queryReturnType = MWDataManager.ReturnType.DataTable;
var result = _dbManLastMonthWP.ExecuteInstruction();
if (!result.success)
{
MessageItem.viewMessage(MessageType.Error, "SQL ERROR", theSystemDBTag, "frmPlanProtTemplateSetup", "loadingData", result.Message, ButtonTypes.OK, MessageDisplayType.FullScreen);
return;
}
DataTableReader reader = new DataTableReader(_dbManLastMonthWP.ResultsDataTable);
CPMProfiles.Load(reader);
_dbManLastMonthWP.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManLastMonthWP.SqlStatement = "SELECT DepartmentID ,TemplateID ,FullAccess ,ReadOnlyAccess , '' Description , CAST(DATA1 .AccessLevel as bit) AccessLevel FROM ( " +
"select DepartmentID ,TemplateID, cast(data.FullAccess as bit) FullAccess, cast(data.ReadOnlyAccess as bit) ReadOnlyAccess, AccessLevel = CASE WHEN FullAccess = 0 THEN '0' ELSE '1' END from ( " +
"SELECT PPA.DepartmentID ,PPA .TemplateID , " +
"FullAccess= CASE WHEN PPA .AccessLevel=1 then '1' else '0' end, " +
"ReadOnlyAccess= case when PPA.AccessLevel =1 then '0' else '1' end , " +
"PPA.AccessLevel FROM PLANPROT_PROFILEACCESS PPA WHERE TemplateID = '" + TempID.ToString() + "')data)DATA1 ";
result = _dbManLastMonthWP.ExecuteInstruction();
if (!result.success)
{
MessageItem.viewMessage(MessageType.Error, "SQL ERROR", theSystemDBTag, "frmPlanProtTemplateSetup", "loadingData", result.Message, ButtonTypes.OK, MessageDisplayType.FullScreen);
return;
}
DataTableReader reader2 = new DataTableReader(_dbManLastMonthWP.ResultsDataTable);
dtProfileInfo.Load(reader2);
foreach (DataRow dr in CPMProfiles.Rows)
{
string expression;
//expression = "ProfileName = '" + dr["USERPROFILEID"].ToString() + "'";
expression = "DepartmentID = '" + dr["DepartmentID"].ToString() + "'";
DataRow[] foundRows;
foundRows = dtProfileInfo.Select(expression);
var description = dr["Description"].ToString();
if (foundRows.Length == 0)
{
//dtProfileInfo.Rows.Add(dr["USERPROFILEID"].ToString(), 0, TempID);
//dtProfileInfo.Rows.Add(dr["Description"].ToString(), 0, TempID);
dtProfileInfo.Rows.Add(dr["DepartmentID"].ToString(), TempID, false, true, description);
}
else
{
foundRows[0]["Description"] = description;
}
}
dtProfileInfo.Select("");
//dtProfileInfo.Columns.Add("Access1", typeof(bool));
//
//{
// if (dr["ProfileAccess"] == DBNull.Value)
// {
// dr["Access1"] = false;
// }
// else
// {
// dr["Access1"] = dr["ProfileAccess"];
// }
//}
//bandedGridView1.PopulateColumns(dtProfileInfo);
//LoadColumns();
gridSecurity.DataSource = dtProfileInfo; // Populate grid
//bandedGridView1.Columns[1].Visible = false;
}
MWDataManager.clsDataAccess _dbManGrid = new MWDataManager.clsDataAccess();
_dbManGrid.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManGrid.SqlStatement = "select Distinct pf.FieldID [FieldID],pf.FieldName [Field Name],ppf.fieldDescription [Field Type],pf2.FieldName[Parent] from PlanProt_Fields pf " +
"left outer join " +
"PlanProt_FieldTypes ppf " +
"on pf.FieldType = ppf.fieldTypeID " +
"left outer join PLANPROT_DATA pg " +
"on pf.FieldID = pg.FieldID " +
"left outer join " +
"PlanProt_Fields pf2 " +
"on pg.FieldID = pf2.parentID " +
" where pf.TemplateID = '" + TempID + "' Order by pf.FieldID ";
_dbManGrid.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManGrid.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManGrid.ExecuteInstruction();
DataTableReader readerGrid = new DataTableReader(_dbManGrid.ResultsDataTable);
tableGrid.Load(readerGrid);
gridOutput.DataSource = tableGrid; // Populate Grid
// bandedGridView2.Columns[0].Visible = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//int AccessType = 0;
foreach (DataRow dr in dtProfileInfo.Rows)
{
MWDataManager.clsDataAccess _dbManDelete = new MWDataManager.clsDataAccess();
_dbManDelete.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManDelete.SqlStatement = "Delete from PlanProt_ProfileAccess where DepartmentID = '" + dr["DepartmentID"].ToString() + "' and TemplateID = '" + TempID + "'";
_dbManDelete.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManDelete.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManDelete.ExecuteInstruction();
MWDataManager.clsDataAccess _dbManLastMonthWP = new MWDataManager.clsDataAccess();
_dbManLastMonthWP.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
//_dbManLastMonthWP.SqlStatement = "Insert into PlanProt_ProfileAccess (DepartmentID ,FullAccess ,ReadOnlyAccess, TemplateID) values ('" + dr["ProfileName"].ToString() + "' , '" + dr["FullAccess"] + "' , '" + dr["ReadOnlyAccess"] + "', '" + TempID + "')";
if (dr["FullAccess"].ToString() == "True")
{
_dbManLastMonthWP.SqlStatement = "Insert into PlanProt_ProfileAccess (DepartmentID ,TemplateID,AccessLevel) values ('" + dr["DepartmentID"].ToString() + "' , '" + TempID + "' , 'True')";
}
else
{
_dbManLastMonthWP.SqlStatement = "Insert into PlanProt_ProfileAccess (DepartmentID ,TemplateID,AccessLevel) values ('" + dr["DepartmentID"].ToString() + "' , '" + TempID + "' , 'False')";
}
_dbManLastMonthWP.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManLastMonthWP.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManLastMonthWP.ExecuteInstruction();
}
if (formAction == currentAction.caAdd)
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_PlanProt_TemplateSetupSave";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@TemplateID", SqlDbType.Int, 7, TempID),
_dbMan.CreateParameter("@TemplateName", SqlDbType.VarChar, 200, txtDescription.Text),
_dbMan.CreateParameter("@Activity", SqlDbType.Int, 7, cmbType.SelectedIndex),
_dbMan.CreateParameter("@Fieldid", SqlDbType.Int, 50, DBNull.Value),
// _dbMan.CreateParameter("@FieldType", SqlDbType.VarChar ,30 ,DBNull.Value ),
_dbMan.CreateParameter("@SelectedValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@MinValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@MaxValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@RiskRating", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@ParentID", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@FrontBack", SqlDbType.Int, 3, 1),
_dbMan.CreateParameter("@Action", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@FieldUpdate", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@User1", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@User2", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@AprovalReq", SqlDbType.Bit, 0, rgReqApproval.Properties.Items[rgReqApproval.SelectedIndex].Value),
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
MessageBox.Show("Data Saved Successfully", "Data Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_PlanProt_TemplateSetupSave";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@TemplateID", SqlDbType.Int, 7, TempID),
_dbMan.CreateParameter("@TemplateName", SqlDbType.VarChar, 200, txtDescription.Text),
_dbMan.CreateParameter("@Activity", SqlDbType.Int, 7, cmbType.SelectedIndex),
_dbMan.CreateParameter("@Fieldid", SqlDbType.Int, 50, DBNull.Value),
//_dbMan.CreateParameter("@FieldType", SqlDbType.VarChar ,30 ,DBNull.Value ),
_dbMan.CreateParameter("@SelectedValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@MinValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@MaxValue", SqlDbType.VarChar, 4, DBNull.Value),
_dbMan.CreateParameter("@RiskRating", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@ParentID", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@FrontBack", SqlDbType.Int, 3, 1),
_dbMan.CreateParameter("@Action", SqlDbType.Int, 3, 1),
_dbMan.CreateParameter("@FieldUpdate", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@User1", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@User2", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@AprovalReq", SqlDbType.Bit, 0, rgReqApproval.Properties.Items[rgReqApproval.SelectedIndex].Value),
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
MWDataManager.clsDataAccess _UpdateData = new MWDataManager.clsDataAccess();
_UpdateData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_UpdateData.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_UpdateData.queryReturnType = MWDataManager.ReturnType.DataTable;
foreach (DataRow r in dsTemplateSecurity.theUnits.Rows)
{
if (r["IsUpdated"].ToString() == "1")
{
_UpdateData.SqlStatement = "UPDATE PlanProt_ApproveUsers SET User1 = '" + r["User1"].ToString() + "'," +
" User2 = '" + r["User2"].ToString() + "' " +
"WHERE TemplateID = '" + r["TemplateID"].ToString() + "' and " +
" Shaft = '" + r["Shaft"].ToString() + "' and " +
" Unit= '" + r["Unit"].ToString() + "' and" +
" Section = '" + r["Section"].ToString() + "' ";
_UpdateData.ExecuteInstruction();
}
}
foreach (DataRow r in dsTemplateSecurity.theSection.Rows)
{
if (r["IsUpdated"].ToString() == "1")
{
_UpdateData.SqlStatement = "UPDATE PlanProt_ApproveUsers SET User1 = '" + r["User1"].ToString() + "'," +
" User2 = '" + r["User2"].ToString() + "' " +
"WHERE TemplateID = '" + r["TemplateID"].ToString() + "' and " +
" Shaft = '" + r["Shaft"].ToString() + "' and " +
" Section = '" + r["Section"].ToString() + "' ";
_UpdateData.ExecuteInstruction();
}
}
foreach (DataRow r in dsTemplateSecurity.theShaft.Rows)
{
if (r["IsUpdated"].ToString() == "1")
{
_UpdateData.SqlStatement = "UPDATE PlanProt_ApproveUsers SET User1 = '" + r["User1"].ToString() + "'," +
" User2 = '" + r["User2"].ToString() + "' " +
"WHERE TemplateID = '" + r["TemplateID"].ToString() + "' and " +
" Shaft = '" + r["Shaft"].ToString() + "' and " +
" Section = '" + r["Section"].ToString() + "' ";
_UpdateData.ExecuteInstruction();
}
}
TsysNotification.showNotification("Data Saved", "Template data was saved successfully", Color.CornflowerBlue);
CanClose = true;
}
dtProfileInfo.Clear();
dsTemplateSecurity.theTemplates.Clear();
dsTemplateSecurity.theShaft.Clear();
dsTemplateSecurity.theSection.Clear();
dsTemplateSecurity.theUnits.Clear();
loadingData();
// this.Close();
//gridControl1.Refresh();
//gridControl1.RefreshDataSource();
// gridControl1.DataSource = "";
}
catch (SqlException s)
{
MessageItem.viewMessage(MessageType.Error, "ERROR SAVING DATA", theSystemTag, "frmPlanProtTemplateSetup", "btnSave_Click", s.Message, ButtonTypes.OK, MessageDisplayType.FullScreen);
CanClose = false;
}
}
public bool unApproveSelected()
{
MWDataManager.clsDataAccess _UnApproveData = new MWDataManager.clsDataAccess();
_UnApproveData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_UnApproveData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_UnApproveData.queryReturnType = MWDataManager.ReturnType.longNumber;
_UnApproveData.SqlStatement = "sp_PrePlanning_Unapprove";
if (editReason.Text == "")
{
MessageBox.Show("Provide a Reason for this Un-Approve procedure.");
return(false);
}
else
{
foreach (DataRow row in theUnApproveData.Rows)
{
try
{
if (Convert.ToBoolean(row["Selected"].ToString()) == true)
{
// Unapprove all dinamic plan
SqlParameter[] _paramCollection =
{
_UnApproveData.CreateParameter("@Prodmonth", SqlDbType.VarChar, 20, row["Prodmonth"].ToString()),
_UnApproveData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 20, row["Workplaceid"]),
_UnApproveData.CreateParameter("@Activitycode", SqlDbType.Int, 0, row["Activity"]),
_UnApproveData.CreateParameter("@Sectionid", SqlDbType.VarChar, 20, row["Sectionid"]),
_UnApproveData.CreateParameter("@CurrentUser", SqlDbType.VarChar, 20, TUserInfo.UserID),
_UnApproveData.CreateParameter("@Reason", SqlDbType.VarChar, 0, editReason.Text),
};
_UnApproveData.ParamCollection = _paramCollection;
var result = _UnApproveData.ExecuteInstruction();
if (Convert.ToDecimal(row["CubicMetres"].ToString()) > 0)
{
// unapprove cube
SqlParameter[] _paramCollection1 =
{
_UnApproveData.CreateParameter("@Prodmonth", SqlDbType.VarChar, 20, row["Prodmonth"].ToString()),
_UnApproveData.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 20, row["Workplaceid"]),
_UnApproveData.CreateParameter("@Activitycode", SqlDbType.Int, 0, 7),
_UnApproveData.CreateParameter("@Sectionid", SqlDbType.VarChar, 20, row["Sectionid"]),
_UnApproveData.CreateParameter("@CurrentUser", SqlDbType.VarChar, 20, TUserInfo.UserID),
_UnApproveData.CreateParameter("@Reason", SqlDbType.VarChar, 0, editReason.Text),
};
_UnApproveData.ParamCollection = _paramCollection1;
_UnApproveData.ExecuteInstruction();
}
}
}
catch (Exception _exception)
{
throw new ApplicationException(_exception.Message, _exception);
}
}
return(true);
}
}
public void countcheck()
{
string text = "";
string separator = "";
foreach (DataRow r in dsHRPlanning.PrePlanning.Rows)
{
string textCMB = text;
MWDataManager.clsDataAccess _RequiredData = new MWDataManager.clsDataAccess();
_RequiredData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RequiredData.SqlStatement = "spCountMiningMethod";
_RequiredData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
if (Convert.ToInt32(r["TargetIDValid"].ToString()) == 0)
{
SqlParameter[] _paramCollection1 =
{
_RequiredData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["Prodmonth"].ToString())),
_RequiredData.CreateParameter("@Sectionid_2 ", SqlDbType.VarChar, 50, r["Sectionid_2"].ToString()),
//_RequiredData.CreateParameter("@WorkplaceID", SqlDbType.Int, 0,r["WORKPLACEID"]),
//_RequiredData.CreateParameter("@TemplateID", SqlDbType.Int, 0,r["TemplateID"]),
// _RequiredData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0,TUserInfo.UserID),
_RequiredData.CreateParameter("@Activity", SqlDbType.Int, 0, r["Activitycode"]),
// _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["MiningMethodCount"]) > 0)
{
text += separator + r["WorkplaceDesc"];
separator = ",";
// textCMB += text;
string ss = string.Join(",", r["WorkplaceDesc"]);
}
}
}
}
if (text == "")
{
}
else
{
MessageBox.Show("Please provide Mining Methods required for the Workplaces " + text, "", MessageBoxButtons.OK);
}
string text1 = "";
string separator1 = "";
foreach (DataRow r in dsHRPlanning.PrePlanning.Rows)
{
string textCMB = text1;
MWDataManager.clsDataAccess _RequiredData = new MWDataManager.clsDataAccess();
_RequiredData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RequiredData.SqlStatement = "spCountNightCrew";
_RequiredData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
if (Convert.ToInt32(r["NightCrewValid"].ToString()) == 0)
{
SqlParameter[] _paramCollection1 =
{
_RequiredData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["Prodmonth"].ToString())),
_RequiredData.CreateParameter("@Sectionid_2 ", SqlDbType.VarChar, 50, r["Sectionid_2"].ToString()),
//_RequiredData.CreateParameter("@WorkplaceID", SqlDbType.Int, 0,r["WORKPLACEID"]),
//_RequiredData.CreateParameter("@TemplateID", SqlDbType.Int, 0,r["TemplateID"]),
// _RequiredData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0,TUserInfo.UserID),
_RequiredData.CreateParameter("@Activity", SqlDbType.Int, 0, r["Activitycode"]),
// _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["NightCrewCount"]) > 0)
{
text1 += separator1 + r["WorkplaceDesc"];
separator1 = ",";
// textCMB += text;
string ss = string.Join(",", r["WorkplaceDesc"]);
}
}
}
}
if (text1 == "")
{
}
else
{
MessageBox.Show("Please provide Night Crews required for the Workplaces " + text1, "", MessageBoxButtons.OK);
}
string text2 = "";
string separator2 = "";
foreach (DataRow r in dsHRPlanning.PrePlanning.Rows)
{
string textCMB = text1;
MWDataManager.clsDataAccess _RequiredData = new MWDataManager.clsDataAccess();
_RequiredData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RequiredData.SqlStatement = "spCountPanelLengthValid";
_RequiredData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
if (Convert.ToInt32(r["PanelLengthValid"].ToString()) == 0)
{
SqlParameter[] _paramCollection1 =
{
_RequiredData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["Prodmonth"].ToString())),
_RequiredData.CreateParameter("@Sectionid_2 ", SqlDbType.VarChar, 50, r["Sectionid_2"].ToString()),
//_RequiredData.CreateParameter("@WorkplaceID", SqlDbType.Int, 0,r["WORKPLACEID"]),
//_RequiredData.CreateParameter("@TemplateID", SqlDbType.Int, 0,r["TemplateID"]),
// _RequiredData.CreateParameter("@ApprovedBy", SqlDbType.VarChar, 0,TUserInfo.UserID),
_RequiredData.CreateParameter("@Activity", SqlDbType.Int, 0, r["Activitycode"]),
// _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["PanelLengthCount"]) > 0)
{
text2 += separator2 + r["WorkplaceDesc"];
separator2 = ",";
// textCMB += text;
string ss = string.Join(",", r["WorkplaceDesc"]);
}
}
}
}
if (text2 == "")
{
}
else
{
MessageBox.Show("Please provide Panel Length required for the Workplaces " + text2, "", MessageBoxButtons.OK);
}
string text3 = "";
string separator3 = "";
foreach (DataRow r in dsHRPlanning.PrePlanning.Rows)
{
string textCMB = text1;
MWDataManager.clsDataAccess _RequiredData = new MWDataManager.clsDataAccess();
_RequiredData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RequiredData.SqlStatement = "spCountStopeWidthValid";
_RequiredData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
if (Convert.ToInt32(r["StopeWidthValid"].ToString()) == 0)
{
SqlParameter[] _paramCollection1 =
{
_RequiredData.CreateParameter("@Prodmonth", SqlDbType.Int, 7, Convert.ToInt32(r["Prodmonth"].ToString())),
_RequiredData.CreateParameter("@Sectionid_2 ", SqlDbType.VarChar, 50, r["Sectionid_2"].ToString()),
_RequiredData.CreateParameter("@Activity", SqlDbType.Int, 0, r["Activitycode"]),
};
_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["StopeWidthCount"]) > 0)
{
text3 += separator3 + r["WorkplaceDesc"];
separator3 = ",";
// textCMB += text;
string ss = string.Join(",", r["WorkplaceDesc"]);
}
}
}
}
if (text3 == "")
{
}
else
{
MessageBox.Show("Please provide Stope Width required for the Workplaces " + text3, "", MessageBoxButtons.OK);
}
}
public void createReport(Object theReportSettings)
{
MWDataManager.clsDataAccess _sect = new MWDataManager.clsDataAccess();
_sect.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_sect.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_sect.queryReturnType = MWDataManager.ReturnType.DataTable;
_sect.ResultsTableName = "sect";
_sect.SqlStatement = "select top 1 name from section where sectionid='" + reportSettings.sectionid + "'";
_sect.ExecuteInstruction();
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_StatusDetails";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_dbMan.ExecuteInstruction();
MWDataManager.clsDataAccess _RevisedStatus = new MWDataManager.clsDataAccess();
_RevisedStatus.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RevisedStatus.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_RevisedStatus.queryReturnType = MWDataManager.ReturnType.DataTable;
_RevisedStatus.ResultsTableName = "RevisedStatus";
_RevisedStatus.SqlStatement = "sp_RevisedPlanningAudit";
try
{
SqlParameter[] _paramCollection2 =
{
_RevisedStatus.CreateParameter("@Prodmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.FromProdmonth)),
_RevisedStatus.CreateParameter("@ToProdmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.ToProdmonth)),
_RevisedStatus.CreateParameter("@Section", SqlDbType.VarChar, 30, reportSettings.sectionid),
_RevisedStatus.CreateParameter("@RevisedType", SqlDbType.VarChar, 50, reportSettings.RevisedPlanningType),
};
_RevisedStatus.ParamCollection = _paramCollection2;
_RevisedStatus.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException(_exception.Message, _exception);
}
DataTable changetype = new DataTable();
changetype = _RevisedStatus.ResultsDataTable.DefaultView.ToTable(true, "ChangeType");
changetype.TableName = "ChangeType";
MWDataManager.clsDataAccess _RevisedStatusDetails = new MWDataManager.clsDataAccess();
_RevisedStatusDetails.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RevisedStatusDetails.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_RevisedStatusDetails.queryReturnType = MWDataManager.ReturnType.DataTable;
_RevisedStatusDetails.ResultsTableName = "RevisedStatusDetails";
_RevisedStatusDetails.SqlStatement = "sp_RevisedPlanningAudit_StatusDetail";
try
{
SqlParameter[] _paramCollection8 =
{
_RevisedStatus.CreateParameter("@Prodmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.FromProdmonth)),
_RevisedStatus.CreateParameter("@ToProdmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.ToProdmonth)),
};
_RevisedStatusDetails.ParamCollection = _paramCollection8;
_RevisedStatusDetails.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException(_exception.Message, _exception);
}
MWDataManager.clsDataAccess _RevisedSummarybet = new MWDataManager.clsDataAccess();
_RevisedSummarybet.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RevisedSummarybet.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_RevisedSummarybet.queryReturnType = MWDataManager.ReturnType.DataTable;
_RevisedSummarybet.ResultsTableName = "RevisedSummarybet";
_RevisedSummarybet.SqlStatement = "sp_Revised_Audit_Summary";
try
{
SqlParameter[] _paramCollection4 =
{
_RevisedStatus.CreateParameter("@Prodmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.FromProdmonth)),
_RevisedStatus.CreateParameter("@ToProdmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.ToProdmonth)),
_RevisedSummarybet.CreateParameter("@Section", SqlDbType.VarChar, 30, reportSettings.sectionid),
_RevisedSummarybet.CreateParameter("@between", SqlDbType.VarChar, 50, "0"),
};
_RevisedSummarybet.ParamCollection = _paramCollection4;
_RevisedSummarybet.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException(_exception.Message, _exception);
}
MWDataManager.clsDataAccess _RevisedSummarynotbet = new MWDataManager.clsDataAccess();
_RevisedSummarynotbet.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_RevisedSummarynotbet.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_RevisedSummarynotbet.queryReturnType = MWDataManager.ReturnType.DataTable;
_RevisedSummarynotbet.ResultsTableName = "RevisedSummarynotbet";
_RevisedSummarynotbet.SqlStatement = "sp_Revised_Audit_Summary";
try
{
SqlParameter[] _paramCollection3 =
{
_RevisedStatus.CreateParameter("@Prodmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.FromProdmonth)),
_RevisedStatus.CreateParameter("@ToProdmonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsInt(reportSettings.ToProdmonth)),
_RevisedSummarynotbet.CreateParameter("@Section", SqlDbType.VarChar, 30, reportSettings.sectionid),
_RevisedSummarynotbet.CreateParameter("@between", SqlDbType.VarChar, 50, "1"),
};
_RevisedSummarynotbet.ParamCollection = _paramCollection3;
_RevisedSummarynotbet.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException(_exception.Message, _exception);
}
DataSet RevisedAudit = new DataSet();
RevisedAudit.Tables.Add(_sect.ResultsDataTable);
RevisedAudit.Tables.Add(_RevisedStatus.ResultsDataTable);
RevisedAudit.Tables.Add(_RevisedStatusDetails.ResultsDataTable);
RevisedAudit.Tables.Add(_RevisedSummarybet.ResultsDataTable);
RevisedAudit.Tables.Add(_RevisedSummarynotbet.ResultsDataTable);
RevisedAudit.Tables.Add(changetype);
theReport.RegisterData(RevisedAudit);
theReport.Load(TGlobalItems.ReportsFolder + "\\Revised_Audit_Report.frx");
theReport.SetParameterValue("logo", TGlobalItems.ClientLogo);
theReport.SetParameterValue("logoMineware", TGlobalItems.CompanyLogo);
theReport.SetParameterValue("type", reportSettings.RevisedPlanningType);
//theReport.Design();
if (TParameters.DesignReport)
{
theReport.Design();
}
theReport.Prepare();
ActiveReport.SetReport = theReport;
ActiveReport.isDone = true;
}
public void sendRequest(string theSystemDBTag, string userConnection)
{
MWDataManager.clsDataAccess _sendRequest = new MWDataManager.clsDataAccess();
_sendRequest.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, userConnection);
_sendRequest.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_sendRequest.queryReturnType = MWDataManager.ReturnType.DataTable;
_sendRequest.SqlStatement = "sp_RevisedPLanning_Request";
SqlParameter[] _paramCollectionS =
{
_sendRequest.CreateParameter("@requestType", SqlDbType.Int, 0, _requestType),
_sendRequest.CreateParameter("@ProdMonth", SqlDbType.Int, 0, _ProdMonth),
_sendRequest.CreateParameter("@WorkplaceID", SqlDbType.VarChar, 50, _WorkplaceID),
_sendRequest.CreateParameter("@SectionID", SqlDbType.VarChar, 20, _SectionID),
_sendRequest.CreateParameter("@SectionID_2", SqlDbType.VarChar, 20, _SectionID_2),
_sendRequest.CreateParameter("@DayCrew", SqlDbType.VarChar, 50, _DayCrew),
_sendRequest.CreateParameter("@NightCrew", SqlDbType.VarChar, 50, _NightCrew),
_sendRequest.CreateParameter("@AfternoonCrew", SqlDbType.VarChar, 50, _AfternoonCrew),
_sendRequest.CreateParameter("@RovingCrew", SqlDbType.VarChar, 50, _RovingCrew),
_sendRequest.CreateParameter("@StartDate", SqlDbType.VarChar, 20, String.Format("{0:yyy/MM/dd}",_StartDate)),
_sendRequest.CreateParameter("@StopDate", SqlDbType.VarChar, 20, String.Format("{0:yyy/MM/dd}",_StopDate)),
_sendRequest.CreateParameter("@UserComments", SqlDbType.VarChar, 600, _UserComments),
_sendRequest.CreateParameter("@RequestBy", SqlDbType.VarChar, 20, TUserInfo.UserID),
_sendRequest.CreateParameter("@SQMOn", SqlDbType.Float, 0, _SQMOn),
_sendRequest.CreateParameter("@SQMOff", SqlDbType.Float, 0, _SQMOff),
_sendRequest.CreateParameter("@Cube", SqlDbType.Float, 0, _Cube),
_sendRequest.CreateParameter("@MeterOn", SqlDbType.Float, 0, _MeterOn),
_sendRequest.CreateParameter("@MeterOff", SqlDbType.Float, 0, _MeterOff),
_sendRequest.CreateParameter("@MiningMethod", SqlDbType.VarChar, 20, _MiningMethod),
_sendRequest.CreateParameter("@OldWorkplaceID", SqlDbType.VarChar, 50, _OldWorkplaceID),
_sendRequest.CreateParameter("@activity", SqlDbType.Int, 0, _activity),
_sendRequest.CreateParameter("@Facelength", SqlDbType.Int, 0, _Facelength),
_sendRequest.CreateParameter("@DrillRig", SqlDbType.VarChar, 150, _DrillRig),
_sendRequest.CreateParameter("@DeleteBookings", SqlDbType.Bit, 150, _DeleteBookings)
};
StringBuilder tempstring = new StringBuilder();
foreach (SqlParameter a in _paramCollectionS)
{
//x += 1;
tempstring.AppendLine(a.ParameterName.ToString() + " = " + a.SqlValue.ToString() + ",");
}
_sendRequest.ParamCollection = _paramCollectionS;
clsDataResult DataResults = _sendRequest.ExecuteInstruction();
if (DataResults.success == false)
{
MessageBox.Show(DataResults.Message, "Error sending request!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadReportData()
{
if (reportSettings.useShiftsDefault == false)
{
_DefaultShift = "N";
}
string _topPanels = "";
if (reportSettings.TopPanels == "Gold")
{
_topPanels = "G";
}
if (reportSettings.TopPanels == "Cmgt")
{
_topPanels = "C";
}
if (reportSettings.TopPanels == "Top Panels")
{
_topPanels = "T";
}
ucGradeReport _ucEfficiency = new ucGradeReport {
theConnection = ActiveReport.UserCurrentInfo.Connection
};
try
{
if (reportSettings.Activity.ToString() == "0")
{
_DailyGradeReportData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_DailyGradeReportData.SqlStatement = "SP_DailyGradeReport";
_DailyGradeReportData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_DailyGradeReportData.ResultsTableName = "DailyGradeReportData";
SqlParameter[] _paramCollection1 =
{
_DailyGradeReportData.CreateParameter("@TheDate", SqlDbType.DateTime, 50, reportSettings.ReportDate.ToString("yyyy-MM-dd")),
_DailyGradeReportData.CreateParameter("@ShiftsNo", SqlDbType.Int, 10, reportSettings.ShiftsNo),
_DailyGradeReportData.CreateParameter("@DefaultShift", SqlDbType.VarChar, 1, _DefaultShift),
_DailyGradeReportData.CreateParameter("@PayLimit", SqlDbType.Int, 10, reportSettings.Paylimit),
_DailyGradeReportData.CreateParameter("@CutOffGrade", SqlDbType.Int, 10, reportSettings.CutOffGrade),
_DailyGradeReportData.CreateParameter("@TopPanels", SqlDbType.VarChar, 1, _topPanels),
};
_DailyGradeReportData.ParamCollection = _paramCollection1;
_DailyGradeReportData.queryReturnType = MWDataManager.ReturnType.DataTable;
_DailyGradeReportData.ExecuteInstruction();
}
else
{
_DailyGradeReportData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_DailyGradeReportData.SqlStatement = "sp_DailyGradeReport_Development";
_DailyGradeReportData.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_DailyGradeReportData.ResultsTableName = "DailyGradeReportData";
SqlParameter[] _paramCollection1 =
{
_DailyGradeReportData.CreateParameter("@TheDate", SqlDbType.DateTime, 50, reportSettings.ReportDate.ToString("yyyy-MM-dd")),
_DailyGradeReportData.CreateParameter("@ShiftsNo", SqlDbType.Int, 10, reportSettings.ShiftsNo),
_DailyGradeReportData.CreateParameter("@DefaultShift", SqlDbType.VarChar, 1, _DefaultShift),
_DailyGradeReportData.CreateParameter("@PayLimit", SqlDbType.Int, 10, reportSettings.Paylimit),
_DailyGradeReportData.CreateParameter("@CutOffGrade", SqlDbType.Int, 10, reportSettings.CutOffGrade),
};
_DailyGradeReportData.ParamCollection = _paramCollection1;
_DailyGradeReportData.queryReturnType = MWDataManager.ReturnType.DataTable;
_DailyGradeReportData.ExecuteInstruction();
}
}
catch (Exception _exception)
{
throw new ApplicationException("Report Section:Grade Report:" + _exception.Message, _exception);
}
if (_DailyGradeReportData.ResultsDataTable.Rows.Count == 0)
{
_sysMessagesClass.viewMessage(MessageType.Info, "Grade Report", "No data found for your selection", ButtonTypes.OK, MessageDisplayType.Small);
ErrFound = true;
}
}
private void createReport(Object theReportSettings)
{
Report theReport = new Report();
ProblemAnalysisReportProperties currentReportSettings = theReportSettings as ProblemAnalysisReportProperties;
ucProblemAnalysisReport _ProblemAnalysisReport = new ucProblemAnalysisReport {
theConnection = ActiveReport.UserCurrentInfo.Connection
};
//DevExpress.XtraEditors.CheckedComboBoxEdit editor = (sender as DevExpress.XtraEditors.CheckedComboBoxEdit);
//editor.CheckAll();
TheAvailableText = reportSettings.Available;
result = TheAvailableText.Split(',').ToList();
MWDataManager.clsDataAccess _ProblemAnalysis = new MWDataManager.clsDataAccess();
_ProblemAnalysis.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_ProblemAnalysis.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_ProblemAnalysis.SqlStatement = "DELETE FROM Temp_Problem_Analysis";
_ProblemAnalysis.queryReturnType = MWDataManager.ReturnType.longNumber;
_ProblemAnalysis.ExecuteInstruction();
foreach (string ProblemCode in result)
{
_ProblemAnalysis.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_ProblemAnalysis.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_ProblemAnalysis.SqlStatement = "Insert into Temp_Problem_Analysis Values ('" + UserCurrentInfo.UserID + "', '" + ProblemCode.Trim() + "')";
_ProblemAnalysis.queryReturnType = MWDataManager.ReturnType.longNumber;
_ProblemAnalysis.ExecuteInstruction();
}
//DataSet repUserActivitySet = new DataSet();
//MWDataManager.clsDataAccess _ProblemAnalysis = new MWDataManager.clsDataAccess();
if (reportSettings.Activity == "Stoping")
{
try
{
_ProblemAnalysis.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_ProblemAnalysis.SqlStatement = "SP_Problem_Analysis_Report_Stp";
_ProblemAnalysis.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_ProblemAnalysis.ResultsTableName = "Problem Analysis Data Stp";
SqlParameter[] _paramCollection =
{
_ProblemAnalysis.CreateParameter("@Period", SqlDbType.VarChar, 10, reportSettings.Period),
_ProblemAnalysis.CreateParameter("@FromMonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsString(reportSettings.FromProdmonth)),
_ProblemAnalysis.CreateParameter("@ToMonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsString(reportSettings.ToProdmonth)),
_ProblemAnalysis.CreateParameter("@Section", SqlDbType.VarChar, 60, reportSettings.NAME),
_ProblemAnalysis.CreateParameter("@UserID", SqlDbType.VarChar, 50, UserCurrentInfo.UserID),
_ProblemAnalysis.CreateParameter("@FromDate", SqlDbType.Date, 50, reportSettings.FromDate),
_ProblemAnalysis.CreateParameter("@ToDate", SqlDbType.Date, 50, reportSettings.ToDate),
};
_ProblemAnalysis.ParamCollection = _paramCollection;
_ProblemAnalysis.queryReturnType = MWDataManager.ReturnType.DataTable;
_ProblemAnalysis.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException("Report Section:_ProblemAnalysis:" + _exception.Message, _exception);
}
DataSet repDataSet = new DataSet();
repDataSet.Tables.Add(_ProblemAnalysis.ResultsDataTable);
theReport.RegisterData(repDataSet);
theReport.Load(TGlobalItems.ReportsFolder + "\\ProblemAnalysisReport_Stp.frx");
theReport.SetParameterValue("Banner", SysSettings.Banner);
theReport.SetParameterValue("Prodmonth", TProductionGlobal.ProdMonthAsString(reportSettings.FromProdmonth) + " - " + TProductionGlobal.ProdMonthAsString(reportSettings.ToProdmonth));
theReport.SetParameterValue("Sections", reportSettings.NAME);
theReport.SetParameterValue("logo", TGlobalItems.ClientLogo);
theReport.SetParameterValue("logoMineware", TGlobalItems.CompanyLogo);
}
else if (reportSettings.Activity == "Development")
{
try
{
_ProblemAnalysis.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_ProblemAnalysis.SqlStatement = "SP_Problem_Analysis_Report_Dev";
_ProblemAnalysis.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
_ProblemAnalysis.ResultsTableName = "Problem Analysis Data Dev";
SqlParameter[] _paramCollection =
{
_ProblemAnalysis.CreateParameter("@Period", SqlDbType.VarChar, 10, reportSettings.Period),
_ProblemAnalysis.CreateParameter("@FromMonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsString(reportSettings.FromProdmonth)),
_ProblemAnalysis.CreateParameter("@ToMonth", SqlDbType.Int, 0, TProductionGlobal.ProdMonthAsString(reportSettings.ToProdmonth)),
_ProblemAnalysis.CreateParameter("@Section", SqlDbType.VarChar, 60, reportSettings.NAME),
_ProblemAnalysis.CreateParameter("@UserID", SqlDbType.VarChar, 50, UserCurrentInfo.UserID),
_ProblemAnalysis.CreateParameter("@FromDate", SqlDbType.Date, 50, reportSettings.FromDate),
_ProblemAnalysis.CreateParameter("@ToDate", SqlDbType.Date, 50, reportSettings.ToDate),
};
_ProblemAnalysis.ParamCollection = _paramCollection;
_ProblemAnalysis.queryReturnType = MWDataManager.ReturnType.DataTable;
_ProblemAnalysis.ExecuteInstruction();
}
catch (Exception _exception)
{
throw new ApplicationException("Report Section:_ProblemAnalysis:" + _exception.Message, _exception);
}
DataSet repDataSet = new DataSet();
repDataSet.Tables.Add(_ProblemAnalysis.ResultsDataTable);
theReport.RegisterData(repDataSet);
theReport.Load(TGlobalItems.ReportsFolder + "\\ProblemAnalysisReport_Dev.frx");
theReport.SetParameterValue("Banner", SysSettings.Banner);
theReport.SetParameterValue("Prodmonth", TProductionGlobal.ProdMonthAsString(reportSettings.FromProdmonth) + " - " + TProductionGlobal.ProdMonthAsString(reportSettings.ToProdmonth));
theReport.SetParameterValue("Sections", reportSettings.NAME);
}
if (TParameters.DesignReport)
{
theReport.Design();
ActiveReport.SetReport = theReport;
ActiveReport.isDone = true;
}
else
{
theReport.Prepare();
ActiveReport.SetReport = theReport;
ActiveReport.isDone = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (cmbParent.ItemIndex == -1)
{
ParentID = 0;
}
else
{
ParentID = Convert.ToInt32(cmbParent.EditValue.ToString());
}
if (table.Rows.Count == 0 && formAction1 == currentAction.caAdd)
{
MWDataManager.clsDataAccess _dbManInsert = new MWDataManager.clsDataAccess();
_dbManInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManInsert.SqlStatement = "Select MAX(FIELDID) FIELDID from PlanProt_Fields";
_dbManInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManInsert.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManInsert.ExecuteInstruction();
Int32 TheFieldID = Convert.ToInt32(_dbManInsert.ResultsDataTable.Rows[0]["FIELDID"].ToString()) + 1;
_dbManInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManInsert.SqlStatement = "Insert into PlanProt_Fields(FieldID, TemplateID,FieldName,FieldType,NoCharacters,NoLines) values('" + TheFieldID + "','" + TempId + "','" + txtFieldName.Text + "','" + cmbFieldType.EditValue.ToString() + "','" + lcCharacters.Text + "','" + lcLines.Text + "')";
_dbManInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManInsert.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManInsert.ExecuteInstruction();
MWDataManager.clsDataAccess _dbManFieldName = new MWDataManager.clsDataAccess();
_dbManFieldName.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManFieldName.SqlStatement = "select FieldId = FieldID from PlanProt_Fields " +
"where FieldName = '" + txtFieldName.Text + "'";
_dbManFieldName.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManFieldName.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManFieldName.ExecuteInstruction();
DataTableReader readerName = new DataTableReader(_dbManFieldName.ResultsDataTable);
dtFieldID.Load(readerName);
foreach (DataRow dt in dtFieldID.Rows)
{
FieldValuesFieldID = Convert.ToInt32(dt["FieldId"].ToString());
}
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_PlanProt_TemplateSetupSave";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@TemplateID", SqlDbType.Int, 7, TempId),
_dbMan.CreateParameter("@TemplateName", SqlDbType.VarChar, 7, DBNull.Value),
_dbMan.CreateParameter("@Activity", SqlDbType.Int, 7, DBNull.Value),
_dbMan.CreateParameter("@FieldID", SqlDbType.Int, 50, FieldValuesFieldID),
// _dbMan.CreateParameter("@FieldType", SqlDbType.VarChar ,30 ,cmbFieldType.SelectedValue.ToString() ),
_dbMan.CreateParameter("@SelectedValue", SqlDbType.VarChar, 50, DBNull.Value),
_dbMan.CreateParameter("@MinValue", SqlDbType.VarChar, 30, DBNull.Value),
_dbMan.CreateParameter("@MaxValue", SqlDbType.VarChar, 30, DBNull.Value),
_dbMan.CreateParameter("@RiskRating", SqlDbType.Int, 3, DBNull.Value),
_dbMan.CreateParameter("@ParentID", SqlDbType.Int, 3, ParentID),
_dbMan.CreateParameter("@FrontBack", SqlDbType.Int, 3, 2),
_dbMan.CreateParameter("@Action", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@FieldUpdate", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@User1", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@User2", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@AprovalReq", SqlDbType.Int, 0, 0)
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
MessageBox.Show("Data Saved Successfull", "Data Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (formAction1 == currentAction.caAdd)
{
Boolean Deleted = false;
if (ceDeleted.Checked == true)
{
Deleted = true;
}
MWDataManager.clsDataAccess _dbManInsert = new MWDataManager.clsDataAccess();
_dbManInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManInsert.SqlStatement = "Insert into PlanProt_Fields(TemplateID,FieldName,FieldType, Deleted) values('" + TempId + "','" + txtFieldName.Text + "','" + cmbFieldType.EditValue.ToString() + "','" + Deleted + "')";
_dbManInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManInsert.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManInsert.ExecuteInstruction();
MWDataManager.clsDataAccess _dbManFieldName = new MWDataManager.clsDataAccess();
_dbManFieldName.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManFieldName.SqlStatement = "select FieldId = FieldID from PlanProt_Fields " +
"where FieldName = '" + txtFieldName.Text + "'";
_dbManFieldName.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManFieldName.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManFieldName.ExecuteInstruction();
DataTableReader readerName = new DataTableReader(_dbManFieldName.ResultsDataTable);
dtFieldID.Load(readerName);
foreach (DataRow dt in dtFieldID.Rows)
{
FieldValuesFieldID = Convert.ToInt16(dt["FieldId"].ToString());
}
foreach (DataRow dr in table.Rows)
{
if (cmbFieldType.Text == "Selection")
{
Max = dr[1].ToString();
Max = "0";
}
else
{
Max = dr[1].ToString();
}
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_PlanProt_TemplateSetupSave";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@TemplateID", SqlDbType.Int, 7, TempId),
_dbMan.CreateParameter("@TemplateName", SqlDbType.VarChar, 7, " "),
_dbMan.CreateParameter("@Activity", SqlDbType.Int, 7, 0),
_dbMan.CreateParameter("@FieldID", SqlDbType.Int, 50, FieldValuesFieldID),
// _dbMan.CreateParameter("@FieldType", SqlDbType.VarChar ,30 ,cmbFieldType.SelectedValue.ToString() ),
_dbMan.CreateParameter("@SelectedValue", SqlDbType.VarChar, 50, cmbFieldType.EditValue.ToString()),
_dbMan.CreateParameter("@MinValue", SqlDbType.VarChar, 30, dr[0].ToString()),
_dbMan.CreateParameter("@MaxValue", SqlDbType.VarChar, 30, Max),
_dbMan.CreateParameter("@RiskRating", SqlDbType.Int, 3, dr["Risk Rating"].ToString()),
_dbMan.CreateParameter("@ParentID", SqlDbType.Int, 3, ParentID),
_dbMan.CreateParameter("@FrontBack", SqlDbType.Int, 3, 2),
_dbMan.CreateParameter("@Action", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@FieldUpdate", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@User1", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@User2", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@AprovalReq", SqlDbType.Int, 0, 0)
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
clsDataResult result = _dbMan.ExecuteInstruction();
}
MessageBox.Show("Data Saved Successfull", "Data Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else // Forms CurrentAction = Edit
{
if (checkEdit1.Checked == true)
{
bool abc = true;
MWDataManager.clsDataAccess _dbManInsert = new MWDataManager.clsDataAccess();
_dbManInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManInsert.SqlStatement = "Update PlanProt_Fields Set TemplateID = '" + TempId + "' ,FieldName = '" + txtFieldName.Text + "' ,FieldType = '" + cmbFieldType.EditValue.ToString() + "',NoCharacters='" + txtCharacters.Text + "',NoLines='" + txtLines.Text + "',FieldRequired='" + abc + "', Deleted = '" + ceDeleted.Checked + "' where FieldID = '" + FieldID + "' ";
_dbManInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManInsert.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManInsert.ExecuteInstruction();
}
else
{
bool abc1 = false;
MWDataManager.clsDataAccess _dbManInsert = new MWDataManager.clsDataAccess();
_dbManInsert.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManInsert.SqlStatement = "Update PlanProt_Fields Set TemplateID = '" + TempId + "' ,FieldName = '" + txtFieldName.Text + "' ,FieldType = '" + cmbFieldType.EditValue.ToString() + "',NoCharacters='" + txtCharacters.Text + "',NoLines='" + txtLines.Text + "',FieldRequired='" + abc1 + "', Deleted = '" + ceDeleted.Checked + "' where FieldID = '" + FieldID + "' ";
_dbManInsert.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManInsert.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManInsert.ExecuteInstruction();
}
MWDataManager.clsDataAccess _dbManFieldName = new MWDataManager.clsDataAccess();
_dbManFieldName.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManFieldName.SqlStatement = "select FieldId = FieldID from PlanProt_Fields " +
"where FieldName = '" + txtFieldName.Text + "' and TemplateID = '" + TempId + "'";
_dbManFieldName.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManFieldName.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManFieldName.ExecuteInstruction();
DataTableReader readerName = new DataTableReader(_dbManFieldName.ResultsDataTable);
dtFieldID.Load(readerName);
MWDataManager.clsDataAccess _dbManDelete = new MWDataManager.clsDataAccess();
_dbManDelete.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);//ConfigurationSettings.AppSettings["SQLConnectionStr"];
_dbManDelete.SqlStatement = "delete from PlanProt_FieldValue where FieldID = '" + FieldID + "'";
_dbManDelete.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManDelete.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManDelete.ExecuteInstruction();
foreach (DataRow dt in dtFieldID.Rows)
{
FieldValuesFieldID = Convert.ToInt32(dt["FieldId"].ToString());
}
foreach (DataRow dr in table.Rows)
{
if (cmbFieldType.Text == "Selection")
{
//Max = dr[1].ToString();
Max = "0";
}
else
{
Max = dr[1].ToString();
}
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.SqlStatement = "sp_PlanProt_TemplateSetupSave";
_dbMan.queryExecutionType = MWDataManager.ExecutionType.StoreProcedure;
SqlParameter[] _paramCollection =
{
_dbMan.CreateParameter("@TemplateID", SqlDbType.Int, 7, TempId),
_dbMan.CreateParameter("@TemplateName", SqlDbType.VarChar, 7, " "),
_dbMan.CreateParameter("@Activity", SqlDbType.Int, 7, 0),
_dbMan.CreateParameter("@FieldID", SqlDbType.Int, 50, FieldValuesFieldID),
//_dbMan.CreateParameter("@FieldType", SqlDbType.VarChar ,30 ,cmbFieldType.EditValue.ToString() ),
_dbMan.CreateParameter("@SelectedValue", SqlDbType.VarChar, 2, cmbFieldType.EditValue.ToString()),
_dbMan.CreateParameter("@MinValue", SqlDbType.VarChar, 50, dr[0].ToString()),
_dbMan.CreateParameter("@MaxValue", SqlDbType.VarChar, 4, Max),
_dbMan.CreateParameter("@RiskRating", SqlDbType.Int, 3, dr["Risk Rating"].ToString()),
_dbMan.CreateParameter("@ParentID", SqlDbType.Int, 3, ParentID),
_dbMan.CreateParameter("@FrontBack", SqlDbType.Int, 3, 2),
_dbMan.CreateParameter("@Action", SqlDbType.Int, 3, 0),
_dbMan.CreateParameter("@FieldUpdate", SqlDbType.Int, 3, 1),
_dbMan.CreateParameter("@User1", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@User2", SqlDbType.VarChar, 50, ""),
_dbMan.CreateParameter("@AprovalReq", SqlDbType.Int, 0, 0)
};
_dbMan.ParamCollection = _paramCollection;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
clsDataResult result = _dbMan.ExecuteInstruction();
}
MessageBox.Show("Data Edited Successfull", "Data Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
this.Close();
}
catch (SqlException x)
{
MessageBox.Show("Data could not be saved" + x.Message.ToString(), "Save Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}