Пример #1
0
        public void Field_IndexVersion_NegativeIndexThrows()
        {
            DataTable table = new DataTable("test");
            DataRow   row   = table.NewRow();

            Assert.Throws <IndexOutOfRangeException>(() => DataRowExtensions.Field <int>(row, columnIndex: -1, version: DataRowVersion.Default));
        }
Пример #2
0
        public void Field_ColumnVersion_NullColumnThrows()
        {
            DataTable table = new DataTable("test");
            DataRow   row   = table.NewRow();

            AssertExtensions.Throws <ArgumentNullException>("column", () => DataRowExtensions.Field <int>(row, column: null, version: DataRowVersion.Default));
        }
Пример #3
0
        public void Field_String_NullColumnNameThrows()
        {
            DataTable table = new DataTable("test");
            DataRow   row   = table.NewRow();

            AssertExtensions.Throws <ArgumentNullException>("name", () => DataRowExtensions.Field <int>(row, columnName: null));
        }
Пример #4
0
        public void Field_NullSource_ThrowsArgumentNullException()
        {
            var        table  = new DataTable();
            DataColumn column = table.Columns.Add("Column");

            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column));
            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, 0));
            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, "Column"));
            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column, DataRowVersion.Current));
            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, 0, DataRowVersion.Current));
            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, "Column", DataRowVersion.Current));
        }
Пример #5
0
        //選択された日付の日記を探すメソッド
        public void FindDiary()
        {
            //2箇所のdateTextBoxに表示するメソッドを呼び出す
            SetDate();

            Form1Data.diaryEditTextBoxText = null;

            //選択された日付の日記を探す
            var row   = dataSet.diaryDataTable.Rows.Find(Form1Data.date);
            var colum = dataSet.diaryDataTable.Columns.IndexOf("日記");

            //選択された日付の日記が存在しなければ return
            if (row == null)
            {
                return;
            }

            //選択された日付の日記が存在していれば、内容を TextBox に代入
            var value = DataRowExtensions.Field <string>(row, colum);

            Form1Data.diaryEditTextBoxText = value;
        }
Пример #6
0
        public void Field_ColumnVersion_NullRowThrows()
        {
            DataColumn column = new DataColumn();

            AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, column: column, version: DataRowVersion.Default));
        }
Пример #7
0
 public void Field_NameVersion_NullRowThrows()
 {
     AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, columnName: "foo", version: DataRowVersion.Default));
 }
