Esempio n. 1
0
        //ReportDailyAttendence

        public List <catalogue> getCatalogues()
        {
            catalogue        cat;
            List <catalogue> Catalogues = new List <catalogue>();

            try
            {
                SqlConnection conn  = new SqlConnection(Login.connString);
                string        query = "select CatalogueValueID,Description from CatalogueValue where" +
                                      " CatalogueID='AttendanceStatus' and Status=1";
                SqlCommand cmd = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    cat             = new catalogue();
                    cat.catalogueID = reader.GetString(0);
                    cat.description = reader.GetString(1);
                    Catalogues.Add(cat);
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
            }
            return(Catalogues);
        }
Esempio n. 2
0
        public Boolean updateCatalogue(catalogue cat)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "update Catalogue set Description='" + cat.description +
                                   "',Status=" + cat.status +
                                   " where CatalogueID='" + cat.catalogueID + "'";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("update", "Catalogue", "", updateSQL) +
                           Main.QueryDelimiter;
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
                status = false;
            }
            return(status);
        }
Esempio n. 3
0
        public Boolean insertCatalogue(catalogue cat)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "insert into Catalogue (catalogueID,Description,Status,CreateTime,CreateUser)" +
                                   "values (" +
                                   "'" + cat.catalogueID + "'," +
                                   "'" + cat.description + "'," +
                                   cat.status + "," +
                                   "GETDATE()" + "," +
                                   "'" + Login.userLoggedIn + "'" + ")";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("insert", "Catalogue", "", updateSQL) +
                           Main.QueryDelimiter;
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
                status = false;
            }
            return(status);
        }
Esempio n. 4
0
        public Boolean validateCatalogue(catalogue cat)
        {
            Boolean status = true;

            try
            {
                if (cat.catalogueID.Trim().Length == 0 || cat.catalogueID == null)
                {
                    return(false);
                }
                if (cat.description.Trim().Length == 0 || cat.description == null)
                {
                    return(false);
                }
            }
            catch (Exception)
            {
                MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
                return(false);
            }
            return(status);
        }