public int Add(HtmlItem obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTHtmlItem;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterDetails = new SqlParameter(PN_DETAILS, SqlDbType.NVarChar);
parameterDetails.Value = obj.Details;
parameterDetails.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDetails);
SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Bit);
parameterIsDeleted.Value = obj.IsDeleted;
parameterIsDeleted.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsDeleted);
SqlParameter parameterHash = new SqlParameter(PN_HASH, SqlDbType.NVarChar);
parameterHash.Value = obj.Hash;
parameterHash.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterHash);
SqlParameter paramType = new SqlParameter(PN_TYPE, SqlDbType.Int);
paramType.Value = Convert.ToInt32(obj.Type);
paramType.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramType);
SqlParameter paramStatus = new SqlParameter(PN_STATUS, SqlDbType.Int);
paramStatus.Value = obj.Status;
paramStatus.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramStatus);
SqlParameter paramDate = new SqlParameter(PN_DATE, SqlDbType.NVarChar);
paramDate.Value = obj.Date;
paramDate.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramDate);
SqlParameter paramlangID = new SqlParameter(PN_LANGUAGE_ID, SqlDbType.Int);
paramlangID.Value = obj.LanguageID;
paramlangID.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramlangID);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
public void PopulateHtmlItem(SqlDataReader _dtr, HtmlItem obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_DETAILS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Details = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_HASH);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Hash = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_DATE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Date = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_STATUS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Status = (RootEnums.HtmlBlockStatus)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_TYPE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (RootEnums.HtmlBlockType)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(HtmlItemDataMapper.CN_LANGUAGE_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.LanguageID = _dtr.GetInt32((columnIndex));
}
}
public static void Update(HtmlItem obj)
{
HtmlItemDataMapper objCaller = new HtmlItemDataMapper();
objCaller.Update(obj);
}
public static int Add(HtmlItem obj)
{
HtmlItemDataMapper objCaller = new HtmlItemDataMapper();
return objCaller.Add(obj);
}
private void EditMode()
{
if (ObjectID > 0)
{
HtmlItem cat = new HtmlItem();
cat = HtmlItemManager.GetByID(ObjectID);
if (null == cat)
return;
txtName.Text = cat.Name;
txtHash.Text = cat.Hash;
txtDetails.Text = cat.Details;
plcControls.Visible = true;
}
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
HtmlItem html = new HtmlItem();
if (ObjectID <= 0)
{
try
{
html.IsDeleted = false;
html.Name = txtName.Text;
html.Details = (txtDetails.Text);
html.Hash = txtHash.Text;
html.Type = DataLayer.Enums.RootEnums.HtmlBlockType.HTML;
html.Status = DataLayer.Enums.RootEnums.HtmlBlockStatus.Visible;
html.Date = DateTime.Now.ToString("dd/MM/yyyy");
HtmlItemManager.Add(html);
AddMode();
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
html = HtmlItemManager.GetByID(ObjectID);
if (null == html)
{
dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures);
return;
}
html.IsDeleted = false;
html.Name = txtName.Text;
html.Details = (txtDetails.Text);
html.Hash = txtHash.Text;
html.Type = DataLayer.Enums.RootEnums.HtmlBlockType.HTML;
html.Status = DataLayer.Enums.RootEnums.HtmlBlockStatus.Visible;
html.Date = DateTime.Now.ToString("dd/MM/yyyy");
HtmlItemManager.Update(html);
EditMode();
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
}
private void EditMode()
{
if (ObjectID > 0)
{
HtmlItem cat = new HtmlItem();
cat = HtmlItemManager.GetByID(ObjectID);
if (null == cat)
return;
ddlStatus.SelectedValue = Convert.ToInt32(cat.Status).ToString();
txtName.Text = cat.Name;
txtHash.Text = cat.Hash;
txtDetails.Content = cat.Details;
plcControls.Visible = true;
}
}
public HtmlItem GetHtmlItem(SqlDataReader _dtr, IList<HtmlItem> colobj)
{
HtmlItem obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new HtmlItem();
colobj.Add(obj);
}
return obj;
}
public IList<HtmlItem> Search(string keyword)
{
HtmlItem obj = null;
IList<HtmlItem> colobj = new List<HtmlItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "[usp_SearchHtmlItem]";
#region [Parameters]
SqlParameter parameterhash = new SqlParameter("Keyword", SqlDbType.NVarChar);
parameterhash.Value = keyword;
parameterhash.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterhash);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new HtmlItem();
colobj = new List<HtmlItem>();
while (_dtreader.Read())
{
obj = GetHtmlItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<HtmlItem> GetAll()
{
HtmlItem obj = null;
IList<HtmlItem> colobj = new List<HtmlItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLHtmlItem;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new HtmlItem();
colobj = new List<HtmlItem>();
while (_dtreader.Read())
{
obj = GetHtmlItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, HtmlItem obj)
{
PopulateHtmlItem(_dtr, obj);
}
public HtmlItem GetByHashNameandLangID(string hashName, int langid)
{
HtmlItem obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "usp_SelectHtmlItemByHashNameandLangID";
#region [Parameters]
SqlParameter parameterhash = new SqlParameter(PN_HASH, SqlDbType.NVarChar);
parameterhash.Value = hashName;
parameterhash.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterhash);
SqlParameter paramlang = new SqlParameter(PN_LANGUAGE_ID, SqlDbType.Int);
paramlang.Value = langid;
paramlang.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramlang);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new HtmlItem();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
public HtmlItem GetByID(int ID)
{
HtmlItem obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTHtmlItem;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new HtmlItem();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}