public int Update(FamilyUpdateModel model) { _adoNetDbHelper.command = _adoNetDbHelper.connection.CreateCommand(); _adoNetDbHelper.command.CommandText = $"UPDATE {TableName} SET TC=@newTCNo, Citizenship=@citizenship,Name=@name, Surname=@surname, BirthDate=@birthDate, PlaceOfBirth=@placeOfBirth, Gender=@gender, JobState=@jobState, JobDescription=@jobDescription,Reference=@reference, Salary=@salary, MobilePhone=@mobilePhone, HomePhone=@homePhone, MotherName=@motherName, FatherName=@fatherName, isMarried=@isMarried, EducationalStatus=@educationalStatusId, SocialSecurityId=@socialSecurityId, FamilyId=@familyId WHERE Id={model.Person.Id}"; _adoNetDbHelper.command.Parameters.AddWithValue("@newTCNo", model.Person.TC); _adoNetDbHelper.command.Parameters.AddWithValue("@citizenship", model.Person.Citizenship); _adoNetDbHelper.command.Parameters.AddWithValue("@name", model.Person.Name); _adoNetDbHelper.command.Parameters.AddWithValue("@surname", model.Person.Surname); _adoNetDbHelper.command.Parameters.AddWithValue("@birthDate", model.Person.BirthDate.Date); _adoNetDbHelper.command.Parameters.AddWithValue("@placeOfBirth", model.Person.PlaceOfBirth); _adoNetDbHelper.command.Parameters.AddWithValue("@gender", model.Person.Gender); _adoNetDbHelper.command.Parameters.AddWithValue("@jobState", model.Person.JobState); _adoNetDbHelper.command.Parameters.AddWithValue("@jobDescription", model.Person.JobDescription); _adoNetDbHelper.command.Parameters.AddWithValue("@reference", model.Person.Reference ?? ""); _adoNetDbHelper.command.Parameters.AddWithValue("@salary", model.Person.Salary); _adoNetDbHelper.command.Parameters.AddWithValue("@mobilePhone", model.Person.MobilePhone); _adoNetDbHelper.command.Parameters.AddWithValue("@homePhone", model.Person.HomePhone); _adoNetDbHelper.command.Parameters.AddWithValue("@motherName", model.Person.MotherName); _adoNetDbHelper.command.Parameters.AddWithValue("@fatherName", model.Person.FatherName); _adoNetDbHelper.command.Parameters.AddWithValue("@isMarried", model.Person.isMarried); _adoNetDbHelper.command.Parameters.AddWithValue("@educationalStatusId", model.Person.EducationalStatus); _adoNetDbHelper.command.Parameters.AddWithValue("@socialSecurityId", model.Person.SocialSecurityId); _adoNetDbHelper.command.Parameters.AddWithValue("@familyId", model.Person.FamilyId); _adoNetDbHelper.OpenSafeConnection(); int count = _adoNetDbHelper.command.ExecuteNonQuery(); _adoNetDbHelper.CloseSafeConnection(); _adoNetDbHelper.command.Dispose(); return(count); }
private void btnUpdate_Click(object sender, EventArgs e) { int familyId = _familyManager.GetFamilyByFatherTCNo(txtFatherNo.Text).Id; Person person = new Person() { Id = personId, TC = txtTcNo.Text, Citizenship = txtCitizenship.Text, Name = txtName.Text, Surname = txtSurname.Text, BirthDate = dateBirthDate.Value, PlaceOfBirth = txtPlaceOfBirth.Text, Gender = chckMan.Checked, JobState = chckWorking.Checked, Reference = rchReference.Text, JobDescription = txtJob.Text, Salary = numSalary.Value, MobilePhone = mskPhone.Text, HomePhone = mskPhone.Text, MotherName = txtMotherName.Text, FatherName = txtFatherName.Text, isMarried = cmbMarried.SelectedItem.ToString(), EducationalStatus = GetCurrentEducationalStatusId(), SocialSecurityId = GetCurrentSocialSecurityId(), FamilyId = familyId }; FamilyUpdateModel model = new FamilyUpdateModel(); model.Person = person; model.LastTCNo = personTCNo; model.FatherTCNo = txtFatherNo.Text; var layerResult = _personManager.Update(model); if (layerResult.HasError()) { string firstError = layerResult.Errors.FirstOrDefault(); MessageBox.Show(firstError, "", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } else { MessageBox.Show("Düzenleme işlemi başarılı, yönlendiriliyorsunuz..", "", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.Yes; this.Close(); this.Dispose(); } //if (FatherTC == personTC) //{ // helper.command = helper.connection.CreateCommand(); // int familyId = GetFamilyId(personTC); // helper.command.CommandText = "UPDATE Family SET FatherNo=@p1 WHERE Id=@p2"; // helper.command.Parameters.AddWithValue("@p1", txtTcNo.Text); // helper.command.Parameters.AddWithValue("@p2", familyId); // helper.command.ExecuteReader(); //} }
public LayerResult <Person> Update(FamilyUpdateModel model) { LayerResult <Person> layerResult = new LayerResult <Person>(); layerResult.Result = model.Person; //this validation base will be refactoring! if (string.IsNullOrEmpty(model.Person.TC)) { layerResult.AddError("T.C kimlik numarası boş geçilemez!"); } if (model.Person.TC.Length != 11) { layerResult.AddError("T.C kimlik numarası 11 karakter olmalıdır!"); } if (string.IsNullOrEmpty(model.Person.Citizenship)) { layerResult.AddError("Uyruk boş geçilemez!"); } if (string.IsNullOrEmpty(model.Person.Name)) { layerResult.AddError("İsim alanı boş geçilemez!"); } if (string.IsNullOrEmpty(model.Person.Surname)) { layerResult.AddError("Soyisim alanı boş geçilemez!"); } if (model.Person.BirthDate == null) { layerResult.AddError("Doğum Tarihi boş geçilemez!"); } if (string.IsNullOrEmpty(model.Person.PlaceOfBirth)) { layerResult.AddError("Doğum yeri boş geçilemez!"); } if (string.IsNullOrEmpty(model.Person.MotherName)) { layerResult.AddError("Anne adı boş geçilemez!"); } if (string.IsNullOrEmpty(model.Person.FatherName)) { layerResult.AddError("Baba adı numarası boş geçilemez!"); } if (layerResult.HasError()) { return(layerResult); } int count = _personDal.Update(model); if (count == 0) { layerResult.AddError("Güncelleme işlemi gerçekleştirilemedi!"); } else { if (model.LastTCNo == model.FatherTCNo) { var family = _familyManager.GetFamilyByFatherTCNo(model.FatherTCNo); family.FatherNo = model.Person.TC; _familyManager.Update(family); } } return(layerResult); }