/*
* ----------------------------------------------------------------------------------------------------
* Synopsis : Used to get the Filter Details
* Input :
* Output :
* -----------------------------------------------------------------------------------------------------
*/
private void GetFilterDetails()
{
NTrust.K2.BO.ExportManager ObjExpMan = null;
ObjExpMan = (NTrust.K2.BO.ExportManager)NTrustSession.CreateBusinessObject("ExportManager", 1);
string strFilter = "varname ='" + FIELDSETTINGS + "'";
string strSort = "";
DataTable dtExportResult = ObjExpMan.GetExportNamedFilter(strFilter, strSort);
DataRow drNewRow = null;
drNewRow = dtExportResult.NewRow();
drNewRow[SELECT_VARNAME] = "";
drNewRow[SELECT_FKEY] = strDEFAULT_SELECTION_VALUE;
drNewRow["FILTERNAME"] = strDEFAULT_SELECTION_TEXT;
dtExportResult.Rows.Add(drNewRow);
dtExportResult.DefaultView.Sort = SELECT_FKEY;
FillCombo(this.ddlNamedFilter, dtExportResult, SELECT_FKEY, "FILTERNAME");
}
/*
* ----------------------------------------------------------------------------------------------------
* Synopsis : This function will Set the Default value to respectively controls
* Input : udgFieldList as object E
* Output :
* -----------------------------------------------------------------------------------------------------
*/
private void SetDefaultValue()
{
NTrust.K2.BO.ExportManager ObjExpMan = null;
ObjExpMan = (NTrust.K2.BO.ExportManager)NTrustSession.CreateBusinessObject("ExportManager", 1);
strFilter = "varname ='" + EXPORTDIRECTORY + "'";
strSort = "";
DataTable dtExportResult = ObjExpMan.GetExportVariable(strFilter, strSort);
if (dtExportResult.Rows.Count > 0)
{
string mon = DateTime.Today.Month.ToString();
string day = DateTime.Today.Day.ToString();
txtSelectedFile.Text = file_name;
}
strFilter = "varname ='" + DELIMITCHAR + "'";
dtExportResult = ObjExpMan.GetExportVariable(strFilter, strSort);
if (dtExportResult.Rows.Count > 0)
{
setDefault(this.ddlDelimiter, dtExportResult.Rows[0][SELECT_FIELDNAME].ToString());
}
}
/*
* ----------------------------------------------------------------------------------------------------
* Synopsis : This Method will EXPORT the Data to a TEXT FILE
* Input :
* Output :
* -----------------------------------------------------------------------------------------------------
*/
protected void btnExport_Click(object sender, System.EventArgs e)
{
bool blnWriteFlag = false;
string[] strSQLScript = new string[4];
try
{
NTrust.K2.BO.Export objExport = (NTrust.K2.BO.Export)NTrustSession.CreateBusinessObject("AEXPORT", 1);
NTrust.K2.BO.Export.ExportFieldStruct ExpFldStruct = new NTrust.K2.BO.Export.ExportFieldStruct();
string strPKEY = ddlNamedFilter.SelectedValue;
string strDelimiter = this.ddlDelimiter.SelectedValue;
string strFilePath = this.txtSelectedFile.Text;
bool blnOpenOrOverWrite = (this.chkAppend.Checked == true)?true:false;
string strFilter = "";
/*
* if (this.chkSave.Checked )
* {
* // Here Deleting the Demlimiter Record
* strFilter = "varname='" + DELIMITCHAR + "'";
* strSQLScript[0] = "DELETE FROM Y_VARIABLES WHERE " + strFilter ;
* // Here Deleting the Export File Directory Record
* strFilter = "varname='" + EXPORTDIRECTORY + "'";
* strSQLScript[1] = "DELETE FROM Y_VARIABLES WHERE " + strFilter ;
* // Here Forming the Insert Script for the Demlimiter Record
* ExpFldStruct.strTemplateName = "";
* ExpFldStruct.strValue1 = strDelimiter;
* ExpFldStruct.strValue2 = "";
* ExpFldStruct.strValue3 = "";
* ExpFldStruct.strVarName = DELIMITCHAR;
* ExpFldStruct.strValueDate = "";
* ExpFldStruct.strSeqence = "0";
* strSQLScript[2] = objExport.GenInsExportFieldsSetting(ExpFldStruct);
*
* // Here Forming the Insert Script for the Export File Directory Record
* ExpFldStruct.strTemplateName = "";
* ExpFldStruct.strValue1 = strFilePath;
* ExpFldStruct.strValue2 = "";
* ExpFldStruct.strValue3 = "";
* ExpFldStruct.strVarName = EXPORTDIRECTORY;
* ExpFldStruct.strValueDate = "";
* ExpFldStruct.strSeqence = "0";
* strSQLScript[3] = objExport.GenInsExportFieldsSetting(ExpFldStruct);
* // Here Execution the Script Both Deleting and Inserting in a Single Transaction
* objExport.AddExportFieldsSetting(strSQLScript);
*
* }
*
* // Here Getting the Template details
* NTrust.K2.BO.ExportManager ObjExpMan = null;
* ObjExpMan = (NTrust.K2.BO.ExportManager) NTrustSession.CreateBusinessObject("ExportManager", 1);
* strFilter = "varname ='"+ FIELDSETTINGS +"' and VALUE_FKEY='"+strPKEY +"'";
* strSort = SELECT_FIELDVALUE;
* DataTable dtExportResult = ObjExpMan.GetExportVariable(strFilter,strSort);
*
*/
NTrust.K2.BO.ExportManager ObjExpMan = null;
ObjExpMan = (NTrust.K2.BO.ExportManager)NTrustSession.CreateBusinessObject("ExportManager", 1);
// Here forming the Select Statement Based on the Template Selected
int [] intSize = new int[50];
intSize[0] = 8;
intSize[1] = 20;
intSize[2] = 8;
intSize[3] = 11;
intSize[4] = 8;
intSize[5] = 8;
intSize[6] = 30;
string strQuery = "SELECT * FROM V_K2_EXPORTJOURNALFIELDSCOCOS";
strQuery += " ORDER BY PARENT_ID,GLCODE,VENDOR_NUMBER,DUE_DATE,CHECK_KEY";
if (strFilePath != "")
{
//Cocos Result data to Text File
strDelimiter = ","; // For CSV file.
string strpath = System.Configuration.ConfigurationSettings.AppSettings[SAVE_FILE_PATH] + ADD_FILE_PATH;
bool folderExists = Directory.Exists(strpath);
if (!folderExists)
{
Directory.CreateDirectory(strpath);
}
strFilePath = strpath + strFilePath;
blnWriteFlag = ObjExpMan.ExportToCOCOSFile(strQuery, strDelimiter, strFilePath, blnOpenOrOverWrite, intSize);
if (blnWriteFlag)
{
string url = "";//changes made for CR - Journal Accrual Export for not to update Accrual Records. by Biru
if (chkExportLocal.Checked)
{
url = "JounralExportMessage.aspx?ParentName=" + strSettings + "&DisplayName=" + strDisplayName + "&MenuKey=" + strMenuKey + "&ExportType=" + strExportType + "&FileName=" + txtSelectedFile.Text + "";
}
else
{
url = "JounralExportMessage.aspx?ParentName=" + strSettings + "&DisplayName=" + strDisplayName + "&MenuKey=" + strMenuKey + "&ExportType=" + strExportType + "&FileName=";
}
string strScript = "<script language=JavaScript>window.showModalDialog('" + url + "',window,'status:no;dialogWidth:465px;dialogHeight:175px;');</script>";
this.RegisterStartupScript("Winclose", strScript);
}
else
{
NTrustSessionPage.InitializeResources("K2Web.CommonResource");
this.CreateMessageAlert(this, GetString("NoRectoExportExcel"));
}
}
}
catch (NTrust.Util.NTrustException nex)
{
if (nex.ErrorCode == 500000)
{
ErrExist = "Y";
lblErrorMessage.Visible = true;
NTrustSessionPage.InitializeResources("K2Web.Utility.Integration");
CreateMessageAlert(this, GetString("FileAccess"));
//lblErrorMessage.Text = "File is accessed by Another Process. Close the file and export again";
}
else
{
ErrExist = "Y";
lblErrorMessage.Visible = true;
NTrustSessionPage.InitializeResources("K2Web.Utility.Integration");
SetErrorMessage(lblErrorMessage, nex.ErrorCode, nex.Message, GetString("Export File"));
}
}
catch (System.IO.FileNotFoundException Ferr)
{
ErrExist = "Y";
lblErrorMessage.Visible = true;
SetErrorMessage(lblErrorMessage, 0, Ferr.Message.ToString(), "");
}
catch (Exception ex)
{
ErrExist = "Y";
ShowCustomError(0, ex.Message.ToString());
}
}
