public HttpResponseMessage Put(int id, [FromBody] contacte val)
{
var contacte = ContactesRepository.UpdateContacte(id, val);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, contacte);
return(response);
}
public HttpResponseMessage PostC([FromBody] contacte val)
{
var c = ContactesRepository.CreateContacte(val);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, c);
return(response);
}
public HttpResponseMessage PostTot([FromBody] contacte cont)
{
var contactes = ContactesRepository.InsertContacteTot(cont);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, contactes);
return(response);
}
public static void DeleteContacte(int id)
{
contacte c = dataContext.contactes.Where(x => x.contacteId == id).SingleOrDefault();
dataContext.contactes.Remove(c);
dataContext.SaveChanges();
}
public ContacteWindow(SentinelDBEntities context, client c, contacte con, modeControllerContacte mode)
{
InitializeComponent();
client = c;
contacte = con;
this.mode = mode;
controller = new ContacteWindowController(context);
}
internal string eliminaContacte(contacte contacte)
{
try
{
tContacte.remove(contacte);
return("El contacte s'ha eliminat correctament.");
}
catch (Exception ex)
{
return("El contacte no s'ha pogut eliminar.");
}
}
internal string modificaContacte(contacte contacte)
{
try
{
tContacte.modify(contacte);
return("El contacte del client " + contacte.client.nom + " s'ha modificat correctament.");
}
catch (Exception ex)
{
return("El contacte del client " + contacte.client.nom + " no s'ha pogut modificar.");
}
}
public static contacte InsertContacte(contacte c)
{
try
{
RepositoryGlobal.dataContext.contactes.Add(c);
RepositoryGlobal.dataContext.SaveChanges();
return(GetContacte(c.contacteId));
}
catch (Exception e)
{
return(null);
}
}
public static void DeleteContacte(int id)
{
contacte c = RepositoryGlobal.dataContext.contactes.Where(x => x.contacteId == id).SingleOrDefault();
if (c != null)
{
if (c.telefons.Count == 0 && c.telefons.Count == 0)
{
RepositoryGlobal.dataContext.contactes.Remove(c);
RepositoryGlobal.dataContext.SaveChanges();
}
}
}
public static List <email> GetContacteEmails(int id)
{
contacte c = (contacte)MakeRequest(string.Concat(ws1, "contacteTot/", id), null, "GET", "application/json", typeof(contacte));
List <email> emails = new List <email>();
if (c != null)
{
emails.AddRange(c.emails);
}
return(emails);
}
public static List <telefon> GetContactePhones(int id)
{
contacte c = (contacte)MakeRequest(string.Concat(ws1, "contacteTot/", id), null, "GET", "application/json", typeof(contacte));
List <telefon> tels = new List <telefon>();
if (c != null)
{
tels.AddRange(c.telefons);
}
return(tels);
}
public static contacte CreateContacte(contacte c)
{
try
{
dataContext.contactes.Add(c);
dataContext.SaveChanges();
return(GetContacte(c.contacteId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(null);
}
}
internal string afegeixContacte(client client, contacte contacte)
{
try
{
contacte.Client_CIF = client.CIF;
tContacte.add(contacte);
return("El contacte del client " + client.nom + @" s'ha afegit correctament.");
}
catch
{
return("El contacte del client " + client.nom + " no s'ha pogut afegir.");
}
}
public static bool contacteHasForeign(int contacteID)
{
contacte c = dataContext.contactes.Where(x => x.contacteId == contacteID).SingleOrDefault();
foreach (email em in dataContext.emails.Where(x => x.contacteId == contacteID))
{
return(true);
}
foreach (telefon t in dataContext.telefons.Where(x => x.contacteId == contacteID))
{
return(true);
}
return(false);
}
public static contacte InsertContacteTot(contacte c)
{
try
{
if (c.telefons.Count > 0 && c.emails.Count > 0)
{
RepositoryGlobal.dataContext.contactes.Add(c);
RepositoryGlobal.dataContext.SaveChanges();
return(GetContacte(c.contacteId));
}
return(null);
}
catch (Exception e)
{
return(null);
}
}
public static void DeleteContacteTot(int id)
{
contacte c = dataContext.contactes.Where(x => x.contacteId == id).SingleOrDefault();
foreach (email em in dataContext.emails.Where(x => x.contacteId == id))
{
dataContext.emails.Remove(em);
}
foreach (telefon t in dataContext.telefons.Where(x => x.contacteId == id))
{
dataContext.telefons.Remove(t);
}
dataContext.contactes.Remove(c);
dataContext.SaveChanges();
}
public HttpResponseMessage PostCTot([FromBody] contacte c)
{
var contactes = ContactesRepository.GetAllContactes();
if (contactes == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
c.serializeMail = true;
c.serializeTelefons = true;
var co = ContactesRepository.CreateContacte(c);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, co);
return(response);
}
public static void DeleteContacteTot(int id)
{
contacte c = RepositoryGlobal.dataContext.contactes.Where(x => x.contacteId == id).SingleOrDefault();
if (c != null)
{
if (c.telefons != null)
{
RepositoryGlobal.dataContext.telefons.RemoveRange(c.telefons);
}
if (c.emails != null)
{
RepositoryGlobal.dataContext.emails.RemoveRange(c.emails);
}
RepositoryGlobal.dataContext.contactes.Remove(c);
RepositoryGlobal.dataContext.SaveChanges();
}
}
public static contacte UpdateContacte(int id, contacte c)
{
try
{
contacte c0 = RepositoryGlobal.dataContext.contactes.Where(x => x.contacteId == id).SingleOrDefault();
if (c.nom != null)
{
c0.nom = c.nom;
}
if (c.cognoms != null)
{
c0.cognoms = c.cognoms;
}
RepositoryGlobal.dataContext.SaveChanges();
return(GetContacte(id));
}
catch (Exception e)
{
return(null);
}
}
public static contacte GetContacte(int contacteID)
{
contacte c = RepositoryGlobal.dataContext.contactes.Where(x => x.contacteId == contacteID).SingleOrDefault();
return(c);
}
public void BtnContacteClick(string btName)
{
contacte c = new contacte();
switch (btName)
{
case "addContacte":
c.nom = contacteNom;
c.cognoms = contacteCognoms;
db.contactes.Add(c);
db.SaveChanges();
TableChoice = "Contacts";
break;
case "removeContacte":
OnNewModalDialog();
if (Ok == 1)
{
foreach (contacte co in contactes.Where(x => x.IsSelected))
{
foreach (telefon t in db.telefons.Where(x => x.contacteId == co.contacteId))
{
db.telefons.Remove(t);
}
foreach (email e in db.emails.Where(x => x.contacteId == co.contacteId))
{
db.emails.Remove(e);
}
db.contactes.Remove(co);
}
multipleSel = false;
db.SaveChanges();
if (TableChoice.Equals("Telefons"))
{
telefonsPopulate();
}
else if (TableChoice.Equals("Emails"))
{
emailsPopulate();
}
else
{
contactesPopulate();
}
}
break;
case "modifyContacte":
OnNewModalDialog();
if (Ok == 1)
{
c = db.contactes.Find(SelectedContacte.contacteId);
c.nom = contacteNom;
c.cognoms = contacteCognoms;
db.SaveChanges();
if (TableChoice.Equals("Telefons"))
{
contacteTelefons();
}
else if (TableChoice.Equals("Emails"))
{
contacteEmails();
}
else
{
contactesPopulate();
}
}
break;
case "duplicateContacte":
foreach (contacte co in contactes.Where(x => x.IsSelected))
{
contacte c0 = new contacte();
c0.nom = co.nom;
c0.cognoms = co.cognoms;
foreach (email e in co.emails)
{
email email0 = new email();
email0.email1 = e.email1;
email0.tipus = e.tipus;
c0.emails.Add(email0);
}
foreach (telefon t in co.telefons)
{
telefon telefon0 = new telefon();
telefon0.telefon1 = t.telefon1;
telefon0.tipus = t.tipus;
c0.telefons.Add(telefon0);
}
db.contactes.Add(c0);
}
multipleSel = false;
db.SaveChanges();
TableChoice = "Contacts";
break;
default:
Console.WriteLine("Error");
break;
}
}
public static contacte GetContacteTot(int id)
{
contacte c = (contacte)MakeRequest(string.Concat(ws1, "contacteTot/", id), null, "GET", "application/json", typeof(contacte));
return(c);
}
public void BtsClick(string rbName)
{
RbNameActual = rbName;
switch (rbName)
{
case "HabilitarMulti":
IsMultiEnabled = true;
break;
/* Buttons CRUD */
case "afegirContactes":
contacte co = new contacte();
co = ContacteSelected;
context.contactes.Add(co);
try
{
context.SaveChanges();
}
catch (Exception ex) { }
BtsClick("rbContactes");
PopulateEmailsTelefons();
break;
case "modificarContactes":
OnNewModalDialog();
if (respuesta == 1)
{
contacte c = context.contactes.Where(x => x.contacteId == ContacteSelected.contacteId).FirstOrDefault();
try
{
c = ContacteSelected;
}
catch (Exception ex)
{
}
context.SaveChanges();
//BtsClick("rbContactes");
PopulateEmailsTelefons();
}
break;
case "esborrarContactes":
OnNewModalDialog();
if (respuesta == 1)
{
try
{
context.contactes.Remove(ContacteSelected);
}
catch (Exception ex) { }
context.SaveChanges();
PopulateEmailsTelefons();
BtsClick("rbContactes");
}
break;
case "DuplicarContactes":
OnNewModalDialog();
if (respuesta == 1)
{
contacte con = new contacte();
con.nom = ContacteSelected.nom;
con.cognoms = ContacteSelected.cognoms;
context.contactes.Add(con);
context.SaveChanges();
List <telefon> telefons = ContacteSelected.telefons.ToList();
List <email> emails = ContacteSelected.emails.ToList();
foreach (telefon item in telefons)
{
telefon tel = new telefon();
tel.contacteId = con.contacteId;
tel.telefon1 = item.telefon1;
tel.tipus = item.tipus;
con.telefons.Add(tel);
}
foreach (email item in emails)
{
email ema = new email();
ema.contacteId = con.contacteId;
ema.email1 = item.email1;
ema.tipus = item.tipus;
con.emails.Add(ema);
}
try
{
context.SaveChanges();
}
catch (Exception) {}
PopulateEmailsTelefons();
BtsClick("rbContactes");
}
break;
case "afegirTelefons":
telefon t = new telefon();
t.tipus = TipusT;
t.telefon1 = Telefon1;
ContacteSelected.telefons.Add(t);
//context.telefons.Add(t);
try
{
context.SaveChanges();
}
catch (Exception ex) { }
PopulateEmailsTelefons();
//BtsClick("rbTelefons");
break;
case "modificarTelefons":
OnNewModalDialog();
if (respuesta == 1)
{
telefon te = context.telefons.Where(x => x.contacteId == TelefonSelected.contacteId).FirstOrDefault();
try
{
te.telefon1 = Telefon1;
te.tipus = TipusT;
}
catch (Exception ex)
{
}
context.SaveChanges();
PopulateEmailsTelefons();
}
//BtsClick("rbTelefons");
break;
case "esborrarTelefons":
OnNewModalDialog();
if (respuesta == 1)
{
try
{
context.telefons.Remove(TelefonSelected);
}
catch (Exception ex) { }
context.SaveChanges();
PopulateEmailsTelefons();
}
//BtsClick("rbTelefons");
break;
case "afegirEmails":
email e = new email();
e.tipus = TipusE;
e.email1 = Email1;
ContacteSelected.emails.Add(e);
try
{
context.SaveChanges();
}
catch (Exception ex) { }
//BtsClick("rbEmails");
PopulateEmailsTelefons();
break;
case "modificarEmails":
OnNewModalDialog();
if (respuesta == 1)
{
email em = context.emails.Where(x => x.contacteId == EmailSelected.contacteId).FirstOrDefault();
try
{
em.email1 = Email1;
em.tipus = TipusE;
}
catch (Exception ex)
{
}
context.SaveChanges();
PopulateEmailsTelefons();
}
//BtsClick("rbEmails");
break;
case "esborrarEmails":
OnNewModalDialog();
if (respuesta == 1)
{
try
{
context.emails.Remove(EmailSelected);
}
catch (Exception ex)
{
}
context.SaveChanges();
PopulateEmailsTelefons();
}
//BtsClick("rbEmails");
break;
/* Radio Buttons Columnas */
case "rbContactes":
BtsClick("rbSenseContactes");
EnableContactes();
RbColumnaActual = "contactes";
Contactes = context.contactes.ToList().OrderBy(x => x.cognoms).ThenBy(x => x.nom).ToList();
ContacteSelected = Contactes.FirstOrDefault();
break;
case "rbTelefons":
BtsClick("rbSenseTelefons");
EnableTelefons();
RbColumnaActual = "telefons";
Telefons = context.telefons.OrderBy(x => x.tipus).ToList();
TelefonSelected = Telefons.FirstOrDefault();
break;
case "rbEmails":
BtsClick("rbSenseEmails");
EnableEmails();
RbColumnaActual = "emails";
Emails = context.emails.ToList().OrderBy(x => x.email1).ToList();
EmailSelected = Emails.FirstOrDefault();
break;
/* Contactes */
case "rbConteContacte":
Contactes = context.contactes.Where(x => x.nom.Contains(TextBoxContactes) || x.cognoms.Contains(TextBoxContactes)).OrderBy(x => x.cognoms).ThenBy(x => x.nom).ToList();
ContacteSelected = Contactes.FirstOrDefault();
EnableContactes();
RbColumnaActual = "contactes";
break;
case "rbComençaContacte":
Contactes = context.contactes.Where(x => x.nom.StartsWith(TextBoxContactes) || x.cognoms.StartsWith(TextBoxContactes)).OrderBy(x => x.cognoms).ThenBy(x => x.nom).ToList();
ContacteSelected = Contactes.FirstOrDefault();
EnableContactes();
RbColumnaActual = "contactes";
break;
case "rbAcabaContacte":
Contactes = context.contactes.Where(x => x.nom.EndsWith(TextBoxContactes) || x.cognoms.EndsWith(TextBoxContactes)).OrderBy(x => x.cognoms).ThenBy(x => x.nom).ToList();
ContacteSelected = Contactes.FirstOrDefault();
EnableContactes();
RbColumnaActual = "contactes";
break;
case "rbSenseContacte":
BtsClick("rbSenseContactes");
EnableContactes();
RbColumnaActual = "contactes";
Contactes = context.contactes.ToList().OrderBy(x => x.cognoms).ThenBy(x => x.nom).ToList();
ContacteSelected = Contactes.FirstOrDefault();
break;
/* Telèfons */
case "rbConteTelefon":
Telefons = context.telefons.Where(x => x.telefon1.Contains(TextBoxTelefons) || x.tipus.Contains(TextBoxTelefons)).OrderBy(x => x.tipus).ToList();
TelefonSelected = Telefons.FirstOrDefault();
EnableTelefons();
RbColumnaActual = "telefons";
break;
case "rbComençaTelefon":
Telefons = context.telefons.Where(x => x.telefon1.StartsWith(TextBoxTelefons) || x.tipus.StartsWith(TextBoxTelefons)).OrderBy(x => x.tipus).ToList();
TelefonSelected = Telefons.FirstOrDefault();
EnableTelefons();
RbColumnaActual = "telefons";
break;
case "rbAcabaTelefon":
Telefons = context.telefons.Where(x => x.telefon1.EndsWith(TextBoxTelefons) || x.tipus.EndsWith(TextBoxTelefons)).OrderBy(x => x.tipus).ToList();
TelefonSelected = Telefons.FirstOrDefault();
EnableTelefons();
RbColumnaActual = "telefons";
break;
case "rbSenseTelefon":
BtsClick("rbSenseTelefons");
EnableTelefons();
RbColumnaActual = "telefons";
Telefons = context.telefons.OrderBy(x => x.tipus).ToList();
TelefonSelected = Telefons.FirstOrDefault();
break;
/* Emails */
case "rbConteEmail":
Emails = context.emails.Where(x => x.email1.Contains(TextBoxEmails) || x.tipus.Contains(TextBoxEmails)).OrderBy(x => x.email1).ToList();
EmailSelected = Emails.FirstOrDefault();
EnableEmails();
RbColumnaActual = "emails";
break;
case "rbComençaEmail":
Emails = context.emails.Where(x => x.email1.StartsWith(TextBoxEmails) || x.tipus.StartsWith(TextBoxEmails)).OrderBy(x => x.email1).ToList();
EmailSelected = Emails.FirstOrDefault();
EnableEmails();
RbColumnaActual = "emails";
break;
case "rbAcabaEmail":
Emails = context.emails.Where(x => x.email1.EndsWith(TextBoxEmails) || x.tipus.EndsWith(TextBoxEmails)).OrderBy(x => x.email1).ToList();
EmailSelected = Emails.FirstOrDefault();
EnableEmails();
RbColumnaActual = "emails";
break;
case "rbSenseEmail":
BtsClick("rbSenseEmails");
EnableEmails();
RbColumnaActual = "emails";
Emails = context.emails.ToList().OrderBy(x => x.email1).ToList();
EmailSelected = Emails.FirstOrDefault();
break;
}
}
