public IEnumerable <CMSProduct> GetProductCMS(string product) { List <CMSProduct> products = new List <CMSProduct>(); using (SqlConnection con = new SqlConnection(getConnectionStringFromSettings())) { try { con.Open(); string qryGetUsers = "SELECT ProductID_CMS, ProductName_CMS, DockSpotTimeslotDuration FROM dbo.ProductsCMS WHERE ProductID_CMS = @prod"; using (SqlCommand command = new SqlCommand(qryGetUsers, con)) { command.Parameters.Add(new SqlParameter("@prod", product)); SqlDataReader sReader = command.ExecuteReader(); while (sReader.Read()) { products.Add(CMSProduct.adaptToProductCMS(sReader)); } } } catch (Exception ex) { string strErr = " Exception Error in DataProvider GetProductCMS(). Details: " + ex.ToString(); MessageLog alog = new MessageLog(MessageType.Exception, "GetProductCMS Exception Message=" + strErr); logger.Error(alog.CreateAuditLogMessage()); throw; } } return(products); }
public static CMSProduct adaptToProductCMS(IDataRecord record) { CMSProduct cmsProduct = new CMSProduct(); cmsProduct.ProductID_CMS = record["ProductID_CMS"].ToString(); cmsProduct.ProductName_CMS = record["ProductName_CMS"].ToString(); cmsProduct.DockSpotTimeslotDuration = (int)record["DockSpotTimeslotDuration"]; return(cmsProduct); }