/// <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);
}
