public static bool VerifyMemberPackageAllowCertainService(int nPackageID, string strServiceCode)
{
string cmdText = " Select Count (*) from tblPackageService A " +
" inner join tblMemberPackage B on A.strPackageCode = B.strPackageCode " +
" Where B.nPackageID = @nPackageID and A.strServiceCode = @strServiceCode";
TblServiceSession serviceSession = new TblServiceSession();
object obj = serviceSession.ExecuteScalar(cmdText, new string[] { "@nPackageID", "@strServiceCode" }, new object[] { nPackageID, strServiceCode });
if (obj != null)
{
Int32 r = (Int32)obj;
if (r > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
public static bool IsMemberExceedUOBBookingThisMonth(string strMembershipID, DateTime uobBookingDate)
{
TblCompany comp = new TblCompany();
DataTable table = comp.SelectAll();
DataRow compMasterRow = table.Rows[0];
int nUOBMonthlyBooking = ACMS.Convert.ToInt32(compMasterRow["nUOBMonthlyBooking"]);
TblServiceSession serviceSession = new TblServiceSession();
DataTable uobBookingTable = serviceSession.GetUOBBookingServiceSessionBaseMembershipID(strMembershipID);
int uobBookingMade = 0;
if (uobBookingTable != null && uobBookingTable.Rows.Count > 0)
{
foreach (DataRow r in uobBookingTable.Rows)
{
DateTime serviceSessionDate = ACMS.Convert.ToDateTime(r["dtDate"]);
if (serviceSessionDate != DateTime.MinValue)
{
if (serviceSessionDate.Month == uobBookingDate.Month &&
serviceSessionDate.Year == uobBookingDate.Year)
{
uobBookingMade++;
}
}
}
}
return(uobBookingMade >= nUOBMonthlyBooking);
}
public void DeleteCreditPackageUsage(int nPackageID)
{
int nCreditPackageID;
TblServiceSession ssUsage = new TblServiceSession();
ssUsage.NPackageID = nPackageID;
DataTable tblUsage = ssUsage.SelectAllWnPackageIDLogic();
if (tblUsage.Rows.Count > 0)
{
throw new Exception("You Cant deleted a Used Package.");
}
TblMemberPackage mmbPckg = new TblMemberPackage();
mmbPckg.NPackageID = nPackageID;
DataTable table = mmbPckg.SelectOne();
if (table == null || table.Rows.Count == 0)
{
throw new Exception("The Data has been deleted from database.");
}
mmbPckg.NStatusID = 2;
mmbPckg.Update();
nCreditPackageID = mmbPckg.NCreditPackageID.Value;
//Check any package redeemed from this credit package
ACMSDAL.TblMemberPackage memberPackage = new TblMemberPackage();
string cmdText = "Select COUNT(*) from TblMemberPackage Where (nStatusID = 0 or nStatusID = 1) AND " +
" nCreditPackageID = @nCreditPackageID ";
int nExist = (int)memberPackage.ExecuteScalar(cmdText, new string [] { "@nCreditPackageID" }, new object[] { nCreditPackageID });
if (nExist == 0)
{
TblMemberCreditPackage creditPackage = new TblMemberCreditPackage();
creditPackage.NCreditPackageID = nCreditPackageID;
creditPackage.SelectOne();
creditPackage.DtStartDate = SqlDateTime.Null;
creditPackage.DtExpiryDate = SqlDateTime.Null;
creditPackage.Update();
}
}
public DataTable GetMemberPackage(string strMemberShipID)
{
TblMemberPackage memberPackege = new TblMemberPackage();
DataTable table = memberPackege.GetActiveMemberPackageForServiceSession();
if (!table.Columns.Contains("Balance"))
{
DataColumn colBalance = new DataColumn("Balance", System.Type.GetType("System.Int32"));
table.Columns.Add(colBalance);
}
TblClassAttendance classAttendance = new TblClassAttendance();
TblServiceSession serviceSession = new TblServiceSession();
foreach (DataRow r in table.Rows)
{
int nCategoryID = ACMS.Convert.ToInt32(r["nCategoryID"]);
int nPackageID = ACMS.Convert.ToInt32(r["nPackageID"]);
// class Attendance
if (nCategoryID == 1 || nCategoryID == 2)
{
classAttendance.NPackageID = nPackageID;
DataView classAttendanceTable = classAttendance.SelectAllWnPackageIDLogic().DefaultView;
classAttendanceTable.RowFilter = "nStatusID = 1 or nStatusID = 2";
r["Balance"] = ACMS.Convert.ToInt32(r["nMaxSession"]) - classAttendanceTable.Count;
}
else if (nCategoryID == 4 || nCategoryID == 5 || nCategoryID == 6) // Service Session
{
serviceSession.NPackageID = nPackageID;
DataView serviceSessionTable = serviceSession.SelectAllWnPackageIDLogic().DefaultView;
serviceSessionTable.RowFilter = "nStatusID = 5 or nStatusID = 6";
r["Balance"] = ACMS.Convert.ToInt32(r["nMaxSession"]) - serviceSessionTable.Count;
}
}
return(table);
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
//if (DateTime.Compare(dtEdtStartTime.DateTime.Date, DateTime.Today.Date) < 0)
//{
// if (oUser.NRightsLevelID() >= 1003 && oUser.NRightsLevelID() <= 1004 )
// {
// MessageBox.Show(this, "Invalid Date. Pls choose other date.");
// this.DialogResult = DialogResult.None;
// return;
// }
//}
if (lkpEdtBranchCode.Text == "")
{
MessageBox.Show(this, "Please select a branch.");
this.DialogResult = DialogResult.None;
//return;
}
else if (lkpEdtEmployeeID.Text == "")
{
MessageBox.Show(this, "Please select a therapist");
this.DialogResult = DialogResult.None;
//return;
}
else if (lkpEdtServiceCode.Text == "")
{
MessageBox.Show(this, "Please select a treatment.");
this.DialogResult = DialogResult.None;
//return;
}
else
{
try
{
TblEmployee myTherapist = new TblEmployee();
myTherapist.NEmployeeID = this.TherapistID;
DataTable tblTherapist = myTherapist.SelectOne();
MemberPackage myMemPackage = new MemberPackage();
DataTable tblMemberPackageBalance = MemberPackage.CalculateMemberPackageBalance(this.ServiceCode, myMemberShipID, myPackageID);
myPackageBalance = (Convert.ToInt32(tblMemberPackageBalance.Rows[0]["Balance"].ToString()) - Convert.ToInt32(this.NQuantity));
string strBalance = myPackageBalance.ToString();
string strTherapist = tblTherapist.Rows[0]["strEmployeeName"].ToString();
string strDateTime = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt");
string strDateTimeMM = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
string strExpiryDate = Convert.ToDateTime(tblMemberPackageBalance.Rows[0]["dtExpiryDate"]).ToString("dd/MM/yyyy");
//** Insert Signature eric 15052009
//==================================
string strSignatureID = "";
string strKeyData = "";
string strPdfExportPath = "";
//int mySessionID = 0;
DataTable dtss = new DataTable();
dtss.Columns.Add("nSessionID", typeof(int));
dtss.Columns.Add("strMembershipID", typeof(string));
mydtSessionID = dtss;
//Key data format for Spa Service Utilisation
//MemberID|DateTime|ExpiryDate|Branch|Therapist|PkgCode|ServCode|Qty|Bal
strPdfExportPath = (string)ConfigurationSettings.AppSettings["SaveSpaServiceReceiptPath"].ToString() + "\\" + User.BranchCode + "\\" + myMemberShipID.Trim() + "_" + strDateTime.Replace(":", "").Replace(" ", "").Replace("/", "") + ".pdf";
strKeyData = myMemberShipID.Trim() + "|" + strExpiryDate + "|" + this.BranchCode + "|" + strTherapist + "|" + myPackageCode + "|" + this.ServiceCode + "|" + strBalance + "|" + this.NQuantity;
myKeyData = strKeyData;
if (myPackageCategoryID == 4 || myPackageCategoryID == 5 || myPackageCategoryID == 6 || myPackageCategoryID == 34)
{
MemberPackage myMemberPackage = new MemberPackage();
myMemberPackage.NewServiceSession(myPackageID, this.ServiceCode, myMemberShipID.Trim(),
this.TherapistID, this.BranchCode, this.Date, this.StartTime, this.TreatmentDate, strSignatureID,
System.Convert.ToInt32(this.NQuantity), false, myPackageCategoryID, strKeyData,
strPdfExportPath, ref mydtSessionID, this.SsRemark);
}
else
{
MemberPackage myMemberPackage = new MemberPackage();
myMemberPackage.NewServiceSession(myPackageID, this.ServiceCode, myMemberShipID.Trim(),
this.TherapistID, this.BranchCode, this.Date, this.StartTime, this.TreatmentDate, strSignatureID,
System.Convert.ToInt32(this.NQuantity), false, myPackageCategoryID, "", "", this.SsRemark);
}
bool outputPrint = false;
//Derek From Credit Package Usage Do not print
if (!myIsFromCreditUsage)
{
if (myPackageCategoryID == 4 || myPackageCategoryID == 5 || myPackageCategoryID == 6 || myPackageCategoryID == 34)
{
DigSignature frmSig = new DigSignature(strKeyData, "ServiceUtilisation", null, null, dtServiceUtilization);
DialogResult result1 = frmSig.ShowDialog();
if (result1 == DialogResult.OK)
{
strSignatureID = frmSig.ShowSignature();
//**DEREK Update Service Session Signature ID **
try
{
foreach (DataRow row in mydtSessionID.Rows)
{
//Derek Need Fixing Here - Update only strSignatureID and strPdfExportPath
TblServiceSession myServiceSessionSigPath = new TblServiceSession();
if (strSignatureID.Trim() != "" && strSignatureID.Trim() != "300D0A300D0A")
{
myServiceSessionSigPath.UpdateServiceSessionSigPdfPath(strSignatureID, strKeyData, strPdfExportPath, Convert.ToInt32(row["nSessionID"]), myMemberShipID);
}
else
{
myServiceSessionSigPath.UpdateServiceSessionSigPdfPath(strPdfExportPath, Convert.ToInt32(row["nSessionID"]), myMemberShipID);
}
}
}
catch { }
outputPrint = true;
/*if (strSignatureID == null || strSignatureID == "")
* {
* DialogResult yes = MessageBox.Show(this, "Member haven't signed on signature pad. Confirm to print?", "Warning", MessageBoxButtons.YesNo);
* if (yes == DialogResult.No)
* return;
* }*/
//============================================
//InitMemberPackage(CurrentMembershipID);
//OnMemberPackageGridFocusRowChanged();
}
//OnPrintMemberPackageUsage(tblTherapist.Rows[0]["strEmployeeName"].ToString(), CurrentMembershipID, MemberPackageStrPackageCode, frm.ServiceCode, strBalance);//eric 18052009
//**Call Print Package A/C report
//rpt.PrintRpt(strSignatureID, CurrentMembershipID, strDateTime, frm.BranchCode, strTherapist, MemberPackageStrPackageCode, frm.ServiceCode, strBalance);
PackageAccountRpt rpt = new PackageAccountRpt();
rpt.PrintRpt("Therapist Name :", strSignatureID, strKeyData, myMemberShipID.Trim(), strDateTimeMM, strExpiryDate, this.BranchCode, strTherapist, myPackageCode, this.ServiceCode, strBalance, this.NQuantity);
rpt.ExportToPdf(strPdfExportPath);
if (outputPrint)
{
rpt.Print();
}
}
}
else
{
if (myPackageCategoryID == 4 || myPackageCategoryID == 5 || myPackageCategoryID == 6 || myPackageCategoryID == 34)
{
//Update DataTable
DataTable dt = new DataTable();
dt.Columns.Add("Caption", typeof(string));
dt.Columns.Add("MemberID", typeof(string));
dt.Columns.Add("DateTime", typeof(string));
dt.Columns.Add("ExpiryDate", typeof(string));
dt.Columns.Add("BranchCode", typeof(string));
dt.Columns.Add("StaffName", typeof(string));
dt.Columns.Add("PackageCode", typeof(string));
dt.Columns.Add("PackageDesc", typeof(string));//lblPackageDesc.Text
dt.Columns.Add("ServiceCode", typeof(string));
dt.Columns.Add("Balance", typeof(string));
dt.Columns.Add("Quantity", typeof(int));
//dt.Columns.Add("mySessionID", typeof(int));
//DEREK Need Fixing Here - Need A Different DataTable to Store SessionID
dt.Rows.Add("Therapist Name :", myMemberShipID.Trim(), strDateTimeMM, strExpiryDate, this.BranchCode, strTherapist, myPackageCode,
lblPackageDesc.Text.ToString(), this.ServiceCode, strBalance, this.NQuantity);
mydtServiceUtilization = dt;
}
}
}
catch (Exception ex)
{
this.DialogResult = DialogResult.None;
MessageBox.Show(this, ex.Message);
}
}
}
private void Init()
{
myServiceSession = new TblServiceSession();
}
