Beispiel #1
0
        /// <summary>
        /// Delete Manufacturer having supplied Member ID
        /// </summary>
        /// <param name="vobjManufacturer">Manufacturer Data Object having Manufacturer ID</param>
        public void Delete(ref Manufacturer vobjManufacturer)
        {
            DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_DeleteManufacturer");
            dBase.AddInParameter(objCmd, "@ManufacturerID", DbType.Int32, vobjManufacturer.ManufacturerID);
            dBase.AddOutParameter(objCmd, "@MessageID", DbType.Int32, 4);
            dBase.AddOutParameter(objCmd, "@Message", DbType.String, 255);
            dBase.ExecuteNonQuery(objCmd);

            vobjManufacturer.ReturnValue = (int)dBase.GetParameterValue(objCmd, "@MessageID");
            vobjManufacturer.ReturnMessage = (string)dBase.GetParameterValue(objCmd, "@Message");
            
         }
Beispiel #2
0
        public void Delete(ref Manufacturer vobjManufacturer)
        {
            try
            {
                new ManufacturerDB().Delete(ref vobjManufacturer);
            }
            catch (Exception ex)
            {

                //TODO: Handle exception;
            }
        }
Beispiel #3
0
        public void Add(ref Manufacturer vobjManufacturer)
        {
            try
            {
                new ManufacturerDB().Add(ref vobjManufacturer);
            }
            catch (Exception ex)
            {
                
                //TODO: Handle exception
            }

        }
Beispiel #4
0
        /// <summary>
        /// Adds Manufacturer in the Database
        /// </summary>
        /// <param name="vobjManufacturer">Manufacturer Data Object</param>
        public void Add(ref Manufacturer vobjManufacturer)
        {
            DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_InsertManufacturer");
            dBase.AddInParameter(objCmd, "@CompanyName", DbType.String, vobjManufacturer.CompanyName);
            dBase.AddInParameter(objCmd, "@ContactFirstName", DbType.String, vobjManufacturer.ContactFirstName);
            dBase.AddInParameter(objCmd, "@ContactLastName", DbType.String, vobjManufacturer.ContactLastName);
            dBase.AddInParameter(objCmd, "@Address", DbType.String, vobjManufacturer.Address);
            dBase.AddInParameter(objCmd, "@ZIP", DbType.String, vobjManufacturer.ZIP);
            dBase.AddInParameter(objCmd, "@City", DbType.String, vobjManufacturer.City);
            dBase.AddInParameter(objCmd, "@Country", DbType.String, vobjManufacturer.Country);
            dBase.AddInParameter(objCmd, "@Phone", DbType.String, vobjManufacturer.Phone);
            dBase.AddInParameter(objCmd, "@Email", DbType.String, vobjManufacturer.Email);
            dBase.AddInParameter(objCmd, "@CreatedBy", DbType.Int32, vobjManufacturer.CreatedBy);
            dBase.AddOutParameter(objCmd, "@MessageID", DbType.Int32, 4);
            dBase.AddOutParameter(objCmd, "@Message", DbType.String, 255);
            dBase.ExecuteNonQuery(objCmd);

            vobjManufacturer.ReturnValue = (int)dBase.GetParameterValue(objCmd, "@MessageID");
            vobjManufacturer.ReturnMessage = (string)dBase.GetParameterValue(objCmd, "@Message");

        }
Beispiel #5
0
        /// <summary>
        /// Returns Manufacturer details of supplied Manufacturer id
        /// </summary>
        /// <param name="vobjManufacturer">Manufacturer Data Object</param>
        public void GetByID(ref Manufacturer vobjManufacturer)
        {
            object[] mParams = {
                                    new SqlParameter("@ManufacturerID", SqlDbType.Int)
                                };
            mParams[0] = vobjManufacturer.ManufacturerID;
            using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetManufacturerByID", mParams))
            {

                while (reader.Read())
                {
                   
                    if (reader["CompanyName"] != DBNull.Value)
                        vobjManufacturer.CompanyName = Convert.ToString(reader["CompanyName"]);

                    if (reader["ContactFirstName"] != DBNull.Value)
                        vobjManufacturer.ContactFirstName = Convert.ToString(reader["ContactFirstName"]);

                    if (reader["ContactLastName"] != DBNull.Value)
                        vobjManufacturer.ContactLastName = Convert.ToString(reader["ContactLastName"]);

                    if (reader["Address"] != DBNull.Value)
                        vobjManufacturer.Address = Convert.ToString(reader["Address"]);

                    if (reader["ZIP"] != DBNull.Value)
                        vobjManufacturer.ZIP = Convert.ToString(reader["ZIP"]);

                    if (reader["City"] != DBNull.Value)
                        vobjManufacturer.City = Convert.ToString(reader["City"]);

                    if (reader["Country"] != DBNull.Value)
                        vobjManufacturer.Country = Convert.ToString(reader["Country"]);

                    if (reader["Phone"] != DBNull.Value)
                        vobjManufacturer.Phone = Convert.ToString(reader["Phone"]);

                    if (reader["Email"] != DBNull.Value)
                        vobjManufacturer.Email = Convert.ToString(reader["Email"]);

                    if (reader["IsActive"] != DBNull.Value)
                        vobjManufacturer.IsActive = Convert.ToBoolean(reader["IsActive"].ToString());
                }

            }
        }
