public bool VerifyAppointment(int verifyUserID, string verifyUserPassword, int nAppointmentID)
{
TblEmployee verifyUser = new TblEmployee();
verifyUser.NEmployeeID = verifyUserID;
verifyUser.SelectOne();
if (verifyUser.StrPassword.IsNull)
{
throw new Exception("Invalid User ID or Password");
}
if (verifyUser.StrPassword.Value != verifyUserPassword)
{
throw new Exception("Invalid User ID or Password");
}
TblAppointment myAppointment = new TblAppointment();
myAppointment.NAppointmentId = nAppointmentID;
myAppointment.SelectOne();
if (!myAppointment.NVerifiedBy.IsNull)
{
throw new Exception("This appointment have been verified by other staff with the employee ID : " + myAppointment.NVerifiedBy.Value.ToString());
}
myAppointment.NVerifiedBy = verifyUserID;
//myAppointment.NStatus = 1;
myAppointment.Update();
return(true);
}
public bool Login(string nEmployeeID, string strPassword)
{
TblEmployee oEmployee = new TblEmployee();
DataTable dtEmployee;
int rowCount;
ACMSDAL.TblEmployee emp = new ACMSDAL.TblEmployee();
DataTable dt = emp.SelectAll();
int empId = int.MinValue;
DataRow row;
foreach (DataRow tempLoopVar_row in dt.Rows)
{
row = tempLoopVar_row;
if (row["strEmployeeName"].ToString() == nEmployeeID)
{
empId = System.Convert.ToInt32(row[0].ToString());
}
}
oEmployee.NEmployeeID = new SqlInt32(empId);
oEmployee.StrPassword = new SqlString(strPassword.Trim());
try
{
dtEmployee = oEmployee.SelectOne();
rowCount = dtEmployee.Rows.Count;
if (dtEmployee.Rows.Count > 0)
{
DataRow dr;
dr = dtEmployee.Rows[0];
if (rowCount > 0 && dr[2].ToString() == strPassword)
{
EmployeeID = oEmployee.NEmployeeID.Value;
EmployeeName = oEmployee.StrEmployeeName.ToString();
JobPositionCode = oEmployee.StrJobPositionCode.ToString();
BranchCode = oEmployee.StrBranchCode.ToString();
RightsLevelID = oEmployee.NRightsLevelID.Value;
DepartmentID = oEmployee.NDepartmentID.Value;
dtCessation = System.Convert.ToDateTime(oEmployee.DtCessation.Value);
//RoadShow= ch
return(true);
}
}
else
{
return(false);
}
// oEmployee.Dispose();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
return(true);
}
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);
}
}
}
