Esempio n. 1
0
        protected void LoadRecords(GridView gv, Boolean FromDealer)
        {
            DateTime from = Convert.ToDateTime(this.txtFrom.Value + " 12:00AM");
            DateTime to   = Convert.ToDateTime(this.txtTo.Value + " 11:59PM");

            bool Todays = (this.ddlReportType.SelectedIndex == 0) ? true : false;

            SalitaEntities db = new SalitaEntities();

            IQueryable <v_CustomerNeeds> R = null;

            if (Todays)
            {
                R = db.v_CustomerNeeds.Where(p => p.FromDealer == FromDealer && p.WasFullfilled == false && p.RequestDateTime >= from && p.RequestDateTime <= to && (p.RequestedService_ID == 3 || p.RequestedService_ID == 4)).OrderBy(p => p.RequestDateTime).OrderBy(p => p.WasFullfilled);
            }
            else
            {
                R = db.v_CustomerNeeds.Where(p => p.FromDealer == FromDealer && p.RequestDateTime >= from && p.RequestDateTime <= to && (p.RequestedService_ID == 3 || p.RequestedService_ID == 4)).OrderBy(p => p.RequestDateTime).OrderBy(p => p.WasFullfilled);
            }

            gv.DataSource = R.ToList();
            gv.DataBind();

            if (R != null)
            {
                if (FromDealer)
                {
                    gv.Caption = "Llevar del dealer a destino: " + R.Count();
                }
                else
                {
                    gv.Caption = "Recojer en dirección y llevar al dealer: " + R.Count();
                }
            }
        }
Esempio n. 2
0
        protected void LoadRecords()
        {
            DateTime fromDate = Convert.ToDateTime(this.txtFrom.Value + " 12:00AM");
            DateTime toDate   = Convert.ToDateTime(this.txtTo.Value + " 11:59PM");

            bool Todays = (RadioButtonList1.SelectedIndex == 0) ? true : false;

            SalitaEntities db = new SalitaEntities();

            //var R = db.v_CustomerNeeds.Where(p => p.RequestDateTime >= from && p.RequestDateTime <= to).OrderBy(p => p.RequestDateTime);

            var R = from p in db.v_CustomerNeeds
                    where (p.RequestDateTime >= fromDate && p.RequestDateTime <= toDate)
                    group p by p.ServiceDescription into g
                    select new
            {
                name  = g.Key,
                count = g.Count()
            };

            this.gvRecords.DataSource = R.ToList();
            this.gvRecords.DataBind();

            if (R != null)
            {
                this.gvRecords.Caption = "Tipos de servicio: " + R.Count();
            }
        }
Esempio n. 3
0
        protected void cmdOK_Click(object sender, EventArgs e)
        {
            try
            {
                int vid = Convert.ToInt32(ViewState["vid"]);

                SalitaEntities db = new SalitaEntities();

                var V = db.Visits.Single(p => p.Visit_ID == vid);

                V.Mood = ViewState["m"].ToString();

                db.SaveChanges();

                UpdateHub.SendServer("");

                Response.Redirect("default.aspx");
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;

                if (E.InnerException != null)
                {
                    this.CustomValidator1.ErrorMessage += " InnerException: " + E.InnerException.Message;
                }
            }
        }
Esempio n. 4
0
        public static void FullfillService(int ID, string Note)
        {
            SalitaEntities db = new SalitaEntities();

            var Need = db.CustomerNeeds.Single(p => p.CustomerNeed_ID == ID);

            Need.WasFullfilled = true;

            db.SaveChanges();

            /*
             * if (this.txtServiceDesc.Text.Length > 19)
             * {
             *  if (this.txtServiceDesc.Text.Substring(0, 20) == "Transportacion Fuera")
             *  {
             *      // Take customer out of salita
             *      int Customer_ID = Convert.ToInt32(ViewState["Customer_ID"]);
             *
             *      Visit v = db.Visits.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.InLounge == true);
             *
             *      if (v != null)
             *      {
             *          v.InLounge = false;
             *
             *          db.SaveChanges();
             *      }
             *  }
             * }
             */
        }
Esempio n. 5
0
        protected void cbUseRegisteredAddress_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (cbUseRegisteredAddress.Checked)
                {
                    SalitaEntities db = new SalitaEntities();

                    int Customer_ID = Convert.ToInt32(ViewState["id"]);

                    var C = db.Customers.Single(p => p.Customer_ID == Customer_ID);

                    this.txtSendTo.Text  = C.Address;
                    this.txtZipCode.Text = C.ZipCode;
                    this.txtTown.Text    = C.Town;
                }
                else
                {
                    this.txtSendTo.Text  = "";
                    this.txtZipCode.Text = "";
                    this.txtTown.Text    = "";
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;
            }
        }