Beispiel #6
0
        public List<Manufacturer> GetAllActive()
        {
            object[] mParams = { };


            List<Manufacturer> lstManufacturer = new List<Manufacturer>();
            using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetAllActiveManufacturer", mParams))
            {
                while (reader.Read())
                {
                    Manufacturer objManufacturer = new Manufacturer();

                    if (reader["ManufacturerID"] != DBNull.Value)
                        objManufacturer.ManufacturerID = Convert.ToInt32(reader["ManufacturerID"]);

                    if (reader["CompanyName"] != DBNull.Value)
                        objManufacturer.CompanyName = Convert.ToString(reader["CompanyName"]);

                    lstManufacturer.Add(objManufacturer);
                }
            }
            return lstManufacturer;
        }
Beispiel #7
0
        /// <summary>
        /// Returns all the Manufacturer from Database
        /// </summary>
        /// <returns>Manufacturer collection</returns>
        public List<Manufacturer> GetAll(PageInfo vobjPageInfo)
        {
            object[] mParams = {
                                        new SqlParameter("@SortColumnName", SqlDbType.NVarChar),                                              
                                        new SqlParameter("@SortDirection", SqlDbType.NVarChar),
                                        new SqlParameter("@SearchText", SqlDbType.NVarChar)
                                };

            mParams[0] = vobjPageInfo.SortColumnName;
            mParams[1] = vobjPageInfo.SortDirection;
            mParams[2] = vobjPageInfo.SearchText;

            List<Manufacturer> lstManufacturer = new List<Manufacturer>();
            using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetAllManufacturer", mParams))
            {
                while (reader.Read())
                {
                    Manufacturer objManufacturer = new Manufacturer();

                    if (reader["ManufacturerID"] != DBNull.Value)
                        objManufacturer.ManufacturerID = Convert.ToInt32(reader["ManufacturerID"]);

                    if (reader["CompanyName"] != DBNull.Value)
                        objManufacturer.CompanyName = Convert.ToString(reader["CompanyName"]);

                    if (reader["ContactFirstName"] != DBNull.Value)
                        objManufacturer.ContactFirstName = Convert.ToString(reader["ContactFirstName"]);

                    if (reader["ContactLastName"] != DBNull.Value)
                        objManufacturer.ContactLastName = Convert.ToString(reader["ContactLastName"]);

                    if (reader["Address"] != DBNull.Value)
                        objManufacturer.Address = Convert.ToString(reader["Address"]);

                    if (reader["ZIP"] != DBNull.Value)
                        objManufacturer.ZIP = Convert.ToString(reader["ZIP"]);

                    if (reader["City"] != DBNull.Value)
                        objManufacturer.City = Convert.ToString(reader["City"]);

                    if (reader["Country"] != DBNull.Value)
                        objManufacturer.Country = Convert.ToString(reader["Country"]);

                    if (reader["Phone"] != DBNull.Value)
                        objManufacturer.Phone = Convert.ToString(reader["Phone"]);

                    if (reader["Email"] != DBNull.Value)
                        objManufacturer.Email = Convert.ToString(reader["Email"]);

                    if (reader["IsActive"] != DBNull.Value)
                        objManufacturer.IsActive = Convert.ToBoolean(reader["IsActive"].ToString());

                    lstManufacturer.Add(objManufacturer);

                }
            }
            return lstManufacturer;
        }