public static int validateJobTitleId(string pJobTitleDescription) { try { using (DB_FleetServiceEntities db = new DB_FleetServiceEntities()) { if (pJobTitleDescription.Trim() != "") { var jobTitle = db.JobTitlesClient.Where(jt => jt.jtcl_description.ToUpper() == pJobTitleDescription.ToUpper()).FirstOrDefault(); if (jobTitle == null) { JobTitlesClient job = new JobTitlesClient(); job.jtcl_description = pJobTitleDescription.ToUpper(); job.jtcl_state = true; db.JobTitlesClient.Add(job); db.SaveChanges(); jobTitle = db.JobTitlesClient.Where(jt => jt.jtcl_description.ToUpper() == pJobTitleDescription.ToUpper()).FirstOrDefault(); } return(jobTitle.jtcl_id); } else { return(0); } } } catch (Exception ex) { return(0); } }
public IHttpActionResult validateJobTitle(JobTitleViewModel pJobTitle) { try { using (BDRAEntities db = new BDRAEntities()) { JobTitleViewModel jobTitle; jobTitle = db.JobTitlesClient.Where(j => j.jtcl_description.ToUpper() == pJobTitle.description.ToUpper()) .Select(jt => new JobTitleViewModel { id = jt.jtcl_id, description = jt.jtcl_description }) .FirstOrDefault(); if (jobTitle == null) { JobTitlesClient jt = new JobTitlesClient(); jt.jtcl_description = pJobTitle.description; jt.jtcl_state = true; db.JobTitlesClient.Add(jt); db.SaveChanges(); } var jtcl = db.JobTitlesClient.Where(j => j.jtcl_description.ToUpper() == pJobTitle.description.ToUpper()) .Select(jt => new JobTitleViewModel { id = jt.jtcl_id, description = jt.jtcl_description }) .FirstOrDefault(); return(Ok(jtcl)); } } catch (Exception e) { return(BadRequest(e.Message)); throw; } }
public List <ContactViewModel> validateDataContact(List <string> lsData, string separator) { String sline = "--------------------------------------------------------------------------"; var lsContacts = new List <ContactViewModel>(); int cont = 0; ClientViewModel clientByContact = new ClientViewModel(); JobTitleViewModel jobTitle = new JobTitleViewModel(); BranchViewModel branchByContact = new BranchViewModel(); string sDocumentByClient = ""; string sNameByContact = ""; string sJobTitle = ""; string sPhone = ""; string sCellPhone = ""; string sAdress = ""; string sEmail = ""; try { using (BDRAEntities db = new BDRAEntities()) { foreach (var data in lsData) { cont += 1; if (cont == 1) { continue; } Console.WriteLine(sline); Console.WriteLine("Validanto linea: " + cont); Console.WriteLine(data); var aData = data.Split(separator); sDocumentByClient = aData[(int)atrContact.clientDocument].ToString(); clientByContact = db.Client.Where(cl => cl.cli_document == sDocumentByClient) .Select(cl => new ClientViewModel { id = cl.cli_document, name = cl.cli_name }) .FirstOrDefault(); if (clientByContact != null) { Console.WriteLine("Cliente: " + clientByContact.name); sNameByContact = aData[(int)atrContact.name].ToString(); Console.WriteLine("Contacto: " + sNameByContact); var name = ""; var lastName = ""; var aName = sNameByContact.Split(" "); for (int i = 0; i < aName.Length; i++) { if (aName.Length == 2) { if (i == 0) { name = aName[i]; } else { lastName = aName[i]; } } else { if (i <= 1) { name += aName[i] + " "; } else { lastName += aName[i] + " "; } } } Console.WriteLine("Nombre del contacto: " + name); if (name.Trim() == "") { Console.WriteLine("Contacto no valido ............."); continue; } Console.WriteLine("Apellido del contacto: " + lastName); sJobTitle = aData[(int)atrContact.jobTitle].ToString().ToUpper().Trim(); sJobTitle = sJobTitle.Replace(" ", " "); Console.WriteLine("Cargo: " + sJobTitle); jobTitle = db.JobTitlesClient.Where(jt => jt.jtcl_description.ToUpper() == sJobTitle) .Select(jt => new JobTitleViewModel { id = jt.jtcl_id, description = jt.jtcl_description }) .FirstOrDefault(); if (jobTitle == null) { JobTitlesClient jt = new JobTitlesClient(); jt.jtcl_description = sJobTitle; jt.jtcl_state = true; db.JobTitlesClient.Add(jt); db.SaveChanges(); Console.WriteLine("Se crea cargo en la bd..."); jobTitle = db.JobTitlesClient.Where(jt => jt.jtcl_description.ToUpper() == sJobTitle) .Select(jt => new JobTitleViewModel { id = jt.jtcl_id, description = jt.jtcl_description }) .FirstOrDefault(); } sPhone = aData[(int)atrContact.phone].ToString().Trim(); Console.WriteLine("Teléfono: " + sPhone); sCellPhone = aData[(int)atrContact.cellphone].ToString().Trim(); Console.WriteLine("Celular: " + sCellPhone); sAdress = aData[(int)atrContact.adress].ToString().Trim(); Console.WriteLine("Dirección: " + sAdress); sEmail = aData[(int)atrContact.email].ToString().Trim(); Console.WriteLine("Email: " + sEmail); branchByContact = db.branch.Where(b => b.cli_document == clientByContact.id && b.bra_isMain == true) .Select(b => new BranchViewModel { id = b.bra_id, name = b.bra_name }) .FirstOrDefault(); if (branchByContact == null) { branch branchCnt = new branch(); branchCnt.bra_isMain = true; branchCnt.bra_state = true; branchCnt.bra_name = "PRINCIPAL " + clientByContact.name; branchCnt.cli_document = clientByContact.id; db.branch.Add(branchCnt); db.SaveChanges(); branchByContact = db.branch.Where(b => b.cli_document == clientByContact.id && b.bra_isMain == true) .Select(b => new BranchViewModel { id = b.bra_id, name = b.bra_name }) .FirstOrDefault(); } Console.WriteLine("Sucursal id: " + branchByContact.id + " - " + branchByContact.name); ContactViewModel cnt = new ContactViewModel(); cnt.branch = branchByContact; cnt.name = name; cnt.lastName = lastName; cnt.phone = sPhone; cnt.cellPhone = sCellPhone; cnt.adress = sAdress; cnt.email = sEmail; cnt.jobTitle = jobTitle; lsContacts.Add(cnt); } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(lsContacts); }