public static Usuario VerificarUsuario(string password, int user) { try { var usuario = new Usuario(); using (DBContext db = new DBContext()) { var check = Encrypt(password); var pass = Decrypt(password); var query = from u in db.Usuario where u.idUsuario == user && u.senhaUsuario == pass select u; foreach (Usuario u in query) { usuario = u; } } return usuario; } catch (Exception) { return null; } }
public override Exceptional<IObject> Aggregate(AAttributeIndex attributeIndex, GraphDBType graphDBType, DBContext dbContext) { //if (graphDBType.IsAbstract) //{ // #region For abstract types, count all attribute idx of the subtypes // UInt64 count = 0; // foreach (var aSubType in dbContext.DBTypeManager.GetAllSubtypes(graphDBType, false)) // { // if (!aSubType.IsAbstract) // { // count += aSubType.GetUUIDIndex(dbContext.DBTypeManager).GetValueCount(); // } // } // return new Exceptional<IObject>(new DBUInt64(count)); // #endregion //} //else //{ #region Return the count of idx values var indexRelatedType = dbContext.DBTypeManager.GetTypeByUUID(attributeIndex.IndexRelatedTypeUUID); return new Exceptional<IObject>(new DBUInt64(attributeIndex.GetValueCount())); #endregion //} }
public static BomoUsuario VerificarUsuarioBomo(string password, string user) { try { var usuario = new BomoUsuario(); DBContext db = new DBContext(); //var check = Encrypt(password); var pass = Encrypt(password); var query = from u in db.BomoUsuario where u.bomoCliente.email == user && u.senha == pass select u; foreach (BomoUsuario u in query) { usuario = u; } return usuario; } catch (Exception) { return null; } }
public ActionResult AddBulletin(string packageid, FormCollection form) { SetMenuSelection("Apps"); if (Session["UserID"] == null) return RedirectToAction("Login", "Home"); DBContext db = new DBContext(); ViewData["PackageID"] = packageid; if (form.Count > 0) { //create if (form["txtCreateTitle"] == string.Empty) { ViewData["CreateStatus"] = "Title is required"; return View(); } MetrixBulletinBoardAnnouncement mbba = new MetrixBulletinBoardAnnouncement(); mbba.Message = form["editorCreate"]; mbba.PackageID = packageid; mbba.Title = form["txtCreateTitle"]; db.MetrixBulletinBoardAnnouncements.InsertOnSubmit(mbba); db.SubmitChanges(); Response.Redirect("/Apps/Bulletin/" + packageid); } return View(); }
public override Exceptional<IObject> Aggregate(AAttributeIndex attributeIndex, GraphDBType graphDBType, DBContext dbContext) { if (attributeIndex is UUIDIndex) { return new Exceptional<IObject>(new Error_NotImplemented(new System.Diagnostics.StackTrace(true), "Aggregating attribute UUID is not implemented!")); } else { var indexRelatedType = dbContext.DBTypeManager.GetTypeByUUID(attributeIndex.IndexRelatedTypeUUID); // HACK: rewrite as soon as we have real attribute index keys if (attributeIndex.IndexKeyDefinition.IndexKeyAttributeUUIDs.Count != 1) { return new Exceptional<IObject>(new Error_NotImplemented(new System.Diagnostics.StackTrace(true))); } var typeAttr = graphDBType.GetTypeAttributeByUUID(attributeIndex.IndexKeyDefinition.IndexKeyAttributeUUIDs.First()); ADBBaseObject oneVal = typeAttr.GetADBBaseObjectType(dbContext.DBTypeManager); return new Exceptional<IObject>(attributeIndex.GetKeyValues(indexRelatedType, dbContext).AsParallel().Select(kv => { var mul = oneVal.Clone(kv.Key); mul.Mul(oneVal.Clone(kv.Value.Count())); return mul; }).Aggregate(oneVal.Clone(), (elem, result) => { result.Add(elem); return result; })); } }
/// <summary> /// <seealso cref=" AAttributeAssignOrUpdate"/> /// </summary> public override Exceptional<IObject> GetValueForAttribute(DBObjectStream myDBObject, DBContext myDBContext, GraphDBType myGraphDBType) { if (AttributeIDChain.IsUndefinedAttribute) { return new Exceptional<IObject>(GraphDBTypeMapper.GetBaseObjectFromCSharpType(Value)); } #region Simple value var dbType = AttributeIDChain.LastAttribute.GetDBType(myDBContext.DBTypeManager); if (AttributeIDChain.LastAttribute is SpecialTypeAttribute_UUID) { dbType = myDBContext.DBTypeManager.GetTypeByName(GraphDBTypeMapper.GetBaseObjectFromCSharpType(Value).ObjectName);//DBString.Name); } if (GraphDBTypeMapper.IsAValidAttributeType(dbType, AttributeAssignType, myDBContext, Value)) { return new Exceptional<IObject>(GraphDBTypeMapper.GetGraphObjectFromType(AttributeAssignType, Value)); ; } else { return new Exceptional<IObject>(new Error_InvalidAttributeValue(AttributeIDChain.LastAttribute.Name, Value)); } #endregion }
public override IEnumerable<ObjectUUID> IndexSingleOperation(AAttributeIndex myIndex, ADBBaseObject myOperationValue, AttributeUUID myAttributeUUID, TypesOfBinaryExpression typeOfBinExpr, DBContext dbContext) { IndexKey lookup = new IndexKey(myAttributeUUID, myOperationValue, myIndex.IndexKeyDefinition); var currentType = dbContext.DBTypeManager.GetTypeByUUID(myIndex.IndexRelatedTypeUUID); var result = myIndex.Contains(lookup, currentType, dbContext); if (result.Value) { var interestingUUIDs = myIndex.GetValues(lookup, currentType, dbContext); foreach (var aIndexValue in myIndex.GetAllValues(currentType, dbContext)) { foreach (var aUUID in aIndexValue) { if (!interestingUUIDs.Contains(aUUID)) { yield return aUUID; } } } } else { foreach (var aIndexValue in myIndex.GetKeyValues(currentType, dbContext).Select(kv => kv.Value)) { foreach (var aUUID in aIndexValue) { yield return aUUID; } } } yield break; }
public DBTypeManager(DBTypeManager dBTypeManager) { _DBContext = dBTypeManager._DBContext; _UserID = dBTypeManager._UserID; _DatabaseRootPath = dBTypeManager._DatabaseRootPath; _IGraphFSSession = dBTypeManager._IGraphFSSession; _ObjectLocationsOfAllUserDefinedDatabaseTypes = dBTypeManager._ObjectLocationsOfAllUserDefinedDatabaseTypes; _SystemTypes = dBTypeManager._SystemTypes; _BasicTypes = dBTypeManager._BasicTypes; _GUIDTypeAttribute = dBTypeManager._GUIDTypeAttribute; //TODO: As soon as we have serialized Indices we can recomment these sections #region As soon as we have serialized Indices we can recomment these sections //_UserDefinedTypes = dBTypeManager._UserDefinedTypes; //_TypesNameLookUpTable = dBTypeManager._TypesNameLookUpTable; foreach (GraphDBType ptype in _SystemTypes.Values) _TypesNameLookUpTable.Add(ptype.Name, ptype); foreach (GraphDBType ptype in _BasicTypes.Values) _TypesNameLookUpTable.Add(ptype.Name, ptype); LoadUserDefinedDatabaseTypes(false); #endregion }
/// <summary> /// Constructor /// </summary> /// <param name="dbContext">The TypeManager of the database.</param> public CommonUsageGraph(DBContext dbContext) : this() { _DBContext = dbContext; _DBObjectCache = _DBContext.DBObjectCache; _Levels = new Dictionary<int, IExpressionLevel>(); }
public ActionResult Login(FormCollection form) { if (form.Count > 0) { DBContext db = new DBContext(); User u = (from t in db.Users where t.Login == form[0] && t.Password == UtilCommand.GetMD5(form[1]) select t).FirstOrDefault(); if (u == null) return View(); Session["UserID"] = u.ID; Session["UserTypes"] = u.UserUserTypes.ToList(); Session["License"] = u.SignedLicense; if (u.AuthKey == null) { if (u.UserUserTypes.Where(i => i.UserType.Name == Constants.UserTypes.Admin).Count() > 0) return RedirectToAction("Apps", "Admin"); else return RedirectToAction("List", "Apps"); } else return RedirectToAction("Authentication", "Profile"); } return View(); }
public QueryResult Import(String location, IGraphDBSession graphDBSession, DBContext myDBContext, UInt32 parallelTasks = 1, IEnumerable<string> comments = null, UInt64? offset = null, UInt64? limit = null, VerbosityTypes verbosityType = VerbosityTypes.Errors) { IEnumerable<String> lines = null; #region Read querie lines from location try { if (location.ToLower().StartsWith(@"file:\\")) { lines = ReadFile(location.Substring(@"file:\\".Length)); } else if (location.ToLower().StartsWith("http://")) { lines = ReadHttpResource(location); } else { return new QueryResult(new Exceptional(new Error_InvalidImportLocation(location, @"file:\\", "http://"))); } } catch (Exception ex) { return new QueryResult(new Exceptional(new Error_ImportFailed(ex))); } #endregion #region Start import using the AGraphDBImport implementation return Import(lines, graphDBSession, myDBContext, parallelTasks, comments, offset, limit, verbosityType); #endregion }
public override Exceptional<FuncParameter> ExecFunc(DBContext dbContext, params FuncParameter[] myParams) { Exceptional<FuncParameter> result = new Exceptional<FuncParameter>(); if (CallingObject is DBUInt64) { try { var dtValue = new DateTime(System.Convert.ToInt64(((DBUInt64)CallingObject).Value)); result.Value = new FuncParameter(new DBInt64(dtValue.ToUnixTimeStamp())); } catch (Exception e) { return new Exceptional<FuncParameter>(new Error_UnknownDBError(e.Message)); } return result; } else if (CallingObject is DBDateTime) { result.Value = new FuncParameter(new DBInt64(((DateTime)((DBDateTime)CallingObject).Value).ToUnixTimeStamp())); } else { Debug.Assert(false); // this should never happen due to the ValidateWorkingBase method return new Exceptional<FuncParameter>(new Error_FunctionParameterTypeMismatch(typeof(DBDateTime), CallingObject.GetType())); } return result; }
public HttpResponseMessage Add(List<Gallery> items) { try { foreach (var item in items) { List<string> content = item.Content.Split(',').ToList(); var bytes = Convert.FromBase64String(content[1]); string mappath = HttpContext.Current.Server.MapPath("~/Assets/img/gallery/"); var filepath = Path.Combine(mappath, item.Name); //string filepath = String.Format(mappath + "{0}", item.Name); using (var imageFile = new FileStream(filepath, FileMode.Create)) { imageFile.Write(bytes, 0, bytes.Length); imageFile.Flush(); } item.Content = String.Format("Assets/img/gallery/{0}", item.Name); } using (var db = new DBContext()) { db.Galleries.AddRange(items); db.SaveChanges(); return Request.CreateResponse(HttpStatusCode.Accepted); } } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest,ex.Message); } }
public ActionResult About() { AboutListViewModel aboutListViewModel = new AboutListViewModel(); //add AboutViewModel List<AboutViewModel> listAVM = new List<AboutViewModel>(); List<About> listAbout = new DBContext().Abouts.Where(a => a.IsDelete != true).OrderBy(a => a.Id).ToList(); AboutViewModel AboutViewModel; foreach (var item in listAbout) { AboutViewModel = new AboutViewModel(); AboutViewModel.Title = item.Title; AboutViewModel.Content = item.content; AboutViewModel.Thumbnail = item.Thumbnails; listAVM.Add(AboutViewModel); } aboutListViewModel.listAboutViewModel = listAVM; //Add Welcome Welcome welcome = new DBContext().Welcomes.Where(w => w.IsDelete != null).FirstOrDefault(); if (welcome != null) { aboutListViewModel.WelcomeTitle = welcome.Title; aboutListViewModel.WelcomeContext = welcome.Content; aboutListViewModel.WelcomeBackground = welcome.Background; aboutListViewModel.WelcomeLinkVideo = welcome.LinkVideo; } return View(aboutListViewModel); }
protected Exceptional RemoveBackwardEdges(TypeUUID myTypeUUID, Dictionary<AttributeUUID, object> myUserdefinedAttributes, ObjectUUID myObjectUUIDReference, DBContext myDBContext) { #region get type that carries the attributes var aType = myDBContext.DBTypeManager.GetTypeByUUID(myTypeUUID); #endregion #region process attributes foreach (var aUserDefinedAttribute in myUserdefinedAttributes) { #region Data GraphDBType typeOFAttribute = null; TypeAttribute attributesOfType = null; #endregion #region get GraphType of Attribute attributesOfType = aType.Attributes[aUserDefinedAttribute.Key]; typeOFAttribute = myDBContext.DBTypeManager.GetTypeByUUID(attributesOfType.DBTypeUUID); #endregion IEnumerable<Exceptional<DBObjectStream>> listOfObjects; if (aUserDefinedAttribute.Value is IReferenceEdge) { listOfObjects = ((IReferenceEdge)aUserDefinedAttribute.Value).GetAllEdgeDestinations(myDBContext.DBObjectCache); } else { listOfObjects = myDBContext.DBObjectCache.LoadListOfDBObjectStreams(typeOFAttribute, (HashSet<ObjectUUID>)aUserDefinedAttribute.Value); } foreach (var aDBObject in listOfObjects) { if (aDBObject.Failed()) { return new Exceptional(aDBObject); } var removeExcept = myDBContext.DBObjectManager.RemoveBackwardEdge(aDBObject.Value, myTypeUUID, aUserDefinedAttribute.Key, myObjectUUIDReference); if (removeExcept.Failed()) { return new Exceptional(removeExcept); } } } #endregion return Exceptional.OK; }
public override Exceptional<FuncParameter> ExecFunc(DBContext dbContext, params FuncParameter[] myParams) { if (CallingObject != null) return new Exceptional<FuncParameter>(new FuncParameter(new DBBoolean(true))); else return new Exceptional<FuncParameter>(new FuncParameter(new DBBoolean(false))); }
public ADBBaseObject GetValue(GraphDBType myTypeID, TypeAttribute myAttrID, UUID mySettingUUID, DBContext context) { if (_TypeAttrSetting.ContainsKey(myTypeID.UUID)) { if (_TypeAttrSetting[myTypeID.UUID].ContainsKey(myAttrID.UUID)) { if (_TypeAttrSetting[myTypeID.UUID][myAttrID.UUID].ContainsKey(mySettingUUID)) { return _TypeAttrSetting[myTypeID.UUID][myAttrID.UUID][mySettingUUID]; } } else { _TypeAttrSetting[myTypeID.UUID].Add(myAttrID.UUID, new Dictionary<UUID, ADBBaseObject>()); } } else { _TypeAttrSetting.Add(myTypeID.UUID, new Dictionary<AttributeUUID, Dictionary<UUID, ADBBaseObject>>()); _TypeAttrSetting[myTypeID.UUID].Add(myAttrID.UUID, new Dictionary<UUID, ADBBaseObject>()); } //we are here, so we have to add the setting and return it var settingValue = context.DBSettingsManager.GetSettingValue(mySettingUUID, context, TypesSettingScope.ATTRIBUTE, myTypeID, myAttrID).Value.Clone(); _TypeAttrSetting[myTypeID.UUID][myAttrID.UUID].Add(mySettingUUID, settingValue); return settingValue; }
public override Exceptional<IObject> Aggregate(IEnumerable<DBObjectStream> myDBObjects, TypeAttribute myTypeAttribute, DBContext myDBContext, params Functions.ParameterValue[] myParameters) { var foundFirstMax = false; var aggregateResult = myTypeAttribute.GetADBBaseObjectType(myDBContext.DBTypeManager); foreach (var dbo in myDBObjects) { var attrResult = dbo.GetAttribute(myTypeAttribute, myTypeAttribute.GetDBType(myDBContext.DBTypeManager), myDBContext); if (attrResult.Failed()) { return attrResult; } var attr = attrResult.Value; if (attr != null && attr is ADBBaseObject && aggregateResult.IsValidValue((attr as ADBBaseObject).Value)) { if (foundFirstMax == false) { aggregateResult.Value = (attr as ADBBaseObject).Value; foundFirstMax = true; } else { if (aggregateResult.CompareTo((attr as ADBBaseObject).Value) < 0) { aggregateResult.Value = (attr as ADBBaseObject).Value; } } } else { return new Exceptional<IObject>(new Error_AggregateIsNotValidOnThisAttribute(myTypeAttribute.Name)); } } return new Exceptional<IObject>(aggregateResult); }
public async Task<IEnumerable<CvViewModel>> Get() { List<CvViewModel> cvs = new List<CvViewModel>(); DirectoryInfo photoFolder = new DirectoryInfo(this.workingFolder); var db = new DBContext(); var cvList = new List<CvViewModel>(); await Task.Factory.StartNew(() => { cvs = photoFolder.EnumerateFiles() .Where(fi => new[] { ".doc", ".pdf", ".docx", ".txt", ".rtf", ".odt" }.Contains(fi.Extension.ToLower())) .Select(fi => new CvViewModel { Name = fi.Name, Created = fi.CreationTime, Modified = fi.LastWriteTime, Size = fi.Length / 1024 }) .ToList(); foreach (var item in cvs) { // TODO check if Resume is deleted var resume = db.CVs.FirstOrDefault(f => f.Name.Equals(item.Name, StringComparison.InvariantCultureIgnoreCase)); if (resume!= null) { item.Id = resume.Guid; cvList.Add(item); } } }); return cvList; }
public override QueryResult Import(IEnumerable<String> myLines, IGraphDBSession myIGraphDBSession, DBContext myDBContext, UInt32 parallelTasks = 1, IEnumerable<String> comments = null, ulong? offset = null, ulong? limit = null, VerbosityTypes verbosityTypes = VerbosityTypes.Errors) { var gqlQuery = new GraphQLQuery(myDBContext.DBPluginManager); #region Evaluate Limit and Offset if (offset != null) { myLines = myLines.SkipULong(offset.Value); } if (limit != null) { myLines = myLines.TakeULong(limit.Value); } #endregion var queryResult = new QueryResult(); #region Import queries if (parallelTasks > 1) { queryResult = ExecuteAsParallel(myLines, myIGraphDBSession, gqlQuery, verbosityTypes, parallelTasks, comments); } else { queryResult = ExecuteAsSingleThread(myLines, myIGraphDBSession, gqlQuery, verbosityTypes, comments); } #endregion return queryResult; }
public override Exceptional<FuncParameter> ExecFunc(DBContext dbContext, params FuncParameter[] myParams) { var pResult = new Exceptional<FuncParameter>(); // The edge we starting of (Friends) var typeAttribute = CallingAttribute; // Get the source Objects from the CallingObject, if this is not a reference this function is used in a wrong context and return a error IEnumerable<ObjectUUID> sourceDBOs = null; if (CallingObject is IReferenceEdge) { sourceDBOs = (CallingObject as ASetOfReferencesEdgeType).GetAllReferenceIDs(); } else { throw new GraphDBException(new Error_InvalidEdgeType(CallingAttribute.EdgeType.GetType(), typeof(ASetOfReferencesEdgeType), typeof(ASingleReferenceEdgeType))); } // The destination DBObjects which are passed with the first parameter var destDBOs = (myParams[0].Value as DBEdge).GetDBObjects(); if (destDBOs == null) { throw new GraphDBException(new Error_InvalidEdgeType(CallingAttribute.EdgeType.GetType(), typeof(ASetOfReferencesEdgeType), typeof(ASingleReferenceEdgeType))); } // The depth which is passed as the second parameter Int64 mayDepth = (myParams[1].Value as DBInt64).GetValue(); // Call your own implementation of a path function and return the result, in this case it is a list of DB object (uuids) var resultOfPathFunction = new List<ObjectUUID>(); pResult.Value = new FuncParameter(new EdgeTypeSetOfReferences(resultOfPathFunction, CallingAttribute.DBTypeUUID)); return pResult; }
public override Exceptional<FuncParameter> Aggregate(IEnumerable<DBObjectStream> myDBObjects, TypeAttribute myTypeAttribute, DBContext myDBContext, params Functions.ParameterValue[] myParameters) { var aggregateResult = new DBDouble(0d); var total = 0UL; foreach (var dbo in myDBObjects) { var attr = dbo.GetAttribute(myTypeAttribute, myTypeAttribute.GetDBType(myDBContext.DBTypeManager), myDBContext); if (attr.Failed()) { return new Exceptional<FuncParameter>(attr); } if (attr.Value != null && attr.Value is ADBBaseObject && aggregateResult.IsValidValue((attr.Value as ADBBaseObject).Value)) { aggregateResult.Add((attr.Value as ADBBaseObject)); total++; } else { return new Exceptional<FuncParameter>(new Error_AggregateIsNotValidOnThisAttribute(myTypeAttribute.Name)); } } aggregateResult.Div(new DBUInt64(total)); return new Exceptional<FuncParameter>(new FuncParameter(aggregateResult)); }
/// <summary> /// /// </summary> /// <param name="myParams">The parameters which must match the _Parameters list defined in the constructor.</param> /// <returns>The Value of the GraphResult is of type FuncParameter. The TypeAttribute of FuncParameter will contain NOT NULL if the TypeOfResult is a DBReference or DBList</returns> public virtual Exceptional<FuncParameter> ExecFunc(DBContext dbContext, params FuncParameter[] myParams) { Boolean containsVariableNumOfParams = Parameters.Exists(p => p.VariableNumOfParams); #region check number of parameters if (Parameters.Count != myParams.Length && (!containsVariableNumOfParams)) { return new Exceptional<FuncParameter>(new Error_FunctionParameterCountMismatch(this, Parameters.Count, myParams.Length)); } else if (containsVariableNumOfParams && myParams.Length == 0) { return new Exceptional<FuncParameter>(new Error_FunctionParameterCountMismatch(this, Parameters.Count, myParams.Length)); } #endregion #region check parameter types Int32 definedParamCounter = 0; for (Int32 i = 0; i < myParams.Count(); i++) { if (!Parameters[definedParamCounter].DBType.IsValidValue(((FuncParameter)myParams[i]).Value)) { return new Exceptional<FuncParameter>(new Error_FunctionParameterTypeMismatch(Parameters[definedParamCounter].DBType.GetType(), myParams[i].GetType())); } Parameters[definedParamCounter].DBType.SetValue(((FuncParameter)myParams[i]).Value); if (!Parameters[definedParamCounter].VariableNumOfParams) definedParamCounter++; } #endregion return new Exceptional<FuncParameter>(); }
public override IEnumerable<ObjectUUID> IndexOperation(AAttributeIndex myIndex, TupleDefinition myTuple, TypesOfBinaryExpression typeOfBinExpr, DBContext dbContext) { if (myTuple.Count() != 2) { throw new GraphDBException(new Error_InvalidInRangeInterval(2, myTuple.Count())); } var currentType = dbContext.DBTypeManager.GetTypeByUUID(myIndex.IndexRelatedTypeUUID); #region As soon as the index supports ranges use them!! //limits var fromKey = new IndexKey(myIndex.IndexKeyDefinition.IndexKeyAttributeUUIDs[0], (myTuple.ElementAt(0).Value as ValueDefinition).Value, myIndex.IndexKeyDefinition); var toKey = new IndexKey(myIndex.IndexKeyDefinition.IndexKeyAttributeUUIDs[0], (myTuple.ElementAt(1).Value as ValueDefinition).Value, myIndex.IndexKeyDefinition); switch (myTuple.KindOfTuple) { case KindOfTuple.Inclusive: return myIndex.InRange(fromKey, toKey, true, true, currentType, dbContext); case KindOfTuple.LeftExclusive: return myIndex.InRange(fromKey, toKey, false, true, currentType, dbContext); case KindOfTuple.RightExclusive: return myIndex.InRange(fromKey, toKey, true, false, currentType, dbContext); case KindOfTuple.Exclusive: return myIndex.InRange(fromKey, toKey, false, false, currentType, dbContext); default: throw new GraphDBException(new Error_NotImplemented(new System.Diagnostics.StackTrace(true))); } #endregion }
public IQueryable<CompStore.Model.Employee> GridView1_GetData() { var db = new DBContext(); IQueryable<CompStore.Model.Employee> result = from b in db.People.OfType<Employee>() select b; return result; }
public override Exceptional<FuncParameter> ExecFunc(DBContext dbContext, params FuncParameter[] myParams) { if (CallingObject is ADBBaseObject) return new Exceptional<FuncParameter>(new FuncParameter(new DBString((CallingObject as ADBBaseObject).Value.ToString().ToLower()))); else return new Exceptional<FuncParameter>(new Errors.Error_NotImplemented(new System.Diagnostics.StackTrace(true))); }
public HttpResponseMessage AddServicosEmpresa([FromBody]JObject model) { try { dynamic json = model; List<EmpresaServico> listCadastrar = new List<EmpresaServico>(); DBContext db = new DBContext(); int idServico = 0; int idEmpresa = 0; idEmpresa = json.idEmpresa; json = model["Servicos"]; foreach (var s in json) { EmpresaServico es = new EmpresaServico(); idServico = s.idServico; es.servico = db.Servico.Single(x => x.idServico == idServico); es.empresa = db.Empresa.Single(x => x.idEmpresa == idEmpresa); es.tempoServico = s.tempoServico == null ? 0 : s.tempoServico; es.valorServico = s.valorServico == null ? 0 : s.valorServico; db.EmpresaServico.Add(es); } db.SaveChanges(); return Request.CreateResponse(HttpStatusCode.OK); } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); } }
public static List<WorkZoneListInfo> GetWorkZoneListSearch(int companyId, string WorkZoneName, string DateMin, string DateMax, string FactoryName,string MachineName) { if(DateMin==string.Empty) DateMin ="1/1/1973"; if(DateMax ==string.Empty) DateMax ="12/31/2999"; var context = new DBContext(); return (from w in context.GetTable<WorkZone>() from f in context.GetTable<Factory>() from m in context.GetTable<Machine>() where w.CompanyId == companyId && w.FactoryId == f.FactoryId && w.MachineId == m.MachineId && w.Name.Contains(WorkZoneName) && f.Name.Contains(FactoryName) && m.Name.Contains(MachineName) && w.ProgramDate >= Convert.ToDateTime(DateMin) && w.ProgramDate <= Convert.ToDateTime(DateMax) select new { WorkZoneId = w.WorkZoneId, Name = w.Name, WorkZonePath = w.WorkZonePath, ModelDataProgramer = w.ModelDataProgramer, NCDataProgramer = w.NCDataProgramer, ProgramDate = w.ProgramDate, ModelName = w.ModelName, Parts = w.Parts, PartName = w.PartName, MachiningTimeTotal = w.MachiningTimeTotal, FactoryId = w.FactoryId, FactoryName = f.Name, MachineId = w.MachineId, MachineName = m.Name, Comment = w.Comment, Status = w.Status, ImageFile = w.ImageFile }).AsEnumerable().Select(w => new WorkZoneListInfo { WorkZoneId = w.WorkZoneId, Name = w.Name, WorkZonePath = w.WorkZonePath, ModelDataProgramer = w.ModelDataProgramer, NCDataProgramer = w.NCDataProgramer, ProgramDate = w.ProgramDate, ModelName = w.ModelName, Parts = w.Parts, PartName = w.PartName, MachiningTimeTotal = w.MachiningTimeTotal, FactoryId = w.FactoryId, FactoryName = w.FactoryName, MachineId = w.MachineId, MachineName = w.MachineName, Status = w.Status, Comment = w.Comment, ImageFile = w.ImageFile }).ToList(); }
/// <summary> /// The constructor. /// </summary> /// <param name="myIGraphDBSession">The filesystem where the information is stored.</param> /// <param name="DatabaseRootPath">The database root path.</param> public DBTypeManager(IGraphFSSession myIGraphFS, ObjectLocation myDatabaseRootPath, EntityUUID myUserID, Dictionary<String, ADBSettingsBase> myDBSettings, DBContext dbContext) { _DBContext = dbContext; _UserID = myUserID; _DatabaseRootPath = myDatabaseRootPath; _IGraphFSSession = myIGraphFS; _ObjectLocationsOfAllUserDefinedDatabaseTypes = LoadListOfTypeLocations(myDatabaseRootPath); }
protected Exceptional<IDictionary<String, IObject>> LoadUndefAttributes(String myName, DBContext dbContext, DBObjectStream myObjStream) { var loadExcept = myObjStream.GetUndefinedAttributePayload(dbContext.DBObjectManager); if (loadExcept.Failed()) return new Exceptional<IDictionary<string, IObject>>(loadExcept); return new Exceptional<IDictionary<string, IObject>>(loadExcept.Value); }
public PersonRepository(IConfiguration configuration, DBContext context) { _configuration = configuration; _context = context; }
public EDI315MsgParsing() { util = new Util(); context = new DBContext(); }
public EngineService() { logFile = new LogFile(); edi315MsgParsing = new EDI315MsgParsing(); context = new DBContext(); }
public JsonResult MonthlyGSTCalculateAmount(string MonthID = "", string ServiceName = "", string Year = "") { initpage();//// if (MonthID != null) { var db = new DBContext(); int Monthval = 0; int.TryParse(MonthID, out Monthval); long serviceid = 0; //var serviceId = db.TBL_SERVICE_PROVIDERS.Where(x => x.ID == serviceid).Select(c => c.SERVICE_NAME).FirstOrDefault(); var GSTValu12e = (from x in db.TBL_ACCOUNTS where x.MEM_ID == MemberCurrentUser.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == ServiceName && x.MEMBER_TYPE == "SUPER DISTRIBUTOR" && x.NARRATION == "Commission" select new { MEM_ID = x.MEM_ID, TRANSACTION_TYPE = x.TRANSACTION_TYPE, TRANSACTION_DATE = x.TRANSACTION_DATE, AMOUNT = x.AMOUNT, GST = x.GST, GSTPERCENTAGE = x.GST_PERCENTAGE, TDS = x.TDS, TDSPERCENTAGE = x.TDS_PERCENTAGE, }).AsEnumerable().Select(z => new TBL_ACCOUNTS { MEM_ID = z.MEM_ID, TRANSACTION_TYPE = z.TRANSACTION_TYPE, timevalue = z.TRANSACTION_DATE.ToString(), //TRANSACTION_DATE = z.TRANSACTION_DATE, AMOUNT = z.AMOUNT, GST = z.GST, GST_PERCENTAGE = z.GSTPERCENTAGE, TDS = z.TDS, TDS_PERCENTAGE = z.TDSPERCENTAGE }).ToList().Distinct(); var GSTValue = (from x in db.TBL_ACCOUNTS where x.MEM_ID == MemberCurrentUser.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == ServiceName && x.MEMBER_TYPE == "SUPER DISTRIBUTOR" && x.NARRATION == "Commission" select new { Operator = db.TBL_SERVICE_PROVIDERS.Where(d => d.ID == x.SERVICE_ID).Select(c => c.SERVICE_NAME).FirstOrDefault(), COMMISSIONAMT = x.COMM_AMT }).Sum(c => (decimal?)c.COMMISSIONAMT) ?? 0; var getListGSTComm = db.TBL_ACCOUNTS.Where(x => x.MEM_ID == MemberCurrentUser.MEM_ID && x.TRANSACTION_DATE.Month == Monthval && x.DR_CR == "CR" && x.TRANSACTION_TYPE == ServiceName && x.MEMBER_TYPE == "SUPER DISTRIBUTOR" && x.NARRATION == "Commission").FirstOrDefault(); TBL_ACCOUNTS objval = new TBL_ACCOUNTS() { MEMBER_TYPE = ServiceName, COMM_AMT = GSTValue, timevalue = DateTime.Now.ToString("dd-MM-yyyy"), GST_PERCENTAGE = 18 }; return(Json(objval, JsonRequestBehavior.AllowGet)); } else { return(Json("There is no GST Available in this month", JsonRequestBehavior.AllowGet)); } }
public EreplacedTrainsController(DBContext context) { _context = context; }
public AreaServices(DBContext context) { this.context = context; }
public EDI315MsgParsing() { context = new DBContext(); }
public EtapTsiTransportOperationalIdentifierController(DBContext context) { _context = context; }
public UserRepository(DBContext context) { this.db = context; }
public EquipmentService(DBContext context) { _context = context; }
public EngineService() { util = new Util(); edi315MsgParsing = new EDI315MsgParsing(); context = new DBContext(); }
public bool MeesageParsing(string msg_body, int msg_idnum) { bool result = false; try { #region Initialize values string[] msgBody; string[] rowLine; string header; EDI315 dbEDI315 = new EDI315(); EDI315_Detail dbEDI315_Detail = new EDI315_Detail(); List <EDI315_Detail_N9> dbEDI315_Detail_N9List = new List <EDI315_Detail_N9>(); List <EDI315_Detail_R4> dbEDI315_Detail_R4List = new List <EDI315_Detail_R4>(); int convertToInt = 0; decimal convertToDecimal = 0; #endregion msg_body = Regex.Replace(msg_body, @"^\s+$[\r\n]*", "", RegexOptions.Multiline); msgBody = msg_body.Split(new[] { Environment.NewLine }, StringSplitOptions.None); foreach (string row in msgBody) { if (row != null && row.Count() > 0) { rowLine = row.Split('*'); header = ""; if (EDI315_HEADERS.Any(x => x.ToUpper() == rowLine[0])) { header = rowLine[0]; } switch (header) { case "ISA": #region ISA dbEDI315 = new EDI315() { msg_idnum = msg_idnum, ISA_auth_info_qualifier = rowLine[1] ?? "", ISA_auth_info = rowLine[2] ?? "", ISA_security_info_qualifier = rowLine[3] ?? "", ISA_security_info = rowLine[4] ?? "", ISA_interchange_id_qualifier_1 = rowLine[5] ?? "", ISA_interchange_sender_id = rowLine[6] ?? "", ISA_interchange_id_qualifier_2 = rowLine[7] ?? "", ISA_interchange_receiver_id = rowLine[8] ?? "", ISA_interchage_date = rowLine[9] ?? "", ISA_interchange_time = rowLine[10] ?? "", ISA_interchange_control_standards_id = rowLine[11] ?? "", ISA_interchange_control_version_number = rowLine[12] ?? "", ISA_interchange_control_number = rowLine[13] ?? "", ISA_ack_requested = rowLine[14] ?? "", ISA_usage_indicator = rowLine[15] ?? "", ISA_component_element_separator = rowLine[16] ?? "", }; #endregion break; case "GS": // Table EDI315 insert here. #region GS dbEDI315.GS_functional_id_code = rowLine[1] ?? ""; dbEDI315.GS_app_sender_code = rowLine[2] ?? ""; dbEDI315.GS_app_receiver_code = rowLine[3] ?? ""; dbEDI315.GS_date = rowLine[4] ?? ""; dbEDI315.GS_time = rowLine[5] ?? ""; dbEDI315.GS_group_control_number = rowLine[6] ?? ""; dbEDI315.GS_reponsible_agency_code = rowLine[7] ?? ""; dbEDI315.GS_industry_id_code = rowLine[8] ?? ""; /* Insert table EDI315 after done with ISA & GS */ if (dbEDI315.msg_idnum != 0) { if (dbConnectionCheck()) { using (DBContext context = new DBContext()) { /* check DB is open */ dbEDI315.created_date = DateTime.Now; context.EDI315.Add(dbEDI315); context.SaveChanges(); context.Dispose(); } } else { // not able to access DB //return false; } } #endregion break; case "ST": dbEDI315_Detail = new EDI315_Detail(); break; case "SE": // insert Table EDI315_Detail, EDI315_Detail_N9, EDI315_Detail_R4 & EDI315_Detail_R4_DTM break; case "B4": #region B4 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } dbEDI315_Detail.B4_SHC = rowLine[1]; convertToInt = 0; if (rowLine[2] != null && rowLine[2].Trim() != string.Empty && Int32.TryParse(rowLine[2], out convertToInt)) { dbEDI315_Detail.B4_request_number = convertToInt; } dbEDI315_Detail.B4_status_code = rowLine[3]; dbEDI315_Detail.B4_date = rowLine[4] ?? ""; dbEDI315_Detail.B4_status_time = rowLine[5] ?? ""; dbEDI315_Detail.B4_status_location = rowLine[6] ?? ""; dbEDI315_Detail.B4_equip_initial = rowLine[7]; dbEDI315_Detail.B4_equip_number = rowLine[8]; dbEDI315_Detail.B4_equip_status_code = rowLine[9]; dbEDI315_Detail.B4_equip_type = rowLine[10]; dbEDI315_Detail.B4_location_code = rowLine[11]; dbEDI315_Detail.B4_location_id = rowLine[12]; if (rowLine.Count() > 13) { convertToInt = 0; if (rowLine[13] != null && rowLine[13].Trim() != string.Empty && Int32.TryParse(rowLine[13], out convertToInt)) { dbEDI315_Detail.B4_equip_check_digit = convertToInt; } } #endregion break; case "Q2": #region Q2 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } dbEDI315_Detail.Q2_vessel_code = rowLine[1]; dbEDI315_Detail.Q2_country_code = rowLine[2]; dbEDI315_Detail.Q2_date_1 = rowLine[3]; dbEDI315_Detail.Q2_date_2 = rowLine[4]; dbEDI315_Detail.Q2_date_3 = rowLine[5]; convertToInt = 0; if (rowLine[6] != null && rowLine[6].Trim() != string.Empty && Int32.TryParse(rowLine[6], out convertToInt)) { dbEDI315_Detail.Q2_lading_quantity = convertToInt; } convertToDecimal = 0; if (rowLine[7] != null && rowLine[7].Trim() != string.Empty && Decimal.TryParse(rowLine[7], out convertToDecimal)) { dbEDI315_Detail.Q2_weight = convertToDecimal; } dbEDI315_Detail.Q2_weight_qualifier = rowLine[8]; dbEDI315_Detail.Q2_voyage_number = rowLine[9]; dbEDI315_Detail.Q2_reference_id_qualifier = rowLine[10]; dbEDI315_Detail.Q2_reference_id = rowLine[11]; dbEDI315_Detail.Q2_vessel_code_qualifier = rowLine[12]; dbEDI315_Detail.Q2_vessel_name = rowLine[13]; convertToDecimal = 0; if (rowLine[14] != null && rowLine[14].Trim() != string.Empty && Decimal.TryParse(rowLine[14], out convertToDecimal)) { dbEDI315_Detail.Q2_volume = convertToDecimal; } dbEDI315_Detail.Q2_volume_unit_qualifier = rowLine[15]; dbEDI315_Detail.Q2_weight_unit_code = rowLine[16]; #endregion break; case "N9": #region N9 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_N9 dbTemp = new EDI315_Detail_N9(); dbTemp.reference_id_qualifier = rowLine[1]; if (rowLine.Count() > 2) { dbTemp.reference_id = rowLine[2]; } if (rowLine.Count() > 3) { dbTemp.free_form_description = rowLine[3]; } if (rowLine.Count() > 4) { dbTemp.free_form_description = rowLine[4]; } if (rowLine.Count() > 5) { dbTemp.date = rowLine[5]; } if (rowLine.Count() > 6) { dbTemp.time = rowLine[6]; } if (rowLine.Count() > 7) { dbTemp.time_code = rowLine[7]; } dbEDI315_Detail_N9List.Add(dbTemp); } #endregion break; case "R4": if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_R4 dbTemp = new EDI315_Detail_R4(); dbTemp.Detail_R4_idnum = dbEDI315_Detail_R4List.Count() + 1; dbTemp.port_function_code = rowLine[1]; if (rowLine.Count() > 2) { dbTemp.location_qualifier = rowLine[2]; } if (rowLine.Count() > 3) { dbTemp.location_id = rowLine[3]; } if (rowLine.Count() > 4) { dbTemp.port_name = rowLine[4]; } if (rowLine.Count() > 5) { dbTemp.country_code = rowLine[5]; } if (rowLine.Count() > 6) { dbTemp.terminal_name = rowLine[6]; } if (rowLine.Count() > 7) { dbTemp.pier_number = rowLine[7]; } if (rowLine.Count() > 8) { dbTemp.province_code = rowLine[8]; } dbEDI315_Detail_R4List.Add(dbTemp); } break; case "DTM": if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_R4_DTM dbTemp = new EDI315_Detail_R4_DTM(); dbTemp.Detail_R4_idnum = dbEDI315_Detail_R4List.Count(); convertToInt = 0; if (rowLine[1] != null && rowLine[1].Trim() != string.Empty && Int32.TryParse(rowLine[1], out convertToInt)) { dbEDI315_Detail.Q2_lading_quantity = convertToInt; } dbTemp.datetime_qualifier = rowLine[1]; } break; } } } } catch (Exception ex) { result = false; } return(result); }
public SessionService(DBContext DbContext) { this.DbContext = DbContext; }
public AudioRepository(DBContext dbctx) : base(dbctx) { }
/// <summary> /// generate EC and other curves for a benchmark /// </summary> public static async Task <(EquityCurve equityCurve, Dictionary <DateTime, double> benchmarkSeries, List <double> benchmarkReturns)> GetBenchmarkReturns( int benchmarkID, DBContext context, List <DateTime> datesInPeriod, IDataSourcer dataSourcer) { Logger logger = LogManager.GetCurrentClassLogger(); List <BenchmarkComponent> components = context.BenchmarkComponents.Where(x => x.BenchmarkID == benchmarkID).ToList(); DateTime earliestDate = datesInPeriod[0].Date; DateTime latestDate = datesInPeriod.Last(); var data = new Dictionary <int, TimeSeries>(); foreach (var component in components) { data.Add(component.QDMSInstrumentID, new TimeSeries(await dataSourcer.GetExternalData(component.QDMSInstrumentID, earliestDate, latestDate).ConfigureAwait(true))); } Dictionary <int, decimal> weights = components.ToDictionary(x => x.QDMSInstrumentID, x => (decimal)x.Weight); var benchmarkSeries = new Dictionary <DateTime, double>(); var benchmarkReturns = new List <double>(); var benchmarkEC = new EquityCurve(1, null); decimal equity = 1; bool first = true; foreach (DateTime today in datesInPeriod) { decimal ret = 0; foreach (var kvp in data) { var ts = kvp.Value; ts.ProgressTo(today); if (ts.CurrentBar > 0) { decimal todayClose = ts[0].AdjClose.HasValue ? ts[0].AdjClose.Value : ts[0].Close; decimal lastClose = ts[1].AdjClose.HasValue ? ts[1].AdjClose.Value : ts[1].Close; ret += weights[kvp.Key] * (todayClose / lastClose - 1); #if DEBUG logger.Log(LogLevel.Trace, "Benchmark component: Date: {0} Close: {1} PrevClose: {2} Ret: {3}", today, todayClose, lastClose, ret); #endif } } benchmarkEC.AddReturn((double)ret, today); if (first) { first = false; benchmarkReturns.Add((double)(1 + ret)); benchmarkSeries.Add(today, (double)equity); continue; } equity *= 1 + ret; benchmarkReturns.Add((double)(1 + ret)); benchmarkSeries.Add(today, (double)equity); } return(benchmarkEC, benchmarkSeries, benchmarkReturns); }
public EmailRegRepository(DBContext _context) { context = _context; }
public static List <tbl_DealItem> getAll() { RMSEntities db = DBContext.getInstance(); return(db.tbl_DealItem.ToList()); }
public InterestController(DBContext context) { _dBContext = context; }
public GreenTemplateController() : this(DBContext.Create()) { }
static void Main(string[] args) { string foo_bar_1 = "foo bar 1"; string someVersion = "v$12345678"; var dbContext = new DBContext { server = "127.0.0.1", port = 5432, database = "pccrms", userId = "editor", password = "******" }; // ---------------------------------------------------------------------------------------------------------- // ServiceProvider.Instance.Singleton<Client<Personnel>>(() => new Client<Personnel>(dbContext)); // var pclient = ServiceProvider.Instance.GetService<Client<Personnel>>(); // pclient.save("v$12345678", new Personnel { id = "0", name = "abc123", ts = DateTime.Now }); // var p = pclient.one<Personnel>("v$0", "id", "taoh02"); // var l = pclient.list("v$0", 0, 10); // ---------------------------------------------------------------------------------------------------------- ServiceProvider.Instance.Singleton <VersionControlManager>(() => new VersionControlManager(dbContext)); // var vc = ServiceProvider.Instance.GetService<VersionControlManager>(); // var vcs = vc.getVersionControls(); // var vcs1 = vc.getVersionControls().Where(d => d.name == foo_bar_1).ToList(); // vc.createNewVersionControl(foo_bar_1); // ---------------------------------------------------------------------------------------------------------- // Create an Affiliation // ServiceProvider.Instance.Singleton<EmpireClient<Empire>>(() => new EmpireClient<Empire>(dbContext)); // var empireClient = ServiceProvider.Instance.GetService<EmpireClient<Empire>>(); // var badRoster = new List<Participant>(); // var empire = new Empire { id = "empire", roster = badRoster, ts = DateTime.Now }; // empireClient.save(someVersion, empire); // Associate something to that affiliation // ServiceProvider.Instance.Singleton<DroidClient<Droid>>(() => new DroidClient<Droid>(dbContext)); // var droidClient = ServiceProvider.Instance.GetService<DroidClient<Droid>>(); // var droid = new Droid { id = "2-1B", name = "2-1B", ts = DateTime.Now }; // droidClient.save(someVersion, droid); // var empireObj = empireClient.one<Record<Empire>>(someVersion, "id", "empire"); // empireClient.associate<Participant, Droid>(someVersion, empireObj.id, droid.id); // ---------------------------------------------------------------------------------------------------------- // Create an extended Affiliation // ServiceProvider.Instance.Singleton<Client<EmpireExtended>>(() => new Client<EmpireExtended>(dbContext)); // var empireExtendedClient = ServiceProvider.Instance.GetService<Client<EmpireExtended>>(); // var badRosterExtended = new List<ParticipantExtended>(); // var empireExtended = new EmpireExtended { id = "empire", roster = badRosterExtended, ts = DateTime.Now }; // empireExtendedClient.save(someVersion, empireExtended); // Associate something that was also extended to that extended affiliation // ServiceProvider.Instance.Singleton<DroidClient<DroidExtended>>(() => new DroidClient<DroidExtended>(dbContext)); // var droidExtendedClient = ServiceProvider.Instance.GetService<DroidClient<DroidExtended>>(); // var droidExtended = new DroidExtended { id = "2-1B", name = "2-1B", ts = DateTime.Now, language = "None" }; // droidExtendedClient.save(someVersion, droidExtended); // var empireExtendedObj = empireExtendedClient.one<Record<EmpireExtended>>(someVersion, "id", "empire"); // empireExtendedClient.associate<ParticipantExtended, DroidExtended>(someVersion, empireExtendedObj.id, droidExtended.id); // Passing a "party" Type to an Affiliation and check that the party is a DroidExtended and not a dynamic type // empireExtendedObj = empireExtendedClient.one<Record<EmpireExtended>>(someVersion, "id", "empire", typeof(DroidExtended)); // Associate again 3 times and check for dupes // foreach(int i in Enumerable.Range(1, 3)) { // empireExtendedClient.associate<ParticipantExtended, DroidExtended>(someVersion, empireExtendedObj.id, droidExtended.id); // } // empireExtendedClient.associate<ParticipantExtended, DroidExtended>(someVersion, empireExtendedObj.id, droidExtended.id); // Disassociate from an Affiliation // empireExtendedClient.disassociate<ParticipantExtended>(someVersion, empireExtendedObj.id, droidExtended.id); // ---------------------------------------------------------------------------------------------------------- // Affiliation should fetch the latest party record. ServiceProvider.Instance.Singleton <HumanClient <Human> >(() => new HumanClient <Human>(dbContext)); ServiceProvider.Instance.Singleton <Client <RebelAlliance> >(() => new Client <RebelAlliance>(dbContext)); Record <RebelAlliance> currentRebelAlliance = null; Human currentLeia = null; var humanClient = ServiceProvider.Instance.GetService <HumanClient <Human> >(); var generalLeia = new Human { id = "organa-leia", name = "Leia Organa" }; humanClient.save(someVersion, generalLeia); var rebelAllianceClient = ServiceProvider.Instance.GetService <Client <RebelAlliance> >(); var rebelAlliance = new RebelAlliance { id = "rebel-alliance", name = "The Rebel Alliance", ts = DateTime.Now, roster = { } }; rebelAllianceClient.save(someVersion, rebelAlliance); // Associate Leia to Rebel Alliance. rebelAllianceClient.associate <Participant, Human>(someVersion, "rebel-alliance", generalLeia.id); // Get the latest participants to Rebel Alliance. currentRebelAlliance = rebelAllianceClient.one <Record <RebelAlliance> >(someVersion, "id", "rebel-alliance", typeof(Human)); currentLeia = currentRebelAlliance.current.roster.FirstOrDefault(d => d.id == "organa-leia").party; Console.WriteLine(currentLeia.name); // Leia married Han. Update Leia's name. generalLeia.name = "Leia Organa Solo"; humanClient.save(someVersion, generalLeia); // Get the latest participants to Rebel Alliance. currentRebelAlliance = rebelAllianceClient.one <Record <RebelAlliance> >(someVersion, "id", "rebel-alliance", typeof(Human)); currentLeia = currentRebelAlliance.current.roster.FirstOrDefault(d => d.id == "organa-leia").party; // Name should now be Leia Organa Solo. Console.WriteLine(currentLeia.name); // ---------------------------------------------------------------------------------------------------------- // Calling one when version and schema does not exist will not throw var fac = new Factory <NpgsqlConnection>(); var dbConnection = fac.Get(dbContext); CommandRunner runner = new CommandRunner(dbConnection); try { runner.Transact(new DbCommand[] { runner.BuildCommand("drop schema v$12345678 cascade", null) }); } catch (Exception err) { // Expect -> 3F000: schema "v$12345678" does not exist Console.WriteLine(err.Message); } ServiceProvider.Instance.Singleton <DroidClient <Droid> >(() => new DroidClient <Droid>(dbContext)); var someDroidClient = ServiceProvider.Instance.GetService <DroidClient <Droid> >(); var someDroid = someDroidClient.one <Droid>(someVersion, "id", "R2-D2"); Console.WriteLine(someDroid == null); // ---------------------------------------------------------------------------------------------------------- // Calling save when version and schema does not exist will not throw var newDroid = new Droid { id = "2-1B", name = "2-1B", ts = DateTime.Now }; someDroidClient.save("v$12345678", newDroid); var fetchNewDroid = someDroidClient.one <Droid>(someVersion, "id", "2-1B"); Console.WriteLine(fetchNewDroid != null); // ---------------------------------------------------------------------------------------------------------- //Create a Affiliation that is derived from the Empire called FirstOrder ServiceProvider.Instance.Singleton <Client <FirstOrder> >(() => new Client <FirstOrder>(dbContext)); ServiceProvider.Instance.Singleton <Client <DroidExtended> >(() => new Client <DroidExtended>(dbContext)); var firstOrderClient = ServiceProvider.Instance.GetService <Client <FirstOrder> >(); var firstOrder = new FirstOrder { id = "first-order", name = "The First Order", ts = DateTime.Now, roster = { } }; firstOrderClient.save <FirstOrder>(someVersion, firstOrder); var droidExtendedClient = ServiceProvider.Instance.GetService <Client <DroidExtended> >(); var droidExtended = new DroidExtended { id = "2-1B", name = "2-1B", ts = DateTime.Now, language = "None" }; droidExtendedClient.save(someVersion, droidExtended); firstOrderClient.associate <ParticipantExtended, DroidExtended>(someVersion, "first-order", droidExtended.id); // Passing a "party" Type to an derived Affiliation and check that the party is a DroidExtended and not a dynamic type var firstOrderObj = firstOrderClient.one <Record <FirstOrder> >(someVersion, "id", "first-order", typeof(DroidExtended)); // ---------------------------------------------------------------------------------------------------------- // Create List<IModel> as attribute of Model and associate it with Affiliation ServiceProvider.Instance.Singleton <EmpireClient <Empire> >(() => new EmpireClient <Empire>(dbContext)); var empireClient = ServiceProvider.Instance.GetService <EmpireClient <Empire> >(); ServiceProvider.Instance.Singleton <DroidClient <Droid> >(() => new DroidClient <Droid>(dbContext)); var droidClient = ServiceProvider.Instance.GetService <DroidClient <Droid> >(); // Create an Empire var empire = new Empire { id = "empire", roster = { }, ts = DateTime.Now }; empireClient.save(someVersion, empire); // Get a count var count = empireClient.count(someVersion, "id", "empire"); // Create a Droid var droid = new Droid { id = "2-1B", name = "2-1B", ts = DateTime.Now }; // Assign an Affiliation to the droid droid.alliance.Add(empire); droidClient.save(someVersion, droid); // Check how many alliances the droid has droid = droidClient.one <Droid>(someVersion, "id", "2-1B"); int allianceCount = 0; allianceCount = droid.alliance.Count(); // Assign the same Affiliation to the droid 3 times and get count foreach (int i in Enumerable.Range(1, 3)) { droid = droidClient.one <Droid>(someVersion, "id", "2-1B"); droid.alliance = new List <Affiliation <Participant> > { empire }; droidClient.save(someVersion, droid); } allianceCount = droid.alliance.Count(); // ---------------------------------------------------------------------------------------------------------- /** * packages\nspec.1.0.13\tools\NSpecRunner.exe C:\cygwin64\home\htao\Store\Store.Storage.Pgsql.Test\bin\Debug\Store.Storage.Pgsql.Test.dll */ }
public TrifoliaImporter() : this(DBContext.Create()) { }
public bool MeesageParsing(string msg_body, int msg_idnum) { bool result = false; try { #region Initialize values string[] msgBody; string[] rowLine; string header; EDI315 dbEDI315 = new EDI315(); EDI315_Detail dbEDI315_Detail = new EDI315_Detail(); List<EDI315_Detail_N9> dbEDI315_Detail_N9List = new List<EDI315_Detail_N9>(); List<EDI315_Detail_R4> dbEDI315_Detail_R4List = new List<EDI315_Detail_R4>(); #endregion msg_body = Regex.Replace(msg_body, @"^\s+$[\r\n]*", "", RegexOptions.Multiline); msgBody = msg_body.Split(new[] { Environment.NewLine }, StringSplitOptions.None); foreach(string row in msgBody) { if(row != null && row.Count() > 0) { rowLine = row.Split('*'); header = ""; if (EDI315_HEADERS.Any(x => x.ToUpper() == rowLine[0])) { header = rowLine[0]; } switch (header) { case "ISA": #region ISA dbEDI315 = new EDI315() { msg_idnum = msg_idnum, ISA_auth_info_qualifier = rowLine[1] ?? "", ISA_auth_info = rowLine[2] ?? "", ISA_security_info_qualifier = rowLine[3] ?? "", ISA_security_info = rowLine[4] ?? "", ISA_interchange_id_qualifier_1 = rowLine[5] ?? "", ISA_interchange_sender_id = rowLine[6] ?? "", ISA_interchange_id_qualifier_2 = rowLine[7] ?? "", ISA_interchange_receiver_id = rowLine[8] ?? "", ISA_interchage_date = rowLine[9] ?? "", ISA_interchange_time = rowLine[10] ?? "", ISA_interchange_control_standards_id = rowLine[11] ?? "", ISA_interchange_control_version_number = rowLine[12] ?? "", ISA_interchange_control_number = rowLine[13] ?? "", ISA_ack_requested = rowLine[14] ?? "", ISA_usage_indicator = rowLine[15] ?? "", ISA_component_element_separator = rowLine[16] ?? "", }; #endregion break; case "GS": #region GS dbEDI315.GS_functional_id_code = rowLine[1] ?? ""; dbEDI315.GS_app_sender_code = rowLine[2] ?? ""; dbEDI315.GS_app_receiver_code = rowLine[3] ?? ""; dbEDI315.GS_date = rowLine[4] ?? ""; dbEDI315.GS_time = rowLine[5] ?? ""; dbEDI315.GS_group_control_number = rowLine[6] ?? ""; dbEDI315.GS_reponsible_agency_code = rowLine[7] ?? ""; dbEDI315.GS_industry_id_code = rowLine[8] ?? ""; /* Insert table EDI315 after done with ISA & GS */ if (dbEDI315.msg_idnum != 0) { using (DBContext context = new DBContext()) { /* check DB is open */ dbEDI315.created_date = DateTime.Now; context.EDI315.Add(dbEDI315); context.SaveChanges(); } } #endregion break; case "ST": dbEDI315_Detail = new EDI315_Detail(); break; case "SE": // insert EDI315_Detail // init. all vaues break; case "B4": if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) continue; dbEDI315_Detail.B4_SHC = rowLine[1]; if(rowLine[2] != null && rowLine[2].Trim() != string.Empty && Int32.TryParse(rowLine[2]) dbEDI315_Detail.B4_request_number = rowLine[2] ?? null : rowLine[2]; break; } } } } catch(Exception ex) { result = false; } return result; }
public SolutionController(DBContext _db, IHostingEnvironment env) { db = _db; }
public PrizeRepository(DBContext context) : base(context) { }
public OrdersController() { this.db = new DBContext(); }
public TcustomerController(DBContext context) { _context = context; }
public FlowerOrderSqlRepository(DBContext context) { this.context = context; }
public IAsyncEnumerable <Contract> Get() { DBContext context = new DBContext(); return(context.Contracts.Include(s => s.Stages).AsAsyncEnumerable()); }
public bool MeesageParsing(string msg_body, int msg_idnum) { bool result = false; try { #region Initialize values string[] msgBody; string[] rowLine; string header; EDI315 dbEDI315 = new EDI315(); EDI315_Detail dbEDI315_Detail = new EDI315_Detail(); List <EDI315_Detail_N9> dbEDI315_Detail_N9List = new List <EDI315_Detail_N9>(); List <EDI315_Detail_R4> dbEDI315_Detail_R4List = new List <EDI315_Detail_R4>(); List <EDI315_Detail_R4_DTM> dbEDI315_Detail_R4_DTMList = new List <EDI315_Detail_R4_DTM>(); int convertToInt = 0; decimal convertToDecimal = 0; #endregion msg_body = Regex.Replace(msg_body, @"^\s+$[\r\n]*", "", RegexOptions.Multiline); msgBody = msg_body.Split(new[] { Environment.NewLine }, StringSplitOptions.None); foreach (string row in msgBody) { if (row != null && row.Count() > 0) { rowLine = row.Split('*'); header = ""; if (EDI315_HEADERS.Any(x => x.ToUpper() == rowLine[0])) { header = rowLine[0]; } switch (header) { case "ISA": #region ISA dbEDI315 = new EDI315() { msg_idnum = msg_idnum, ISA_auth_info_qualifier = substringValue(rowLine[1] ?? "", 2), ISA_auth_info = substringValue(rowLine[2] ?? "", 10), ISA_security_info_qualifier = substringValue(rowLine[3] ?? "", 2), ISA_security_info = substringValue(rowLine[4] ?? "", 10), ISA_interchange_id_qualifier_1 = substringValue(rowLine[5] ?? "", 2), ISA_interchange_sender_id = substringValue(rowLine[6] ?? "", 15), ISA_interchange_id_qualifier_2 = substringValue(rowLine[7] ?? "", 2), ISA_interchange_receiver_id = substringValue(rowLine[8] ?? "", 15), ISA_interchage_date = substringValue(rowLine[9] ?? "", 8), ISA_interchange_time = substringValue(rowLine[10] ?? "", 4), ISA_interchange_control_standards_id = substringValue(rowLine[11] ?? "", 1), ISA_interchange_control_version_number = substringValue(rowLine[12] ?? "", 5), ISA_interchange_control_number = substringValue(rowLine[13] ?? "", 9), ISA_ack_requested = substringValue(rowLine[14] ?? "", 1), ISA_usage_indicator = substringValue(rowLine[15] ?? "", 1), ISA_component_element_separator = substringValue(rowLine[16] ?? "", 1), }; #endregion break; case "GS": // insert DB #region GS dbEDI315.GS_functional_id_code = substringValue(rowLine[1] ?? "", 2); dbEDI315.GS_app_sender_code = substringValue(rowLine[2] ?? "", 15); dbEDI315.GS_app_receiver_code = substringValue(rowLine[3] ?? "", 15); dbEDI315.GS_date = substringValue(rowLine[4] ?? "", 8); dbEDI315.GS_time = substringValue(rowLine[5] ?? "", 8); dbEDI315.GS_group_control_number = substringValue(rowLine[6] ?? "", 9); dbEDI315.GS_reponsible_agency_code = substringValue(rowLine[7] ?? "", 2); dbEDI315.GS_industry_id_code = substringValue(rowLine[8] ?? "", 12); /* Insert table EDI315 after done with ISA & GS */ if (dbEDI315.msg_idnum != 0) { if (util.dbConnectionCheck()) { using (DBContext context = new DBContext()) { dbEDI315.created_date = DateTime.Now; context.EDI315.Add(dbEDI315); context.SaveChanges(); context.Dispose(); } } else { string logMsg = "Function: MeesageParsing - Table EDI315\r\n"; logMsg += "Error Message: Not able to access DB. Process rollbacked.\r\n"; util.insertLog("315", msg_idnum, dbEDI315.EDI315_idnum, 0, logMsg); rollbackProcess(msg_idnum); return(false); } } #endregion break; case "ST": #region ST /* Detail start. Init. */ dbEDI315_Detail = new EDI315_Detail(); dbEDI315_Detail_N9List = new List <EDI315_Detail_N9>(); dbEDI315_Detail_R4List = new List <EDI315_Detail_R4>(); dbEDI315_Detail_R4_DTMList = new List <EDI315_Detail_R4_DTM>(); #endregion break; case "SE": // inset DB #region SE if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } convertToInt = 0; if (rowLine[1] != null && rowLine[1].Trim() != string.Empty && Int32.TryParse(rowLine[1], out convertToInt)) { dbEDI315_Detail.SE_included_segments_number = convertToInt; } dbEDI315_Detail.SE_transaction_set_control_number = rowLine[2]; /* insert Table EDI315_Detail, EDI315_Detail_N9, EDI315_Detail_R4 & EDI315_Detail_R4_DTM */ if (util.dbConnectionCheck()) { using (DBContext context = new DBContext()) { /* EDI315_Detail Insert */ dbEDI315_Detail.EDI315_idnum = dbEDI315.EDI315_idnum; context.EDI315_Detail.Add(dbEDI315_Detail); context.SaveChanges(); /* EDI315_Detail_N9 Insert */ dbEDI315_Detail_N9List.ForEach(x => x.EDI315_Detail_idnum = dbEDI315_Detail.EDI315_Detail_idnum); context.EDI315_Detail_N9.AddRange(dbEDI315_Detail_N9List); context.SaveChanges(); /* EDI315_Detail_R4 & EDI315_Detail_R4_DTM Insert */ foreach (EDI315_Detail_R4 dbR4Row in dbEDI315_Detail_R4List) { List <EDI315_Detail_R4_DTM> dtmList = dbEDI315_Detail_R4_DTMList.Where(x => x.Detail_R4_idnum == dbR4Row.Detail_R4_idnum).ToList(); dbR4Row.EDI315_Detail_idnum = dbEDI315_Detail.EDI315_Detail_idnum; context.EDI315_Detail_R4.Add(dbR4Row); context.SaveChanges(); foreach (EDI315_Detail_R4_DTM dtmRow in dtmList) { dtmRow.EDI315_Detail_idnum = dbEDI315_Detail.EDI315_Detail_idnum; dtmRow.Detail_R4_idnum = dbR4Row.Detail_R4_idnum; } context.EDI315_Detail_R4_DTM.AddRange(dtmList); context.SaveChanges(); } context.Dispose(); } } else { string logMsg = "Function: MeesageParsing - Table EDI315_Detail, EDI315_Detail_N9, EDI315_Detail_R4, EDI315_Detail_R4_DTM\r\n"; logMsg += "Error Message: Not able to access DB. Process rollbacked.\r\n"; util.insertLog("315", msg_idnum, dbEDI315.EDI315_idnum, dbEDI315_Detail.EDI315_Detail_idnum, logMsg); rollbackProcess(msg_idnum); return(false); } #endregion break; case "B4": #region B4 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } dbEDI315_Detail.B4_SHC = rowLine[1]; convertToInt = 0; if (rowLine[2] != null && rowLine[2].Trim() != string.Empty && Int32.TryParse(rowLine[2], out convertToInt)) { dbEDI315_Detail.B4_request_number = convertToInt; } dbEDI315_Detail.B4_status_code = rowLine[3]; dbEDI315_Detail.B4_date = rowLine[4] ?? ""; dbEDI315_Detail.B4_status_time = rowLine[5] ?? ""; dbEDI315_Detail.B4_status_location = rowLine[6] ?? ""; dbEDI315_Detail.B4_equip_initial = rowLine[7]; dbEDI315_Detail.B4_equip_number = rowLine[8]; dbEDI315_Detail.B4_equip_status_code = rowLine[9]; dbEDI315_Detail.B4_equip_type = rowLine[10]; dbEDI315_Detail.B4_location_code = rowLine[11]; dbEDI315_Detail.B4_location_id = rowLine[12]; if (rowLine.Count() > 13) { convertToInt = 0; if (rowLine[13] != null && rowLine[13].Trim() != string.Empty && Int32.TryParse(rowLine[13], out convertToInt)) { dbEDI315_Detail.B4_equip_check_digit = convertToInt; } } #endregion break; case "Q2": #region Q2 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } dbEDI315_Detail.Q2_vessel_code = rowLine[1]; dbEDI315_Detail.Q2_country_code = rowLine[2]; dbEDI315_Detail.Q2_date_1 = rowLine[3]; dbEDI315_Detail.Q2_date_2 = rowLine[4]; dbEDI315_Detail.Q2_date_3 = rowLine[5]; convertToInt = 0; if (rowLine[6] != null && rowLine[6].Trim() != string.Empty && Int32.TryParse(rowLine[6], out convertToInt)) { dbEDI315_Detail.Q2_lading_quantity = convertToInt; } convertToDecimal = 0; if (rowLine[7] != null && rowLine[7].Trim() != string.Empty && Decimal.TryParse(rowLine[7], out convertToDecimal)) { dbEDI315_Detail.Q2_weight = convertToDecimal; } dbEDI315_Detail.Q2_weight_qualifier = rowLine[8]; dbEDI315_Detail.Q2_voyage_number = rowLine[9]; dbEDI315_Detail.Q2_reference_id_qualifier = rowLine[10]; dbEDI315_Detail.Q2_reference_id = rowLine[11]; dbEDI315_Detail.Q2_vessel_code_qualifier = rowLine[12]; dbEDI315_Detail.Q2_vessel_name = rowLine[13]; convertToDecimal = 0; if (rowLine[14] != null && rowLine[14].Trim() != string.Empty && Decimal.TryParse(rowLine[14], out convertToDecimal)) { dbEDI315_Detail.Q2_volume = convertToDecimal; } dbEDI315_Detail.Q2_volume_unit_qualifier = rowLine[15]; dbEDI315_Detail.Q2_weight_unit_code = rowLine[16]; #endregion break; case "N9": #region N9 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_N9 dbTemp = new EDI315_Detail_N9(); dbTemp.reference_id_qualifier = rowLine[1]; if (rowLine.Count() > 2) { dbTemp.reference_id = rowLine[2]; } if (rowLine.Count() > 3) { dbTemp.free_form_description = rowLine[3]; } if (rowLine.Count() > 4) { dbTemp.free_form_description = rowLine[4]; } if (rowLine.Count() > 5) { dbTemp.date = rowLine[5]; } if (rowLine.Count() > 6) { dbTemp.time = rowLine[6]; } if (rowLine.Count() > 7) { dbTemp.time_code = rowLine[7]; } dbEDI315_Detail_N9List.Add(dbTemp); } #endregion break; case "R4": #region R4 if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_R4 dbTemp = new EDI315_Detail_R4(); dbTemp.Detail_R4_idnum = dbEDI315_Detail_R4List.Count() + 1; dbTemp.port_function_code = rowLine[1]; if (rowLine.Count() > 2) { dbTemp.location_qualifier = rowLine[2]; } if (rowLine.Count() > 3) { dbTemp.location_id = rowLine[3]; } if (rowLine.Count() > 4) { dbTemp.port_name = rowLine[4]; } if (rowLine.Count() > 5) { dbTemp.country_code = rowLine[5]; } if (rowLine.Count() > 6) { dbTemp.terminal_name = rowLine[6]; } if (rowLine.Count() > 7) { dbTemp.pier_number = rowLine[7]; } if (rowLine.Count() > 8) { dbTemp.province_code = rowLine[8]; } dbEDI315_Detail_R4List.Add(dbTemp); } #endregion break; case "DTM": #region DTM if (dbEDI315 == null || dbEDI315.EDI315_idnum == 0) { continue; } { EDI315_Detail_R4_DTM dbTemp = new EDI315_Detail_R4_DTM(); dbTemp.Detail_R4_idnum = dbEDI315_Detail_R4List.Count(); convertToInt = 0; if (rowLine[1] != null && rowLine[1].Trim() != string.Empty && Int32.TryParse(rowLine[1], out convertToInt)) { dbTemp.datetime_qualifier = convertToInt; } if (rowLine.Count() > 2) { dbTemp.date = rowLine[2]; } if (rowLine.Count() > 3) { dbTemp.time = rowLine[3]; } if (rowLine.Count() > 4) { dbTemp.time_code = rowLine[4]; } dbEDI315_Detail_R4_DTMList.Add(dbTemp); } #endregion break; } } } result = true; } catch (DbEntityValidationException ex) { string logMsg = "Function: MeesageParsing\r\n"; logMsg += "Process rollbacked.\r\n"; logMsg += "Error Message:\r\n"; foreach (DbEntityValidationResult item in ex.EntityValidationErrors) { // Get entry DbEntityEntry entry = item.Entry; string entityTypeName = entry.Entity.GetType().Name; foreach (DbValidationError subItem in item.ValidationErrors) { logMsg += string.Format("Error '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName) + "\r\n"; } } util.insertLog("315", msg_idnum, 0, 0, logMsg); rollbackProcess(msg_idnum); result = false; } catch (Exception ex) { string logMsg = "Function: MeesageParsing\r\n"; logMsg += "Process rollbacked.\r\n"; logMsg += "Error Message: " + ex.ToString(); util.insertLog("315", msg_idnum, 0, 0, logMsg); rollbackProcess(msg_idnum); result = false; } return(result); }
public EDI315MsgParsing() { logFile = new LogFile(); context = new DBContext(); }