public static bool AddTheTheDonorsProject(TheDonorsProject tb) { try { db = new UcasProEntities(); db.TheDonorsProjects.Add(tb); db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; File.WriteAllText("t.txt", ex.InnerException.InnerException.Message); e.UserDescription = "Error in Save Changed"; if (ex.InnerException.InnerException.Message.Contains("Violation of PRIMARY KEY constraint 'PK_TheDonorsProjects'. Cannot insert duplicate key in object 'dbo.TheDonorsProjects'")) { e.UserDescriptionArabic = "الممول مضاف مسبقا للمشروع"; } else e.UserDescriptionArabic = e.OtherDescription;//"خطاء في اضافة البيانات"; throw e; } }
public static bool EditTheDonorsProject(TheDonorsProject tb) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.TheDonorsProjects.Where(p => p.ID == tb.ID).SingleOrDefault(); q.DonorsID = tb.DonorsID; q.TotalCost = tb.TotalCost; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; File.WriteAllText("t.txt", ex.InnerException.InnerException.Message); e.UserDescription = "Error in Save Changed"; if (ex.InnerException.InnerException.Message.Contains("Violation of PRIMARY KEY constraint 'PK_TheDonorsProjects'. Cannot insert duplicate key in object 'dbo.TheDonorsProjects'")) { e.UserDescriptionArabic = "الممول مضاف مسبقا للمشروع"; } else e.UserDescriptionArabic = e.OtherDescription;//"خطاء في اضافة البيانات"; throw e; } }
public static bool DeleteDonorsProject(int xid) { try { db = new UcasProEntities(); TheDonorsProject tb = new TheDonorsProject(); tb = db.TheDonorsProjects.Where(f => f.ID == xid).Single(); if (tb.ID != 0) { db.TheDonorsProjects.Remove(tb); db.SaveChanges(); return true; } return false; } catch (Exception) { return false; } }