コード例 #1
0
        /// <summary>
        /// Get list of product status in application
        /// </summary>
        /// <param name="sessionKey">string</param>
        /// <returns>ResponseObjectForAnything</returns>
        public ResponseObjectForAnything GetProductStatusList(string sessionKey)
        {
            List<ProductStatus> productstatuslist = new List<ProductStatus>();
            AuthenticationEngine authEngine = new AuthenticationEngine();
            bool isValid = authEngine.IsValidSession(sessionKey);
            ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
            int count = 0;

            try
            {
                if (isValid)
                {
                    Database db = DatabaseFactory.CreateDatabase();
                    DbCommand dbCommand = db.GetStoredProcCommand("usp_GetProductStatus");

                    using (IDataReader dr = db.ExecuteReader(dbCommand))
                    {
                        while (dr.Read())
                        {
                            ProductStatus productstatus = new ProductStatus();
                            if (dr["ProductStatusID"] != DBNull.Value) { productstatus.ProductStatusID = Convert.ToInt32(dr["ProductStatusID"]); }
                            if (dr["ProductStatusName"] != DBNull.Value) { productstatus.ProductStatusName = dr["ProductStatusName"].ToString(); }
                            productstatuslist.Add(productstatus);
                            count++;
                        }
                    }
                    responseObject.ResultCode = "SUCCESS";
                    responseObject.ResultObjectJSON = Serializer.ObjectToJSON(productstatuslist);
                    responseObject.ResultObjectRecordCount = count;
                    if (responseObject.ResultObjectRecordCount == 0) { responseObject.ResultMessage = "No product statuses configured."; }
                }
            }
            catch (Exception ex)
            {
                responseObject.ResultCode = "ERROR";
                responseObject.ResultMessage = ex.Message;
                CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetProductStatus", System.DateTime.Now);
                ExceptionManager.PublishException(exc);
            }
            return (responseObject);
        }
コード例 #2
0
        /// <summary>
        /// Get master list of dropdowns for create problem page.
        /// </summary>
        /// <param name="sessionkey">string</param>
        /// <returns>string</returns>
        public ResponseObjectForAnything GetDropDownItems(string sessionkey)
        {
            List<Company> lstcompany = new List<Company>();
            List<Category> lstcategory = new List<Category>();
            List<Country> lstcountry = new List<Country>();
            List<ProductStatus> lstproductstatus = new List<ProductStatus>();
            List<ResolutionMethod> lstresolutionmethod = new List<ResolutionMethod>();
            CreateProblemObject createproblemobj = new CreateProblemObject();
            AuthenticationEngine authEngine = new AuthenticationEngine();
            bool isValid = authEngine.IsValidSession(sessionkey);
            int count = 0;
            ResponseObjectForAnything responseObject = new ResponseObjectForAnything();

            try
            {
                if (isValid)
                {
                    Database db = DatabaseFactory.CreateDatabase();
                    DbCommand dbCommand = db.GetStoredProcCommand("usp_GetDropDownItems");
                    db.AddInParameter(dbCommand, "SessionKey", DbType.String, sessionkey);

                    DataSet dsDropdowns = db.ExecuteDataSet(dbCommand);
                    if(dsDropdowns.Tables.Count > 0)
                    {
                        DataTable tDropDowns = dsDropdowns.Tables[0];
                        foreach(DataRow dr in tDropDowns.Rows)
                        {
                            Company company = new Company();
                            if (dr["CompanyID"] != DBNull.Value) { company.CompanyID = Convert.ToInt32(dr["CompanyID"]); }
                            if (dr["CompanyName"] != DBNull.Value) { company.CompanyName = dr["CompanyName"].ToString(); }
                            lstcompany.Add(company);
                            count++;
                        }
                        createproblemobj.companies = lstcompany;
                    }
                    if (dsDropdowns.Tables.Count > 1)
                    {
                        DataTable tDropDowns = dsDropdowns.Tables[1];
                        foreach (DataRow dr in tDropDowns.Rows)
                        {
                            Category category = new Category();
                            if (dr["ID"] != DBNull.Value) { category.ID = Convert.ToInt32(dr["ID"]); }
                            if (dr["Name"] != DBNull.Value) { category.Name = dr["Name"].ToString(); }
                            lstcategory.Add(category);
                            count++;
                        }
                        createproblemobj.categories = lstcategory;
                    }
                    if (dsDropdowns.Tables.Count > 2)
                    {
                        DataTable tDropDowns = dsDropdowns.Tables[2];
                        foreach (DataRow dr in tDropDowns.Rows)
                        {
                            ProductStatus productstatus = new ProductStatus();
                            if (dr["ProductStatusID"] != DBNull.Value) { productstatus.ProductStatusID = Convert.ToInt32(dr["ProductStatusID"]); }
                            if (dr["ProductStatusName"] != DBNull.Value) { productstatus.ProductStatusName = dr["ProductStatusName"].ToString(); }
                            lstproductstatus.Add(productstatus);
                            count++;
                        }
                        createproblemobj.productstatuses = lstproductstatus;
                    }
                    if (dsDropdowns.Tables.Count > 3)
                    {
                        DataTable tDropDowns = dsDropdowns.Tables[3];
                        foreach (DataRow dr in tDropDowns.Rows)
                        {
                            Country country = new Country();
                            if (dr["CountryID"] != DBNull.Value) { country.CountryID = Convert.ToInt32(dr["CountryID"]); }
                            if (dr["CountryName"] != DBNull.Value) { country.CountryName = dr["CountryName"].ToString(); }
                            if (dr["IsDefaulted"] != DBNull.Value) { country.IsDefaulted = Convert.ToBoolean(dr["IsDefaulted"].ToString()); }
                            lstcountry.Add(country);
                            count++;
                        }
                        createproblemobj.countries = lstcountry;
                    }
                    if (dsDropdowns.Tables.Count > 4)
                    {
                        DataTable tDropDowns = dsDropdowns.Tables[4];
                        foreach (DataRow dr in tDropDowns.Rows)
                        {
                            if (dr["PinCode"] != DBNull.Value) { createproblemobj.PinCode = dr["PinCode"].ToString(); }
                        }
                    }
                }
                responseObject.ResultCode = "SUCCESS";
                responseObject.ResultObjectJSON = Serializer.ObjectToJSON(createproblemobj);
                responseObject.ResultObjectRecordCount = count;
                if (responseObject.ResultObjectRecordCount == 0) { responseObject.ResultMessage = "No master items configured."; }
            }
            catch (Exception ex)
            {
                responseObject.ResultCode = "ERROR";
                responseObject.ResultMessage = ex.Message;
                CustomException exc = new CustomException(ex.ToString(), this.ToString(), "GetDropDownItems", System.DateTime.Now);
                ExceptionManager.PublishException(exc);
            }
            return (responseObject);
        }