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 EditSalary(Monthlysalary tb) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.Monthlysalaries.Where(p => p.ID == tb.ID).SingleOrDefault(); q.ContractID = tb.ContractID; q.IssueDate = tb.IssueDate; q.Amount = tb.Amount; q.Formonth = tb.Formonth; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في حفظ البيانات"; throw e; } }
public static bool EditSubActivity(ProjectSubActivity SActv) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.ProjectSubActivities.Where(p => p.ID == SActv.ID).SingleOrDefault(); q.SubActivityName = SActv.SubActivityName; q.Description = SActv.Description; q.Startdate = SActv.Startdate; q.enddate = SActv.enddate; q.TotalCost = SActv.TotalCost; q.Status = SActv.Status; q.Progress = SActv.Progress; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في حفظ البيانات"; throw e; } }
public static bool EditContract(Contract Ct) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.Contracts.Where(p => p.ID == Ct.ID).SingleOrDefault(); q.Employee_ID = Ct.Employee_ID; q.TotalSalary = Ct.TotalSalary; q.SelaryAmount = Ct.SelaryAmount; q.StartDate = Ct.StartDate; q.EndDate = Ct.EndDate; q.Status = Ct.Status; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في حفظ البيانات"; throw e; } }
public static bool NewContract(Contract Ct) { try { db = new UcasProEntities(); db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; db.Contracts.Add(Ct); 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_Contracts'. Cannot insert duplicate key in object 'dbo.Contracts'")) { e.UserDescriptionArabic = "الموظف موجود عقده في المشروع مسبقا"; } else e.UserDescriptionArabic = e.OtherDescription;//"خطاء في اضافة البيانات"; throw e; } }
public static bool EditProjectProfile(ProjectProfile ptb) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.ProjectProfiles.Where(p => p.ID == ptb.ID).SingleOrDefault(); q.ProjectName = ptb.ProjectName; q.ProjectDescription = ptb.ProjectDescription; q.StartDate = ptb.StartDate; q.EndDate = ptb.EndDate; q.Status = ptb.Status; q.Coin = ptb.Coin; q.TotalCost = ptb.TotalCost; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Add"; e.UserDescriptionArabic = "خطاء في اضافة البيانات"; throw e; } }
public static bool AddNewProject(ProjectProfile tb) { try { db = new UcasProEntities(); db.ProjectProfiles.Add(tb); db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Add"; e.UserDescriptionArabic = "خطاء في اضافة البيانات"; throw e; } }
public static List<ProjectProfile> GetAllProjects() { try { db = new UcasProEntities(); var lst = (from p in db.ProjectProfiles select p).ToList(); return lst; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error "; e.UserDescriptionArabic = "خطاء "; throw e; } }
public static bool EditUser(UserTb tb) { try { db = new UcasProEntities(); var q = db.UserTbs.Where(p => p.ID == tb.ID).SingleOrDefault(); q.ID = tb.ID; q.UserName = tb.UserName; q.Password = tb.Password; q.TypeUser = tb.TypeUser; db.SaveChanges(); return true; } catch (Exception ex) { // throw 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("Cannot insert duplicate key row in object 'dbo.UserTbs' with unique index 'IX_UserTbs'")) { e.UserDescriptionArabic = "اسم المستخدم موجود يرجى تغير الاسم"; } else e.UserDescriptionArabic = e.OtherDescription;//"خطاء في اضافة البيانات"; throw e; } }
public static bool NewSalary(Monthlysalary tb) { try { db = new UcasProEntities(); db.Monthlysalaries.Add(tb); db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في اضافة البيانات"; throw e; } }
public static bool NewProjectExpens(ProjectExpens tb) { try { db = new UcasProEntities(); db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; db.ProjectExpenses.Add(tb); db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في اضافة البيانات"; 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 EditProjectExpens(ProjectExpens tb) { try { db = new UcasProEntities(); db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var q = db.ProjectExpenses.Where(p => p.ID == tb.ID).SingleOrDefault(); q.ExpensesName = tb.ExpensesName; q.DateofProcess = tb.DateofProcess; q.BillNumber = tb.BillNumber; q.RequiarAmount = tb.RequiarAmount; q.CashingNumber = tb.CashingNumber; q.ProjectSubActivity_ID = tb.ProjectSubActivity_ID; q.Supplier_ID = tb.Supplier_ID; db.SaveChanges(); return true; } catch (Exception ex) { Xprema.XpremaException e = new Xprema.XpremaException(); e.CodeNumber = 6; e.OtherDescription = ex.InnerException.InnerException.Message; e.UserDescription = "Error in Save Changed"; e.UserDescriptionArabic = "خطاء في حفظ البيانات"; throw e; } }