Esempio n. 1
0
        public Message saveToFile(string pathToSave, List <UserStruct> data)
        {
            this.createWordApplication();

            Message msg = new Message();

            if (WordApp != null && doc != null)
            {
                UserStruct last = data[data.Count - 1];

                foreach (UserStruct user in data)
                {
                    newTable.Cell(newTable.Rows.Count, 1).Range.Text = user.name;
                    newTable.Cell(newTable.Rows.Count, 2).Range.Text = user.bal.ToString();
                    newTable.Cell(newTable.Rows.Count, 3).Range.Text = user.numberSchool.ToString();

                    if (last != user)
                    {
                        newTable.Rows.Add();
                    }
                }

                doc.SaveAs(@pathToSave, ref oMissing, ref oMissing, ref oMissing,
                           ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                           ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                           ref oMissing, ref oMissing, ref oMissing, ref oMissing);

                msg.userMessage = "Файл збережено!";
                msg.code        = true;

                this.closeWordApp();

                return(msg);
            }
            else
            {
                msg.userMessage = "Неможливо записати у документ.\nПрограму буде завершено!";
                msg.logMessage  = "Cannot write to word file";
                msg.code        = false;

                return(msg);
            }
        }
Esempio n. 2
0
        public List <UserStruct> readDataFromTable()
        {
            DataSet ds = this.ReadTables();

            foreach (DataRow myRow in ds.Tables[0].Rows)
            {
                UserStruct user         = new UserStruct();
                int        columnNumber = 1;

                foreach (DataColumn myCol in ds.Tables[0].Columns)
                {
                    if (myRow[myCol] != System.DBNull.Value)
                    {
                        if (columnNumber == 1)
                        {
                            user.name = myRow[myCol].ToString();
                        }
                        if (columnNumber == 2)
                        {
                            user.bal = Convert.ToInt32(myRow[myCol]);
                        }
                        if (columnNumber == 3)
                        {
                            user.numberSchool = Convert.ToInt32(myRow[myCol]);
                        }
                    }

                    columnNumber++;
                }

                this.userData.Add(user);
            }


            return(this.userData);
        }