Esempio n. 1
0
 public IHttpActionResult CreateArea(string token, JDE_Areas item, int UserId)
 {
     if (token != null && token.Length > 0)
     {
         var tenants = db.JDE_Tenants.Where(t => t.TenantToken == token.Trim());
         if (tenants.Any())
         {
             item.TenantId = tenants.FirstOrDefault().TenantId;
             db.JDE_Areas.Add(item);
             db.SaveChanges();
             JDE_Logs Log = new JDE_Logs {
                 UserId = UserId, Description = "Utworzenie obszaru", TenantId = tenants.FirstOrDefault().TenantId, Timestamp = DateTime.Now, NewValue = new JavaScriptSerializer().Serialize(item)
             };
             db.JDE_Logs.Add(Log);
             db.SaveChanges();
             return(Ok(item));
             //return CreatedAtRoute("DefaultApi", new { id = item.AreaId }, item);
         }
         else
         {
             return(NotFound());
         }
     }
     else
     {
         return(NotFound());
     }
 }
Esempio n. 2
0
        public IHttpActionResult EditArea(string token, int id, JDE_Areas item, int UserId)
        {
            if (token != null && token.Length > 0)
            {
                var tenants = db.JDE_Tenants.Where(t => t.TenantToken == token.Trim());
                if (tenants.Any())
                {
                    var items = db.JDE_Areas.AsNoTracking().Where(u => u.TenantId == tenants.FirstOrDefault().TenantId&& u.AreaId == id);
                    if (items.Any())
                    {
                        JDE_Logs Log = new JDE_Logs {
                            UserId = UserId, Description = "Edycja obszaru", TenantId = tenants.FirstOrDefault().TenantId, Timestamp = DateTime.Now, OldValue = new JavaScriptSerializer().Serialize(items.FirstOrDefault()), NewValue = new JavaScriptSerializer().Serialize(item)
                        };
                        db.JDE_Logs.Add(Log);
                        db.Entry(item).State = EntityState.Modified;
                        try
                        {
                            db.SaveChanges();
                        }
                        catch (DbUpdateConcurrencyException)
                        {
                            if (!JDE_AreasExists(id))
                            {
                                return(NotFound());
                            }
                            else
                            {
                                throw;
                            }
                        }
                    }
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Esempio n. 3
0
        public IHttpActionResult GetPlacesBySetName(string token, string name, int UserId)
        {
            if (token != null && token.Length > 0)
            {
                var tenants = db.JDE_Tenants.Where(t => t.TenantToken == token.Trim());
                if (tenants.Any())
                {
                    object returned = JDE_SetsExists(name, false);
                    if (Type.GetTypeCode(returned.GetType()) == TypeCode.Int32)
                    {
                        //there's set of given name, return its places
                        var items = (from pl in db.JDE_Places
                                     join st in db.JDE_Sets on pl.SetId equals st.SetId
                                     join ar in db.JDE_Areas on pl.AreaId equals ar.AreaId
                                     join us in db.JDE_Users on pl.CreatedBy equals us.UserId
                                     join t in db.JDE_Tenants on pl.TenantId equals t.TenantId
                                     where t.TenantId == tenants.FirstOrDefault().TenantId&& st.SetId == (int)returned
                                     orderby pl.CreatedOn descending
                                     select new
                        {
                            PlaceId = pl.PlaceId,
                            Number1 = pl.Number1,
                            Number2 = pl.Number2,
                            Name = pl.Name,
                            Description = pl.Description,
                            AreaId = ar.AreaId,
                            AreaName = ar.Name,
                            SetId = st.SetId,
                            SetName = st.Name,
                            Priority = pl.Priority,
                            CreatedOn = pl.CreatedOn,
                            CreatedBy = us.UserId,
                            CreatedByName = us.Name + " " + us.Surname,
                            TenantId = t.TenantId,
                            TenantName = t.TenantName,
                            PlaceToken = pl.PlaceToken
                        }
                                     );
                        return(Ok(items));
                    }
                    else
                    {
                        //there's NO set of given name, create it
                        //But first you have to assign it to "Nieokreślone" Area (create if have to)
                        JDE_Areas nArea;
                        JDE_Sets  nSet;
                        JDE_Logs  Log;

                        if (!db.JDE_Areas.Where(a => a.Name.Equals("Nieokreślone")).Any())
                        {
                            //no are like that, let's create it.
                            nArea = new JDE_Areas
                            {
                                Name        = "Nieokreślone",
                                Description = "Trafia tu wszystko co zostaje utworzone bez jasno określonego docelowego obszaru",
                                TenantId    = tenants.FirstOrDefault().TenantId,
                                CreatedBy   = UserId,
                                CreatedOn   = DateTime.Now
                            };
                            db.JDE_Areas.Add(nArea);
                            db.SaveChanges();
                            Log = new JDE_Logs {
                                UserId = UserId, Description = "Utworzenie obszaru", TenantId = tenants.FirstOrDefault().TenantId, Timestamp = DateTime.Now, NewValue = new JavaScriptSerializer().Serialize(nArea)
                            };
                            db.JDE_Logs.Add(Log);
                            db.SaveChanges();
                        }
                        else
                        {
                            //it exists, ret
                            nArea = db.JDE_Areas.Where(a => a.Name.Equals("Nieokreślone")).FirstOrDefault();
                        }

                        nSet = new JDE_Sets
                        {
                            Name        = name.Trim(),
                            Description = null,
                            CreatedBy   = UserId,
                            CreatedOn   = DateTime.Now,
                            TenantId    = tenants.FirstOrDefault().TenantId
                        };
                        db.JDE_Sets.Add(nSet);
                        db.SaveChanges();
                        Log = new JDE_Logs {
                            UserId = UserId, Description = "Utworzenie instalacji", TenantId = tenants.FirstOrDefault().TenantId, Timestamp = DateTime.Now, NewValue = new JavaScriptSerializer().Serialize(nSet)
                        };
                        db.JDE_Logs.Add(Log);
                        db.SaveChanges();


                        JDE_Places nPlace = new JDE_Places
                        {
                            Name        = name.Trim(),
                            Description = null,
                            PlaceToken  = Utilities.uniqueToken(),
                            AreaId      = nArea.AreaId,
                            SetId       = nSet.SetId,
                            CreatedBy   = UserId,
                            CreatedOn   = DateTime.Now,
                            TenantId    = tenants.FirstOrDefault().TenantId
                        };
                        db.JDE_Places.Add(nPlace);
                        db.SaveChanges();
                        Log = new JDE_Logs {
                            UserId = UserId, Description = "Utworzenie zasobu", TenantId = tenants.FirstOrDefault().TenantId, Timestamp = DateTime.Now, NewValue = new JavaScriptSerializer().Serialize(nPlace)
                        };
                        db.JDE_Logs.Add(Log);
                        db.SaveChanges();

                        var items = (from pl in db.JDE_Places
                                     join st in db.JDE_Sets on pl.SetId equals st.SetId
                                     join ar in db.JDE_Areas on pl.AreaId equals ar.AreaId
                                     join us in db.JDE_Users on pl.CreatedBy equals us.UserId
                                     join t in db.JDE_Tenants on pl.TenantId equals t.TenantId
                                     where t.TenantId == tenants.FirstOrDefault().TenantId&& st.SetId == nSet.SetId
                                     orderby pl.CreatedOn descending
                                     select new
                        {
                            PlaceId = pl.PlaceId,
                            Number1 = pl.Number1,
                            Number2 = pl.Number2,
                            Name = pl.Name,
                            Description = pl.Description,
                            AreaId = ar.AreaId,
                            AreaName = ar.Name,
                            SetId = st.SetId,
                            SetName = st.Name,
                            Priority = pl.Priority,
                            CreatedOn = pl.CreatedOn,
                            CreatedBy = us.UserId,
                            CreatedByName = us.Name + " " + us.Surname,
                            TenantId = t.TenantId,
                            TenantName = t.TenantName,
                            PlaceToken = pl.PlaceToken
                        }
                                     );

                        return(Ok(items));
                    }
                }
                else
                {
                    return(NotFound());
                }
            }
            else
            {
                return(NotFound());
            }
        }