public string SaveFormInfo(string recID, string elementID, string itemXML, string dataXML, string sessionID)
{
string sError = "";
DataSet ds;
CForms.SetLastFormID(ref sError, recID, elementID, sessionID);
if (!string.IsNullOrEmpty(itemXML))
{
ds = new DataSet();
ds.ReadXml(new System.IO.StringReader(itemXML));
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CForms.SetFormItemStatus(ref sError, recID, ds.Tables[0].Rows[i]["ID"].ToString(), ds.Tables[0].Rows[i]["Value"].ToString());
}
}
}
ds = new DataSet();
ds.ReadXml(new System.IO.StringReader(dataXML));
CForms.SetFormResultStatus(ref sError, recID, elementID,
ds.Tables[0].Rows[0]["Analysis"].ToString(),
ds.Tables[0].Rows[0]["Findings"].ToString(),
ds.Tables[0].Rows[0]["Result1"].ToString(),
ds.Tables[0].Rows[0]["Result2"].ToString(),
ds.Tables[0].Rows[0]["Result3"].ToString(),
ds.Tables[0].Rows[0]["Amount"].ToString());
return(sError);
}
private void CheckMIDandSummaryComplete()
{
string sError = "";
//If all forms are complete but MID table not complete, disable MarkCaseCompleteButton
DataSet ds = CForms.CheckMIDandCaseSummaryData(ref sError, RecID);
if (sError == "" && ds.Tables[0].Rows.Count == 0 && Session["IsReadOnly"].ToString() != "1")
{
if (Completed == "1")
{
btnMarkCaseComplete.Disabled = true;
}
else
{
btnMarkCaseComplete.Disabled = false;
}
lblMIDTableIncomplete.Visible = false;
}
else
{
btnMarkCaseComplete.Disabled = true;
lblMIDTableIncomplete.Visible = true;
}
}
public string ResetCaseIncomplete(string recID)
{
string sError = "";
CForms.ResetDataEntryFormIncomplete(ref sError, recID);
return(sError);
}
/* This is not called anywhere */
//private void LoadReviewerEntryData()
//{
// string sError = "";
// /*begin - load the form static description element*/
// DataSet ds = CForms.GetReviewerEntryData(ref sError, RecID);
//}
private void LoadFormData()
{
string sError = "";
/*begin - load the form static description element*/
DataSet dsFormTemplateInfo = CForms.GetFormTemplateInfo(ref sError, FormID);
if (dsFormTemplateInfo.Tables.Count > 0 && dsFormTemplateInfo.Tables[0].Rows.Count > 0)
{
lblSectionHeader.Text = dsFormTemplateInfo.Tables[0].Rows[0]["SectionDescription"].ToString();
lblFormTitle.Text = dsFormTemplateInfo.Tables[0].Rows[0]["FormTitle"].ToString();
lblFormDescription.Text = dsFormTemplateInfo.Tables[0].Rows[0]["FormDescription"].ToString();
}
/*begin - load the form saved data into this form*/
DataSet dsFormSavedData = CForms.GetFormSavedData(ref sError, Convert.ToInt32(RecID), FormID);
if (dsFormSavedData.Tables.Count > 0 && dsFormSavedData.Tables[0].Rows.Count > 0)
{
txtAnalysis.Text = dsFormSavedData.Tables[0].Rows[0]["Analysis"].ToString();
txtFindings.Text = dsFormSavedData.Tables[0].Rows[0]["Findings"].ToString();
cboError.SelectedValue = dsFormSavedData.Tables[0].Rows[0]["Result1"].ToString().Trim();
cboMissDoc.SelectedValue = dsFormSavedData.Tables[0].Rows[0]["Result2"].ToString().Trim();
cboMidOption.SelectedValue = dsFormSavedData.Tables[0].Rows[0]["Result3"].ToString().Trim();
if (cboError.SelectedValue == "0")
{
cboMissDoc.Enabled = false;
//if (FormID == 410)
//{
// cboErrorAutho.Enabled = false;
//}
}
//if (FormID == 410)
//{
// cboErrorAutho.SelectedValue = dsFormSavedData.Tables[0].Rows[0]["Result3"].ToString().Trim();
// txtTotalAmountIAP.Text = dsFormSavedData.Tables[0].Rows[0]["Amount"].ToString();
// txtTotalPayment.Text = dsFormSavedData.Tables[0].Rows[0]["TotalPaid"].ToString();
//}
}
else
{
sScript.Text += "arrForms['" + FormID.ToString() + "'][12]='0';";
}
/*begin - load the requirement list control*/
lstRequirements.FormID = FormID;
lstRequirements.RecID = RecID;
lstRequirements.FundingStream = FundingStream;
lstRequirements.Placement = Placement;
lstRequirements.RecType = RecType;
//lstRequirements.eID = eID;
//if (FormID == 410)
//{
// LastFormFooter.Visible = true;
//}
}
private void LoadReviewerComment(string recID)
{
string sError = "";
DataSet dsComment = CForms.GetReviewerFinalComment(ref sError, recID, "");
grdComment.DataSource = dsComment;
grdComment.DataBind();
}
public string SaveReviewerInfo(string recID, string feeLevel, string familySize, string familyIncome,
string days, string providerRate, string parentFee, string transAmount,
string totalAmount, string smi, string reviewerSupServices)
{
string sError = "";
CForms.SetReviewerEntryData(ref sError, recID, feeLevel, familySize, familyIncome,
days, providerRate, parentFee, transAmount, totalAmount, smi, reviewerSupServices);
return("");
}
protected void btnMarkCaseInComplete_Click(object sender, EventArgs e)
{
string sError = "";
CForms.ResetDataEntryFormIncomplete(ref sError, RecID);
Completed = "0";
//LoadFormContent();
Response.Redirect("selectchild.aspx?hn=" + Session["Hidenames"].ToString());
}
protected void btnSave_Click(object sender, EventArgs e)
{
string errorMsg = "";
string status = cboStatus.SelectedValue.ToString();
string username = Session["UserName"].ToString(); // AppData.GetLogonUsername(Request);
string date = DateTime.Now.ToShortDateString();
string comment = txtComment.Text;
CForms.SetFinalReviewerComment(ref errorMsg, RecID, username, date, status, comment);
LoadReviewerComment(RecID);
}
public string SaveReviewerInfo(string recID, string feeLevel, string familySize, string familyIncome,
string days, string providerRate, string parentFee, string transAmount,
string totalAmount, string smi, string reviewerSupServices,
string programType, string employmentType, string partTimeHours, string fullTimeHours,
string travelTime)
{
string sError = "";
CForms.SetReviewerEntryData(ref sError, recID, feeLevel, familySize, familyIncome,
days, providerRate, parentFee, transAmount, totalAmount, smi, reviewerSupServices
, programType, employmentType, partTimeHours, fullTimeHours, travelTime);
return("");
}
private void LoadRequirementList()
{
string sError = "";
DataSet dsInfo;
dsInfo = CForms.GetRequirementInfo(ref sError, Convert.ToInt32(RecID), FormID, RecType, FundingStream.ToString(), Placement, "");
lstRequirements.DataSource = CreateItemList(dsInfo);
// Get second parent info, if any
dsInfo = CForms.GetRequirementInfo(ref sError, Convert.ToInt32(RecID), FormID, RecType, FundingStream.ToString(), Placement, "2");
lstRequirements2.DataSource = CreateItemList(dsInfo);
DataBind();
}
//public string hn
//{
// get
// {
// return ViewState["hn"].ToString();
// }
// set
// {
// ViewState["hn"] = value;
// }
//}
protected void btnMarkComplete_Click(object sender, EventArgs e)
{
string sError = "";
CForms.SetDataEntryForm(ref sError, RecID, RecID, txtDataEntryMonthField.Value,
txtDataEntryReviewDateField.Value, txtReviewerName.Text,
txtDataEntryErrorNumField.Value, //txtDataEntryImproperPaymentField.Value,
//txtDataEntryImproperPaymentTypeField.Value,
"0", "", txtDataEntryMissingDocField.Value,
txtDataEntryTotalPaidField.Value, txtDataEntryCountyField.Value);
Completed = "1";
//LoadFormContent();
Response.Redirect("selectchild.aspx?hn=" + Session["Hidenames"].ToString());
}
private void LoadSelfComment(string recID)
{
string sError = "";
string username = Session["UserName"].ToString(); // AppData.GetLogonUsername(Request);
DataSet dsComment = CForms.GetReviewerFinalComment(ref sError, recID, username);
lblReviewerName.Text = username;
lblDate.Text = DateTime.Now.ToShortDateString();
if (dsComment.Tables.Count > 0 && dsComment.Tables[0].Rows.Count > 0)
{
cboStatus.SelectedValue = dsComment.Tables[0].Rows[0]["Status"].ToString();
txtComment.Text = dsComment.Tables[0].Rows[0]["Comment"].ToString();
}
}
private void LoadMIDTable(string recID)
{
string sError = "";
DataSet dsMIDTable = CForms.GetMIDTableDataPivot(ref sError, recID);
if (sError == "")
{
DataRow drow = dsMIDTable.Tables[0].Rows[0];
//lblSampleID.Text = drow["SampleID"].ToString();
//lblChildName.Text = drow["ChildName"].ToString();
lblChildId.Text = recID;
grdMIDList.DataSource = dsMIDTable;
grdMIDList.DataBind();
}
}
private void LoadFormData()
{
string sError = "";
DataSet ds = CForms.GetDataEntryFormData(ref sError, recID);
txtDataEntryChildID.Text = ds.Tables[0].Rows[0]["ChildID"].ToString();
txtDataEntryMonth.Text = AppData.FormatDateStr(ds.Tables[0].Rows[0]["SampleMonth"].ToString());
txtDataEntryCounty.Text = ds.Tables[0].Rows[0]["County"].ToString();
txtDataEntryErrorNum.Text = ds.Tables[0].Rows[0]["ErrorNum"].ToString();
//txtDataEntryImproperPayment.Text = "$" + ((ds.Tables[0].Rows[0]["ImproperPayment"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["ImproperPayment"].ToString());
//txtDataEntryImproperPaymentType.Text = ds.Tables[0].Rows[0]["ImproperPaymentType"].ToString();
txtDataEntryMissingDoc.Text = ds.Tables[0].Rows[0]["MissingDoc"].ToString();
txtDataEntryTotalPaid.Text = "$" + ((ds.Tables[0].Rows[0]["TotalPaid"].ToString() == "") ? "0.00" : ds.Tables[0].Rows[0]["TotalPaid"].ToString());
txtDataEntryState.Text = "MA";
txtDataEntryReviewDate.Text = AppData.FormatDateStr(ds.Tables[0].Rows[0]["ReviewDate"].ToString());
txtDataEntryReviewerName.Text = ds.Tables[0].Rows[0]["ReviewerName"].ToString();
}
private void LoadCaseSummaryData(string RecID)
{
string sError = "";
DataSet dsCase = CForms.GetCaseSummary(ref sError, RecID);
if (sError == "")
{
DataRow drow = dsCase.Tables[0].Rows[0];
//lblSampleID.Text = drow["SampleID"].ToString();
//lblChildName.Text = drow["ChildName"].ToString();
cboError.SelectedValue = drow["HasError"].ToString();
txtMIDErrorNum.Text = drow["CountMIDError"].ToString();
txtMIDErrorAmount.Text = drow["TotalMIDAmount"].ToString();
txtTimesAddInquiryUsed.Text = drow["CountAddInquiryUsed"].ToString();
txtTimesAddInquiryMitigated.Text = drow["CountAddInquiryMitigated"].ToString();
txtIPAmountMitigated.Text = drow["TotalMitigatedAmount"].ToString();
cboErrorAutho.SelectedValue = drow["OverUnderPayment"].ToString();
txtTotalAmountIP.Text = drow["TotalIPAmount"].ToString();
txtTotalPayment.Text = drow["TotalPaymentAmount"].ToString();
txtCaseSummaryFindings.Text = drow["CaseSummaryFindings"].ToString();
var hasMidError = Convert.ToBoolean(drow["HasMidError"]);
var midOption = Convert.ToBoolean(drow["MidOption"]);
if (cboError.SelectedValue == "0" || cboError.SelectedValue == "")
{
cboMissDoc.SelectedValue = "0";
}
else if (hasMidError && midOption)
{
cboMissDoc.SelectedValue = "2";
}
else if (hasMidError && !midOption)
{
cboMissDoc.SelectedValue = "1";
}
else
{
cboMissDoc.SelectedValue = "0";
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string errorMsg = "";
try
{
Session["CaseSummaryFindings"] = txtCaseSummaryFindings.Text;
CForms.SaveCaseSummary(ref errorMsg, Convert.ToInt32(hidRecID.Value), txtCaseSummaryFindings.Text);
if (errorMsg == "")
{
LoadCaseSummaryData(RecID);
}
}
catch (Exception ex)
{
lblErrMsg.Text = "Error updating the CaseSummary data, " + ex.Message;
lblErrMsg.Visible = true;
return;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string errorMsg = "";
int i = 0;
int j = 0;
string ElementID = "";
string QuestionID = "";
string QuestionAns = "";
try
{
for (i = 1; i < grdMIDList.Rows.Count; i++)
{
ElementID = ((TextBox)grdMIDList.Rows[i].Cells[0].FindControl("txtElementID")).Text.ToString();
if (ElementID == "Total")
{
ElementID = "410";
}
for (j = 2; j <= grdMIDList.Columns.Count; j++)
{
QuestionID = "txtQuestion" + j.ToString();
QuestionAns = ((TextBox)grdMIDList.Rows[i].Cells[j - 1].FindControl(QuestionID)).Text.ToString();
CForms.SaveMIDTableData(ref errorMsg, Convert.ToInt32(RecID), Convert.ToInt32(ElementID), j, QuestionAns, Session["UserName"].ToString());
}
}
lblErrMsg.Visible = false;
LoadMIDTable(RecID);
}
catch (Exception ex)
{
lblErrMsg.Text = "Error updating the MID Table, " + ex.Message;
lblErrMsg.Visible = true;
return;
}
}
private void LoadFormContent()
{
/* we need to put all available form ID to a list because we need to use databind for the datalist*/
lstFormID = new SortedList();
for (int i = 0; i < formID.Length; i++)
{
lstFormID.Add(i, formID[i]);
}
string sError = "";
//if (HideNames == "")
HideNames = Session["HideNames"].ToString();
dsChildInfo = CChild.LoadSelectedChildInfo(RecID, Convert.ToInt16(RecType), ServiceDate, Session.SessionID, HideNames);
dsReviewerEntryInfo = CForms.GetReviewerEntryData(ref sError, RecID);
authorizedAmount = dsChildInfo.Tables[0].Rows[0]["Authorized Amount"].ToString();
authorizedAmount = ((!string.IsNullOrEmpty(authorizedAmount)) ? Convert.ToDouble(authorizedAmount).ToString("N2") : "0.00");
placement = (dsChildInfo.Tables[0].Rows[0]["Autho Type"].ToString() == "N") ? "0" : "1";
/*begin - load the child info*/
childDetail.recID = RecID;
childDetail.recType = RecType;
childDetail.serviceDate = ServiceDate;
childDetail.funding = Funding;
childDetail.placement = placement;
childDetail.dsChildInfo = dsChildInfo;
childDetail.dsReviewerEntryInfo = dsReviewerEntryInfo;
//childDetail.eID = eID;
pageDetailTitle.eID = eID;
pageDetailTitle.recID = RecID;
pageDetailTitle.recType = RecType;
pageDetailTitle.serviceDate = ServiceDate;
pageDetailTitle.dsChildInfo0 = dsChildInfo;
/*end - load the child info*/
lstForms.DataSource = lstFormID;
DataBind();
Page.ClientScript.RegisterStartupScript(typeof(Page), "setFirstForm", "<script language='javascript'>javascript:SetCurrentForm('100')</script>");
/* begin - set data entry form */
txtDataEntryTotalPaid.Text = "$" + authorizedAmount;
txtDataEntryMonth.Text = ServiceDate;
txtDataEntryReviewDate.Text = AppData.FormatDateStr(DateTime.Now.ToShortDateString());
txtDataEntryChildID.Text = RecID;
txtDataEntryCounty.Text = dsChildInfo.Tables[0].Rows[0]["county"].ToString();
txtDataEntryTotalPaidField.Value = authorizedAmount;
txtDataEntryMonthField.Value = txtDataEntryMonth.Text;
txtDataEntryReviewDateField.Value = txtDataEntryReviewDate.Text;
txtDataEntryChildIDField.Value = RecID;
txtDataEntryCountyField.Value = txtDataEntryCounty.Text;
/* end - set data entry form */
strLastFormID = dsChildInfo.Tables[0].Rows[0]["LastFormID"].ToString();
hidLastFormID.Value = strLastFormID;
if (Session["UserName"].ToString() == "IPFedUser")
{
Page.ClientScript.RegisterStartupScript(typeof(Page), "AllFormCompleted", "<script>displayAllCompleted()</script>");
btnMarkCaseComplete.Disabled = true;
btnReviewerForm.Disabled = true;
}
else
{
if (Completed == "1")
{
Page.ClientScript.RegisterStartupScript(typeof(Page), "AllFormCompleted", "<script>displayAllCompleted()</script>");
btnMarkCaseComplete.Visible = false;
if (Session["IsAdminUser"] != null)
{
if (Session["IsAdminUser"].ToString() == "1")
{
btnMarkCaseIncomplete.Visible = true;
}
}
lblCompleted.Visible = true;
}
}
}
