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);
}
}
