public static ModelResult <int> UpdatePageHdr(DTO.News.PagesHdr oPageHdr)
{
var oResult = new ModelResult <int>();
using (var conn = new SqlConnection(DbConnection.ConnectionString))
{
try
{
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_UpdatePagesHdr";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", oPageHdr.Id);
cmd.Parameters.AddWithValue("@Image", oPageHdr.Image);
conn.Open();
oResult.Results = Convert.ToInt32(cmd.ExecuteScalar());
oResult.HasResult = true;
}
}
catch
{
conn.Close();
throw;
}
return(oResult);
}
}
public static ModelResult <List <DTO.News.PagesHdr> > GetPagesHdr(DTO.News.PagesHdr oPageHdr)
{
var oResult = new ModelResult <List <DTO.News.PagesHdr> >();
var conn = new SqlConnection(DbConnection.ConnectionString);
try
{
using (conn)
{
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = @"select * from PagesHdr where 1=1 ";
if (oPageHdr.Id > 0)
{
cmd.CommandText += "and Id=@Id ";
cmd.Parameters.AddWithValue("@Id", oPageHdr.Id);
}
if (!string.IsNullOrEmpty(oPageHdr.Name))
{
cmd.CommandText += "and Name=@Name ";
cmd.Parameters.AddWithValue("@Name", oPageHdr.Name);
}
cmd.CommandText += " order by Id asc ";
cmd.CommandType = CommandType.Text;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
var lstResult = new List <DTO.News.PagesHdr>();
if (reader.HasRows)
{
while (reader.Read())
{
var objPageHdr = new DTO.News.PagesHdr();
objPageHdr.Id = Convert.ToInt32(reader["Id"]);
objPageHdr.Name = reader["PageName"].ToString();
objPageHdr.Image = reader["Image"].ToString();
lstResult.Add(objPageHdr);
}
}
if (lstResult.Count > 0)
{
oResult.HasResult = true;
oResult.Results = lstResult;
oResult.RowCount = lstResult.Count;
}
}
}
}
finally
{
conn.Close();
}
return(oResult);
}