Esempio n. 6
0
        protected void FullfillService(int ID)
        {
            SalitaEntities db = new SalitaEntities();

            var Need = db.CustomerNeeds.Single(p => p.CustomerNeed_ID == ID);

            Need.WasFullfilled = true;

            db.SaveChanges();

            if (this.txtServiceDesc.Text.Length > 19)
            {
                if (this.txtServiceDesc.Text.Substring(0, 20) == "Transportacion Fuera")
                {
                    // Take customer out of salita
                    int Customer_ID = Convert.ToInt32(ViewState["Customer_ID"]);

                    Visit v = db.Visits.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.InLounge == true);

                    if (v != null)
                    {
                        v.InLounge = false;

                        db.SaveChanges();
                    }
                }
            }
        }
Esempio n. 7
0
        public static void LeaveLounge(int Customer_ID)
        {
            SalitaEntities db = new SalitaEntities();

            //
            // Cancel requests except for transportation
            //
            var Needs = db.CustomerNeeds.Where(p => p.Customer_ID == Customer_ID && p.WasFullfilled == false && p.Canceled == false && p.RequestedService_ID != 3 && p.RequestedService_ID != 4);

            foreach (CustomerNeed N in Needs)
            {
                SalitaEntities db2 = new SalitaEntities();

                var NeedToUpdate = db2.CustomerNeeds.Single(p => p.CustomerNeed_ID == N.CustomerNeed_ID);

                NeedToUpdate.Canceled = true;

                db2.SaveChanges();
            }

            //
            // Take customer out
            //
            var V = db.Visits.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.InLounge == true);

            if (V != null)
            {
                V.InLounge = false;

                db.SaveChanges();
            }
        }
Esempio n. 8
0
        protected void LoadNeed(int id)
        {
            SalitaEntities db = new SalitaEntities();

            var N = db.v_CustomerNeeds.Single(p => p.CustomerNeed_ID == id);

            this.lblFullName.Text = N.FullName;
        }
Esempio n. 9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    SalitaEntities db = new SalitaEntities();

                    if (Request.QueryString["id"] == null || Request.QueryString["vid"] == null)
                    {
                        this.cmdOK.Enabled = false;

                        throw new Exception("id or visit_id was not supplied.");
                    }
                    else
                    {
                        ViewState["Customer_ID"] = Request.QueryString["id"];
                        ViewState["m"]           = Request.QueryString["m"];
                        ViewState["vid"]         = Request.QueryString["vid"];

                        int    cid = Convert.ToInt32(ViewState["Customer_ID"]);
                        string m   = ViewState["m"].ToString();

                        Customer C = db.Customers.Single(p => p.Customer_ID == cid);

                        this.lblFullName.Text = C.FullName;

                        //CustomerService S = db.CustomerServices.Single(p => p.CustomerService_ID == sid);

                        //this.lblServiceRequested.Text = S.ServiceDescription;

                        if (m == "N")
                        {
                            this.imageIcon.ImageUrl = @"images\customer_neutral.png";
                        }
                        else if (m == "G")
                        {
                            this.imageIcon.ImageUrl = @"images\face_idle.png";
                        }
                        else if (m == "B")
                        {
                            this.imageIcon.ImageUrl = @"images\face_bad.png";
                        }
                    }
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;

                if (E.InnerException != null)
                {
                    this.CustomValidator1.ErrorMessage += " InnerException: " + E.InnerException.Message;
                }
            }
        }
Esempio n. 10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    SalitaEntities db = new SalitaEntities();

                    if (Request.QueryString["id"] == null || Request.QueryString["sid"] == null)
                    {
                        this.cmdOK.Enabled = false;

                        throw new Exception("id or sid was not supplied.");
                    }
                    else
                    {
                        ViewState["Customer_ID"] = Request.QueryString["id"];
                        ViewState["sid"]         = Request.QueryString["sid"];

                        int cid = Convert.ToInt32(ViewState["Customer_ID"]);
                        int sid = Convert.ToInt32(ViewState["sid"]);

                        Customer C = db.Customers.Single(p => p.Customer_ID == cid);

                        this.lblFullName.Text = C.FullName;

                        CustomerService S = db.CustomerServices.Single(p => p.CustomerService_ID == sid);

                        this.lblServiceRequested.Text = S.ServiceDescription;

                        if (sid == 1)
                        {
                            this.imageIcon.ImageUrl = @"images\pop_water.png";
                        }
                        else if (sid == 2)
                        {
                            this.imageIcon.ImageUrl = @"images\pop_soda.png";
                        }
                        else if (sid == 3)
                        {
                            this.imageIcon.ImageUrl = @"images\pop_cafe.png";
                        }
                    }
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;

                if (E.InnerException != null)
                {
                    this.CustomValidator1.ErrorMessage += " InnerException: " + E.InnerException.Message;
                }
            }
        }
