public bool CloseAppointment(int nAppointmentID)
{
TblAppointment myAppointment = new TblAppointment();
myAppointment.NAppointmentId = nAppointmentID;
myAppointment.SelectOne();
myAppointment.NStatus = 2;
myAppointment.Update();
TblContacts myContact = new TblContacts();
myContact.UpdateLeadStatus(Convert.ToInt32(myAppointment.NContactId.Value), 0);
return true;
}
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;
}