//
/// <summary>
/// Fills the moh visitsheet.
/// </summary>
/// <param name="theApp">The application.</param>
private void fillMohVisitsheet(Excel.Spreadsheet theApp)
{
Int32 theColIdx = 73;
Int32 theRepIdx = 64;
string xlcolumn;
isvisitSheet = true;
string lastcolumn = string.Empty;
Excel.Worksheet worksheet = (Excel.Worksheet)theApp.Sheets[3];
writeInCell(worksheet, "E5", "Patientvisitinfo", "IQNumber", 0);
//xlcolumn = 'I';
Excel.Range theRange;
for (int a = 0; a < theRepDS.Tables["IEFuinfopervisit"].Rows.Count; a++)
{
visitid = Convert.ToInt32(theRepDS.Tables["IEFuinfopervisit"].Rows[a]["Visit_id"].ToString());
if (a > 17)
{
if (theColIdx > 90)
{
theColIdx = 65;
theRepIdx = theRepIdx + 1;
}
xlcolumn = Convert.ToChar(theRepIdx).ToString() + Convert.ToChar(theColIdx).ToString();
theColIdx = theColIdx + 1;
}
else
{
xlcolumn = Convert.ToChar(theColIdx).ToString();
theColIdx = theColIdx + 1;
}
if (a > 0)
{
writeInCell(worksheet, xlcolumn + "7", "", "V" + (a + 1).ToString(), 0);
//
theRange = (Excel.Range)theApp.ActiveSheet.Cells[7, 73 + a];
theRange.EntireRow.Font.set_Bold(true);
for (int b = 7; b <= 44; b++)
{
theRange = worksheet.Cells.get_Range(xlcolumn + b.ToString(), xlcolumn + b.ToString());
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlThin, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
}
}
lastcolumn = xlcolumn;
writeCellWiseInExcel(worksheet, xlcolumn, a);
}
/////////////////////
if (!string.IsNullOrEmpty(lastcolumn))
{
theRange = worksheet.get_Range("B4", lastcolumn + "6");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B7", lastcolumn + "7");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
object obj = new Object();
obj = (object)("0xD8D8D8").ToString();
theRange.Interior.set_Color(ref obj);
theRange = worksheet.get_Range("B4", lastcolumn + "44");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B10", lastcolumn + "11");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B12", lastcolumn + "15");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B16", lastcolumn + "17");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B18", lastcolumn + "19");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B20", lastcolumn + "21");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B22", lastcolumn + "22");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B23", lastcolumn + "23");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B24", lastcolumn + "24");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B25", lastcolumn + "26");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B27", lastcolumn + "27");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B28", lastcolumn + "28");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B29", lastcolumn + "31");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B32", lastcolumn + "36");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B37", lastcolumn + "37");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B38", lastcolumn + "38");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B39", lastcolumn + "42");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B43", lastcolumn + "43");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B44", lastcolumn + "44");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
//////////////////////////
}
else
{
theRange = worksheet.get_Range("B4", "I6");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
theRange = worksheet.get_Range("B7", "I7");
theRange.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, 1);
}
releaseObject(theRange);
releaseObject(worksheet);
}
/// <summary>
/// Fills the moh reg sheet.
/// </summary>
/// <param name="theApp">The application.</param>
private void fillMohRegSheet(Excel.Spreadsheet theApp)
{
Excel.Worksheet theSheet = (Excel.Worksheet)theApp.Sheets[2];
writeInCell(theSheet, "F4", "patientinfo", "FacilityName", 0);
writeInCell(theSheet, "X4", "patientinfo", "PatientClinicNumber", 0);
writeInCell(theSheet, "S8", "patientinfo", "UniquePatNumber", 0);
string name = theRepDS.Tables["patientinfo"].Rows[0]["FirstName"].ToString() + " " + theRepDS.Tables["patientinfo"].Rows[0]["LastName"].ToString();
writeInCell(theSheet, "C11", "", name, 0);
if (theRepDS.Tables["patientinfo"].Rows[0]["Gender"].ToString().Contains("Female"))
{
// writeInCell(theSheet, "D13", "", "N", 0);
writeInCell(theSheet, "I13", "", "Y", 0);
}
else
{
writeInCell(theSheet, "D13", "", "Y", 0);
// writeInCell(theSheet, "I13", "", "N", 0);
}
writeInCell(theSheet, "W11", "", theRepDS.Tables["PatientInfo"].Rows[0]["DOB"].ToString(), 0);;
writeInCell(theSheet, "AD11", "patientinfo", "Age", 0);
writeInCell(theSheet, "X13", "patientinfo", "Address", 0);
writeInCell(theSheet, "D14", "patientinfo", "TelContact", 0);
writeInCell(theSheet, "D15", "patientinfo", "District", 0);
writeInCell(theSheet, "W15", "patientinfo", "Location", 0);
writeInCell(theSheet, "D16", "patientinfo", "SubLocation", 0);
writeInCell(theSheet, "W16", "patientinfo", "LandMark", 0);
if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Single"))
{
writeInCell(theSheet, "T21", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Married"))
{
writeInCell(theSheet, "D21", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Divorced"))
{
writeInCell(theSheet, "N19", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Cohabiting"))
{
writeInCell(theSheet, "T19", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Married Polygamous"))
{
writeInCell(theSheet, "D19", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Married Monogamous"))
{
writeInCell(theSheet, "D21", "", "Y", 0);
}
else if (theRepDS.Tables["patientinfo"].Rows[0]["MaritalStatus"].ToString().Contains("Widowed"))
{
writeInCell(theSheet, "N21", "", "Y", 0);
}
// EmergContact
writeInCell(theSheet, "F23", "EmergContact", "TSName", 0);
writeInCell(theSheet, "Y23", "EmergContact", "TSRelation", 0);
writeInCell(theSheet, "F24", "EmergContact", "TSAddress", 0);
writeInCell(theSheet, "W24", "EmergContact", "TSPhone", 0);
//
// for (int i = 0; i < theRepDS.Tables["Referred"].Rows.Count; i++)
if (theRepDS.Tables["Referred"].Rows.Count > 0)
{
if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("VCT"))
{
writeInCell(theSheet, "D30", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("PMTCT"))
{
writeInCell(theSheet, "D28", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("IPD - Ad"))
{
writeInCell(theSheet, "N28", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("TB Clinic"))
{
writeInCell(theSheet, "V28", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("OPD"))
{
writeInCell(theSheet, "AD28", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("IPD - Ch"))
{
writeInCell(theSheet, "L30", "", "Y", 0);
}
else if (theRepDS.Tables["Referred"].Rows[0]["ReferredFrom"].ToString().Contains("MCH child"))
{
writeInCell(theSheet, "V30", "", "Y", 0);
}
else
{
writeInCell(theSheet, "D32", "", "Y", 0);
writeInCell(theSheet, "M32", "Referred", "Transfered From Facility", 0);
}
}
writeInCell(theSheet, "G34", "Referred", "TransferInDate", 0);
writeInCell(theSheet, "V34", "Referred", "ReferredFrom", 0);
writeInCell(theSheet, "G36", "Referred", "Transfered From Facility", 0);
writeInCell(theSheet, "Z36", "Referred", "ARTStartDate", 0);
//PrevARV
if (theRepDS.Tables["PrevARV"].Rows.Count > 0)
{
if (!String.IsNullOrEmpty(Convert.ToString(theRepDS.Tables["PrevARV"].Rows[0]["PrevARV1"])))
{
writeInCell(theSheet, "P43", "PrevARV", "PrevARV1", 0);
writeInCell(theSheet, "AB43", "PrevARV", "PrevARV1dtUsed", 0);
}
if (!String.IsNullOrEmpty(Convert.ToString(theRepDS.Tables["PrevARV"].Rows[0]["PrevARV2"])))
{
writeInCell(theSheet, "P45", "PrevARV", "PrevARV2", 0);
writeInCell(theSheet, "AB45", "PrevARV", "PrevARV2dtUsed", 0);
}
if (!String.IsNullOrEmpty(Convert.ToString(theRepDS.Tables["PrevARV"].Rows[0]["PrevARV3"])))
{
writeInCell(theSheet, "P47", "PrevARV", "PrevARV3", 0);
writeInCell(theSheet, "AB47", "PrevARV", "PrevARV3dtUsed", 0);
}
}
//HIVDiagnosis
writeInCell(theSheet, "I49", "HIVDiagnosis", "DtConfirmHIVPositive", 0);
writeInCell(theSheet, "I50", "HIVDiagnosis", "dtEnrolledHIVCare", 0);
writeInCell(theSheet, "AB51", "HIVDiagnosis", "WHOStage", 0);
writeInCell(theSheet, "I51", "patientAllergy", "Allergy", 0);
//FamilyInfo
for (int i = 0; i < 5; i++)
{
writeInCell(theSheet, "C" + (57 + i).ToString(), "", (i + 1).ToString(), 0);
writeInCell(theSheet, "D" + (57 + i).ToString(), "FamilyInfo", "RName", i);
writeInCell(theSheet, "K" + (57 + i).ToString(), "FamilyInfo", "AgeYear", i);
writeInCell(theSheet, "M" + (57 + i).ToString(), "FamilyInfo", "Relation", i);
writeInCell(theSheet, "T" + (57 + i).ToString(), "FamilyInfo", "HIVStatus", i);
writeInCell(theSheet, "W" + (57 + i).ToString(), "FamilyInfo", "InCare", i);
writeInCell(theSheet, "Z" + (57 + i).ToString(), "FamilyInfo", "CCCNumber", i);
}
//
if (theRepDS.Tables["patientlabresults"].Rows.Count > 0)
{
// if (!String.IsNullOrEmpty(theRepDS.Tables["patientlabresults"].Rows[0]["CD4Count"].ToString()))
// {
writeInCell(theSheet, "BA10", "", "Y", 0);
writeInCell(theSheet, "BI11", "patientlabresults", "CD4Count", 0);
writeInCell(theSheet, "AV11", "patientlabresults", "WHOStage", 0);
writeInCell(theSheet, "AO17", "patientlabresults", "Weight", 0);
writeInCell(theSheet, "AV17", "patientlabresults", "Height", 0);
writeInCell(theSheet, "BD17", "patientlabresults", "BMI", 0);
writeInCell(theSheet, "BK17", "patientlabresults", "WHOStage", 0);
// }
}
for (int i = 0; i < 3; i++)
{
writeInCell(theSheet, "AS" + (i + 22).ToString(), "firstgegimen", "RegimenType", i);
writeInCell(theSheet, "AK" + (i + 22).ToString(), "firstgegimen", "RegDate", i);
}
releaseObject(theSheet);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (validation() == false)
{
return;
}
IQCareUtils theUtils = new IQCareUtils();
if ((ddQuarter.SelectedValue.ToString() != "0") && (txtyears.Text.Trim() != ""))
{
IReports ReportDetails = (IReports)ObjectFactory.CreateInstance("BusinessProcess.Reports.BReports,BusinessProcess.Reports");
theRepQuarterDS = (DataSet)ReportDetails.GetNACPQuarterlyReportData(Convert.ToInt32(ddQuarter.SelectedValue.ToString()), Convert.ToInt32(txtyears.Text.Trim()), Convert.ToInt32(Session["AppLocationId"]));
#region "TableNames"
theRepQuarterDS.Tables[0].TableName = "FacilityInfo1";
theRepQuarterDS.Tables[1].TableName = "Table1Data1";
theRepQuarterDS.Tables[2].TableName = "Table2Data1";
#endregion
Excel.Spreadsheet theApp = new Microsoft.Office.Interop.Owc11.Spreadsheet();
string theFilePath = Server.MapPath("..\\ExcelFiles\\Templates\\TZNACPQuarterlyReport.xml");
theApp.XMLURL = theFilePath;
writeCellWiseInExcel(theApp);
//theApp.Export(Server.MapPath("..\\ExcelFiles\\TZNACPQuarterlyReport.xls"), Microsoft.Office.Interop.Owc11.SheetExportActionEnum.ssExportActionOpenInExcel, Microsoft.Office.Interop.Owc11.SheetExportFormat.ssExportXMLSpreadsheet);
theApp.Export(Server.MapPath("..\\ExcelFiles\\TZNACPQuarterlyReport.xls"), Microsoft.Office.Interop.Owc11.SheetExportActionEnum.ssExportActionNone, Microsoft.Office.Interop.Owc11.SheetExportFormat.ssExportXMLSpreadsheet);
//theUtils.OpenExcelFile(Server.MapPath("..\\ExcelFiles\\TZNACPQuarterlyReport.xls"),Response);
IQWebUtils theUtl = new IQWebUtils();
theUtl.ShowExcelFile(Server.MapPath("..\\ExcelFiles\\TZNACPQuarterlyReport.xls"), Response);
}
else if ((ddMonth.SelectedValue.ToString() != "0") && (txtYear.Text.Trim() != ""))
{
int years = Convert.ToInt32(txtYear.Text);
int Months = Convert.ToInt32(ddMonth.SelectedItem.Value);
IReports ReportDetails = (IReports)ObjectFactory.CreateInstance("BusinessProcess.Reports.BReports,BusinessProcess.Reports");
theRepDS = (DataSet)ReportDetails.GetNACPMonthlyReportData(Months, years, Convert.ToInt32(Session["AppLocationId"]));
#region "TableNames"
theRepDS.Tables[0].TableName = "FacilityInfo";
theRepDS.Tables[1].TableName = "Table1Data";
theRepDS.Tables[2].TableName = "Table2Data";
#endregion
//Response.Redirect("..\\ExcelFiles\\TZNACPMonthlyReport.xls");
Excel.Spreadsheet theApp = new Microsoft.Office.Interop.Owc11.Spreadsheet();
string theFilePath = Server.MapPath("..\\ExcelFiles\\Templates\\TanzaniaNACPMonthlyreport.xml");
theApp.XMLURL = theFilePath;
writeCellWiseInExcel(theApp);
// theApp.Export(Server.MapPath("..\\ExcelFiles\\TZNACPMonthlyReport.xls"), Microsoft.Office.Interop.Owc11.SheetExportActionEnum.ssExportActionOpenInExcel, Microsoft.Office.Interop.Owc11.SheetExportFormat.ssExportAsAppropriate);
theApp.Export(Server.MapPath("..\\ExcelFiles\\TZNACPMonthlyReport.xls"), Microsoft.Office.Interop.Owc11.SheetExportActionEnum.ssExportActionNone, Microsoft.Office.Interop.Owc11.SheetExportFormat.ssExportXMLSpreadsheet);
//theUtils.OpenExcelFile(Server.MapPath("..\\ExcelFiles\\TZNACPMonthlyReport.xls"), Response);
IQWebUtils theUtl = new IQWebUtils();
theUtl.ShowExcelFile(Server.MapPath("..\\ExcelFiles\\TZNACPMonthlyReport.xls"), Response);
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareMsgBox.Show("#C1", theBuilder, this);
return;
}
}
// private void writeCellWiseInExcel(Excel.Spreadsheet theSheet) { }
private void writeCellWiseInExcel(Excel.Spreadsheet theSheet)
{
try
{
if ((ddQuarter.SelectedValue.ToString() != "0") && (txtyears.Text != ""))
{
// theSheet.
writeInCell(theSheet, "C4", "FacilityInfo1", "Date");
writeInCell(theSheet, "C6", "FacilityInfo1", "FacilityName");
writeInCell(theSheet, "C8", "FacilityInfo1", "District");
writeInCell(theSheet, "E4", "", Application["AppCurrentDate"].ToString());
writeInCell(theSheet, "E8", "FacilityInfo1", "Region");
writeInCell(theSheet, "E15", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE15");
writeInCell(theSheet, "E16", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE16");
writeInCell(theSheet, "E17", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE17");
writeInCell(theSheet, "E18", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE18");
writeInCell(theSheet, "E21", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE21");
writeInCell(theSheet, "E22", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE22");
writeInCell(theSheet, "E23", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE23");
writeInCell(theSheet, "E24", theRepQuarterDS.Tables[1].TableName.ToString(), "Table3ColE24");
writeInCell(theSheet, "D35", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColD35");
writeInCell(theSheet, "D36", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColD36");
writeInCell(theSheet, "D37", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColD37");
writeInCell(theSheet, "D38", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColD38");
writeInCell(theSheet, "D41", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColD41");
writeInCell(theSheet, "E41", theRepQuarterDS.Tables[2].TableName.ToString(), "Table4ColE41");
}
else if ((ddMonth.SelectedValue.ToString() != "0") && (txtYear.Text.Trim() != ""))
{
writeInCell(theSheet, "C5", "FacilityInfo", "Date");
writeInCell(theSheet, "C7", "FacilityInfo", "FacilityName");
writeInCell(theSheet, "C9", "FacilityInfo", "District");
writeInCell(theSheet, "E5", "", Application["AppCurrentDate"].ToString());
writeInCell(theSheet, "E9", "FacilityInfo", "Region");
writeInCell(theSheet, "D16", theRepDS.Tables[1].TableName.ToString(), "Table1ColD16");
writeInCell(theSheet, "D17", theRepDS.Tables[1].TableName.ToString(), "Table1ColD17");
writeInCell(theSheet, "D18", theRepDS.Tables[1].TableName.ToString(), "Table1ColD18");
writeInCell(theSheet, "D19", theRepDS.Tables[1].TableName.ToString(), "Table1ColD19");
writeInCell(theSheet, "E16", theRepDS.Tables[1].TableName.ToString(), "Table1ColE16");
writeInCell(theSheet, "E17", theRepDS.Tables[1].TableName.ToString(), "Table1ColE17");
writeInCell(theSheet, "E18", theRepDS.Tables[1].TableName.ToString(), "Table1ColE18");
writeInCell(theSheet, "E19", theRepDS.Tables[1].TableName.ToString(), "Table1ColE19");
writeInCell(theSheet, "G16", theRepDS.Tables[1].TableName.ToString(), "Table1ColG16");
writeInCell(theSheet, "G17", theRepDS.Tables[1].TableName.ToString(), "Table1ColG17");
writeInCell(theSheet, "G18", theRepDS.Tables[1].TableName.ToString(), "Table1ColG18");
writeInCell(theSheet, "G19", theRepDS.Tables[1].TableName.ToString(), "Table1ColG19");
writeInCell(theSheet, "D24", theRepDS.Tables[2].TableName.ToString(), "Table2ColD24");
writeInCell(theSheet, "D25", theRepDS.Tables[2].TableName.ToString(), "Table2ColD25");
writeInCell(theSheet, "D26", theRepDS.Tables[2].TableName.ToString(), "Table2ColD26");
writeInCell(theSheet, "D27", theRepDS.Tables[2].TableName.ToString(), "Table2ColD27");
writeInCell(theSheet, "D29", theRepDS.Tables[2].TableName.ToString(), "Table2ColD29");
writeInCell(theSheet, "D30", theRepDS.Tables[2].TableName.ToString(), "Table2ColD30");
writeInCell(theSheet, "E24", theRepDS.Tables[2].TableName.ToString(), "Table2ColE24");
writeInCell(theSheet, "E25", theRepDS.Tables[2].TableName.ToString(), "Table2ColE25");
writeInCell(theSheet, "E26", theRepDS.Tables[2].TableName.ToString(), "Table2ColE26");
writeInCell(theSheet, "E27", theRepDS.Tables[2].TableName.ToString(), "Table2ColE27");
writeInCell(theSheet, "E29", theRepDS.Tables[2].TableName.ToString(), "Table2ColE29");
writeInCell(theSheet, "E30", theRepDS.Tables[2].TableName.ToString(), "Table2ColE30");
writeInCell(theSheet, "F32", theRepDS.Tables[2].TableName.ToString(), "Table2ColF32");
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareMsgBox.Show("#C1", theBuilder, this);
return;
}
}
private void writeInCell(Excel.Spreadsheet theSheet, string cell, string tablename, string column)
{
Excel.Range theRange = theSheet.Cells.get_Range(cell, cell);
//theRange.Value2
//theRange.WrapText = true;
string theExitvalue = "";
if (theRange.Value2 != null)
{
theExitvalue = theRange.Value2.ToString();
}
else
{
theExitvalue = "";
}
if ((ddQuarter.SelectedValue.ToString() != "0") && (txtyears.Text != ""))
{
try
{
if (tablename != "")
{
if (theExitvalue.ToString().Trim() == "")
{
theRange.Value2 = theRepQuarterDS.Tables[tablename].Rows[0][column].ToString();
}
else
{
theRange.Value2 = theExitvalue + " " + theRepQuarterDS.Tables[tablename].Rows[0][column].ToString();
}
}
else
{
if (theExitvalue.ToString().Trim() == "")
{
theRange.Value2 = column;
}
else
{
theRange.Value2 = theExitvalue + " " + column;
}
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareMsgBox.Show("#C1", theBuilder, this);
return;
}
}
else if ((ddMonth.SelectedValue.ToString() != "0") && (txtYear.Text != ""))
{
try
{
if (tablename != "")
{
if (theExitvalue.ToString().Trim() == "")
{
theRange.Value2 = theRepDS.Tables[tablename].Rows[0][column].ToString();
}
else
{
theRange.Value2 = theExitvalue + " " + theRepDS.Tables[tablename].Rows[0][column].ToString();
}
}
else
{
if (theExitvalue.ToString().Trim() == "")
{
theRange.Value2 = column;
}
else
{
theRange.Value2 = theExitvalue + " " + column;
}
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareMsgBox.Show("#C1", theBuilder, this);
return;
}
}
}