public static async void NewOrgObjView(string org, string obj, string fy, ExtendedForm parentForm)
{
try
{
parentForm.Waiting();
GridForm newGridForm = new GridForm(parentForm, "Org/Obj Info");
string glColumns = " glma_org, glma_obj, glma_desc, glma_seg5, glma_bud_yr, glma_orig_bud_cy, glma_rev_bud_cy, glma_encumb_cy, glma_memo_bal_cy, glma_rev_bud_cy-glma_encumb_cy-glma_memo_bal_cy AS 'Funds Available' ";
string glMasterQry = "Select TOP " + intMaxResults + " " + glColumns + "FROM glmaster";
QueryParamCollection glParams = new QueryParamCollection();
glParams.Add("glma_org", org, true);
if (!string.IsNullOrEmpty(obj)) //Show Rollup info for Object
{
glParams.Add("glma_obj", obj, true);
string rollUpCode = await munisComms.ReturnSqlValueAsync("gl_budget_rollup", "a_org", org, "a_rollup_code");
string rollUpByCodeQry = "SELECT TOP " + intMaxResults + " * FROM gl_budget_rollup WHERE a_rollup_code = '" + rollUpCode + "'";
string budgetQry = "SELECT TOP " + intMaxResults + " a_projection_no,a_org,a_object,db_line,db_bud_desc_line1,db_bud_reason_desc,db_bud_req_qty5,db_bud_unit_cost,db_bud_req_amt5,a_account_id FROM gl_budget_detail_2"; // WHERE a_projection_no='" & FY & "' AND a_org='" & Org & "' AND a_object='" & Obj & "'"
QueryParamCollection budgetParams = new QueryParamCollection();
budgetParams.Add("a_projection_no", fy, true);
budgetParams.Add("a_org", org, true);
budgetParams.Add("a_object", obj, true);
newGridForm.AddGrid("OrgGrid", "GL Info:", await munisComms.ReturnSqlTableFromCmdAsync(munisComms.GetSqlCommandFromParams(glMasterQry, glParams.Parameters)));
newGridForm.AddGrid("RollupGrid", "Rollup Info:", await munisComms.ReturnSqlTableAsync(rollUpByCodeQry));
newGridForm.AddGrid("BudgetGrid", "Budget Info:", await munisComms.ReturnSqlTableFromCmdAsync(munisComms.GetSqlCommandFromParams(budgetQry, budgetParams.Parameters)));
}
else // Show Rollup info for all Objects in Org
{
string rollUpAllQry = "SELECT TOP " + intMaxResults + " * FROM gl_budget_rollup";
QueryParamCollection rollUpParams = new QueryParamCollection();
rollUpParams.Add("a_org", org, true);
newGridForm.AddGrid("OrgGrid", "GL Info:", await munisComms.ReturnSqlTableFromCmdAsync(munisComms.GetSqlCommandFromParams(glMasterQry, glParams.Parameters))); //MunisComms.Return_MSSQLTableAsync(Qry))
newGridForm.AddGrid("RollupGrid", "Rollup Info:", await munisComms.ReturnSqlTableFromCmdAsync(munisComms.GetSqlCommandFromParams(rollUpAllQry, rollUpParams.Parameters))); //MunisComms.Return_MSSQLTableAsync("SELECT TOP " & intMaxResults & " * FROM gl_budget_rollup WHERE a_org = '" & Org & "'"))
}
newGridForm.Show();
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}
public static async void NewMunisPOSearch(string po, ExtendedForm parentForm)
{
try
{
parentForm.Waiting();
if (po == "")
{
return;
}
string query = "SELECT TOP " + intMaxResults + @" pohd_pur_no, pohd_fsc_yr, pohd_req_no, pohd_gen_cm, pohd_buy_id, pohd_pre_dt, pohd_exp_dt, pohd_sta_cd, pohd_vnd_cd, pohd_dep_cd, pohd_shp_cd, pohd_tot_amt, pohd_serial
FROM poheader";
QueryParamCollection searchParams = new QueryParamCollection();
searchParams.Add("pohd_pur_no", po, true);
GridForm newGridForm = new GridForm(parentForm, "MUNIS PO Info");
using (var cmd = munisComms.GetSqlCommandFromParams(query, searchParams.Parameters))
{
using (var results = await munisComms.ReturnSqlTableFromCmdAsync(cmd))
{
if (HasResults(results, parentForm))
{
newGridForm.AddGrid("POGrid", "PO Info:", results);
newGridForm.Show();
}
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}
public static async void ReqSearch(ExtendedForm parentForm)
{
try
{
string reqNumber = "";
string fy = "";
using (var newDialog = new Dialog(parentForm))
{
newDialog.Text = "Req Search";
newDialog.AddTextBox("ReqNum", "Requisition #:");
newDialog.AddTextBox("FY", "FY:");
newDialog.ShowDialog();
if (newDialog.DialogResult == DialogResult.OK)
{
reqNumber = newDialog.GetControlValue("ReqNum").ToString();
fy = newDialog.GetControlValue("FY").ToString();
if (DataConsistency.IsValidYear(fy))
{
parentForm.Waiting();
var blah = await NewMunisReqSearch(reqNumber, fy, parentForm);
}
else
{
OtherFunctions.Message("Invalid year.", MessageBoxButtons.OK, MessageBoxIcon.Information, "Invalid", parentForm);
}
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}
private static async void NewMunisEmployeeSearch(string name, ExtendedForm parentForm)
{
try
{
parentForm.Waiting();
string columns = "e.a_employee_number,e.a_name_last,e.a_name_first,e.a_org_primary,e.a_object_primary,e.a_location_primary,e.a_location_p_desc,e.a_location_p_short,e.e_work_location,m.a_employee_number as sup_employee_number,m.a_name_first as sup_name_first,m.a_name_last as sup_name_last";
string query = "SELECT TOP " + intMaxResults + " " + columns + @"
FROM pr_employee_master e
INNER JOIN pr_employee_master m on e.e_supervisor = m.a_employee_number";
QueryParamCollection searchParams = new QueryParamCollection();
searchParams.Add("e.a_name_last", name.ToUpper(), "OR");
searchParams.Add("e.a_name_first", name.ToUpper(), "OR");
using (var cmd = munisComms.GetSqlCommandFromParams(query, searchParams.Parameters))
using (var results = await munisComms.ReturnSqlTableFromCmdAsync(cmd))
{
if (HasResults(results, parentForm))
{
parentForm.DoneWaiting();
GridForm newGridForm = new GridForm(parentForm, "MUNIS Employee Info");
newGridForm.AddGrid("EmpGrid", "MUNIS Info:", results);
newGridForm.Show();
}
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}
public static async void LoadMunisInfoByDevice(Device device, ExtendedForm parentForm)
{
try
{
parentForm.Waiting();
DataTable reqLinesTable = new DataTable();
DataTable reqHeaderTable = new DataTable();
DataTable inventoryTable = new DataTable();
if (device.PO == "" || device.PO == null)
{
device.PO = await GetPOFromDevice(device);
}
if (device.PO != string.Empty)
{
inventoryTable = await LoadMunisInventoryGrid(device);
reqLinesTable = await GetReqLineItemsFromReqNum(await GetReqNumberFromPOAsync(device.PO), GetFYFromPO(device.PO));
reqHeaderTable = await GetReqHeaderFromReqNum(await GetReqNumberFromPOAsync(device.PO), GetFYFromPO(device.PO));
}
else
{
inventoryTable = await LoadMunisInventoryGrid(device);
reqLinesTable = null;
reqHeaderTable = null;
}
if (inventoryTable != null || reqLinesTable != null)
{
GridForm newGridForm = new GridForm(parentForm, "MUNIS Info");
if (inventoryTable == null)
{
OtherFunctions.Message("Munis Fixed Asset info. not found.", MessageBoxButtons.OK, MessageBoxIcon.Information, "No FA Record");
}
else
{
newGridForm.AddGrid("InvGrid", "FA Info:", inventoryTable);
}
if (reqLinesTable == null)
{
OtherFunctions.Message("Could not resolve PO from Asset Tag or Serial. Please add a valid PO if possible.", MessageBoxButtons.OK, MessageBoxIcon.Information, "No Req. Record");
}
else
{
newGridForm.AddGrid("ReqHeadGrid", "Requisition Header:", reqHeaderTable);
newGridForm.AddGrid("ReqLineGrid", "Requisition Line Items:", reqLinesTable);
}
if (newGridForm.GridCount > 0)
{
newGridForm.Show();
}
else
{
newGridForm.Dispose();
}
}
else if (inventoryTable == null && reqLinesTable == null)
{
OtherFunctions.Message("Could not resolve any purchase or Fixed Asset info.", MessageBoxButtons.OK, MessageBoxIcon.Information, "Nothing Found");
}
}
catch (Exception ex)
{
ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod());
}
finally
{
parentForm.DoneWaiting();
}
}