Exemple #1
0
        // write to current
        public virtual void dataGrid_CellValuePushed(DataGridViewCellValueEventArgs e)
        {
            // if no current get selected as current
            if (current_editrow == null)
            {
                if (e.RowIndex < dlist.Count)
                {
                    current_editrow = (cBaseItem)dlist[e.RowIndex];
                }
            }

            // edit
            if (current_editrow != null)
            {
                cBaseItem d = current_editrow;
                try
                {
                    d.UpdateCell(e.ColumnIndex, e.Value);
                }
                catch (Exception exp)
                {
                    string err = exp.Message; // error
                    MessageBox.Show("Invalid data type.\nError: 1");
                }
            }
        }
Exemple #2
0
        public virtual int InsertDB(object o)
        {
            cBaseItem d = (cBaseItem)o;

            if (d != null)
            {
                vlist.Reset();
                int i = 0;

                // if index -1 then, need to use seqance
                if (((int)d.data[0]) == -1)
                {
                    vlist.AddSeqNextValue(tbl_name);
                    i++;
                }

                for (; i < d.data.Count; i++)
                {
                    vlist.Add(d.data[i]);
                }

                return(Insert(tbl_name, vlist.SQL));
            }

            return(1);
        }
Exemple #3
0
        // DB_base object is going to call this function to custom fill the array list
        public override object ReadData(object[] row)
        {
            cBaseItem d = getNewRow();

            if (row.Length == d.data.Count)
            {
                Type t;
                for (int i = 0; i < row.Length; i++)
                {
                    t = d.data[i].GetType();

                    // prevent exception thrown when setting data type
                    // if null then set a empty string
                    if (row[i] is DBNull)
                    {
                        row[i] = "";
                    }

                    // if string
                    if (row[i] is string)
                    {
                        string s = row[i].ToString();

                        // if empty string and expecting not a string
                        if ((s.Length < 1) &&
                            !(d.data[i] is string))
                        {
                            d.data[i] = Convert.ChangeType(0, t);
                        }
                        else
                        {
                            // expecting a string
                            if (d.data[i] is string)
                            {
                                s = s.Replace("\\:", ",");  // replace all "\:" with commas ","
                                s = s.Replace("\\n", "\n"); // replace all "\n" with linefeeds
                                s = s.Replace("\\r", "\r"); // replace all "\r" with returns
                            }

                            d.data[i] = Convert.ChangeType(s, t);
                        }
                    }
                    else
                    {
                        // if type not string
                        d.data[i] = Convert.ChangeType(row[i], t);
                    }
                }

                d.already_inDB = true;
                d.is_new       = false;
                dlist.Add(d);
                return(d);
            }

            return(null);
        }
Exemple #4
0
        public virtual int DeleteDB(object o)
        {
            cBaseItem d = (cBaseItem)o;

            if (d != null)
            {
                vlist.Reset();
                vlist.Add(nlist[0].ToString(), d.data[0]);

                return(Delete(tbl_name, vlist.SQL));
            }

            return(1);
        }
Exemple #5
0
 // -----------------------------------------
 // DataGrid Events
 // read from internal ArrayList
 public virtual void dataGrid_CellValueNeeded(DataGridView dg, DataGridViewCellValueEventArgs e)
 {
     if (e.RowIndex < dlist.Count)
     {
         cBaseItem d = (cBaseItem)dlist[e.RowIndex];
         e.Value = d.RenderCell(e.ColumnIndex);
     }
     else
     {
         // if displaying new row
         if (current_editrow != null)
         {
             cBaseItem d = current_editrow;
             e.Value = d.RenderCell(e.ColumnIndex);
         }
     }
 }
Exemple #6
0
        public virtual int InsertUpdate(cBaseItem d)
        {
            if (d.already_inDB)
            {
                return(UpdateDB(d));
            }
            else
            {
                int e = InsertDB(d);
                if (e == 0)
                {
                    d.already_inDB = true;
                    dlist.Add(d);
                }

                return(e);
            }
        }
