public bool InsertGroupTemplate(Common.GroupTemplate groupTemplate) { try { DataTable dataTableGroupTemplate = base.FetchDataTable("SELECT COUNT(*) AS [Count] FROM [GroupTemplates] WHERE [Title] = @Title AND [UserGuid] = @UserGuid", "@Title", groupTemplate.Title, "@UserGuid", groupTemplate.UserGuid); if (Helper.GetInt(dataTableGroupTemplate.Rows[0]["Count"]) == 0) { return(base.Insert(groupTemplate) != Guid.Empty ? true : false); } else { throw new Exception(Language.GetString("DuplicateTitleGroupTemplate")); } } catch (Exception ex) { throw ex; } }
public bool UpdateGroupTemplate(Common.GroupTemplate groupTemplate) { try { DataTable dataTableGroupTemplate = base.FetchDataTable(@"SELECT COUNT(*) AS [Count] FROM [GroupTemplates] WHERE [Title] = @Title AND [Guid] != @Guid AND [UserGuid] = @UserGuid" , "@Title", groupTemplate.Title, "@Guid", groupTemplate.GroupTemplateGuid, "@UserGuid", groupTemplate.UserGuid); if (Helper.GetInt(dataTableGroupTemplate.Rows[0]["Count"]) == 0) { return(base.ExecuteSPCommand("UpdateGroupTemplate", "Guid", groupTemplate.GroupTemplateGuid, "Title", groupTemplate.Title)); } else { throw new Exception(Language.GetString("DuplicateTitleGroupTemplate")); } } catch (Exception ex) { throw ex; } }