Пример #8
0
 public void Field_Index_NullRowThrows()
 {
     AssertExtensions.Throws <ArgumentNullException>("row", () => DataRowExtensions.Field <int>(null, 0));
 }
        public DataTable getLigsPick()
        {
            DataTable dt1;

            try
            {
                DataTable dt = (DataTable)this.Session[this._nameSessionData];
                if (dt == null || dt.Rows.Count == 0)
                {
                    return(new DataTable());
                }

                dt1 = DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => DataRowExtensions.Field <string>(x, "liq_estid").Equals("PM") || DataRowExtensions.Field <string>(x, "liq_estid").Equals("PF"))));
                return(dt1);

                //return DataTableExtensions.CopyToDataTable<DataRow>((IEnumerable<DataRow>)EnumerableRowCollectionExtensions.Where<DataRow>(DataTableExtensions.AsEnumerable(dt), (Func<DataRow, bool>)(x => DataRowExtensions.Field<string>(x, "liq_estid").Equals("PF"))));
            }
            catch
            {
                return(new DataTable());
            }
        }
        /// <summary>
        /// Calculo de totales
        /// </summary>
        /// <param name="gv"></param>
        /// <param name="dt"></param>
        /// <param name="printLabels"></param>
        protected void calculateTotals(GridView gv, DataTable dt, bool printLabels, bool showAlert)
        {
            try
            {
                if (dt == null || dt.Rows.Count <= 0)
                {
                    return;
                }
                var fAnonymousType3 = Enumerable.FirstOrDefault(Enumerable.Select(Enumerable.GroupBy <DataRow, DataTable>((IEnumerable <DataRow>)DataTableExtensions.AsEnumerable(dt), (Func <DataRow, DataTable>)(x => x.Table)), y =>
                {
                    var local_0 = new
                    {
                        x1 = Enumerable.Count <DataRow>((IEnumerable <DataRow>)y),
                        x2 = Enumerable.Sum <DataRow>((IEnumerable <DataRow>)y, (Func <DataRow, Decimal>)(x => DataRowExtensions.Field <Decimal>(x, "Cantidad"))),
                        x3 = Enumerable.Count <DataRow>(Enumerable.Where <DataRow>((IEnumerable <DataRow>)y, (Func <DataRow, bool>)(x => !string.IsNullOrEmpty(x["pin_employee"].ToString())))),
                        x4 = Enumerable.Sum <DataRow>(Enumerable.Where <DataRow>((IEnumerable <DataRow>)y, (Func <DataRow, bool>)(x => !string.IsNullOrEmpty(x["pin_employee"].ToString()))), (Func <DataRow, Decimal>)(x => DataRowExtensions.Field <Decimal>(x, "Cantidad")))
                    };
                    return(local_0);
                }));
                gv.FooterRow.Cells[0].Text = "TOTALES:";
                gv.FooterRow.Cells[1].Text = fAnonymousType3.x1.ToString("N0");
                gv.FooterRow.Cells[6].Text = fAnonymousType3.x2.ToString("N0");

                // Pedidos sin asignacion de marcacion
                if (showAlert)
                {
                    int num = (fAnonymousType3.x1 - fAnonymousType3.x3);
                    if (num > 0)
                    {
                        string script = string.Empty;
                        script += "dialogInfo('Marcación de pedidos','Nuevos pedidos en marcación','Tiene <b> " + num + " nuevos pedidos </b>');";
                        System.Web.UI.ScriptManager.RegisterStartupScript(upMsg, Page.GetType(), "dialogInfo", script, true);
                    }
                }

                if (printLabels)
                {
                    Label  label1 = this.lblLiqInPick;
                    int    num1   = fAnonymousType3.x3;
                    string str1   = num1.ToString("N0");
                    label1.Text = str1;
                    Label   label2 = this.lblQtysInPick;
                    Decimal num2   = fAnonymousType3.x4;
                    string  str2   = num2.ToString("N0");
                    label2.Text = str2;
                    Label label3 = this.lblLiqNotPick;
                    num1 = fAnonymousType3.x1 - fAnonymousType3.x3;
                    string str3 = num1.ToString("N0");
                    label3.Text = str3;
                    Label label4 = this.lblQtyNotPick;
                    num2 = fAnonymousType3.x2 - fAnonymousType3.x4;
                    string str4 = num2.ToString("N0");
                    label4.Text = str4;
                }
            }
            catch
            {
            }
        }
        public DataTable getLiqsHalls()
        {
            try
            {
                DataTable dt = (DataTable)this.Session[this._nameSessionData];
                if (dt == null || dt.Rows.Count == 0)
                {
                    return(new DataTable());
                }

                return(DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => !DataRowExtensions.Field <string>(x, "lhv_status").Equals("PM")))));
            }
            catch
            {
                return(new DataTable());
            }
        }
