/// <summary> /// Updates a SurveyInfo. /// </summary> /// <param name="SurveyInfo">SurveyInfo.</param> public void UpdateSurveyInfo(SurveyInfoBO SurveyInfo) { try { Guid Id = new Guid(SurveyInfo.SurveyId); //Update Survey using (var Context = DataObjectFactory.CreateContext()) { //var Query = from response in Context.SurveyMetaDatas // where response.SurveyId == Id // select response; //var DataRow = Query.Single(); //DataRow = Mapper.ToEF(SurveyInfo); SurveyMetaData Row = Context.SurveyMetaDatas.First(x => x.SurveyId == Id); Row.IsSQLProject = SurveyInfo.IsSqlProject; Row.IsDraftMode = SurveyInfo.IsDraftMode; Row.IsShareable = SurveyInfo.IsShareable; Row.DataAccessRuleId = SurveyInfo.DataAccessRuleId; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/*====================================================*/ protected virtual bool WfTaskOutcome_CreateNewTaskAssignments(XmlNodeList aTaskNodeList) { foreach (XmlNode aTaskNode in aTaskNodeList) { //check if WfTaskAssignment already exists for GranteeProjectID, PersonID, WfTaskID int aNewTaskID = cXMLDoc.AttributeToInt(aTaskNode, "TaskKey", 0); string aUpdateExistingWFTA = cXMLDoc.AttributeToString(aTaskNode, "UpdateExistingWFTA", "True"); String aNewPersonProperty; int aNewPersonID = -1; int aDefaultWorkgroupID = -1; if (!cXMLDoc.AttributeToBool(aTaskNode, "NoPersonID", false)) { aNewPersonProperty = cXMLDoc.AttributeToString(aTaskNode, "PersonID"); if (aNewPersonProperty == "") aNewPersonProperty = "PersonID"; aNewPersonID = this.GetRelatedPropertyInt(aNewPersonProperty, -1); if (aNewPersonID == 0 || aNewPersonID == -1) { aNewPersonID = -1; aDefaultWorkgroupID = cXMLDoc.AttributeToInt(aTaskNode, "DefaultWorkgroupID", -1); } } XmlNode aDataObjectNode; XmlNode aFiltersNode; cXMLDoc aXmlDoc = this.DataObjectList.DataObjectFactory.CreateDataObjectNode("WfTaskAssignment", out aDataObjectNode, out aFiltersNode); aFiltersNode.AppendChild(this.DataObjectList.DataObjectFactory.CreateArgumentNode(aXmlDoc, "Data", "GranteeProjectID", this.GetPropertyString("GranteeProjectID"))); if (aNewPersonID != -1) aFiltersNode.AppendChild(this.DataObjectList.DataObjectFactory.CreateArgumentNode(aXmlDoc, "Data", "PersonID", aNewPersonID.ToString())); aFiltersNode.AppendChild(this.DataObjectList.DataObjectFactory.CreateArgumentNode(aXmlDoc, "Data", "WfTaskID", aNewTaskID.ToString())); aFiltersNode.AppendChild(this.DataObjectList.DataObjectFactory.CreateArgumentNode(aXmlDoc, "Data", "AppWftaID", this.GetPropertyString("WfTaskAssignmentID"))); XmlNodeList aExistingFiltersList = aTaskNode.SelectNodes("ExistingWfTAFilters/Argument"); foreach (XmlNode aExistingFilterNode in aExistingFiltersList) { WfTaskOutcome_SetRelatedDataObjectArgValues(null, aExistingFilterNode); aFiltersNode.InnerXml += aExistingFilterNode.OuterXml; } cWfTaskAssignment aWfTaskAssgDataObject = (cWfTaskAssignment)this.DataObjectList.DataObjectFactory.GetDataObject(aDataObjectNode); if (aWfTaskAssgDataObject == null){ //create new WfTaskAssignment object aWfTaskAssgDataObject = (cWfTaskAssignment)DataObjectFactory.CreateNewDataObjectFromKey("WfTaskAssignment"); aWfTaskAssgDataObject["WfTaskID"] = aNewTaskID; if (aNewPersonID != -1) aWfTaskAssgDataObject["PersonID"] = aNewPersonID; else if (aDefaultWorkgroupID != -1) aWfTaskAssgDataObject["WorkgroupID"] = aDefaultWorkgroupID; WfTaskOutcome_SaveNewTaskAssignment(aWfTaskAssgDataObject, aTaskNode); } else if (aUpdateExistingWFTA == "True") { WfTaskOutcome_SaveNewTaskAssignment(aWfTaskAssgDataObject, aTaskNode); } if (!aWfTaskAssgDataObject.ContinueProcessing) return false; //create related data objects XmlNodeList aRelatedDOList = aTaskNode.SelectNodes("RelatedDataObject"); foreach (XmlNode aRelatedDONode in aRelatedDOList) WfTaskOutcome_CreateTARelatedDataObject(aWfTaskAssgDataObject, aRelatedDONode); } return true; }
/*----------------------------------------------------*/ protected cDataObject WfTaskOutcome_CreateTARelatedDataObject(cDataObject aNewWfTaskAssgDataObject, XmlNode aRelatedDONode) { //Get related data object if it already exists. String aDODefKey = cXMLDoc.AttributeToString(aRelatedDONode, "DataObjectDefinitionKey"); XmlNodeList aFilterArgsList = aRelatedDONode.SelectNodes("Filters/Argument"); foreach (XmlNode aArgNode in aFilterArgsList) { WfTaskOutcome_SetRelatedDataObjectArgValues(aNewWfTaskAssgDataObject, aArgNode); } cDataObject aDataObject = DataObjectFactory.GetDataObject(aRelatedDONode); //If not, create a new one. if (aDataObject == null) aDataObject = DataObjectFactory.CreateNewDataObjectFromKey(aDODefKey); //Populate properties and save. XmlNodeList aPropertyArgsList = aRelatedDONode.SelectNodes("DataObjectProperties/Argument"); foreach (XmlNode aArgNode in aPropertyArgsList) { WfTaskOutcome_SetRelatedDataObjectArgValues(aNewWfTaskAssgDataObject, aArgNode); String aPropertyKey = cXMLDoc.AttributeToString(aArgNode, "PropertyKey"); aDataObject[aPropertyKey] = cXMLDoc.AttributeToString(aArgNode, "Value"); } int aUserID; aUserID = ((cPerson) this.GetRelatedPropertyDataObject("Person")).Get_EG_User(); aDataObject.DataObjectList.UserID = aUserID; aDataObject.SaveData(); if (cXMLDoc.AttributeToString(aRelatedDONode, "Key") != "") { RelatedDataObjectCollection.Add(cXMLDoc.AttributeToString(aRelatedDONode, "Key"), aDataObject); } return aDataObject; }
private void ImportAction_Execute(object sender, SimpleActionExecuteEventArgs e) { var paramObj = (ImportArCustomersParam)View.CurrentObject; var conn = (SqlConnection)((XPObjectSpace)ObjectSpace).Connection; var loader = new SqlServerLoader(conn); loader.CreateSql = @"CREATE TABLE {TempTable} ( CustomerNumber nvarchar(255), CustomerName nvarchar(255), Collector nvarchar(255), Activity nvarchar(255) )"; loader.PersistSql = @"DELETE FROM VHAFinance.dbo.ArCustomers INSERT INTO VHAFinance.dbo.ArCustomers SELECT CustomerNumber, CustomerName, Collector, Activity FROM {TempTable}"; var sourceTable = DataObjectFactory.CreateTableFromExcelXml(paramObj.FilePath, "ArCustomers"); var messagesText = loader.Execute(sourceTable); new Xafology.ExpressApp.SystemModule.GenericMessageBox( messagesText, "Import Successful" ); }
public IList <Measure> GetMeasures() { using (var context = DataObjectFactory.CreateContext()) { var measures = context.Measures.ToList(); return(measures.Select(Mapper.Map).ToList()); } }
// get Employee by id public Employee GetEmployeeById(int employeeId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Employees.FirstOrDefault(e => e.EmployeeId == employeeId); return(entity == null ? null : Mapper.Map(entity)); } }
public IList <Employee> GetEmployees() { using (var context = DataObjectFactory.CreateContext()) { var employees = context.Employees.ToList(); return(employees.Select(Mapper.Map).ToList()); } }
public void AddCustomState(string name) { ICustomState customState = DataObjectFactory.CreateObject <ICustomState> (); customState.Name = name; customState.Color = DefaultStateColor; CustomStates.Add(customState); }
public static List <Product> GetProductsForLocation(Location location) { Expression <Func <Product_Location, Product, Manufacturer, ProductCategory, object> > ex = (pl, p, m, pc) => pl.FK_LocationId == location.Id && p.Id == pl.FK_ProductId && m.Id == p.FK_ManufacturerId && pc.Title == p.FK_ProductCategoryTitle; return(DataObjectFactory.Select <Product>(ex)); }
// get Measure by id public Measure GetMeasureById(int measureId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Measures.FirstOrDefault(e => e.MeasureId == measureId); return(entity == null ? null : Mapper.Map(entity)); } }
// get product by id public Product GetProduct(int productId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Products.FirstOrDefault(e => e.ProductId == productId); return(entity == null ? null : Mapper.Map(entity)); } }
/// <summary> /// Gets a product given a product identifier. /// </summary> /// <param name="productId">Product identifier.</param> /// <returns>The product.</returns> public Product GetProduct(int productId) { using (var context = DataObjectFactory.CreateContext()) { return(Mapper.Map(context.ProductEntities .SingleOrDefault(p => p.ProductId == productId))); } }
/*====================================================*/ /* A SQL version of the above method. All Updates a wraped in a DB transaction. * Use only this method for DB integrity and consistency. */ public void GenerateGrantNumberSP() { string aSQLStr = "GenerateGrantNumber @GranteeProjectID=" + this.GetPropertyString("GranteeProjectID"); cDataProviderSQL aDP; aDP = (cDataProviderSQL)DataObjectFactory.GetDataProvider("EGDatabase"); aDP.DBConn.ExecuteCommand(aSQLStr); }
public Company GetCompany(int companyId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Companies.FirstOrDefault(e => e.CompanyId == companyId); return(entity == null ? null : Mapper.Map(entity)); } }
public CompanyLocation GetLocation(int locationId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.CompanyLocations.FirstOrDefault(e => e.CompanyLocationId == locationId); return(entity == null ? null : Mapper.Map(entity)); } }
public IList <Vendor> GetVendors() { using (var context = DataObjectFactory.CreateContext()) { var vendors = context.Vendors.ToList(); return(vendors.Select(Mapper.Map).ToList()); } }
// get Vendor by id public Vendor GetVendorById(int vendorId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Vendors.FirstOrDefault(e => e.VendorId == vendorId); return(entity == null ? null : Mapper.Map(entity)); } }
// get Supplier by id public Supplier GetSupplierById(int supplierId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Suppliers.FirstOrDefault(e => e.SupplierId == supplierId); return(entity == null ? null : Mapper.Map(entity)); } }
/*----------------------------------------------------*/ public void FinalizeSelectedProjectOutcomes(int aGranteeProjectID, int aProposedOutcomeID) { cDataObject aGPDO; //workflow task assignment aGPDO = DataObjectFactory.GetDataObjectFromPrimaryKey("GranteeProject", aGranteeProjectID); aGPDO["WfProjectOutcomeID"] = aProposedOutcomeID; DataObjectFactory.SaveDataObject(aGPDO); }
/*----------------------------------------------------*/ public void ReportOutput_Delete() { int aRptOutDataID; aRptOutDataID = GetRelatedPropertyInt("ReportOutputData.ReportOutputDataID"); DataObjectFactory.DeleteData("ReportOutputData", aRptOutDataID.ToString()); DataObjectFactory.DeleteData(this); }
public IList <Supplier> GetSuppliers() { using (var context = DataObjectFactory.CreateContext()) { var suppliers = context.Suppliers.ToList(); return(suppliers.Select(Mapper.Map).ToList()); } }
// get Currency by id public Currency GetCurrencyById(int currencyId) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Currencys.FirstOrDefault(e => e.CurrencyId == currencyId); return(entity == null ? null : Mapper.Map(entity)); } }
public IList <Currency> GetCurrencys() { using (var context = DataObjectFactory.CreateContext()) { var currencys = context.Currencys.ToList(); return(currencys.Select(Mapper.Map).ToList()); } }
// get all products public List <Product> GetProducts() { using (var context = DataObjectFactory.CreateContext()) { var products = context.Products.ToList(); return(products.Select(Mapper.Map).ToList()); } }
/*-----------------------------------------------------*/ public cEGUser LoginUserFromCredentials(String aLoginID, String aPassword, bool aEnforceUserNameCase, bool aEnforcePasswordCase) { cEGUser aUser; cXMLDoc aModuleDoc; String startPage=""; String redirectUrl; aUser = ValidateLoginCredentials(aLoginID, aPassword, aEnforceUserNameCase, aEnforcePasswordCase, out aModuleDoc); if (aUser != null) { //for logging login history LogLoginHistory(aUser.UserID); //getting the start page for extranet users cDataObject aUserDO = DataObjectFactory.GetDataObjectListWithFilter("User", "UserID", aUser.UserID.ToString())[0]; if (CurrentPage.Request["RequestKeyOut"]!="" && CurrentPage.Request["RequestKeyOut"]!= null) { startPage = CurrentPage.Request["RequestKeyOut"]; } else { cDataObject aExtranetUser = DataObjectFactory.GetDataObjectListWithFilter("ExtranetGroup", "EasygrantsUserID", aUser.UserID.ToString())[0]; if (aExtranetUser != null) { startPage = aExtranetUser.GetRelatedPropertyString("SecurityGroup.StartPage"); } } if (CurrentPage.Request["returnurl"] != "" && CurrentPage.Request["returnurl"] != null) { redirectUrl = WebAppl.Root + WebAppl.Root + "/Gateway/pgGateway.aspx"; redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "Direction", "Out"); //redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "RequestKey", CurrentPage.Request["RequestKeyIn"]); redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "returnurl", CurrentPage.Request["returnurl"]); CurrentPage.Redirect(redirectUrl); } else if (CurrentPage.Request["RequestKeyIn"]!= "" && CurrentPage.Request["RequestKeyIn"] != null) { redirectUrl = WebAppl.Root + WebAppl.Root + "/Gateway/pgGateway.aspx"; redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "Direction", "In"); redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "RequestKeyIn", CurrentPage.Request["RequestKeyIn"]); //redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "TargetUrl", CurrentPage.Request.UrlReferrer.ToString()); CurrentPage.Redirect(redirectUrl); } else if (startPage == null || startPage == "" ) { ((cModulePage)CurrentPage).ModulePage_RedirectToModule(aModuleDoc); } else { redirectUrl = WebAppl.Root + WebAppl.Root + "/Gateway/pgGateway.aspx"; redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "Direction", "Out"); redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "RequestKey", startPage); //redirectUrl = cWebLib.AddQuerystringParameter(redirectUrl, "TargetUrl", CurrentPage.Request.UrlReferrer.ToString()); CurrentPage.Redirect(redirectUrl); } } return aUser; }
/// <summary> /// Deletes a customer record from the database. /// </summary> /// <param name="customer">The customer to be deleted.</param> /// <returns>Number of rows affected.</returns> public void DeleteCustomer(Customer customer) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.CustomerEntities.Where(c => c.CustomerId == customer.CustomerId).SingleOrDefault(); context.CustomerEntities.DeleteObject(entity); context.SaveChanges(); } }
/// <summary> /// Update existing student /// </summary> /// <param name="id">Unique student identifier</param> /// <param name="student">Unique student object</param> public void PatchStudent(int id, Student student) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Students.Where(s => s.StudentId == id).FirstOrDefault(); entity.StudentName = student.StudentName; context.SaveChanges(); } }
internal IGenre MapGenreCoreToData(Genre genreCore) { DataObjectFactory dataObjectFactory = new DataObjectFactory(); IGenre genreData = (IGenre)dataObjectFactory.RetrieveObject("genre"); genreData.genreID = genreCore.id; genreData.name = genreCore.name; return(genreData); }
public void DataObjectFactory_GetPropertyObjectFor_CreatesCorrectObject(string dataObjectType, Type valueType) { var valueProvider = new DefaultValueProvider(); object defaultValue = valueProvider.GetValue(valueType); DataObject obj = DataObjectFactory.GetPropertyObjectFor("name", defaultValue); Assert.Equal(dataObjectType, obj.Type); }
public int DeleteCurrency(int id = 0) { using (var context = DataObjectFactory.CreateContext()) { var entity = context.Currencys.FirstOrDefault(s => s.CurrencyId == id); context.Currencys.Remove(entity); return(context.SaveChanges()); } }
public void CountTest() { DataObjectFactory DOFactory = new DataObjectFactory(_DAL); ObjectCache target = new ObjectCache(DOFactory); target.GetByID<SaleDO>(1); Assert.Equal(1, target.Count); var tempSale = new SaleDO { rowID = 2 }; target.Add( tempSale, ObjectCache.AddBehavior.THROWEXCEPTION); Assert.Equal(2, target.Count); target.Remove(tempSale); Assert.Equal(1, target.Count); //target.Clear(); //Assert.AreEqual(0, target.Count); }
public ObjectCacheTest() { _DAL = new DAL("ObjectCacheTest.cruise", true); _DOFactory = new DataObjectFactory(_DAL); }