public void PrintClassAttendanceReminder(int nPackageID, string strMembershipID, int nClassInstanceID)
{
TblCompany comp = new TblCompany();
DataTable compTable = comp.SelectAll();
int nClassLeft = 0;
int nDaysToExpire = 0;
if (compTable != null && compTable.Rows.Count > 0)
{
nClassLeft = ACMS.Convert.ToInt32(compTable.Rows[0]["nClassLeft"]);
nDaysToExpire = ACMS.Convert.ToInt32(compTable.Rows[0]["nDaysToExpire"]);
}
TblMemberPackage sqlMemberPackage = new TblMemberPackage();
DataTable memberPackageTable = sqlMemberPackage.GetMemberPackage(nPackageID);
ACMSLogic.MemberPackage.CalculateMemberPackageBalance(memberPackageTable.Rows[0]["strPackageCode"].ToString(),strMembershipID, memberPackageTable);
DateTime expiryDate = ACMS.Convert.ToDateTime(memberPackageTable.Rows[0]["dtExpiryDate"]);
TblMember member = new TblMember();
DataTable memberTable = member.LoadData("Select dtDOB, strMemberName from tblMember Where strMembershipID = @strMembershipID",
new string[] {"@strMembershipID"}, new object[] {strMembershipID});
ACMSLogic.Printing myReceiptPrinting = new Printing();
myReceiptPrinting.WriteLine(string.Format("Branch : {0} {1}", User.BranchCode,
DateTime.Now.ToString("dd/MM/yyyy hh:mm tt")));
myReceiptPrinting.WriteLine(string.Format("Membership ID : {0}", strMembershipID));
myReceiptPrinting.WriteLine(string.Format("Member Name : {0}", memberTable.Rows[0]["strMemberName"].ToString()));
myReceiptPrinting.WriteLine("");
if (memberPackageTable.Rows[0]["strPackageCode"].ToString() == "Unlinked")
{
myReceiptPrinting.WriteLine("No Valid Fitness Package.");
//DataTable packageTable = sqlMemberPackage.LoadData("select mListPrice from tblPackage Where strDescription = 'Trial Gym'");
//myReceiptPrinting.WriteLine("No Valid Fitness Package.");
myReceiptPrinting.Print();
return;
}
bool bClassPrint ;
bClassPrint=false;
if (memberPackageTable.Rows[0]["dtStartDate"] != DBNull.Value)
myReceiptPrinting.WriteLine(string.Format("Package Start On : {0}",
ACMS.Convert.ToDateTime(memberPackageTable.Rows[0]["dtStartDate"]).ToString("dd/MM/yyyy")));
if (memberPackageTable.Rows[0]["dtExpiryDate"] != DBNull.Value)
myReceiptPrinting.WriteLine(string.Format("Package Expiry Date : {0}",
ACMS.Convert.ToDateTime(memberPackageTable.Rows[0]["dtExpiryDate"]).ToString("dd/MM/yyyy")));
if (DateTime.Compare(ACMS.Convert.ToDBDateTime(memberPackageTable.Rows[0]["dtStartDate"]),DateTime.Today.Date)==0)
//if (memberPackageTable.Rows[0]["dtExpiryDate"] == DBNull.Value)
{
TblClassAttendance classAttendance = new TblClassAttendance();
classAttendance.NPackageID = nPackageID;
int totalClassAttend = classAttendance.SelectAllWnPackageIDLogic().Rows.Count;
if (totalClassAttend == 1)
{
myReceiptPrinting.WriteLine("Package Has Been Activated.");
bClassPrint = true;
}
}
//Print Day To Expiry
System.TimeSpan timeSpan = expiryDate.Date.Subtract(DateTime.Today.Date);
if (timeSpan.Days <= nDaysToExpire)
{
myReceiptPrinting.WriteLine(string.Format("Days To Expiry : {0}", timeSpan.Days));
bClassPrint = true;
}
//Print Member Package Balance
int balance = ACMS.Convert.ToInt32(memberPackageTable.Rows[0]["Balance"]);
if (balance <= nClassLeft)
{
myReceiptPrinting.WriteLine(string.Format("Balance Visit : {0} ", balance));
bClassPrint = true;
}
// Check Member Outstanding Receipt
TblReceipt receipt = new TblReceipt();
Decimal mTotalOutstanding = 0;
object obj= receipt.GetOutStandingBalance(strMembershipID);
if (obj != null)
{
mTotalOutstanding = (decimal)obj;
mTotalOutstanding = decimal.Round(mTotalOutstanding, 2);
}
if (mTotalOutstanding > 0)
{
myReceiptPrinting.WriteLine("Outstanding Cash Bill Check.");
bClassPrint = true;
}
if (memberPackageTable.Rows[0]["strRemarks"].ToString().Length > 0)
{
myReceiptPrinting.WriteLine("Refer To Member Package's Remark.");
bClassPrint = true;
}
if (ACMS.Convert.ToDateTime(memberTable.Rows[0]["DtDOB"]).Date == DateTime.Today.Date)
{
myReceiptPrinting.WriteLine("");
myReceiptPrinting.WriteLine(string.Format("Happy Birthday To {0}.",
memberTable.Rows[0]["strMemberName"].ToString()));
bClassPrint = true;
}
// myReceiptPrinting.Close;
if (bClassPrint == true)
{
myReceiptPrinting.Print();
}
else myReceiptPrinting.DelFile();
}
