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; }
public bool VerifyAppointmentLimit(int nContactID) { TblAppointment appt = new TblAppointment(); DataTable table = appt.LoadData("Select COUNT (*) as nCount From TblAppointment where nContactID = @nContactID group by strReceiptNo", new string[] { "@nContactID" }, new object[] { nContactID }); decimal netTotal = 0; if (table.Rows.Count > 0) netTotal = ACMS.Convert.ToDecimal(table.Rows[0]["mSubTotal"]); return true; }