private string SquirrelMemberList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.SquirrelMemberList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
string memberNumber = Convert.ToString(dr["MemberNumber"]) == "" ? "" : (Convert.ToString(dr["MemberNumber"]) + new string(' ', 8));
string lastNameSuffix = (Convert.ToString(dr["LastName"]) == "" ? "" : Convert.ToString(dr["LastName"])) + " " + (Convert.ToString(dr["Suffix"]) == "" ? "" : Convert.ToString(dr["Suffix"])) + new string(' ', 15);
string firstMiddle = (Convert.ToString(dr["FirstName"]) == "" ? "" : Convert.ToString(dr["FirstName"])) + " " + (Convert.ToString(dr["MiddleName"]) == "" ? "" : Convert.ToString(dr["MiddleName"])) + new string(' ', 20);
strOutput = memberNumber.Substring(0, 8) + "0";
strOutput += lastNameSuffix.Substring(0, 15);
strOutput += firstMiddle.Substring(0, 20) + "A0" + new string(' ', 59) + "0";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
private string BlueBookRosterList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.BlueBookRosterList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
DateTime dtMemberDate;
string memberDate = "";
if (DateTime.TryParse(Convert.ToString(dr["MemberDate"]), out dtMemberDate) == true)
{
memberDate = dtMemberDate.ToString("MMMM d, yyyy");
}
strOutput = (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : "");
strOutput += "\t" + Convert.ToString(dr["ReportName"]).Trim();
strOutput += Convert.ToString(dr["MembershipCategoryID"]) == "9" ? " " + Convert.ToString(dr["MilitaryServiceText"]) : (" " + Convert.ToString(dr["MembershipCategoryText"])) + (Convert.ToString(dr["MemberText"]) == "" ? "" : " " + Convert.ToString(dr["MemberText"]));
strOutput += "\t" + memberDate;
strOutput += "\t" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"])); // dum line of code why do we need to check? - Copied from BCIS
strOutput += "\t";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
private string SquirrelCampList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.SquirrelCampList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
string campNumber = "000" + Convert.ToString(dr["CampID"]);
campNumber = campNumber.Substring(campNumber.Length - 3, 3) + new string(' ', 8);
string campName = Convert.ToString(dr["CampName"]) + new string(' ', 35);
strOutput = campNumber.Substring(0, 8) + "0";
strOutput += campName.Substring(0, 35) + "A0" + new string(' ', 59) + "0";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
private string GroveMapNameList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.GroveMapNameList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
strOutput += Convert.ToString(dr["LastName"]) == "" ? "" : Convert.ToString(dr["LastName"]);
strOutput += Convert.ToString(dr["FirstName"]) == "" ? "" : " " + Convert.ToString(dr["FirstName"]);
strOutput += Convert.ToString(dr["MiddleName"]) == "" ? "" : " " + Convert.ToString(dr["MiddleName"]);
strOutput += Convert.ToString(dr["Suffix"]) == "" ? "" : " " + Convert.ToString(dr["Suffix"]);
strOutput += Convert.ToString(dr["CampName"]) == "" ? "" : (((char)9).ToString() + Convert.ToString(dr["CampName"]));
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
private string BlueBookHonoraryAssociateList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.BlueBookHonoraryAssociateList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
DateTime dtMemberDate;
string memberDate = "";
if (DateTime.TryParse(Convert.ToString(dr["MemberDate"]), out dtMemberDate) == true)
{
memberDate = dtMemberDate.ToString("MMMM d, yyyy");
}
strOutput = "/1" + (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : "");
strOutput += "/2" + Convert.ToString(dr["ReportName"]).Trim();
strOutput += "/3" + memberDate;
strOutput += "/4" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"]));
strOutput += "/5";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
/// <summary>
/// GetItem SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public ExportDataEN GetItem(ExportDataEN argEn)
{
try
{
ExportDataDAL loDs = new ExportDataDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Getlist SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public List <ExportDataEN> GetList(ExportDataEN argEn)
{
try
{
ExportDataDAL loDs = new ExportDataDAL();
return(loDs.GetList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Insert SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public bool Insert(ExportDataEN argEn)
{
bool flag;
try
{
ExportDataDAL loDs = new ExportDataDAL();
return(loDs.Insert(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Load All Active Export Data
/// </summary>
private void GetActiveData()
{
try
{
int i = 0;
ExportDataEN loen = new ExportDataEN();
ExportDataDAL lods = new ExportDataDAL();
loen.InterfaceID = "";
lolist = lods.GetList(loen);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Update SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public bool Update(ExportDataEN argEn)
{
//bool flag;
//using (TransactionScope ts = new TransactionScope())
//{
try
{
ExportDataDAL loDs = new ExportDataDAL();
return(loDs.Update(argEn));
//ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
//}
//return flag;
}
/// <summary>
/// Delete SAS_ExportData Data...
/// <summary>
/// <param name=sender></param>
/// <param name= e></param>
public bool Delete(ExportDataEN argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
ExportDataDAL loDs = new ExportDataDAL();
flag = loDs.Delete(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
private string OwlWorksCommitteeMemberList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.OwlWorksCommitteeMemberList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
string strOutput = "";
string strData = "";
foreach (DataColumn dc in dt.Columns)
{
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += dc.Caption;
}
sb.AppendLine(strOutput);
foreach (DataRow dr in dt.Rows)
{
strOutput = "";
foreach (DataColumn dc1 in dt.Columns)
{
strData = Convert.ToString(dr[dc1.Ordinal]);
if (dc1.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += strData;
}
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
//private readonly DataTable data = new DataTable(Settings.Default.DataTableName, Settings.Default.DataTableNamespace);
//private readonly string tempDir = Settings.Default.TemporaryDirectory;
//private readonly string templateFile = Settings.Default.TempateFilePath;
public bool ExportData(ObservableCollection <TransactionEntity> TransactionList, string FileName)
{
IExportDataDAL exportdata = new ExportDataDAL();
if (TransactionList != null)
{
int i = 0;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
foreach (var item in TransactionList)
{
if (item.IsChecked == true)
{
switch (item.ID)
{
//case 1:
// salesquotation = exportdata.GetSalesQuotationsList(item.StartDate, item.EndDate);
// dt = ToDataTable(salesquotation);
// i = 0;
// break;
//case 2:
// salesorder = exportdata.GetSalesOrdersList(item.StartDate, item.EndDate);
// dt = ToDataTable(salesorder);
// i = 0;
// break;
case 3:
salesinvoice = exportdata.GetSalesInvoicesList(item.StartDate, item.EndDate);
dt = ToDataTable(salesinvoice);
i = 0;
break;
case 4:
creditnotelist = exportdata.GetCreditNoteList(item.StartDate, item.EndDate);
dt = ToDataTable(creditnotelist);
i = 0;
break;
case 5:
purchaseinvoices = exportdata.GetPurchaseInvoicesList(item.StartDate, item.EndDate);
dt = ToDataTable(purchaseinvoices);
break;
case 6:
debitnotelist = exportdata.GetDebitNoteList(item.StartDate, item.EndDate);
dt = ToDataTable(debitnotelist);
i = 0;
break;
case 7:
pandssold = exportdata.GetPandSSoldList(item.StartDate, item.EndDate);
dt = ToDataTable(pandssold);
i = 0;
break;
case 8:
pandspurchase = exportdata.GetPandSPurchaseList(item.StartDate, item.EndDate);
dt = ToDataTable(pandspurchase);
i = 0;
break;
case 9:
gsttaxcollected = exportdata.GetGstTaxCollected(item.StartDate, item.EndDate);
dt = ToDataTable(gsttaxcollected);
i = 0;
break;
case 10:
gsttaxpaid = exportdata.GetGstTaxPaid(item.StartDate, item.EndDate);
dt = ToDataTable(gsttaxpaid);
i = 0;
break;
case 11:
gsttaxsummary = exportdata.GetGstTaxSummary(item.StartDate, item.EndDate);
dt = ToDataTable(gsttaxsummary);
i = 0;
break;
//case 9:
// salesquotation = exportdata.GetCashBankStatement(item.StartDate, item.EndDate);
// break;
//case 10:
// salesquotation = exportdata.GetGSTSummary(item.StartDate, item.EndDate);
// break;
//case 11:
// salesquotation = exportdata.GetGSTCollectedDetails(item.StartDate, item.EndDate);
// break;
//case 12:
// salesquotation = exportdata.GetGSTPaidDetails(item.StartDate, item.EndDate);
// break;
}
if (i == 0)
{
ds.Tables.Add(dt);
}
i++;
}
}
if (ds != null)
{
ExportToExcel(ds, FileName);
}
}
//ExportToExcel<Book, Books> s = new ExportToExcel<Book, Books>();
//ICollectionView view = CollectionViewSource.GetDefaultView(dgBook.ItemsSource);
//s.dataToPrint = (Books)view.SourceCollection;
//s.GenerateReport();
return(true);
}
public bool ExportDataMaster(ObservableCollection <MasterEntity> masterlist, string FileName)
{
IExportDataDAL exportdata = new ExportDataDAL();
if (masterlist != null)
{
int i = 0;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
foreach (var item in masterlist)
{
if (item.IsCheckedMaster == true)
{
switch (item.ID)
{
case 1:
customerdetail = exportdata.GetCustomerDetailList();
dt = ToDataTable(customerdetail);
i = 0;
break;
case 2:
supplierdetail = exportdata.GetSupplierDetailList();
dt = ToDataTable(supplierdetail);
i = 0;
break;
case 3:
pandsdetail = exportdata.GetPandSDetailList();
dt = ToDataTable(pandsdetail);
i = 0;
break;
case 4:
accountdetail = exportdata.GetAccountDetailList();
dt = ToDataTable(accountdetail);
i = 0;
break;
case 5:
taxcodesrates = exportdata.GetTaxCodeRatelList();
dt = ToDataTable(taxcodesrates);
i = 0;
break;
case 7:
trialbalancedetail = exportdata.GetTrialBalanceDetailList();
dt = ToDataTable(trialbalancedetail);
i = 0;
break;
case 8:
profitandlossdetail = exportdata.GetProfitandLossDetailList();
dt = ToDataTable(profitandlossdetail);
i = 0;
break;
case 9:
balancesheetdetail = exportdata.GetBalanceSheetDetailList();
dt = ToDataTable(balancesheetdetail);
i = 0;
break;
}
if (i == 0)
{
ds.Tables.Add(dt);
}
i++;
}
}
if (ds != null)
{
ExportToExcel(ds, FileName);
}
}
return(true);
}
public DataTable MailingPostalMemeberList()
{
return(ExportDataDAL.MailingPostalMemeberList());
}
public DataTable MailingActiveMemeberList()
{
return(ExportDataDAL.MailingActiveMemeberList());
}
private string OwlWorksWaitingListList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.OwlWorksWaitingListList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
string strOutput = "";
string strData = "";
DateTime datDate = new DateTime();
string memberId = "";
foreach (DataColumn dc in dt.Columns)
{
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += dc.Caption;
}
sb.AppendLine(strOutput);
foreach (DataRow dr in dt.Rows)
{
strOutput = "";
foreach (DataColumn dc in dt.Columns)
{
strData = Convert.ToString(dr[dc.Ordinal]);
switch (dc.Caption)
{
case "BirthDate":
case "MemberDate":
case "ProbationaryDate":
case "ApplicationDate":
case "EWLDate":
case "WhiteAppApprovedDate":
case "WhiteAppReceivedDate":
{
if (DateTime.TryParse(strData, out datDate) == true)
{
strData = datDate.ToString("MM/dd/yyyy");
}
else
{
strData = "";
}
break;
}
case "YearsInClub":
memberId = Convert.ToString(dr["MemberID"]);
strData = oEM.GetYearsInClub(memberId).ToString();
break;
default:
break;
}
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += strData;
}
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
private string OwlWorksAssociateList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.OwlWorksAssociateList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
string strOutput = "";
string strData = "";
DateTime datDate = new DateTime();
foreach (DataColumn dc in dt.Columns)
{
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += dc.Caption;
}
sb.AppendLine(strOutput);
foreach (DataRow dr in dt.Rows)
{
strOutput = "";
foreach (DataColumn dc1 in dt.Columns)
{
strData = Convert.ToString(dr[dc1.Ordinal]);
switch (dc1.Caption)
{
case "ProbationaryDate":
case "HonoraryDate":
case "WhiteAppApprovedDate":
case "WhiteAppReceivedDate":
{
if (DateTime.TryParse(strData, out datDate) == true)
{
strData = datDate.ToString("MM/dd/yyyy");
}
else
{
strData = "";
}
break;
}
default:
break;
}
if (dc1.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += strData;
}
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}
public DataTable SpecialMember_WaitingList()
{
return(ExportDataDAL.SpecialMember_WaitingList());
}
public DataTable SpecialMember_CommitteeMemberList()
{
return(ExportDataDAL.SpecialMember_CommitteeMemberList());
}
public DataTable SpecialMember_AssociateGroupList()
{
return(ExportDataDAL.SpecialMember_AssociateGroupList());
}
public DataTable SpecialMember_AssociateGroupMembers(string associateGroupId)
{
return(ExportDataDAL.SpecialMember_AssociateGroupMembers(associateGroupId));
}
private string GroveMapCamps()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.GroveMapCamps();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
int coCaptainIndex = 0;
int coCaptainCount = 0;
bool isFirstMember = true;
string campId = Convert.ToString(dr["CampID"]);
string campName = Convert.ToString(dr["CampName"]);
sb.AppendLine(campName);
DataTable dtCampMembers = this.GroveMapCampMemberList(campId);
if (dtCampMembers != null && dtCampMembers.Rows != null && dtCampMembers.Rows.Count > 0)
{
foreach (DataRow drMem in dtCampMembers.Rows)
{
if (Convert.ToString(drMem["CampPositionID"]) == Helper.CAMP_POSITION_CO_CAPTAIN)
{
coCaptainCount++;
}
}
foreach (DataRow drMem in dtCampMembers.Rows)
{
string campPositionId = Convert.ToString(drMem["CampPositionID"]);
if (campPositionId == Helper.CAMP_POSITION_CAPTAIN)
{
strOutput = Convert.ToString(drMem["Prefix"]) == "" ? "" : Convert.ToString(drMem["Prefix"]);
strOutput += Convert.ToString(drMem["FirstName"]) == "" ? "" : " " + Convert.ToString(drMem["FirstName"]);
strOutput += Convert.ToString(drMem["MiddleName"]) == "" ? "" : " " + Convert.ToString(drMem["MiddleName"]);
strOutput += Convert.ToString(drMem["LastName"]) == "" ? "" : " " + Convert.ToString(drMem["LastName"]);
strOutput += Convert.ToString(drMem["Suffix"]) == "" ? "" : " " + Convert.ToString(drMem["Suffix"]);
strOutput += ", Captain, and Messrs. ";
}
if (campPositionId == Helper.CAMP_POSITION_CO_CAPTAIN)
{
if (coCaptainIndex == 0)
{
strOutput = "Messrs. ";
}
else
{
strOutput += " and ";
}
strOutput += Convert.ToString(drMem["FirstName"]) == "" ? "" : " " + Convert.ToString(drMem["FirstName"]);
strOutput += Convert.ToString(drMem["MiddleName"]) == "" ? "" : " " + Convert.ToString(drMem["MiddleName"]);
strOutput += Convert.ToString(drMem["LastName"]) == "" ? "" : " " + Convert.ToString(drMem["LastName"]);
strOutput += Convert.ToString(drMem["Suffix"]) == "" ? "" : " " + Convert.ToString(drMem["Suffix"]);
coCaptainIndex++;
if (coCaptainIndex == coCaptainCount)
{
strOutput += ", Co-Captains, and Messrs. ";
}
}
if (campPositionId != Helper.CAMP_POSITION_CAPTAIN && campPositionId != Helper.CAMP_POSITION_CO_CAPTAIN)
{
if (isFirstMember == false)
{
strOutput += ", ";
}
strOutput += Convert.ToString(drMem["FirstName"]) == "" ? "" : " " + Convert.ToString(drMem["FirstName"]);
strOutput += Convert.ToString(drMem["MiddleName"]) == "" ? "" : " " + Convert.ToString(drMem["MiddleName"]);
strOutput += Convert.ToString(drMem["LastName"]) == "" ? "" : " " + Convert.ToString(drMem["LastName"]);
strOutput += Convert.ToString(drMem["Suffix"]) == "" ? "" : " " + Convert.ToString(drMem["Suffix"]);
isFirstMember = false;
}
}
sb.AppendLine(strOutput);
}
sb.AppendLine("");
sb.AppendLine("");
}
}
return(sb.ToString());
}
private DataTable GroveMapCampMemberList(string campId)
{
return(ExportDataDAL.GroveMapCampMemberList(campId));
}