Esempio n. 11
0
        protected void LoadLists()
        {
            SalitaEntities db = new SalitaEntities();

            var L = db.HourSlots.Where(p => p.IsActive == true).OrderBy(p => p.HourSlotOrder);

            this.cmbTime.DataSource     = L.ToList();
            this.cmbTime.DataTextField  = "HourSlotTime";
            this.cmbTime.DataValueField = "HourSlotTime";
            this.cmbTime.DataBind();
        }
Esempio n. 12
0
        protected void cmdOK_Click(object sender, EventArgs e)
        {
            try
            {
                int Service_ID = 3;

                int Customer_ID = Convert.ToInt32(ViewState["id"]);

                SalitaEntities db = new SalitaEntities();

                DateTime from = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 12:00AM");
                DateTime to   = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 11:59PM");

                if (db.CustomerNeeds.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.RequestDateTime >= from && p.RequestDateTime <= to && p.RequestedService_ID == Service_ID && p.WasFullfilled == false) == null)
                {
                    CustomerNeed S = new CustomerNeed();

                    S.Customer_ID         = Customer_ID;
                    S.RequestDateTime     = DateTime.Now;
                    S.WasFullfilled       = false;
                    S.RequestedService_ID = Service_ID; // 3 == fuera del dealer
                    S.Address_Line        = this.txtSendTo.Text;
                    S.Town       = this.txtTown.Text;
                    S.ZipCode    = this.txtZipCode.Text;
                    S.FromDealer = (this.cmbWhereTo.SelectedIndex == 0) ? true : false;
                    S.Canceled   = false;

                    db.CustomerNeeds.Add(S);
                    db.SaveChanges();

                    if (this.cbRoundTrip.Checked)
                    {
                        S.WasFullfilled       = false;
                        S.RequestedService_ID = 4; // 4 == transportacion al dealer
                        S.RequestDateTime     = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " " + this.cmbTime.SelectedValue);
                        S.FromDealer          = !S.FromDealer;
                        db.CustomerNeeds.Add(S);
                        db.SaveChanges();
                    }

                    Response.Redirect("report_transportation.aspx");
                }
                else
                {
                    throw new Exception("Ya existe un pedido de transportación para hoy el cliente con id: " + Customer_ID.ToString());
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;
            }
        }
Esempio n. 13
0
        protected void txtZipCode_TextChanged(object sender, EventArgs e)
        {
            if (this.txtZipCode.Text != "")
            {
                SalitaEntities db = new SalitaEntities();

                ListZip z = db.ListZips.SingleOrDefault(p => p.ZipCode == this.txtZipCode.Text);

                if (z != null)
                {
                    this.txtTown.Value = z.City;
                }
            }
        }
Esempio n. 14
0
        public static void ChangeSeat(int Customer_ID, int Seat_X, int Seat_Y)
        {
            SalitaEntities db = new SalitaEntities();

            var V = db.Visits.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.InLounge == true);

            if (V != null)
            {
                V.Seat_X = Seat_X;
                V.Seat_Y = Seat_Y;

                db.SaveChanges();
            }
        }
Esempio n. 15
0
        public static void SetService(int Customer_ID, int Service_ID, string Note)
        {
            SalitaEntities db = new SalitaEntities();

            var Need = new CustomerNeed();

            Need.RequestDateTime     = DateTime.Now;
            Need.Customer_ID         = Customer_ID;
            Need.WasFullfilled       = false;
            Need.Note                = Note;
            Need.RequestedService_ID = Service_ID;
            Need.Canceled            = false;

            db.CustomerNeeds.Add(Need);
            db.SaveChanges();
        }
Esempio n. 16
0
        protected void SetService(int Customer_ID, int Service_ID)
        {
            SalitaEntities db = new SalitaEntities();

            var Need = new CustomerNeed();

            Need.RequestDateTime     = DateTime.Now;
            Need.Customer_ID         = Customer_ID;
            Need.WasFullfilled       = false;
            Need.Note                = this.txtServiceNote.Text;
            Need.RequestedService_ID = Service_ID;
            Need.Canceled            = false;

            db.CustomerNeeds.Add(Need);
            db.SaveChanges();
        }
