public static void UpdateRecords() { var siftaDB = new SiftaDBDataContext(); foreach (var agreement in siftaDB.Agreements.Where(p => p.RecordID == null)) { agreement.RecordID = RecordIdentifier(agreement); siftaDB.SubmitChanges(); } foreach (var mod in siftaDB.AgreementMods.Where(p => p.RecordID == null)) { mod.RecordID = RecordIdentifier(mod); siftaDB.SubmitChanges(); } foreach (var s in siftaDB.FundingSites.Where(p => p.RecordID == null)) { s.RecordID = RecordIdentifier(s); siftaDB.SubmitChanges(); } foreach (var s in siftaDB.FundingStudies.Where(p => p.RecordID == null)) { s.RecordID = RecordIdentifier(s); siftaDB.SubmitChanges(); } }
protected void rgReceiver_InsertCommand(object sender, GridCommandEventArgs e) { UpdateDifferences(); //Cast the GridCommandEventArgs item as an editable item GridEditableItem editedItem = e.Item as GridEditableItem; //Find the user control used by that item save it as a UserControl UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); var rec = new AccountFundSource(); GrabValuesFromUserControl(userControl, ref rec); try { int id = siftaDB.AccountFundSources.Max(p => p.AFSID); rec.AFSID = id + 1; } catch (Exception ex) { rec.AFSID = 0; } siftaDB.AccountFundSources.InsertOnSubmit(rec); siftaDB.SubmitChanges(); }
protected void rgAgreementLog_InsertCommand(object sender, GridCommandEventArgs e) { //Cast the GridCommandEventArgs item as an editable item GridEditableItem editedItem = e.Item as GridEditableItem; //Find the user control used by that item save it as a UserControl UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); var modLog = new AgreementModLog(); GrabValuesFromUserControl(userControl, ref modLog); siftaDB.AgreementModLogs.InsertOnSubmit(modLog); siftaDB.SubmitChanges(); }
public static void Delete(this Customer _customer, bool StoreValues = false) { var siftaDB = new SiftaDBDataContext(); if (StoreValues) { var address = String.Format("http://sifta.water.usgs.gov/Services/REST/Customer/CustomerInformation.ashx?CustomerID={0}&AllRecords=true", _customer.CustomerID); System.Net.WebClient wc = new System.Net.WebClient(); var xml = wc.DownloadString(address); siftaDB.Archives.InsertOnSubmit(new Archive() { Type = "Customer", CreatedBy = new User().ID, CreatedOn = DateTime.Now, Data = xml }); } var customer = siftaDB.Customers.FirstOrDefault(p => p.CustomerID == _customer.CustomerID); //Delete all Agreements foreach (var agreement in customer.Agreements) { //Delete the agreement Delete(agreement, false); } //Delete Contacts foreach (var contact in customer.CustomerContacts) { foreach (var address in contact.CustomerContactAddresses) { siftaDB.CustomerContactAddresses.DeleteOnSubmit(address); } siftaDB.CustomerContacts.DeleteOnSubmit(contact); } siftaDB.Customers.DeleteOnSubmit(customer); siftaDB.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { var agreements = siftaDB.Agreements.Where(p => p.RecordID == null); var mods = siftaDB.AgreementMods.Where(p => p.RecordID == null); var siteFunding = siftaDB.FundingSites.Where(p => p.RecordID == null); var studiesFunding = siftaDB.FundingStudies.Where(p => p.RecordID == null); ltlAgreement.Text = agreements.Count().ToString(); ltlMods.Text = mods.Count().ToString(); ltlSiteFunding.Text = siteFunding.Count().ToString(); ltlStudiesFunding.Text = studiesFunding.Count().ToString(); foreach (var agreement in agreements) { agreement.RecordID = agreement.RecordIdentifier(); } foreach (var mod in mods) { mod.RecordID = mod.RecordIdentifier(); } foreach (var sf in siteFunding) { sf.RecordID = sf.RecordIdentifier(); } foreach (var sf in studiesFunding) { sf.RecordID = sf.RecordIdentifier(); } siftaDB.SubmitChanges(); }
protected void rgCustomers_UpdateCommand(object sender, GridCommandEventArgs e) { //Cast the GridCommandEventArgs item as an editable item GridEditableItem editedItem = e.Item as GridEditableItem; //Find the user control used by that item save it as a UserControl UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); //Grab the CustomerID of the customer you are editing from the edited item int CustomerID = Convert.ToInt32(editedItem.GetDataKeyValue("CustomerID")); //Add metrics var metric = new MetricHandler(center.OrgCode, null, null, MetricType.RecordUpdate, "Customer", String.Format("Updated CustomerID = {0}", CustomerID)); metric.SubmitChanges(); //Grabs the customer from the database with the matching ID var customer = siftaDB.Customers.FirstOrDefault(p => p.CustomerID == CustomerID); //Assigns the values from the user control to the customer GrabValuesFromUserControl(userControl, ref customer); //Submits the changes to the database siftaDB.SubmitChanges(); }
public static bool ValidEmployeeID(this string employeeID) { SiftaDBDataContext siftaDB = new SiftaDBDataContext(); //Check to see if they aren't being tracked yet. if (siftaDB.Employees.FirstOrDefault(p => p.EmployeeID == employeeID) == null) { //Call the service for Active Directory var service = new ActiveDirectoryService(); //Try to get the employee with the same id var employee = service.GetEmployee(employeeID); //Check to see that the employee is not null if (employee != null) { var e = new Employee() { FirstName = employee.FirstName, MiddleName = employee.MiddleName, LastName = employee.LastName, OrgCode = employee.OrgCode, EmployeeID = employee.EmployeeID, StreetOne = employee.StreetOne, StreetTwo = employee.StreetTwo, City = employee.City, State = employee.State, ZipCode = employee.ZipCode, Department = employee.Department, Email = employee.Email, Title = employee.Title, PhoneFax = employee.PhoneFax, PhoneWork = employee.PhoneWork }; siftaDB.Employees.InsertOnSubmit(e); siftaDB.SubmitChanges(); return(true); } //Employee is not real return false else { return(false); } } else { return(true); } }
public static void Delete(this Agreement agreement, bool StoreValues = false) { var siftaDB = new SiftaDBDataContext(); var _agreement = siftaDB.Agreements.FirstOrDefault(p => p.AgreementID == agreement.AgreementID); if (StoreValues) { var address = String.Format("http://sifta.water.usgs.gov/Services/REST/Agreement/AgreementInformation.ashx?AgreementID={0}", _agreement.AgreementID); System.Net.WebClient wc = new System.Net.WebClient(); var xml = wc.DownloadString(address); siftaDB.Archives.InsertOnSubmit(new Archive() { Type = "Agreement", CreatedBy = new User().ID, CreatedOn = DateTime.Now, Data = xml }); } //Go through each mod in the agreement foreach (var mod in _agreement.AgreementMods) { //Delete all teh site funding foreach (var site in mod.FundingSites) { siftaDB.FundingSites.DeleteOnSubmit(site); } //Delete all studies funding foreach (var study in mod.FundingStudies) { siftaDB.FundingStudies.DeleteOnSubmit(study); } //Delete all logs foreach (var log in mod.AgreementModLogs) { siftaDB.AgreementModLogs.DeleteOnSubmit(log); } //Delete all coop funding foreach (var coop in mod.CooperativeFundings) { siftaDB.CooperativeFundings.DeleteOnSubmit(coop); } siftaDB.AgreementMods.DeleteOnSubmit(mod); } siftaDB.Agreements.DeleteOnSubmit(_agreement); siftaDB.SubmitChanges(); }
protected void rbSubmitAgreementLog_Click(object sender, EventArgs e) { try { if (rdtpAgreementLogTime.SelectedDate == null) { throw new ArgumentException("A Date Was Not Selected."); } var log = new AgreementModLog() { CreatedBy = user.ID, ModifiedBy = user.ID, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; log.LoggedDate = Convert.ToDateTime(rdtpAgreementLogTime.SelectedDate); log.Remarks = rtbRemarksAgreementLog.Text; if (rcbActionAgreementLog.SelectedIndex != 0) { log.AgreementLogTypeID = Convert.ToInt32(rcbActionAgreementLog.SelectedValue); } else { throw new ArgumentException("An Action Was Not Selected."); } mod.AgreementModLogs.Add(log); siftaDB.SubmitChanges(); pnlAgreementLog.Visible = false; pnlComplete.Visible = true; } catch (Exception ex) { ltlError.Text = ex.Message; pnlAgreementLog.Visible = false; pnlError.Visible = true; } }
/// <summary> /// Called to copy an agreement 1 fiscal year ahead /// </summary> /// <param name="agreement">The agreement to be copied</param> protected void CopyAgreement(Agreement agreement) { //Add metrics var metric = new MetricHandler(customer.OrgCode, customer.CustomerID, null, MetricType.RecordCopied, "Agreement", String.Format("Copied AgreemendID = {0}", agreement.AgreementID)); metric.SubmitChanges(); //Grabs Mod 0 for the Agreement (the original agreement information is what we are copying over) var mod = agreement.AgreementMods.FirstOrDefault(p => p.Number == 0); //Grabs the list of Site funding for the original mod var siteFunding = mod.FundingSites.ToList(); //Grab all coop funding for mod 0; var coopFunding = mod.CooperativeFundings.ToList(); //Grabs the list of studies funding for the original mod var studiesFunding = mod.FundingStudies.ToList(); //Grab list of account fund sources var accFundSrc = siftaDB.AccountFundSources.Where(x => x.AgreementModID == mod.AgreementModID).ToList(); //Create a new mod var copyMod = new AgreementMod(); //Create a new Agreement and assign it values from the old one var copy = new Agreement() { BillingCycleFrequency = agreement.BillingCycleFrequency, PurchaseOrderNumber = agreement.PurchaseOrderNumber + "_Copy", FundsType = agreement.FundsType, Remarks = agreement.Remarks, CustomerBillingContact = agreement.CustomerBillingContact, CustomerTechnicalContact = agreement.CustomerTechnicalContact, Customer2Group = agreement.Customer2Group, USGSBillingContact = agreement.USGSBillingContact, USGSTechnicalContact = agreement.USGSTechnicalContact, CreatedBy = user.ID, CreatedDate = DateTime.Now, ModifiedBy = user.ID, ModifiedDate = DateTime.Now }; //The Start date needs to be pushed up a year if it isn't null if (mod.StartDate != null) { //Set the start date for the agreement to 1 year after the previous agreements start date copy.StartDate = Convert.ToDateTime(mod.StartDate).AddYears(1); } else { copy.StartDate = null; } //The End date needs to be pushed up a year if it isn't null if (mod.EndDate != null) { //Set the end date for the agreement to 1 year after the previous agreements end date copy.EndDate = Convert.ToDateTime(mod.EndDate).AddYears(1); } else { copy.EndDate = null; } //Set the Mods Start and End Date to be the one from the copied Agreement copyMod.StartDate = copy.StartDate; copyMod.EndDate = copy.EndDate; //Assign values from old mod to new mod copyMod.FundingUSGSCMF = mod.FundingUSGSCMF; copyMod.FundingCustomer = mod.FundingCustomer; copyMod.FundingOther = mod.FundingOther; copyMod.FundingOtherReason = mod.FundingOtherReason; copyMod.Number = 0; copyMod.Remarks = mod.Remarks; copyMod.CreatedBy = copyMod.ModifiedBy = user.ID; copyMod.CreatedDate = copyMod.ModifiedDate = DateTime.Now; //Add Site Funding to copy mod foreach (var siteF in siteFunding) { copyMod.FundingSites.Add(new FundingSite() { AgencyCode = siteF.AgencyCode, CollectionCodeID = siteF.CollectionCodeID, DifficultyFactor = siteF.DifficultyFactor, DifficultyFactorReason = siteF.DifficultyFactorReason, FundingCustomer = siteF.FundingCustomer, FundingUSGSCMF = siteF.FundingUSGSCMF, CollectionUnits = siteF.CollectionUnits, SiteNumber = siteF.SiteNumber, StartDate = siteF.StartDate?.AddYears(1), EndDate = siteF.EndDate?.AddYears(1), Remarks = siteF.Remarks, CreatedBy = user.ID, CreatedDate = DateTime.Now, ModifiedBy = user.ID, ModifiedDate = DateTime.Now }); } //Add Studies Funding to the copyMod foreach (var studiesF in studiesFunding) { copyMod.FundingStudies.Add(new FundingStudy() { BasisProjectNumber = studiesF.BasisProjectNumber, ResearchCodeID = studiesF.ResearchCodeID, Units = studiesF.Units, Remarks = studiesF.Remarks, FundingCustomer = studiesF.FundingCustomer, FundingUSGSCMF = studiesF.FundingUSGSCMF, StartDate = studiesF.StartDate?.AddYears(1), EndDate = studiesF.EndDate?.AddYears(1), CreatedBy = user.ID, CreatedDate = DateTime.Now, ModifiedBy = user.ID, ModifiedDate = DateTime.Now }); } //Add Copied Mod to the copied agreement copy.AgreementMods.Add(copyMod); //Add copied agreement to the customer customer.Agreements.Add(copy); //Submit changes to the database siftaDB.SubmitChanges(); //Add the cooperative funding to the new agreement mod foreach (var cfunding in coopFunding) { copyMod.CooperativeFundings.Add(new CooperativeFunding() { AccountNumber = cfunding.AccountNumber, AgreementID = copy.AgreementID, CreatedBy = user.ID, CreatedDate = DateTime.Now, ModifiedBy = user.ID, ModifiedDate = DateTime.Now, Remarks = cfunding.Remarks, Status = "LOW", ModNumber = cfunding.ModNumber, FiscalYear = Convert.ToInt32(cfunding.FiscalYear) + 1, FundingCustomer = cfunding.FundingCustomer, FundingUSGSCMF = cfunding.FundingUSGSCMF }); } siftaDB.SubmitChanges(); foreach (var accFund in accFundSrc) { var newFund = new AccountFundSource(); newFund.AgreementModID = copyMod.AgreementModID; newFund.FundSourceFY = accFund.FundSourceFY + 1; newFund.AccountNumber = accFund.AccountNumber; newFund.CustomerClass = accFund.CustomerClass; newFund.MatchPair = accFund.MatchPair; newFund.ProgramElementCode = accFund.ProgramElementCode; newFund.Funding = accFund.Funding; newFund.FundStatus = "LOW"; newFund.Remarks = accFund.Remarks; newFund.CreatedBy = user.ID; newFund.CreatedDate = DateTime.Now; newFund.ModifiedBy = user.ID; newFund.ModifiedDate = DateTime.Now; siftaDB.AccountFundSources.InsertOnSubmit(newFund); } siftaDB.SubmitChanges(); //Update Records with Unique Record ID's RecordIdentifiers.UpdateRecords(); //Rebind the agreement grid rgAgreements.Rebind(); }
protected void rbSubmitCenterInformation_Click(object sender, EventArgs e) { center.Address = rtbAddress.Text; center.City = rtbCity.Text; center.State = rtbState.Text; center.ZipCode = rtbZipCode.Text; center.DUNS = rtbDUNS.Text; center.ProjectNumber = rtbProjectNumber.Text; center.ProjectName = rtbProjectName.Text; siftaDB.SubmitChanges(); }
public void SubmitChanges() { siftaDB.SubmitChanges(); }