/*
* Nombre : FindClientByNumDoc
* Descripción : Retornar True/False si el numero del documento del cliente existe en el modelo WebPlazas.
* Parámetros : string keyword
*/
public Record FindClientByNumDoc(string keyword)
{
try
{
using (WebPlazasEntities context = new WebPlazasEntities())
{
var result = context.Customers.SingleOrDefault(c => c.docnumber == keyword);
if (result != null)
{
return GetTrue();
}
else
{
return GetNotFound();
}
}
}
catch (Exception e)
{
return new Record() { excode = SERVICE_CODE_FALSE, exdetail = e.Source + ": " + e.Message };
}
}
/*
* 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 };
}
}
/*
* Nombre : GetClients
* Descripción : Retornar objeto lista de clientes por criterio de búsqueda (cédula/nombre/correo).
* Parámetros : string keyword
*/
public List<CCustomers> GetClients(string keyword)
{
try
{
using (WebPlazasEntities context = new WebPlazasEntities())
{
if (Regex.IsMatch(keyword, @"^(?("")("".+?(?<!\\)""@)|(([0-9a-z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-z])@))" +
@"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-z][-\w]*[0-9a-z]*\.)+[a-z0-9][\-a-z0-9]{0,22}[a-z0-9]))$"))
{
// búsqueda por correo electrónico.
var q = from c in context.Customers
join p in context.People on c.id equals p.customerid
where c.email == keyword
select new CCustomers()
{
docnumber = c.docnumber,
name = c.name + "",
lastname1 = p.lastname1 + "",
email = c.email,
exnumber = SERVICE_CODE,
exdetail = SERVICE_DETAIL
};
return q.ToList();
}
else if( Regex.IsMatch( keyword , "^[a-zA-Z]*$" ) )
{
// búsqueda por nombre del cliente.
var q = from c in context.Customers
join p in context.People on c.id equals p.customerid
where c.name.ToLower().Contains(keyword.ToLower()) || p.lastname1.ToLower().Contains(keyword.ToLower())
select new CCustomers()
{
docnumber = c.docnumber,
name = c.name + "",
lastname1 = p.lastname1 + "",
email = c.email,
exnumber = SERVICE_CODE,
exdetail = SERVICE_DETAIL
};
return q.ToList();
}
else
{
// búsqueda por número de documento.
var q = from c in context.Customers
join p in context.People on c.id equals p.customerid
where c.docnumber.Contains(keyword)
select new CCustomers()
{
docnumber = c.docnumber,
name = c.name + "",
lastname1 = p.lastname1 + "",
exnumber = SERVICE_CODE,
exdetail = SERVICE_DETAIL
};
return q.ToList();
}
}
}
catch (Exception e)
{
//return null;
List<CCustomers> exception = new List<CCustomers>();
exception.Add(new CCustomers() { exnumber = e.Source + ": " + e.Message + " - " + e.InnerException });
return exception;
}
}
/*
* Nombre : GetSucursales
* Descripción : Retornar objeto lista de sucursales del modelo WebPlazas.
* Parámetros : N/A
*/
public List<CStore> GetSucursales()
{
try
{
using (WebPlazasEntities context = new WebPlazasEntities())
{
var result = (from store in context.Stores
select new CStore
{
id = store.id.ToString(),
name = store.name
}).ToList();
return result;
}
}
catch (Exception)
{
return null;
}
}
/*
* Nombre : GetClient
* Descripción : Consultar un único registro de cliente con los atributos del modelo WebPlazas.
* Parámetros : string keyword
*/
public CCustomer GetClientByNumDoc(string keyword)
{
using (WebPlazasEntities context = new WebPlazasEntities())
{
try
{
/* búsqueda por el campo docnumber */
var q = from c in context.Customers
join p in context.People on c.id equals p.customerid
where c.docnumber.Contains(keyword)
select new CCustomer()
{
id = c.id.ToString(),
docnumber = c.docnumber,
nationality = p.nationality + "",
name = c.name + "",
name2 = p.name2 + "",
lastname1 = p.lastname1 + "",
lastname2 = p.lastname2 + "",
birthdate = p.birthdate.ToString(),
gender = p.gender.ToString() + "",
maritalstatus = p.maritalstatus.ToString() + "",
occupation = p.occupation + "",
phone1 = c.phone1 + "",
phone2 = c.phone2 + "",
phone3 = c.phone3 + "",
email = c.email,
facebook_account = "",
instagram_account = "",
twitter_account = "",
excode = SERVICE_CODE,
exdetail = SERVICE_DETAIL,
type = c.type + ""
};
return q.FirstOrDefault();
}
catch (Exception e)
{
return new CCustomer { excode = "100", exdetail = e.Source + " - Message : " + e.Message };
}
}
}