Esempio n. 17
0
        public static IEnumerable <v_CustomerNeeds> GetAllNeeds()
        {
            SalitaEntities db = new SalitaEntities();

            DateTime from = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 12:00AM");
            DateTime to   = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 11:59PM");

            var needs = db.v_CustomerNeeds.Where(p => p.WasFullfilled == false && p.Canceled == false && p.RequestDateTime >= from && p.RequestDateTime <= to).OrderBy(p => p.RequestDateTime);

            JavaScriptSerializer TheSerializer = new JavaScriptSerializer();

            var TheJson = TheSerializer.Serialize(needs.ToList());

            //return TheJson;

            return(needs);
        }
Esempio n. 18
0
        public static void ProcessService(int Customer_ID, int Service_ID)
        {
            SalitaEntities db = new SalitaEntities();

            if (db.CustomerNeeds.SingleOrDefault(p => p.Customer_ID == Customer_ID && p.RequestedService_ID == Service_ID && p.WasFullfilled == false) == null)
            {
                CustomerNeed S = new CustomerNeed();

                S.Customer_ID         = Customer_ID;
                S.RequestDateTime     = DateTime.Now;
                S.WasFullfilled       = false;
                S.RequestedService_ID = Service_ID;
                S.Canceled            = false;

                db.CustomerNeeds.Add(S);
                db.SaveChanges();
            }
        }
Esempio n. 19
0
        protected void LoadNeed(int id)
        {
            SalitaEntities db = new SalitaEntities();

            var N = db.v_CustomerNeeds.Single(p => p.CustomerNeed_ID == id);

            this.lblFullName.InnerText = "Editar transportación para el cliente: " + N.FullName;
            this.txtAddressLine1.Value = N.Address_Line;
            this.txtZipCode.Text       = N.ZipCode;
            this.txtTown.Value         = N.Town;

            string Time = N.RequestDateTime.Value.ToShortTimeString();

            if (this.cmbTime.Items.FindByText(Time) != null)
            {
                this.cmbTime.Items.FindByText(Time).Selected = true;
            }
        }
Esempio n. 20
0
        protected void lbEdit_Click(object sender, EventArgs e)
        {
            try
            {
                SalitaEntities db = new SalitaEntities();

                int id = Convert.ToInt32(ViewState["Service_ID"]);

                var N = db.CustomerNeeds.Single(p => p.CustomerNeed_ID == id);

                N.Address_Line    = this.txtAddressLine1.Value;
                N.Town            = this.txtTown.Value;
                N.ZipCode         = this.txtZipCode.Text;
                N.RequestDateTime = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " " + this.cmbTime.SelectedValue);
                // TODO: add a field for # of companions

                db.SaveChanges();

                //
                // Edit the AG Form
                //
                if (N.RequestedService_ID == 3)
                {
                    // Only update the drive to record
                    DateTime NeedDateLow  = Convert.ToDateTime(N.RequestDateTime.Value.ToShortDateString() + " 12:00AM");
                    DateTime NeedDateHigh = Convert.ToDateTime(N.RequestDateTime.Value.ToShortDateString() + " 11:59PM");

                    var V = db.Visits.Single(p => p.Customer_ID == N.Customer_ID && p.VisitDate >= NeedDateLow && p.VisitDate <= NeedDateHigh);

                    V.AG_DriveTo    = this.txtAddressLine1.Value;
                    V.AG_Companions = Convert.ToInt32(this.cmbCompanions.SelectedValue);
                    V.AG_ExitTime   = this.cmbTime.Text;

                    db.SaveChanges();
                }

                Response.Redirect("transport_page.aspx");
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;
            }
        }
Esempio n. 21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    if (Request.QueryString["id"] == null)
                    {
                        this.cmdOK.Enabled = false;

                        throw new Exception("id was not supplied.");
                    }
                    else
                    {
                        ViewState["id"] = Request.QueryString["id"];

                        int ID = Convert.ToInt32(ViewState["id"]);

                        SalitaEntities db = new SalitaEntities();

                        var Need = db.v_CustomerNeeds.Single(p => p.CustomerNeed_ID == ID);

                        ViewState["Customer_ID"] = Need.Customer_ID;


                        this.lblFullName.Text    = Need.FullName;
                        this.txtServiceDesc.Text = Need.ServiceDescription + ((Need.Address_Line != null) ? ": " : "") + Need.Address_Line + " " + Need.Town;

                        ViewState["ServiceType"] = Need.ServiceType;
                    }
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;

                if (E.InnerException != null)
                {
                    this.CustomValidator1.ErrorMessage += " InnerException: " + E.InnerException.Message;
                }
            }
        }
