Beispiel #1
0
        public object Delete(string modelName, JGridRequest packet, DbContext dbContext = null)
        {
            object model = Dynamic.GetInstance(Dynamic.GetFullyQualifiedPath(modelName));

            model.SetPropertyValue(db.GetPrimaryKeyInfo(model).Name, packet.RecordId);
            object result = db.Delete(model, dbContext).Model;

            return(result);
        }
Beispiel #2
0
 public void InsertVerificationLog(JGridRequest packet, object model, OperationType operationType, DbContext dbContext = null)
 {
     if (model.GetType().IsGenericType)
     {
         foreach (var item in (IList)model)
         {
             PerformVerificationLog(packet, item, operationType, dbContext);
         }
     }
     else
     {
         PerformVerificationLog(packet, model, operationType, dbContext);
     }
 }
Beispiel #3
0
        public object Export(JGridRequest packet, IQuerySelector querySelector, DbContext dbContext = null)
        {
            var httpContext = new Http().HttpContext;

            if (packet.Extension == null || packet.Extension == "" || packet.Extension != "csv")
            {
                packet.Extension = "xlsx";
            }

            DataSet   ds = new DataSet();
            DataTable dt = new DataTable();

            dt = db.GetDataTable(querySelector.Select(packet));
            //dt = db.GetDataTable(querySelector.Select(packet), dbContext);
            if (packet.Extension == "csv")
            {
                StringBuilder        sb          = new StringBuilder();
                IEnumerable <string> columnNames = dt.Columns.Cast <DataColumn>().Select(column => column.ColumnName);
                sb.AppendLine(string.Join(",", columnNames));
                foreach (DataRow row in dt.Rows)
                {
                    IEnumerable <string> fields = row.ItemArray.Select(field => field.ToString());
                    sb.AppendLine(string.Join(",", fields));
                }
                string st = sb.ToString();
                return(null);
            }
            else
            {
                dt.TableName = packet.ModelName;
                ds.Tables.Add(dt);
                using (XLWorkbook wb = new XLWorkbook())
                {
                    wb.Worksheets.Add(ds);
                    wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
                    wb.Style.Font.Bold            = true;
                    using (MemoryStream stream = new MemoryStream())
                    {
                        wb.SaveAs(stream);
                        return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", packet.ModelName + "." + packet.Extension));
                    }
                }
            }
        }
Beispiel #4
0
        public object Update(string modelName, JGridRequest packet, DbContext dbContext = null)
        {
            object model = Dynamic.GetInstance(Dynamic.GetFullyQualifiedPath(modelName));
            Dictionary <string, string> dictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(packet.Data.ToString());

            string[] ids    = packet.RecordId.Split(',');
            var      list   = Activator.CreateInstance(typeof(List <>).MakeGenericType(model.GetType()));
            var      pkInfo = db.GetPrimaryKeyInfo(model);

            foreach (string recordId in ids)
            {
                dictionary[pkInfo.Name] = recordId;
                object record = db.GetById(model, recordId);
                record = dictionary.DictionaryToModel(record);
                Dynamic.InvokeMethod("Add", list, model.GetType(), new Type[] { model.GetType() }, record);
            }
            object result = db.Update(list, dbContext).Model;

            return(result);
        }
Beispiel #5
0
        private DbResultAfter PerformVerificationLog(JGridRequest packet, object model, OperationType operationType, DbContext dbContext = null)
        {
            System.Reflection.PropertyInfo pk       = db.GetPrimaryKeyInfo(model);
            object              pkValue             = model.GetPropertyValue(pk.Name);
            object              uUID                = model.GetPropertyValue("UUID");
            List <string>       childTableList      = db.GetChildTableList(model, dbContext);
            DataVerificationLog dataVerificationLog = new DataVerificationLog
            {
                TableName       = packet.ModelName,
                OperationType   = (int)operationType,
                PrimaryKey      = pk.Name,
                UUID            = uUID == null ? "" : (string)uUID,
                IsClientUpdated = 0,
                RecordType      = packet.RecordType == "Master" ? 1 : 2,
                ChildTables     = childTableList.Count() == 0 ? "" : string.Join(",", childTableList)
            };

            dataVerificationLog.SetPropertyValue("Id", pkValue);
            dataVerificationLog.SetPropertyValue("NotifiedTo", model.GetPropertyValue("UserId") ?? 0);
            dataVerificationLog.SetPropertyValue("NotifiedBy", Config.APP.UserId);
            return(db.Save(dataVerificationLog, dbContext));
        }
