public int CreateNewOrganization(string projorganization) { BOTADataContext db = new BOTADataContext(connectString); try { Organization org = new Organization(); db.Organizations.InsertOnSubmit(org); db.SubmitChanges(); General gen = new General(); gen.OrgID = org.OrgID; gen.NameRu = projorganization; db.Generals.InsertOnSubmit(gen); db.SubmitChanges(); return(org.OrgID); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); return(-1); } }
public void UpdateBudget(int id, string infoBox, Decimal Cancellation, Decimal Returned) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { var budgetToUpdate = (from b in db.Budgets where b.BudgetID == id select b).First(); if (budgetToUpdate != null) { budgetToUpdate.InfoBox = infoBox; budgetToUpdate.Cancellation = Cancellation; budgetToUpdate.Returned = Returned; // db.Budgets.Attach(budgetToUpdate); db.Refresh(RefreshMode.KeepCurrentValues, budgetToUpdate); db.SubmitChanges(); } } catch (Exception ex) { // result = false; } //return result; }
public bool CreatePageAccess(PageAccess pa) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { //TODO: I should also check if such project and user exists. if (!db.PageAccesses.Any(l => l.Controller == pa.Controller && l.Action == pa.Action && l.RoleId == pa.RoleId)) // !if exists. { db.PageAccesses.InsertOnSubmit(pa); } else { return(false); } db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public bool DeletePageAccess(int?id) { BOTADataContext db = new BOTADataContext(connectString); bool result = true; try { var toDelete = (from s in db.PageAccesses where s.ID == id select s).FirstOrDefault(); if (toDelete != null) { db.PageAccesses.DeleteOnSubmit(toDelete); db.SubmitChanges(); } } catch (Exception ex) { result = false; } return(result); }
/// <summary> /// It either updates existing account or /// if such account does not exist then inserts. /// </summary> /// <param name="account"></param> public bool SaveAccount(SSPStaff account) { BOTADataContext db = new BOTADataContext(connectString); { try { if (account.SSPStaffID > 0) { db.SSPStaffs.Attach(account); db.Refresh(RefreshMode.KeepCurrentValues, account); } else { db.SSPStaffs.InsertOnSubmit(account); } db.SubmitChanges(); return(true); } catch { return(false); } } }
public bool DeleteOrgOtherFunders(int id) { bool result = true; try { BOTADataContext db = new BOTADataContext(connectString); //using (BOTADataContext db) { OtherFunder item = (from o in db.OtherFunders where o.OtherFundID == id select o).FirstOrDefault(); if (item != null) { db.OtherFunders.DeleteOnSubmit(item); db.SubmitChanges(); } } } catch (Exception ex) { //Log4Net uses its dll, bin/Log4Net.config -> has C:/Logs/errors2.txt Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); }
public bool DeleteOrgContact(int id) { bool result = true; try { BOTADataContext db = new BOTADataContext(connectString); //using (BOTADataContext db) { Contact item = (from conts in db.Contacts where conts.ContactID == id select conts).First(); if (item != null) { db.Contacts.DeleteOnSubmit(item); db.SubmitChanges(); } } } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); }
public bool UpdateBudgetInitialAmount(int initialamt, int budgetID) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { Budget budget = (from b in db.Budgets where b.BudgetID == budgetID select b).FirstOrDefault(); budget.ContractInitialAmt = initialamt; //db.Budgets.Attach(); db.Refresh(RefreshMode.KeepCurrentValues, budget); db.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } //return result; }
public bool InsertNewOrgAddress(int id) { BOTADataContext db = new BOTADataContext(connectString); try { Address addr = new Address(); if (!db.Addresses.Any(l => l.OrgID == id)) // if first address of org then it is the default. { addr.isLegalAddress = true; } addr.OrgID = id; db.Addresses.InsertOnSubmit(addr); db.SubmitChanges(); return(true); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); return(false); } }
/// <summary> /// Inserts staff into project. /// </summary> /// <param name="SSPStaffID"></param> /// <param name="id"></param> /// <returns></returns> public bool InsertSSPStaffIntoProject(int SSPStaffID, int id) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { //TODO: I should also check if such project and user exists. if (!db.SSPStaffProjects.Any(l => l.SSPStaffID == SSPStaffID && l.ProjectID == id)) // !if exists. { SSPStaffProject sspproject = new SSPStaffProject(); sspproject.ProjectID = id; sspproject.SSPStaffID = SSPStaffID; db.SSPStaffProjects.InsertOnSubmit(sspproject); } else { return(false); } db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public bool DeleteSSPStaffFromProject(int SSPStaffID, int id) { BOTADataContext db = new BOTADataContext(connectString); bool result = true; try { var toDelete = (from s in db.SSPStaffProjects where s.ProjectID == id && s.SSPStaffID == SSPStaffID select s).FirstOrDefault(); if (toDelete != null) { db.SSPStaffProjects.DeleteOnSubmit(toDelete); db.SubmitChanges(); } } catch (Exception ex) { result = false; } return(result); }
public bool Insert(UserActionLog item) { bool result = true; try { db.UserActionLogs.InsertOnSubmit(item); db.SubmitChanges(); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(ProjectEventRepository), "-------------User Action Logs- Insert-------------------------", ex); result = false; } return(result); }
public void InsertNewCatName(string NewCatName) { BOTADataContext db = new BOTADataContext(connectString); FinArtCatListR fcatlist = new FinArtCatListR(); fcatlist.FinArticleCatName = NewCatName; try { db.FinArtCatListRs.InsertOnSubmit(fcatlist); db.SubmitChanges(); } catch (Exception ex) { } }
public bool CreateReportPeriod(ReportPeriodListR item) { BOTADataContext db = new BOTADataContext(connectString); bool result = true; try { db.ReportPeriodListRs.InsertOnSubmit(item); db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public bool UpdateStaffProject(int id, List <int> current) { BOTADataContext db = new BOTADataContext(connectString); { try { var sspproj = from a in db.SSPStaffProjects where a.ProjectID == id select a; foreach (var vsp in sspproj) { if (current != null) { if (current.Any(s => s == vsp.SSPStaffID)) { vsp.Active = true; } else { vsp.Active = false; } } else { vsp.Active = false; } } // db.SSPStaffProjects.AttachAll(sspproj); db.Refresh(RefreshMode.KeepCurrentValues, sspproj); db.SubmitChanges(); return(true); } catch { return(false); } } return(false); }
/// <summary> /// Updates Report Periods. /// </summary> /// <param name="repperlist"></param> /// <returns></returns> public bool UpdateReportPeriodList(List <ReportPeriodListR> repperlist) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { db.ReportPeriodListRs.AttachAll(repperlist); db.Refresh(RefreshMode.KeepCurrentValues, repperlist); db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public bool InsertArticleToReportPeriodR(List <ReportPeriodR> ReportPeriods) { BOTADataContext db = new BOTADataContext(connectString); try { db.ReportPeriodRs.InsertAllOnSubmit(ReportPeriods.AsEnumerable()); db.SubmitChanges(); } catch (Exception ex) { //Log4Net uses its dll, bin/Log4Net.config -> has C:/Logs/errors2.txt Log.EnsureInitialized(); Log.Error(typeof(ProjectRepository), "Exception catched while Insert Project.", ex); return(false); //could not insert into Report Periods. } return(true); }
public bool DeleteOrganization(int ProposalID) { /* * // Get movie to delete * var movieToDelete = _db.MovieSet.First(m => m.Id == id); * * // Delete * _db.DeleteObject(movieToDelete); * _db.SaveChanges(); * * // Show Index view * return RedirectToAction("Index"); */ bool result = true; try { BOTADataContext db = new BOTADataContext(connectString); //using (BOTADataContext db) { Organization item = (from projects in db.Projects join organization in db.Organizations on projects.Organization.OrgID equals organization.OrgID where projects.ProjectID == ProposalID select organization).First(); db.Organizations.DeleteOnSubmit(item); db.SubmitChanges(); } } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); }
public bool InsertNewOrgContact(int id) { BOTADataContext db = new BOTADataContext(connectString); try { Contact cont = new Contact(); cont.OrgID = id; db.Contacts.InsertOnSubmit(cont); db.SubmitChanges(); return(true); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); return(false); } }
public bool InsertNewOrgOtherFunders(int id) { BOTADataContext db = new BOTADataContext(connectString); try { OtherFunder o = new OtherFunder(); o.OrgID = id; db.OtherFunders.InsertOnSubmit(o); db.SubmitChanges(); return(true); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); return(false); } }
/// <summary> /// Updates All addreses of current organization. /// </summary> /// <param name="OrgAddresses"></param> /// <returns></returns> public bool UpdateOtherFunders(IEnumerable <OtherFunder> enumotherfunders) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { db.OtherFunders.AttachAll(enumotherfunders); db.Refresh(RefreshMode.KeepCurrentValues, enumotherfunders); db.SubmitChanges(); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); }
public bool UpdateOrganization(Organization org, int ProposalID) { bool result = true; try { BOTADataContext db = new BOTADataContext(connectString); { Organization item = (from projects in db.Projects join organization in db.Organizations //.Include("General") on projects.Organization.OrgID equals organization.OrgID where projects.ProjectID == ProposalID select organization).First(); //join legstatus in db.LegalStatus // on projects.Organization.OrgID equals legstatus.OrgID //General Info Update. item.General.Name = org.General.Name; item.LegalStatus.LegSListID = org.LegalStatus.LegSListID; item.General.FiscalYearEnd = org.General.FiscalYearEnd; item.General.Notes = org.General.Notes; item.Contacts = org.Contacts; db.SubmitChanges(); } } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); }
public bool UpdatePageAccess(PageAccess pa) { BOTADataContext db = new BOTADataContext(connectString); { try { if (pa.ID > 0) { db.PageAccesses.Attach(pa); db.Refresh(RefreshMode.KeepCurrentValues, pa); } db.SubmitChanges(); return(true); } catch { return(false); } } }
public bool DeleteReportPeriod(int RepperID, int BudgetID) { BOTADataContext db = new BOTADataContext(connectString); bool result = true; try { var toDelete = (from r in db.ReportPeriodListRs where r.ReportPeriodID == RepperID && r.BudgetID == BudgetID select r).First(); db.ReportPeriodListRs.DeleteOnSubmit(toDelete); db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public void UpdateCategoriesValues(List <FinArticleCategoryR> FinArticleCategory) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { /*var oldItem = (from p in db.ProjectEvents * where p.EventID == item.EventID * select p).First();*/ db.FinArticleCategoryRs.AttachAll(FinArticleCategory); db.Refresh(RefreshMode.KeepCurrentValues, FinArticleCategory); db.SubmitChanges(); } catch (Exception ex) { // result = false; } //return result; }
public bool DeleteArticleCat(int?FinArticleCatID, int?BudgetID) { BOTADataContext db = new BOTADataContext(connectString); bool result = true; try { var toDelete = (from c in db.FinArticleCategoryRs where c.BudgetID == BudgetID.Value && c.FinArticleCatID == FinArticleCatID select c).First(); db.FinArticleCategoryRs.DeleteOnSubmit(toDelete); db.SubmitChanges(); } catch (Exception ex) { result = false; } return(result); }
public void UpdateReportPeriodTrans(List <ReportPeriodR> ReportPeriods) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { /*var oldItem = (from p in db.ProjectEvents * where p.EventID == item.EventID * select p).First();*/ db.ReportPeriodRs.AttachAll(ReportPeriods); db.Refresh(RefreshMode.KeepCurrentValues, ReportPeriods); db.SubmitChanges(); } catch (Exception ex) { // result = false; } //return result; }
/// <summary> /// Updates Organization General. /// LegalStatus: If exists then update, if no then insert. /// </summary> /// <param name="gen"></param> /// <returns></returns> public bool UpdateOrganizationGeneral(General gen) { bool result = true; BOTADataContext db = new BOTADataContext(connectString); try { db.Generals.Attach(gen); db.Refresh(RefreshMode.KeepCurrentValues, gen); //db.ExecuteCommand("DELETE FROM addresses WHERE ContactID={0} and AddressTypeID={1}", contactID, addressTypeID); // gen.Organization.LegalStatus.Detach(); //check if legalstaus exists. /* var legstat = (from l in db.LegalStatus * where l.OrgID == gen.OrgID * select l).FirstOrDefault(); */ //if (legstat == null) //if it does not exist. if (!db.LegalStatus.Any(l => l.OrgID == gen.OrgID)) // !if exists. { //Insert LegalStatus lstat = new LegalStatus(); lstat.OrgID = gen.OrgID; lstat.LegSListID = gen.Organization.LegalStatus.LegSListID; lstat.SelectedDate = gen.Organization.LegalStatus.SelectedDate; db.LegalStatus.InsertOnSubmit(lstat); } else { //try to update. // legstat.Detach(); // legstat.LegSListID = gen.Organization.LegalStatus.LegSListID; // db.LegalStatus.Attach(legstat); db.Refresh(RefreshMode.KeepCurrentValues, gen.Organization.LegalStatus); } db.SubmitChanges(); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(OrganizationRepository), "----------------------------------------------", ex); result = false; } return(result); /* * try * { * * BOTADataContext db = new BOTADataContext(connectString); * * { General genitem = (from organization in db.Organizations * join general in db.Generals * on organization.OrgID equals general.OrgID * where general.OrgID == gen.Organization.OrgID * select general).First(); * * genitem.Name = gen.Name; * genitem.Organization.LegalStatus.LegSListID = gen.Organization.LegalStatus.LegSListID; * genitem.FiscalYearEnd = gen.FiscalYearEnd; * genitem.Notes = gen.Notes; * db.SubmitChanges(); * * } * } * catch (Exception ex) * { * result = false; * } * * return result; */ }
public bool InsertIndicatorLabel(IndicatorLabel item) { bool result = true; try { db.IndicatorLabels.InsertOnSubmit(item); db.SubmitChanges(); } catch (Exception ex) { Log.EnsureInitialized(); Log.Error(typeof(IndicatorRepository), "----------------------------------------------", ex); result = false; // throw ex; } return(result); }
public int AddFinArticleCategory(int id, int FinCatSel) { BOTADataContext db = new BOTADataContext(connectString); //Check if Any Report Periods Exist! if (!db.ReportPeriodListRs.Any(l => l.BudgetID == id)) // !if exists. { return(-2); //this means no ReportPeriods created yet. } FinArticleCategoryR fcat = new FinArticleCategoryR(); // fcat.FinArticleCatListID = FinCatSel; FinArtCatListR fcatr = (from ls in db.FinArtCatListRs where ls.FinArticleCatListID == FinCatSel select ls).FirstOrDefault(); fcat.FinArticleCatText = fcatr.FinArticleCatName; fcat.BudgetID = id; fcat.Price = 0; fcat.FinCatID = FinCatSel; try { db.FinArticleCategoryRs.InsertOnSubmit(fcat); db.SubmitChanges(); } catch (Exception ex) { //Log4Net uses its dll, bin/Log4Net.config -> has C:/Logs/errors2.txt Log.EnsureInitialized(); Log.Error(typeof(ProjectRepository), "Exception catched while Insert Project.", ex); return(-1); //could not insert new Category somehow. } try { IEnumerable <ReportPeriodListR> ReportPeriodsList = from ls in db.ReportPeriodListRs where ls.BudgetID == id select ls; List <ReportPeriodR> ReportPeriods = new List <ReportPeriodR>(); foreach (ReportPeriodListR rep in ReportPeriodsList) { ReportPeriodR repper = new ReportPeriodR(); repper.ReportPeriodID = rep.ReportPeriodID; repper.FinArticleCatID = fcat.FinArticleCatID; repper.Amount = 0; ReportPeriods.Add(repper); } db.ReportPeriodRs.InsertAllOnSubmit(ReportPeriods.AsEnumerable()); db.SubmitChanges(); } catch (Exception ex) { //Log4Net uses its dll, bin/Log4Net.config -> has C:/Logs/errors2.txt Log.EnsureInitialized(); Log.Error(typeof(ProjectRepository), "Exception catched while Insert Project.", ex); return(-3); //could not insert into Report Periods. } return(fcat.FinArticleCatID); }