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)); }