public static ModelResult <int> UpdateStaticData(DTO.News.StaticData oStaticData) { var oResult = new ModelResult <int>(); using (var conn = new SqlConnection(DbConnection.ConnectionString)) { try { using (var cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_UpdateStaticData"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", oStaticData.Id); cmd.Parameters.AddWithValue("@Title", oStaticData.Title); cmd.Parameters.AddWithValue("@Data", oStaticData.Data); cmd.Parameters.AddWithValue("@Status", oStaticData.Status); cmd.Parameters.AddWithValue("@Icon", oStaticData.Icon); conn.Open(); oResult.Results = Convert.ToInt32(cmd.ExecuteScalar()); oResult.HasResult = true; } } catch { conn.Close(); throw; } return(oResult); } }
public static ModelResult <List <DTO.News.StaticData> > GetStaticData(DTO.News.StaticData oStaticData) { var oResult = new ModelResult <List <DTO.News.StaticData> >(); var conn = new SqlConnection(DbConnection.ConnectionString); try { using (conn) { using (var cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = @"select * from StaticData where 1=1 "; if (oStaticData.Type > 0) { cmd.CommandText += "and Type=@Type "; cmd.Parameters.AddWithValue("@Type", oStaticData.Type); } cmd.CommandText += " order by Id asc "; cmd.CommandType = CommandType.Text; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); var lstResult = new List <DTO.News.StaticData>(); if (reader.HasRows) { while (reader.Read()) { var objStaticData = new DTO.News.StaticData(); objStaticData.Id = Convert.ToInt32(reader["Id"]); objStaticData.Title = reader["Title"].ToString(); objStaticData.Data = reader["Data"].ToString(); objStaticData.Status = Convert.ToBoolean(reader["Status"].ToString()); objStaticData.Icon = reader["Icon"].ToString(); objStaticData.Type = Convert.ToInt32(reader["Type"].ToString()); lstResult.Add(objStaticData); } } if (lstResult.Count > 0) { oResult.HasResult = true; oResult.Results = lstResult; oResult.RowCount = lstResult.Count; } } } } finally { conn.Close(); } return(oResult); }