public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Admission Fee";
float[] size = new float[] { 4, 4, 4, 4 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Collection", "Total" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM AdmissionFee WHERE CAST(Admission_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["Admission_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["Admission_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["Admission_Collection"].ToString());
myPDF.AddToTable(reader["Admission_Total"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDFLedger(DateTime?FromDate, DateTime?ToDate, int id)
{
string pageTitle = "Monthly Deposit";
float[] size = new float[] { 3, 2, 3, 3, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Account No", "Member ID", "Date", "Details", "Deposit", "Withdraw", "Balance" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * From MonthlyDepositLedger where FixedId = " + id + " AND CAST(MonthlyDate AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["MonthlyEntryId"].ToString());
myPDF.AddToTable(reader["MonthlyId"].ToString());
myPDF.AddToTable(reader["MemberId"].ToString());
DateTime OnlyDate = (DateTime)reader["MonthlyDate"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["MonthlyDetails"].ToString());
myPDF.AddToTable(reader["MonthlyDeposit"].ToString());
myPDF.AddToTable(reader["MonthlyWithdraw"].ToString());
myPDF.AddToTable(reader["MonthlyBalance"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Loanee List";
float[] size = new float[] { 3, 3, 3, 3, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Loan No.", "Name", "Account ID", "Amount", "Balance", "Method", "Last Paid", "Total" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
Connection conn = new Connection();
conn.OpenConection();
string query = "Select m.MemberName, l.* From LoanDetails l Left Join Member m ON l.LoanDetails_Account=m.MemberId";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["LoanDetails_Id"].ToString());
myPDF.AddToTable(reader["MemberName"].ToString());
myPDF.AddToTable(reader["LoanDetails_Account"].ToString());
myPDF.AddToTable(reader["LoanDetails_Amount"].ToString());
myPDF.AddToTable(reader["LoanDetails_Balance"].ToString());
myPDF.AddToTable(reader["LoanDetails_Collection"].ToString());
DateTime OnlyDate = (DateTime)reader["LoanDetails_LastPaid"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["LoanDetails_Total"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Reserved Fund";
float[] size = new float[] { 3, 3, 3, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Previous", "Current", "Remaining", "Withdraw", "Total" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM ReservedFund WHERE CAST(Reserved_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["Reserved_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["Reserved_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["Reserved_Previous"].ToString());
myPDF.AddToTable(reader["Reserved_Current"].ToString());
myPDF.AddToTable(reader["Reserved_Remaining"].ToString());
myPDF.AddToTable(reader["Reserved_Withdraw"].ToString());
myPDF.AddToTable(reader["Reserved_Total"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Cash in Hand";
float[] size = new float[] { 3, 3, 3, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Previous", "Deposit", "Expenses", "Remains", "Total" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM CashInformation WHERE CAST(Cash_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["Cash_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["Cash_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["Cash_Previous"].ToString());
myPDF.AddToTable(reader["Cash_Deposit"].ToString());
myPDF.AddToTable(reader["Cash_Expenses"].ToString());
myPDF.AddToTable(reader["Cash_Remains"].ToString());
myPDF.AddToTable(reader["Cash_Total"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Bank Account Information";
float[] size = new float[] { 3, 3, 3, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Deposit", "Interest", "Withdraw", "Service Charge", "Remains" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM BankAccount WHERE CAST(BankAccount_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["BankAccount_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["BankAccount_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["BankAccount_Deposit"].ToString());
myPDF.AddToTable(reader["BankAccount_Interest"].ToString());
myPDF.AddToTable(reader["BankAccount_Withdraw"].ToString());
myPDF.AddToTable(reader["BankAccount_ServiceCharge"].ToString());
myPDF.AddToTable(reader["BankAccount_Remains"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDFLedger(DateTime?FromDate, DateTime?ToDate, string method)
{
string pageTitle = "Loan Ledger";
float[] size = new float[] { 3, 2, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Loan ID", "Collection", "Installment", "Balance" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM [LoanCollection] WHERE LoanCollection_Method = '" + method + "' AND CAST(LoanCollection_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["LoanCollection_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["LoanCollection_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["LoanCollection_Loan"].ToString());
myPDF.AddToTable(reader["LoanCollection_Collection"].ToString());
myPDF.AddToTable(reader["LoanCollection_Installment"].ToString());
myPDF.AddToTable(reader["LoanCollection_Balance"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDF(DateTime?FromDate, DateTime?ToDate)
{
string pageTitle = "Cooperative Development Fund";
float[] size = new float[] { 3, 4, 3, 3, 4, 4 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Current", "Paid", "Previous", "Remains" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM CooperativeDevelopment WHERE CAST(Cooperative_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["Cooperative_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["Cooperative_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["Cooperative_Current"].ToString());
myPDF.AddToTable(reader["Cooperative_Paid"].ToString());
myPDF.AddToTable(reader["Cooperative_Previous"].ToString());
myPDF.AddToTable(reader["Cooperative_Remains"].ToString());
}
conn.CloseConnection();
myPDF.Done();
}
public void PublishPDFIndividualLedger(DateTime?FromDate, DateTime?ToDate, int id, string method)
{
string pageTitle = "Loan Ledger";
float[] size = new float[] { 3, 2, 3, 3, 3, 3 };
string[] tableHeaders = new String[] { "Entry No.", "Date", "Loan ID", "Collection", "Installment", "Balance" };
PDF myPDF = new PDF(pageTitle, size, tableHeaders);
string FDate = FromDate?.ToString("yyyyMMdd");
string TDate = ToDate?.ToString("yyyyMMdd");
Connection conn = new Connection();
conn.OpenConection();
string query = "SELECT * FROM [LoanCollection] WHERE LoanCollection_Method = '" + method + "' AND LoanCollection_Loan = " + id + " AND CAST(LoanCollection_Date AS date) BETWEEN '" + FDate + "' and '" + TDate + "'";
SqlDataReader reader = conn.DataReader(query);
while (reader.Read())
{
myPDF.AddToTable(reader["LoanCollection_Id"].ToString());
DateTime OnlyDate = (DateTime)reader["LoanCollection_Date"];
myPDF.AddToTable(OnlyDate.ToString("dd-MM-yyyy"));
myPDF.AddToTable(reader["LoanCollection_Loan"].ToString());
myPDF.AddToTable(reader["LoanCollection_Collection"].ToString());
myPDF.AddToTable(reader["LoanCollection_Installment"].ToString());
myPDF.AddToTable(reader["LoanCollection_Balance"].ToString());
}
conn.CloseConnection();
Connection conn1 = new Connection();
conn1.OpenConection();
string firstquery = "Select m.MemberName From LoanDetails l Left Join Member m ON l.LoanDetails_Account=m.MemberId where l.LoanDetails_Id = " + id;
SqlDataReader reader1 = conn1.DataReader(firstquery);
string name = "";
while (reader1.Read())
{
name = "Name : " + reader1["MemberName"].ToString();
}
myPDF.AddParagraph("Name : " + name);
conn1.CloseConnection();
myPDF.Done();
}