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