public static void Add(string userID, MessageGroupTypes groupType, string title) { MessageGroup item = new MessageGroup(userID, groupType, -1, title, 0); Data.MessageGroup objData = new Data.MessageGroup(); objData.Save(item); }
public bool Exist(string userID, MessageGroupTypes groupType, string title) { SqlConnection Conn = new SqlConnection(strConn); try { SqlCommand GetData = new SqlCommand(); GetData.Connection = Conn; GetData.CommandType = CommandType.StoredProcedure; GetData.CommandText = "hisp_UserMessagesGroup_Exist"; GetData.Parameters.Add(SqlHelper.AddParameter("@ASP_UserId", SqlDbType.UniqueIdentifier, new Guid(userID))); GetData.Parameters.Add(SqlHelper.AddParameter("@MGR_Type", SqlDbType.Int, (int)groupType)); GetData.Parameters.Add(SqlHelper.AddParameter("@MGR_Title", SqlDbType.NVarChar, title)); Conn.Open(); if (GetData.ExecuteScalar().ToString() == "1") { return(true); } else { return(false); } } finally { Conn.Close(); } }
public void Load(List <Business.MessageGroup> list, string userID, MessageGroupTypes groupType, bool withCount) { SqlConnection Conn = new SqlConnection(strConn); try { SqlCommand GetData = new SqlCommand(); GetData.Connection = Conn; GetData.CommandType = CommandType.StoredProcedure; GetData.CommandText = "hisp_UserMessagesGroup_Load"; GetData.Parameters.Add(SqlHelper.AddParameter("@ASP_UserId", SqlDbType.UniqueIdentifier, new Guid(userID))); GetData.Parameters.Add(SqlHelper.AddParameter("@MGR_Type", SqlDbType.Int, (int)groupType)); Conn.Open(); SqlDataReader sqlReader = GetData.ExecuteReader(CommandBehavior.CloseConnection); while (sqlReader.Read()) { Business.MessageGroup item = new Business.MessageGroup(sqlReader["ASP_UserId"].ToString(), (MessageGroupTypes)int.Parse(sqlReader["MGR_Type"].ToString()), int.Parse(sqlReader["MGR_GroupId"].ToString()), sqlReader["MGR_Title"].ToString(), 0); list.Add(item); } sqlReader.Close(); } finally { if (Conn != null && Conn.State != ConnectionState.Closed) { Conn.Close(); } } }
internal MessageGroup(string userID, MessageGroupTypes groupType, int groupID, string title, int count) { strUserID = userID; enuGroupType = groupType; intGroupID = groupID; strTitle = title; blnDirty = false; intCount = count; }
public static void Delete(string userID, MessageGroupTypes groupType, int groupID) { if (groupID == 0) { return; } Data.MessageGroup objData = new Data.MessageGroup(); objData.Delete(userID, groupType, groupID); }
public void Update(string userID, MessageGroupTypes groupType) { if (intGroupID == 0) { return; } Data.MessageGroup objData = new Data.MessageGroup(); objData.Save(this); }
public static bool Exist(string userID, MessageGroupTypes groupType, string title) { if (title.ToLower().Trim() == groupType.ToString().ToLower()) { return(true); } Data.MessageGroup objData = new Data.MessageGroup(); return(objData.Exist(userID, groupType, title)); }
public static List <MessageGroup> Load(string userID, MessageGroupTypes groupType) { List <MessageGroup> list = new List <MessageGroup>(); list.Add(new MessageGroup(userID, groupType, 0, groupType.ToString(), 0)); Data.MessageGroup objData = new Data.MessageGroup(); objData.Load(list, userID, groupType, false); return(list); }
public static List <MessageGroup> LoadWithCount(string userID, MessageGroupTypes groupType) { List <MessageGroup> list = new List <MessageGroup>(); list.Add(new MessageGroup(userID, groupType, 0, "Default", 0)); Data.MessageGroup objData = new Data.MessageGroup(); objData.Load(list, userID, groupType, true); return(list); }
public void Delete(string userID, MessageGroupTypes groupType, int groupID) { SqlConnection Conn = new SqlConnection(strConn); try { SqlCommand GetData = new SqlCommand(); GetData.Connection = Conn; GetData.CommandType = CommandType.StoredProcedure; GetData.CommandText = "hisp_UserMessagesGroup_Delete"; GetData.Parameters.Add(SqlHelper.AddParameter("@ASP_UserId", SqlDbType.UniqueIdentifier, new Guid(userID))); GetData.Parameters.Add(SqlHelper.AddParameter("@MGR_Type", SqlDbType.Int, (int)groupType)); GetData.Parameters.Add(SqlHelper.AddParameter("@MGR_GroupId", SqlDbType.Int, (int)groupID)); Conn.Open(); GetData.ExecuteNonQuery(); } finally { Conn.Close(); } }
public static void SetGroup(string msgID, MessageGroupTypes groupType, int groupID) { CSBooster_DataContext wdc = new CSBooster_DataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString); wdc.hisp_UserMessages_SetGroup(new Guid(msgID), (int)groupType, groupID); }
public static void SetGroup(string msgID, MessageGroupTypes groupType, int groupID) { CSBooster_DataContext wdc = new CSBooster_DataContext(Helper.GetSiemeConnectionString()); wdc.hisp_UserMessages_SetGroup(new Guid(msgID), (int)groupType, groupID); }