void InsertRow() { try { HospitalEntities db = new HospitalEntities(); tblTasviyeHeasb tblTasviyeHeasb = new tblTasviyeHeasb(); tblTasviyeHeasb.PazireshID = frmPaziresh.tblPaziresh.PazireshID; tblTasviyeHeasb.TarikhTasviyeHeasb = txtTarikhTasviyeHeasb_.MaskedTextProvider.ToDisplayString(); tblTasviyeHeasb.Mablagh = Convert.ToInt64(txtMablagh_.Text.Replace(",", "")); db.tblTasviyeHeasbs.Add(tblTasviyeHeasb); db.SaveChanges(); New(); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("\n", errorMessages); var exceptionMessage = string.Concat(ClsMessage.Error, ex.Message, " The validation errors are: ", fullErrorMessage); FarsiMessagbox.Show(exceptionMessage, "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } catch (DbUpdateException ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } catch (Exception ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } }
void BindRow() { try { HospitalEntities db = new HospitalEntities(); tblTasviyeHeasb = db.tblTasviyeHeasbs.Find(tblTasviyeHeasb.TasviyeHeasbID); if (tblTasviyeHeasb == null) { FarsiMessagbox.Show(ClsMessage.ErrNotFound, "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); return; } frmPaziresh.tblPaziresh.PazireshID = tblTasviyeHeasb.PazireshID; var QueryBimar = (from a in db.tblPazireshes where a.PazireshID == frmPaziresh.tblPaziresh.PazireshID select new { name = a.NameBimar + " " + a.LastNameBimar }).ToList(); txtBimarName.Text = QueryBimar.ElementAt(0).name; txtTarikhTasviyeHeasb_.Text = tblTasviyeHeasb.TarikhTasviyeHeasb; txtMablagh_.Text = tblTasviyeHeasb.Mablagh.ToString(); } catch (Exception ex) { FarsiMessagbox.Show(ClsMessage.ErrNotFound + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } }
void UpdateRow() { try { HospitalEntities db = new HospitalEntities(); tblTasviyeHeasb = db.tblTasviyeHeasbs.Find(tblTasviyeHeasb.TasviyeHeasbID); if (tblTasviyeHeasb == null) { FarsiMessagbox.Show(ClsMessage.ErrNotFound, "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); return; } tblTasviyeHeasb.PazireshID = frmPaziresh.tblPaziresh.PazireshID; tblTasviyeHeasb.TarikhTasviyeHeasb = txtTarikhTasviyeHeasb_.MaskedTextProvider.ToDisplayString(); tblTasviyeHeasb.Mablagh = Convert.ToInt64(txtMablagh_.Text.Replace(",", "")); db.Entry(tblTasviyeHeasb).State = EntityState.Modified; //db.Entry(tblPersonnel).Property(x => x).IsModified = true; db.SaveChanges(); New(); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage); var fullErrorMessage = string.Join("\n", errorMessages); var exceptionMessage = string.Concat(ClsMessage.Error, ex.Message, " The validation errors are: ", fullErrorMessage); FarsiMessagbox.Show(exceptionMessage, "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } catch (DbUpdateException ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } catch (Exception ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } }
void DeleteRow() { try { HospitalEntities db = new HospitalEntities(); tblTasviyeHeasb = db.tblTasviyeHeasbs.Find(tblTasviyeHeasb.TasviyeHeasbID); db.tblTasviyeHeasbs.Remove(tblTasviyeHeasb); db.SaveChanges(); New(); } catch (DbUpdateException ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } catch (Exception ex) { FarsiMessagbox.Show(ClsMessage.Error + "\n" + ex.Message.ToString(), "خطا", FMessageBoxButtons.Ok, FMessageBoxIcon.Error); } }