示例#1
0
        public Boolean updateOffice(office off)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "update Office set name='" + off.name +
                                   "', RegionID='" + off.RegionID +
                                   "', Address1='" + off.Address1 +
                                   "', Address2='" + off.Address2 +
                                   "', Address3='" + off.Address3 +
                                   "', Address4='" + off.Address4 +
                                   "',Status=" + off.status +
                                   " where OfficeID='" + off.OfficeID + "'";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("update", "Office", "", updateSQL) +
                           Main.QueryDelimiter;
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception)
            {
                status = false;
            }
            return(status);
        }
示例#2
0
        public List <office> getOffices()
        {
            office        off;
            List <office> Offices = new List <office>();

            try
            {
                SqlConnection conn  = new SqlConnection(Login.connString);
                string        query = "select a.OfficeID, a.Name,a.RegionID,b.Name,a.Address1,a.Address2,a.Address3,a.Address4,a.status " +
                                      "from Office a, Region b where a.RegionID=b.RegionID order by a.Name";
                SqlCommand cmd = new SqlCommand(query, conn);
                conn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    off            = new office();
                    off.OfficeID   = reader.GetString(0);
                    off.name       = reader.GetString(1);
                    off.RegionID   = reader.GetString(2);
                    off.RegionName = reader.GetString(3);
                    off.Address1   = reader.GetString(4);
                    off.Address2   = reader.GetString(5);
                    off.Address3   = reader.GetString(6);
                    off.Address4   = reader.GetString(7);
                    off.status     = reader.GetInt32(8);
                    Offices.Add(off);
                }
                conn.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Error querying Office Data");
            }
            return(Offices);
        }
示例#3
0
        public Boolean insertOffice(office off)
        {
            Boolean status   = true;
            string  utString = "";

            try
            {
                string updateSQL = "insert into Office (OfficeID,Name,RegionID,Address1,Address2,Address3,Address4,Status,CreateTime,CreateUser)" +
                                   "values (" +
                                   "'" + off.OfficeID + "'," +
                                   "'" + off.name + "'," +
                                   "'" + off.RegionID + "'," +
                                   "'" + off.Address1 + "'," +
                                   "'" + off.Address2 + "'," +
                                   "'" + off.Address3 + "'," +
                                   "'" + off.Address4 + "'," +
                                   off.status + "," +
                                   "GETDATE()" + "," +
                                   "'" + Login.userLoggedIn + "'" + ")";
                utString = utString + updateSQL + Main.QueryDelimiter;
                utString = utString +
                           ActivityLogDB.PrepareActivityLogQquerString("insert", "Office", "", updateSQL) +
                           Main.QueryDelimiter;
                if (!UpdateTable.UT(utString))
                {
                    status = false;
                }
            }
            catch (Exception)
            {
                status = false;
            }
            return(status);
        }
示例#4
0
        public Boolean validateOffice(office off)
        {
            Boolean status = true;

            try
            {
                if (off.OfficeID.Trim().Length == 0 || off.OfficeID == null)
                {
                    return(false);
                }
                if (off.RegionID.Trim().Length == 0 || off.RegionID == null)
                {
                    return(false);
                }
                if (off.name.Trim().Length == 0 || off.name == null)
                {
                    return(false);
                }
            }
            catch (Exception)
            {
            }
            return(status);
        }