public bool UpdateHomePageConfig(HomePageConfiguation model)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.UpdateHomePageConfig(conn, model));
}
}
public bool UpdateHomePageConfig(SqlConnection conn, HomePageConfiguation model)
{
string sql = @" UPDATE Configuration.dbo.LightAppHomePageConfig
SET Name = @Name ,
LastUpdateDateTime = GETDATE()
WHERE ID = @ID;";
return(conn.Execute(sql, model) > 0);
}
public bool AddHomePageConfig(SqlConnection conn, HomePageConfiguation model)
{
string sql = @"INSERT INTO Configuration.dbo.LightAppHomePageConfig
( Name ,
KeyValue,
CreateDateTime ,
LastUpdateDateTime
)
VALUES ( @Name , -- Name - nvarchar(64)
@KeyValue,
GETDATE() , -- CreateDateTime - datetime
GETDATE() -- LastUpdateDateTime - datetime
)";
return(conn.Execute(sql, model) > 0);
}
