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