Example #1
0
        /*
         * Nombre      :    UpdClient
         * Descripción :    Actualizar el registro de cliente del modelo WebPlazas, retornar True/Falso como respuesta de acción.
         * Parámetros  :    string id, string type, string docnumber, string name, string name2, string lastname1, string lastname2, string phone1, string phone2, string maritalstatus, string gender
         */
        public Record UpdClient(string id, string docnumber, string nationality, string name, string name2, string lastname1, string lastname2, string birthdate, string gender, string maritalstatus, string occupation, string phone1, string phone2, string phone3, string email, string type)
        {
            try
            {

                using (WebPlazasEntities context = new WebPlazasEntities())
                {

                    var keyword = int.Parse(id);

                    var customer = context.Customers.SingleOrDefault(c => c.id == keyword);

                    var person = context.People.SingleOrDefault(p => p.customerid == customer.id);

                    if (customer != null && person != null)
                    {

                        DateTime datetime = DateTime.ParseExact(birthdate, "yyyyMMdd", CultureInfo.InvariantCulture);

                        customer.docnumber = docnumber;
                        person.nationality = nationality == "NULO" ? "" : nationality;
                        customer.name = name;
                        person.name2 = name2 == "NULO" ? "" : name2;
                        person.lastname1 = lastname1;
                        person.lastname2 = lastname2 == "NULO" ? "" : lastname2;
                        person.birthdate = datetime;
                        person.gender = byte.Parse(gender);
                        person.maritalstatus = byte.Parse(maritalstatus);
                        person.occupation = occupation == "NULO" ? "" : occupation;
                        customer.phone1 = phone1;
                        customer.phone2 = phone2 == "NULO" ? "" : phone2;
                        customer.phone3 = phone3 == "NULO" ? "" : phone3;
                        customer.email = email;
                        customer.type = byte.Parse(type);
                        customer.lastmodifydate = System.DateTime.Now;

                        context.Entry(customer).State = EntityState.Modified;
                        context.Entry(person).State = EntityState.Modified;

                        context.SaveChanges();

                        return GetTrue();

                    }

                    return GetFalse();

                }

            }
            catch (Exception e)
            {

                return new Record() { excode = "100", exdetail = e.Message };
            }
        }