Exemple #7
0
        // Finished editing a row, now write changed row out
        public virtual void dataGrid_RowValidating(DataGridViewCellCancelEventArgs e)
        {
            display_error = false;

            if (current_editrow != null)
            {
                // insert new, or update existing
                if (!current_editrow.is_new)
                {
                    int error = InsertUpdate(current_editrow);
                    if (error != 0)
                    {
                        throw new Exception();
                    }

                    current_editrow = null;
                }
            }
        }
Exemple #8
0
        public virtual void WriteEntity(StreamWriter sw, int i)
        {
            cSqlValueList vlist = new cSqlValueList();
            cBaseItem     be    = null;

            be = (cBaseItem)dlist[i];
            if (be != null)
            {
                vlist.Reset();
                vlist.Mode = 1; // for file

                for (int j = 0; j < be.data.Count; ++j)
                {
                    vlist.Add(be.data[j]);
                }

                // write line to file
                sw.WriteLine(vlist.SQL);
            }
        }
Exemple #9
0
        public virtual int UpdateDB(object o)
        {
            cBaseItem d = (cBaseItem)o;

            if (d != null)
            {
                vlist.Reset();

                // don't update index
                for (int i = 1; i < nlist.Count; i++)
                {
                    vlist.Add(nlist[i].ToString(), d.data[i]);
                }

                string sql = string.Format("{0} WHERE {1}={2}", vlist.SQL, nlist[0], d.data[0]);

                return(Update(tbl_name, sql));
            }

            return(1);
        }
Exemple #10
0
        public virtual void dataGrid_UserDeletingRow(DataGridViewRowCancelEventArgs e)
        {
            int error = 0;

            if (e.Row.Index < dlist.Count)
            {
                cBaseItem d = (cBaseItem)dlist[e.Row.Index];
                error = DeleteDB(d);

                // if no error
                if (error == 0)
                {
                    dlist.RemoveAt(e.Row.Index);
                }
            }

            if (error != 0)
            {
                throw new Exception();
            }
        }
Exemple #11
0
        // write to current
        public virtual void dataGrid_CellValuePushed(DataGridViewCellValueEventArgs e)
        {
            // if no current get selected as current
            if(current_editrow == null)
            {
                if (e.RowIndex < dlist.Count)
                {
                    current_editrow = (cBaseItem)dlist[e.RowIndex];
                }
            }

            // edit
            if (current_editrow != null)
            {
                cBaseItem d = current_editrow;
                try
                {
                    d.UpdateCell(e.ColumnIndex, e.Value);
                }
                catch (Exception exp)
                {
                    string err = exp.Message; // error
                    MessageBox.Show("Invalid data type.\nError: 1");
                }
            }
        }
Exemple #12
0
 public virtual void dataGrid_CancelRowEdit(QuestionEventArgs e)
 {
     current_editrow = null;
 }
Exemple #13
0
        public virtual int InsertUpdate(cBaseItem d)
        {
            if (d.already_inDB) {
                return UpdateDB(d);
            } else {
                int e = InsertDB(d);
                if (e == 0)
                {
                    d.already_inDB = true;
                    dlist.Add(d);
                }

                return e;
            }
        }
Exemple #14
0
        // Finished editing a row, now write changed row out
        public virtual void dataGrid_RowValidating(DataGridViewCellCancelEventArgs e)
        {
            display_error = false;

            if(current_editrow != null)
            {
                // insert new, or update existing
                if(!current_editrow.is_new)
                {
                    int error = InsertUpdate(current_editrow);
                    if (error != 0) throw new Exception();

                    current_editrow = null;
                }
            }
        }
Exemple #15
0
 public virtual void dataGrid_NewRowNeeded(DataGridViewRowEventArgs e)
 {
     current_editrow = getNewRow();
 }
Exemple #16
0
 public virtual void dataGrid_CancelRowEdit(QuestionEventArgs e)
 {
     current_editrow = null;
 }
Exemple #17
0
 public virtual void dataGrid_NewRowNeeded(DataGridViewRowEventArgs e)
 {
     current_editrow = getNewRow();
 }