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;
}