Пример #12
0
        protected void ProcessZip()
        {
            //TODO: Add functionality to just upload .csv
            var fileName = Path.GetFileName(FileInput.PostedFile.FileName);

            if (int.TryParse(ddlCompetitorName.SelectedValue, out var id))
            {
                if (fileName.EndsWith(".zip"))
                {
                    var saveLocation = Server.MapPath("~/App_Data/") + fileName;
                    if (!CheckFileRecords(id, fileName))
                    {
                        try
                        {
                            FileInput.PostedFile.SaveAs(saveLocation);
                        }
                        catch (Exception ex)
                        {
                            Response.Write("Error: " + ex.Message);
                        }

                        var dtHeartRateZones  = GetHeartRateZones();
                        var dtPointsPerMinute = GetPointsPerMinute();

                        var totalPoints  = 0;
                        var userRange1Lb =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone1LowerBound"];
                        var userRange1Ub =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone1UpperBound"];
                        var userRange2Lb =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone2LowerBound"];
                        var userRange2Ub =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone2UpperBound"];
                        var userRange3Lb =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone3LowerBound"];
                        var userRange3Ub =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone3UpperBound"];
                        var userRange4Lb =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone4LowerBound"];
                        var userRange4Ub =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone4UpperBound"];
                        var userRange5Lb =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone5LowerBound"];
                        var userRange5Ub =
                            (int)dtHeartRateZones.AsEnumerable().FirstOrDefault(x =>
                                                                                DataRowExtensions.Field <int>(x, "CompetitorID").Equals(id))?["Zone5UpperBound"];


                        using (var archive = ZipFile.OpenRead(saveLocation))
                        {
                            foreach (var entry in archive.Entries)
                            {
                                int range2Seconds, range3Seconds, range4Seconds, range5Seconds;

                                var range1Seconds = range2Seconds = range3Seconds = range4Seconds = range5Seconds = 0;

                                if (!entry.FullName.EndsWith(".csv", StringComparison.OrdinalIgnoreCase))
                                {
                                    continue;
                                }
                                try
                                {
                                    var dt = new DataTable();
                                    using (var sr = new StreamReader(entry.Open())) //build dt from .csv
                                    {
                                        sr.ReadLine();
                                        sr.ReadLine();
                                        var headers = sr.ReadLine().Split(',');
                                        foreach (var header in headers)
                                        {
                                            dt.Columns.Add(header);
                                        }
                                        while (!sr.EndOfStream)
                                        {
                                            var rows = sr.ReadLine().Split(',');
                                            var dr   = dt.NewRow();
                                            for (var i = 0; i < headers.Length; i++)
                                            {
                                                dr[i] = rows[i];
                                            }

                                            var heartrate = int.TryParse(dr[2].ToString(), out var s) ? s : 0;
                                            if (heartrate >= userRange1Lb && heartrate <= userRange1Ub)
                                            {
                                                range1Seconds++;
                                            }
                                            else if (heartrate >= userRange2Lb && heartrate <= userRange2Ub)
                                            {
                                                range2Seconds++;
                                            }
                                            else if (heartrate >= userRange3Lb && heartrate <= userRange3Ub)
                                            {
                                                range3Seconds++;
                                            }
                                            else if (heartrate >= userRange4Lb && heartrate <= userRange4Ub)
                                            {
                                                range4Seconds++;
                                            }
                                            else if (heartrate >= userRange5Lb && heartrate <= userRange5Ub)
                                            {
                                                range5Seconds++;
                                            }
                                            dt.Rows.Add(dr);
                                        }
                                    }

                                    //all done with csv, calculate points.
                                    var range1Minutes = decimal.Divide(range1Seconds, 60);
                                    var range2Minutes = decimal.Divide(range2Seconds, 60);
                                    var range3Minutes = decimal.Divide(range3Seconds, 60);
                                    var range4Minutes = decimal.Divide(range4Seconds, 60);
                                    var range5Minutes = decimal.Divide(range5Seconds, 60);

                                    var range1Points = range1Minutes * ((int)dtPointsPerMinute.AsEnumerable().FirstOrDefault(x => x.Field <int>("HeartRateZone").Equals(1))["Points"]);
                                    var range2Points = range2Minutes * ((int)dtPointsPerMinute.AsEnumerable().FirstOrDefault(x => x.Field <int>("HeartRateZone").Equals(2))["Points"]);
                                    var range3Points = range3Minutes * ((int)dtPointsPerMinute.AsEnumerable().FirstOrDefault(x => x.Field <int>("HeartRateZone").Equals(3))["Points"]);
                                    var range4Points = range4Minutes * ((int)dtPointsPerMinute.AsEnumerable().FirstOrDefault(x => x.Field <int>("HeartRateZone").Equals(4))["Points"]);
                                    var range5Points = range5Minutes * ((int)dtPointsPerMinute.AsEnumerable().FirstOrDefault(x => x.Field <int>("HeartRateZone").Equals(5))["Points"]);

                                    var pointsToAdd = int.Parse(Math.Round(range1Points + range2Points + range3Points + range4Points + range5Points).ToString());
                                    totalPoints += pointsToAdd;

                                    RecordFileName(entry.Name, pointsToAdd);
                                }
                                catch (Exception ex)
                                {
                                    Response.Write("Processing Error: " + ex.Message + " ");
                                }
                            }
                        }
                        ////Write final total
                        UpdateTotalPoints();
                        Response.Write($"The file has been uploaded. {totalPoints.ToString()} points have been added to your total score.");
                        //RecordFileName(FileName, TotalPoints);

                        //Delete CSV from Server Data
                        File.Delete(saveLocation);
                    }
                    else
                    {
                        ClientScript.RegisterStartupScript(GetType(), "alert", "repeatedUpload();", true);
                    }
                }
                else
                {
                    ClientScript.RegisterStartupScript(GetType(), "alert", "improperType();", true);
                }
            }
            else
            {
                ClientScript.RegisterStartupScript(GetType(), "alert", "improperID();", true);
            }
        }
