private async Task<int> AddEdu() { try { int tmp = Convert.ToInt16(TxtbxYear.Text); using (var db = new CVDBContext()) { var query = from edu in db.Educations where edu.EDU_ID == IDtoshow select edu; if (query.Count() < 1) { eduToAdd = new Educations { Course = TxtbxCourse.Text, Degree = TxtbxDegree.Text, Year = Convert.ToInt16(TxtbxYear.Text), Notes = TxtbxNotes.Text, School = TxtbxSchool.Text }; db.Educations.Add(eduToAdd); db.Entry(eduToAdd).State = EntityState.Added; await db.SaveChangesAsync(); eduID = eduToAdd.GetEduID(); } else { eduToAdd = query.FirstOrDefault(); eduToAdd.Course = TxtbxCourse.Text; eduToAdd.Degree = TxtbxDegree.Text; eduToAdd.Year = Convert.ToInt16(TxtbxYear.Text); eduToAdd.Notes = TxtbxNotes.Text; eduToAdd.School = TxtbxSchool.Text; eduID = eduToAdd.EDU_ID; db.Entry(eduToAdd).State = EntityState.Modified; db.SaveChanges(); } } return eduID; } catch (Exception ex) { MessageBox.Show(ex.Message + ex.InnerException, "add education error"); return 0; } }
private async Task<int?> Save_Ref() { //return 1; //int tmp = 0; //if (TxtbxCompany.Text.Length > 0) //{ // tmp = await SaveCompany(TxtbxCompany.Text); //} try { using (var db = new CVDBContext()) { int? tmp = null; Employment_Histories e = db.Employment_Histories.Find(emp_hisID); if (e != null) { tmp = e.REF_ID; refID = e.REF_ID; } if (tmp < 1 || tmp == null) { if (TxtbxCompanyRef.Text.Length > 0 && TxtbxEmailRef.Text.Length > 0 && TxtbxFirstNameRef.Text.Length > 0 && TxtbxLastNameRef.Text.Length > 0 && TxtbxMobileRef.Text.Length > 0 && TxtbxPhoneRef.Text.Length > 0 && TxtbxTitleRef.Text.Length > 0) { return null; } else { User_References ur = new User_References { Company_ID = coID, //await SaveCompany(TxtbxCompany.Text), First_Name = TxtbxFirstNameRef.Text, Last_Name = TxtbxLastNameRef.Text, Title = TxtbxTitleRef.Text, Phone = TxtbxPhoneRef.Text, Mobile = TxtbxMobileRef.Text, Email = TxtbxEmailRef.Text }; db.User_References.Add(ur); db.Entry(ur).State = EntityState.Added; await db.SaveChangesAsync(); PopupAddRef.IsOpen = false; return ur.REF_ID; } } User_References u_r = db.User_References.Find(refID); u_r.First_Name = TxtbxFirstNameRef.Text; u_r.Last_Name = TxtbxLastNameRef.Text; u_r.Title = TxtbxTitleRef.Text; u_r.Phone = TxtbxPhoneRef.Text; u_r.Mobile = TxtbxMobileRef.Text; u_r.Email = TxtbxEmailRef.Text; db.Entry(u_r).State = EntityState.Modified; db.SaveChanges(); return u_r.REF_ID; } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.InnerException, "Save Error"); return null; } }
public static async Task<int> Save(this Adresses a) { using (var db = new CVDBContext()) { if (a.Adress_ID < 1) { db.Adresses.Add(a); db.Entry(a).State = EntityState.Added; } else { db.Entry(a).State = EntityState.Modified; } await db.SaveChangesAsync(); return a.Adress_ID; } }
private async Task<int> SaveCompany(string str) { using (var db = new CVDBContext()) { Companies co = db.Companies.Find(GetCompanyID(str)); if (co == null) { co = new Companies { Company_Name = str }; db.Companies.Add(co); db.Entry(co).State = EntityState.Added; await db.SaveChangesAsync(); coID = GetCompanyID(co.Company_Name); return coID; } else { coID = co.Company_ID; return coID; } } }