public List<GetDashboardObject> GetDashBoardsInfo(int? dashboardId, bool? active) { List<GetDashboardObject> lDBObjects = new List<GetDashboardObject>(); SqlDataReader oReader; try { using (SqlCommand oComm = new SqlCommand()) { if (Sqlconn.State == ConnectionState.Closed) Sqlconn.Open(); oComm.Connection = Sqlconn; oComm.CommandType = CommandType.StoredProcedure; oComm.CommandText = "DashBoard.GetDashBoardInfo"; SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int); pDashBoardID.Value = dashboardId; oComm.Parameters.Add(pDashBoardID); SqlParameter pActive = new SqlParameter("@ACTIVE", SqlDbType.Bit); pActive.Value = active; oComm.Parameters.Add(pActive); oReader = oComm.ExecuteReader(); while (oReader.Read()) { GetDashboardObject dbObject = new GetDashboardObject() { id = (int)oReader["dsb_id"] , usercode = oReader["dsb_userCode"].ToString() , numrow = (int)oReader["dsb_rowsNum"] , date = oReader["dsb_date"] != DBNull.Value ? oReader["dsb_date"].ToString() : string.Empty, active = (bool)oReader["dsb_active"] }; lDBObjects.Add(dbObject); } } } catch (Exception ex) { throw ex; } finally { if (Sqlconn.State == ConnectionState.Open) Sqlconn.Close(); } return lDBObjects; }
public int CreateDashBoard(GetDashboardObject PostDataArrived) { int idDBRet; string locales = "", values = ""; foreach (TextLocalised txt in PostDataArrived.text) { locales += txt.locale + "|"; values += txt.title + "|"; } locales = locales.Substring(0, locales.Length - 1); values = values.Substring(0, values.Length - 1); try { using (SqlCommand oComm = new SqlCommand()) { if (Sqlconn.State == ConnectionState.Closed) Sqlconn.Open(); oComm.Connection = Sqlconn; oComm.CommandType = CommandType.StoredProcedure; oComm.CommandText = "DashBoard.Create"; SqlParameter pUserCode = new SqlParameter("@USERCODE", SqlDbType.NVarChar, 255); pUserCode.Value = PostDataArrived.usercode; oComm.Parameters.Add(pUserCode); SqlParameter pRowNum = new SqlParameter("@ROWNUM", SqlDbType.Int); pRowNum.Value = PostDataArrived.numrow; oComm.Parameters.Add(pRowNum); SqlParameter pLocales = new SqlParameter("@LOCALES", SqlDbType.VarChar, 2000); pLocales.Value = locales; oComm.Parameters.Add(pLocales); SqlParameter pValues = new SqlParameter("@VALUES", SqlDbType.VarChar, 5000); pValues.Value = values; oComm.Parameters.Add(pValues); SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int); pDashBoardID.Direction = ParameterDirection.Output; oComm.Parameters.Add(pDashBoardID); oComm.ExecuteNonQuery(); idDBRet = (int)pDashBoardID.Value; } } catch (Exception ex) { throw ex; } finally { if (Sqlconn.State == ConnectionState.Open) Sqlconn.Close(); } return idDBRet; }