Пример #13
0
        public DataSourse GetData(string constr)
        {
            DataSourse dataSourse = new DataSourse();
            string     dbName     = constr.Substring(0, constr.IndexOf(";")).Substring(constr.IndexOf("=") + 1);
            IDbObject  dbObject   = (IDbObject) new DataAccess();

            dbObject.DbConnectStr = constr;
            List <string>    tables = dbObject.GetTables(dbName);
            List <TableData> list1  = new List <TableData>();
            List <Reference> list2  = new List <Reference>();

            if (tables != null && tables.Count > 0)
            {
                foreach (string tableName in tables)
                {
                    TableData tableData = new TableData();
                    tableData.Code = tableName;
                    tableData.Name = tableName;
                    tableData.Id   = tableName;
                    List <string> list3          = new List <string>();
                    DataTable     columnInfoList = dbObject.GetColumnInfoList(dbName, tableName);
                    List <Column> list4          = new List <Column>();
                    foreach (DataRow row in (InternalDataCollectionBase)columnInfoList.Rows)
                    {
                        Column column1 = new Column();
                        column1.Code      = DataRowExtensions.Field <string>(row, 1).Trim();
                        column1.Comment   = DataRowExtensions.Field <string>(row, 15).Trim();
                        column1.DataType  = DataRowExtensions.Field <string>(row, 2).Trim();
                        column1.Displayed = "true";
                        Column column2 = column1;
                        string str1    = tableName;
                        int    num     = DataRowExtensions.Field <int>(row, 0);
                        string str2    = num.ToString();
                        string str3    = str1 + str2;
                        column2.Id = str3;
                        Column column3 = column1;
                        num = DataRowExtensions.Field <int>(row, 3);
                        string str4 = num.ToString();
                        column3.Length    = str4;
                        column1.Mandatory = DataRowExtensions.Field <string>(row, 13).Trim() == "√" ? "" : "1";
                        column1.Name      = DataRowExtensions.Field <string>(row, 1).Trim();
                        column1.TableCode = tableName;
                        column1.TableId   = tableData.Id;
                        if (DataRowExtensions.Field <string>(row, 7).Trim() != "d")
                        {
                            list3.Add(column1.Id);
                        }
                        list4.Add(column1);
                    }
                    tableData.Columns = list4;
                    if (list3.Count > 0)
                    {
                        tableData.PrimaryKey = new Key()
                        {
                            KeyId     = Guid.NewGuid().ToString(),
                            ColumnRef = list3.ToArray()
                        }
                    }
                    ;
                    list1.Add(tableData);
                }
            }
            if (list1 != null && list1.Count > 0)
            {
                foreach (TableData tableData in list1)
                {
                    TableData tab = tableData;
                    foreach (DataRow dataRow in (InternalDataCollectionBase)dbObject.GetTableRefrence(dbName, tab.Code).Rows)
                    {
                        DataRow   item = dataRow;
                        Reference r    = new Reference();
                        r.ParentTable          = Enumerable.SingleOrDefault <string>(Enumerable.Select <TableData, string>(Enumerable.Where <TableData>((IEnumerable <TableData>)list1, (Func <TableData, bool>)(t => t.Code == DataRowExtensions.Field <string>(item, 1).Trim())), (Func <TableData, string>)(t => t.Id)));
                        r.ParentTableColumnRef = Enumerable.SingleOrDefault <string>(Enumerable.Select(Enumerable.Where(Enumerable.Where(Enumerable.SelectMany((IEnumerable <TableData>)list1, (Func <TableData, IEnumerable <Column> >)(t => (IEnumerable <Column>)t.Columns), (t, f) =>
                        {
                            var fAnonymousType2 = new
                            {
                                t = t,
                                f = f
                            };
                            return(fAnonymousType2);
                        }), param0 => param0.t.Id == r.ParentTable), param0 => param0.f.Code == DataRowExtensions.Field <string>(item, 2).Trim()), param0 => param0.f.Id));
                        r.Id                  = Guid.NewGuid().ToString();
                        r.ChildTable          = tab.Id;
                        r.ChildTableColumnRef = Enumerable.SingleOrDefault <string>(Enumerable.Select(Enumerable.Where(Enumerable.Where(Enumerable.SelectMany((IEnumerable <TableData>)list1, (Func <TableData, IEnumerable <Column> >)(t => (IEnumerable <Column>)t.Columns), (t, f) =>
                        {
                            var fAnonymousType2 = new
                            {
                                t = t,
                                f = f
                            };
                            return(fAnonymousType2);
                        }), param0 => param0.t.Id == tab.Id), param0 => param0.f.Code == DataRowExtensions.Field <string>(item, 0).Trim()), param0 => param0.f.Id));
                        list2.Add(r);
                    }
                }
            }
            dataSourse.ListTable     = list1;
            dataSourse.ListReference = list2;
            DataTable       vieWs = dbObject.GetVIEWs(dbName);
            List <ViewData> list5 = new List <ViewData>();

            if (vieWs != null && vieWs.Rows != null && vieWs.Rows.Count > 0)
            {
                foreach (DataRow row in (InternalDataCollectionBase)vieWs.Rows)
                {
                    string str = DataRowExtensions.Field <string>(row, 0);
                    if (!string.IsNullOrWhiteSpace(str))
                    {
                        string    objectViewInfo = dbObject.GetObjectViewInfo(dbName, str);
                        DataTable dataTable      = dbObject.QueryViewInfo(dbName, str);
                        ViewData  viewData       = new ViewData();
                        viewData.Code     = str;
                        viewData.Name     = str;
                        viewData.Id       = str;
                        viewData.SQLQuery = objectViewInfo;
                        List <Column> list3 = new List <Column>();
                        foreach (DataColumn dataColumn in (InternalDataCollectionBase)dataTable.Columns)
                        {
                            list3.Add(new Column()
                            {
                                Name = dataColumn.ColumnName,
                                Code = dataColumn.ColumnName,
                                Id   = Guid.NewGuid().ToString()
                            });
                        }
                        viewData.Columns = list3;
                        list5.Add(viewData);
                    }
                }
            }
            dataSourse.ListView = list5;
            return(dataSourse);
        }
    }