Esempio n. 22
0
        protected void txtZipCode_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.txtZipCode.Text != "")
                {
                    SalitaEntities db = new SalitaEntities();

                    ListZip z = db.ListZips.SingleOrDefault(p => p.ZipCode == this.txtZipCode.Text);

                    if (z != null)
                    {
                        this.txtTown.Text = z.City;
                    }
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;
            }
        }
Esempio n. 23
0
        protected void UpdateRequest(int id)
        {
            SalitaEntities db = new SalitaEntities();

            var N = db.v_CustomerNeeds.Single(p => p.CustomerNeed_ID == id);
        }
Esempio n. 24
0
        protected void lbLogin_Click(object sender, EventArgs e)
        {
            try
            {
                SalitaEntities db = new SalitaEntities();

                var U = db.Users.SingleOrDefault(p => p.Username == this.txtUsername.Value && p.UserPassword == this.txtPassword.Text);

                if (U != null)
                {
                    Session["Username"] = U.Username;
                    Session["Role"]     = U.Role;

                    HttpCookie cookie = FormsAuthentication.GetAuthCookie(this.txtUsername.Value, false);
                    var        ticket = FormsAuthentication.Decrypt(cookie.Value);

                    // Store UserData inside the Forms Ticket with all the attributes
                    // in sync with the web.config
                    var newticket = new FormsAuthenticationTicket(ticket.Version,
                                                                  ticket.Name,
                                                                  ticket.IssueDate,
                                                                  ticket.Expiration,
                                                                  false, // always persistent
                                                                  "admin",
                                                                  ticket.CookiePath);

                    // Encrypt the ticket and store it in the cookie
                    cookie.Value   = FormsAuthentication.Encrypt(newticket);
                    cookie.Expires = newticket.Expiration.AddHours(24);
                    this.Context.Response.Cookies.Set(cookie);

                    if (Session["Role"].ToString() == "D")
                    {
                        Response.Redirect("transport_page.aspx");
                    }
                    else
                    {
                        Response.Redirect("default.aspx");
                    }
                }
                else
                {
                    SalitaEntities db2 = new SalitaEntities();

                    DateTime From = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 12:00AM");
                    DateTime To   = Convert.ToDateTime(DateTime.Today.ToShortDateString() + " 11:59PM");

                    //var C = db2.v_RecentVisits.SingleOrDefault(p => p.VisitDate >= From && p.VisitDate <= To && p.Phone == this.txtUsername.Text && this.txtPassword.Text.Trim() == p.LoginPIN);
                    var C = db2.v_RecentVisits.SingleOrDefault(p => p.Phone == this.txtUsername.Value && this.txtPassword.Text.Trim() == p.LoginPIN);

                    if (C != null)
                    {
                        Session["Username"]    = C.FullName;
                        Session["Role"]        = "C";
                        Session["Customer_ID"] = C.Customer_ID;

                        HttpCookie cookie = FormsAuthentication.GetAuthCookie(this.txtUsername.Value, false);
                        var        ticket = FormsAuthentication.Decrypt(cookie.Value);

                        // Store UserData inside the Forms Ticket with all the attributes
                        // in sync with the web.config
                        var newticket = new FormsAuthenticationTicket(ticket.Version,
                                                                      ticket.Name,
                                                                      ticket.IssueDate,
                                                                      ticket.Expiration,
                                                                      false, // persistent
                                                                      "customer",
                                                                      ticket.CookiePath);

                        // Encrypt the ticket and store it in the cookie
                        cookie.Value = FormsAuthentication.Encrypt(newticket);
                        //cookie.Expires = newticket.Expiration.AddHours(24);
                        this.Context.Response.Cookies.Set(cookie);

                        Response.Redirect(@"\CustomerHome\default.aspx");
                    }
                    else
                    {
                        this.CustomValidator1.IsValid      = false;
                        this.CustomValidator1.ErrorMessage = "Incorrect username or password.";
                    }
                }
            }
            catch (Exception E)
            {
                this.CustomValidator1.IsValid      = false;
                this.CustomValidator1.ErrorMessage = E.Message;

                if (E.InnerException != null)
                {
                    this.CustomValidator1.ErrorMessage += " Inner exception: " + E.InnerException.Message;
                }
            }
        }