Beispiel #6
0
        public object GetVerifyInfo(object model, JGridRequest packet, DbContext dbContext = null)
        {
            string pkName        = db.GetPrimaryKeyInfo(model).Name;
            string sql           = string.Format(@"SELECT ISNULL(ud.FullName, '') as UserName,
                                        d.EntryDate as DataCollectionDate
                                        ,ISNULL(d.IsVerified,0) as IsVerified
                                        ,ISNULL(u.FullName,'') as VerifierName
                                        ,d.VerificationDate as VerificationDate
                                        ,ISNULL(d.VerificationNote,'') as VerificationNote
                                        FROM {0} d
                                        LEFT JOIN AspNetUsers u on u.UserId = d.VerifiedBy
                                        LEFT JOIN AspNetUsers ud on u.UserId = d.UserId
                                        WHERE d.{1} = '{2}'", model.GetType().Name, pkName, packet.RecordId);
            var    result        = db.GetAll(new VerificationInfo(), sql, true, dbContext);
            var    isGreaterThan = (int)result.GetPropertyValue("Count") != 0;

            if (!isGreaterThan)
            {
                return(null);
            }
            result = ((IList)result)[0];
            return(result);
        }
Beispiel #7
0
        public object Manage(JGridRequest packet, object filter, IQuerySelector querySelector, DbContext dbContext = null)
        {
            try
            {
                JGridPacket jGridPacket = new JGridPacket();
                dbContext = dbContext ?? Config.DB.DefaultDbContext;
                if (packet.Data != null)
                {
                    Dictionary <string, object> filterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(packet.Data.ToString());

                    if (packet.RequestType == "ShowEdit" || packet.RequestType == "Update")
                    {
                        if (filter.GetPropertyValue("OverrideModel") != null && packet.IsOverride == true)
                        {
                            packet.ModelName = filterDictionary["OverrideModel"].ToString();
                        }
                    }
                }


                if (packet.RequestType == "Show" || packet.RequestType == "Export")
                {
                    if (!packet.IsOverride)
                    {
                        packet.ModelName = packet.ModelName.Contains("View") == true ? packet.ModelName : packet.ModelName + "View";
                    }
                }
                object model = null;
                if (packet.RequestType != "Export")
                {
                    model = Dynamic.GetInstance(Dynamic.GetFullyQualifiedPath(packet.ModelName, "Domain"));
                }
                switch (packet.RequestType)
                {
                case "Show":
                    jGridPacket.Record = db.GetAll(model, querySelector.Select(packet), true, dbContext);
                    break;

                case "Insert":

                    object data = JsonConvert.DeserializeObject(packet.Data, model.GetType());
                    jGridPacket.Record = db.Save(data, dbContext).Result.Model;
                    db.Commit();
                    break;

                case "Update":
                    Dictionary <string, object> requestData = JsonConvert.DeserializeObject <Dictionary <string, object> >(packet.Data);
                    requestData.Add("ModifiedBy", Config.APP.UserId);
                    requestData.Add("ModificationDate", DateTime.Now.ToString());
                    packet.Data        = JsonConvert.SerializeObject(requestData);
                    jGridPacket.Record = Update(packet.ModelName, packet, dbContext);
                    db.Commit();

                    break;

                case "Delete":
                    jGridPacket.Record = Delete(packet.ModelName, packet, dbContext);
                    InsertVerificationLog(packet, jGridPacket.Record, OperationType.DELETE, dbContext);
                    db.Commit();
                    break;

                case "VerifyInfo":
                    jGridPacket.Record = GetVerifyInfo(model, packet, dbContext);
                    break;

                case "Verify":
                    Dictionary <string, object> verifyData = JsonConvert.DeserializeObject <Dictionary <string, object> >(packet.Data);
                    verifyData.Add("VerifiedBy", Config.APP.UserId);
                    verifyData.Add("VerificationDate", DateTime.Now);
                    packet.Data        = JsonConvert.SerializeObject(verifyData);
                    jGridPacket.Record = Update(packet.ModelName, packet, dbContext);
                    InsertVerificationLog(packet, jGridPacket.Record, OperationType.UPDATE, dbContext);
                    db.Commit();
                    return(new { success = true, Data = "Verification Successful", VerifierName = Config.APP.UserName, VerificationDate = DateTime.Now });

                case "Export":
                    return(Export(packet, querySelector, dbContext));

                case "ShowEdit":
                    object showData = db.GetById(model, packet.RecordId, false, dbContext);
                    string viewName = packet.ControllerName != "QB" ? packet.ModelName : packet.ControllerName;
                    //string html = Cast.View.GetString(packet.ControllerName + "/" + viewName+".cshtml");
                    var html = Cast.View.GetString("~/Views/" + packet.ControllerName + "/" + packet.ModelName + ".cshtml");
                    //string html = Tools.RenderView(packet.ControllerName + "/" + viewName);

                    return(new { success = true, json = showData, html });

                case "ShowCreate":
                    html = Cast.View.GetString("~/Views/" + packet.ControllerName + "/" + packet.ModelName + ".cshtml");
                    return(new { success = true, html });

                case "Map":
                    List <MapJson> lst = new List <MapJson>
                    {
                        new MapJson()
                        {
                            Id = 4, Location = "GMP 1 (1-Dec-2018)", Latitude = "23.7491206", Longitude = "90.3602757"
                        },
                        new MapJson()
                        {
                            Id = 5, Location = "GMP 2 (1-Jan-2019)", Latitude = "23.7478959", Longitude = "90.3629236"
                        },
                        new MapJson()
                        {
                            Id = 3, Location = "GMP 3 (1-Feb-2019)", Latitude = "23.7489088", Longitude = "90.3649791"
                        },
                        new MapJson()
                        {
                            Id = 2, Location = "GMP 4 (1-Mar-2019)", Latitude = "23.7477852", Longitude = "90.3629741"
                        },
                        new MapJson()
                        {
                            Id = 1, Location = "GMP 5 (1-Apr-2019)", Latitude = "23.7390734", Longitude = "90.3609762"
                        }
                    };
                    return(new { success = true, Data = lst });
                }
                return(new { Data = jGridPacket, success = true });
            }
            catch (Exception ex)
            {
                return(new { success = false, Data = ex.Message });
            }
        }