protected void btnAdd_Click(object sender, EventArgs e)
    {
        string nhb = txtNHB.Text;

        if (nhb == "")
        {
            nhb = "0";
        }

        String res = AppointmentsDAL.AddAppointment
                         (Session["username"].ToString(),
                         txtTitle.Text,
                         txtText.Text,
                         txtDate.Text + " " + txtTime.Text,
                         nhb);

        if (res == null)
        {
            lblMsg.Text = "Successfully Added Appointment!";
        }
        else
        {
            lblMsg.Text = "Error -> " + res;
        }
    }
 public ActionResult savePersonalAppt(Personal_Appointment modelAppt)
 {
     try
     {
         if (ModelState.IsValid)
         {
             modelAppt.SalApptUserEntered = User.Identity.Name;
             if (AppointmentsDAL.SaveAppointment(modelAppt))
             {
                 return(RedirectToAction("index", "calendar"));
             }
             else
             {
                 LoadPersonalAppointmentCombos();
                 ModelState.AddModelError(String.Empty, BusinessConstants.duplicateRecord);
                 return(View("personal", modelAppt));
             }
         }
         else
         {
             LoadPersonalAppointmentCombos();
             ModelState.AddModelError(String.Empty, BusinessConstants.ValidateEntries);
             return(View("personal", modelAppt));
         }
     }
     catch (Exception ex)
     {
         LoadPersonalAppointmentCombos();
         ModelState.AddModelError(String.Empty, BusinessConstants.contactAdmin);
         return(View("personal", modelAppt));
     }
 }
 //
 // GET: /Calendar/
 public ActionResult Index()
 {
     ViewBag.Title = "Calendar";
     //this.ControllerContext.RouteData.Values["controller"].ToString();
     ViewBag.AssignToList = new SelectList(AppointmentsDAL.getAssignToList(), "CommID", "FullName");
     return(View());
 }
 private void SetViewBagForCombos(SAL03_ResAppointments appointments)
 {
     ViewBag.StartTime = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.SalApptStartTime);
     ViewBag.EndTime   = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.SalApptEndTime);
     ViewBag.FenceType = AppointmentsDAL.getComboLookupValue("Setup25_FenceTypes", "FenceTypeID", "FenceType", Convert.ToString(appointments.FenceTypeID));
     ViewBag.SalesType = AppointmentsDAL.getComboLookupValue("SAL10_SalesTypes", "SalTypeId", "SalType", Convert.ToString(appointments.SalTypeId));
 }
 private void LoadAppointmentCombos()
 {
     ViewBag.FenceTypesList    = new SelectList(AppointmentsDAL.getFenceTypesList(), "FenceTypeID", "FenceType");
     ViewBag.SalesTypeCallList = new SelectList(AppointmentsDAL.getSalesTypeList(), "SalTypeId", "SalType");
     ViewBag.StatesList        = new SelectList(DataAccess.Entity.Common.getStatesList(), "State", "StateName");
     ViewBag.ShowApptTime      = new SelectList(AppointmentsDAL.getTime(), "Setup40TimeID", "Setup40Time");
     ViewBag.AssignToList      = new SelectList(AppointmentsDAL.getAssignToList(), "CommID", "FullName");
 }
        public JsonResult GetCalendarEvents(string CommId)
        {
            var calendar = new List <Calendar_Evts>();

            if (!string.IsNullOrWhiteSpace(CommId))
            {
                calendar = AppointmentsDAL.getCalendarEvents(CommId);
            }
            return(Json(calendar, JsonRequestBehavior.AllowGet));
        }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        String selecteddate = Calendar1.SelectedDate.ToShortDateString();

        GridView1.DataSource = AppointmentsDAL.
                               GetAppointmentsByDate(Session["username"].ToString(),
                                                     selecteddate);

        GridView1.DataBind();
    }
        //
        // GET: /Appointment/Delete/5

        public ActionResult Delete(string id)
        {
            if (!string.IsNullOrWhiteSpace(id))
            {
                AppointmentsDAL.deleteAppointment(int.Parse(id));
                return(RedirectToAction("index"));
            }
            else
            {
                return(RedirectToAction("create", "appointments", id));
            }
        }
        public ActionResult Create(SAL03_ResAppointments modelAppt)
        {
            try
            {
                ModelState.Remove("SalApptId");
                if (!modelAppt.EmailExists)
                {
                    modelAppt.SalApptEmail = BusinessConstants.NA;
                    ModelState.Remove("SalApptEmail");
                }

                if (ModelState.IsValid)
                {
                    modelAppt.SalApptUserEntered = User.Identity.Name;
                    if (AppointmentsDAL.SaveAppointment(modelAppt))
                    {
                        return(RedirectToAction("index", "calendar"));
                    }
                    else
                    {
                        LoadAppointmentCombos();
                        ModelState.AddModelError(String.Empty, BusinessConstants.duplicateRecord);
                        return(View(modelAppt));
                    }
                }
                else
                {
                    LoadAppointmentCombos();
                    ModelState.AddModelError(String.Empty, BusinessConstants.ValidateEntries);
                    return(View(modelAppt));
                }
            }
            catch (Exception ex)
            {
                LoadAppointmentCombos();
                ModelState.AddModelError(String.Empty, BusinessConstants.contactAdmin);
                return(View(modelAppt));
            }
        }
        public ActionResult ShowApptById(string id)
        {
            var appointments = new ATL_Appointments();

            try
            {
                if (!string.IsNullOrWhiteSpace(id))
                {
                    appointments = AppointmentsDAL.getAppointmentDetails(int.Parse(id));
                    appointments.ScheduledAppointments.CommID             = AppointmentsDAL.getCommissionName(appointments.ScheduledAppointments.CommID);
                    appointments.ScheduledAppointments.SalApptUserEntered = AppointmentsDAL.getUsername(appointments.ScheduledAppointments.SalApptUserEntered);
                    appointments.ScheduledAppointments.SalApptPhone       = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptPhone);
                    appointments.ScheduledAppointments.SalApptPhoneExt    = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptPhoneExt);
                    appointments.ScheduledAppointments.SalApptFax         = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptFax);
                    appointments.ScheduledAppointments.SalApptMobile      = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptMobile);
                }
            }
            catch (Exception ex)
            {
                return(RedirectToAction("index"));
            }
            return(Json(appointments));
        }
        //
        // GET: /Appointment/Create

        public ActionResult Create(string id = "", string assign = "0")
        {
            LoadAppointmentCombos();
            id = string.IsNullOrWhiteSpace(id) ? "0" : Convert.ToString(id);
            int ApptId = int.Parse(id);



            if (ApptId == 0 || assign.Equals("1"))
            {
                ViewBag.Title = BusinessConstants.titleNewAppointments;
                var Appointment = new SAL03_ResAppointments();
                Appointment.SalApptStartDate = DateTime.Now.ToShortDateString();
                Appointment.SalApptEndDate   = DateTime.Now.ToShortDateString();

                return(View(Appointment));
            }
            else
            {
                var Appointment = AppointmentsDAL.getEditAppointment(ApptId);
                ViewBag.Title = BusinessConstants.titleEditAppointments;
                Appointment.SalApptStartDate = Convert.ToDateTime(Appointment.SalApptStartDate).ToShortDateString();
                Appointment.SalApptEndDate   = Convert.ToDateTime(Appointment.SalApptStartDate).ToShortDateString();
                if (String.IsNullOrWhiteSpace(Appointment.SalApptEmail) ||
                    Appointment.SalApptEmail.Equals(BusinessConstants.NA))
                {
                    Appointment.SalApptEmail = string.Empty;
                    Appointment.EmailExists  = false;
                }
                else
                {
                    Appointment.EmailExists = true;
                }
                return(View(Appointment));
            }
        }
        //
        // GET: /Appointment/Details/5

        public ActionResult Details(string id)
        {
            try
            {
                if (!string.IsNullOrWhiteSpace(id))
                {
                    ViewBag.Title = BusinessConstants.titleAppointments;
                    var appointments = AppointmentsDAL.getAppointmentDetails(int.Parse(id));

                    if (appointments.PersonalAppointments != null)
                    {
                        ViewBag.Title = BusinessConstants.titleEditPersonalAppointments;
                        LoadPersonalAppointmentCombos();
                        ViewBag.StartTime = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.PersonalAppointments.SalApptStartTime);
                        ViewBag.EndTime   = AppointmentsDAL.getComboLookupValue("Setup40_Time", "Setup40TimeID", "Setup40Time", appointments.PersonalAppointments.SalApptEndTime);
                        return(View("personal", appointments.PersonalAppointments));
                    }
                    appointments.ScheduledAppointments.CommID             = AppointmentsDAL.getCommissionName(appointments.ScheduledAppointments.CommID);
                    appointments.ScheduledAppointments.SalApptUserEntered = AppointmentsDAL.getUsername(appointments.ScheduledAppointments.SalApptUserEntered);
                    appointments.ScheduledAppointments.SalApptPhone       = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptPhone);
                    appointments.ScheduledAppointments.SalApptPhoneExt    = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptPhoneExt);
                    appointments.ScheduledAppointments.SalApptFax         = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptFax);
                    appointments.ScheduledAppointments.SalApptMobile      = DataAccess.Entity.Common.FormatPhoneText(appointments.ScheduledAppointments.SalApptMobile);
                    SetViewBagForCombos(appointments.ScheduledAppointments);
                    return(View(appointments.ScheduledAppointments));
                }
                else
                {
                    return(RedirectToAction("index"));
                }
            }
            catch (Exception ex)
            {
                return(RedirectToAction("index"));
            }
        }
 private void LoadPersonalAppointmentCombos()
 {
     ViewBag.ShowApptTime     = new SelectList(AppointmentsDAL.getTime(), "Setup40TimeID", "Setup40Time");
     ViewBag.AssignToList     = new SelectList(AppointmentsDAL.getAssignToList(), "CommID", "FullName");
     ViewBag.ApptDescriptions = new SelectList(AppointmentsDAL.getAppointmentDescriptions(), "SALApptDescId", "SALApptDesc");
 }
        public ActionResult Search(string lastName, string city, string zipCode)
        {
            var appointment = AppointmentsDAL.searchAppointment(lastName, city, zipCode);

            return(Json(appointment));
        }