private void FillObject(Business.Registration item, SqlDataReader sqlReader)
{
if (item != null)
{
item.ID = sqlReader["NRE_ID"].ToString();
item.CurrentUserID = sqlReader["NUS_USR_ID"].ToString().ToGuid();
item.IsGlobal = (bool)sqlReader["NRE_IsGlobal"];
if (sqlReader["NRE_ObjectID"] != DBNull.Value && !string.IsNullOrEmpty(sqlReader["NRE_ObjectID"].ToString()))
{
item.ObjectID = sqlReader["NRE_ObjectID"].ToString().ToGuid();
}
if (sqlReader["NRE_UserID"] != DBNull.Value && !string.IsNullOrEmpty(sqlReader["NRE_UserID"].ToString()))
{
item.UserID = sqlReader["NRE_UserID"].ToString().ToGuid();
}
if (sqlReader["NRE_CommunityID"] != DBNull.Value && !string.IsNullOrEmpty(sqlReader["NRE_CommunityID"].ToString()))
{
item.CommunityID = sqlReader["NRE_CommunityID"].ToString().ToGuid();
}
item.Title = sqlReader["NRE_Title"].ToString();
Business.Carrier objCarrier = item.Carriers.Item((CarrierType)Convert.ToInt32(sqlReader["NRE_Carrier"]));
if (objCarrier != null)
{
objCarrier.Checked = true;
objCarrier.Collect = (CarrierCollect)Convert.ToInt32(sqlReader["NRE_CarrierCollect"]);
objCarrier.CollectValue = int.Parse(sqlReader["NRE_CollectValue"].ToString());
}
}
}
private void FillObjectTagWords(Business.Registration item, SqlDataReader sqlReader)
{
if (item != null)
{
item.TagWords.Add(new Business.TagWord()
{
TagID = sqlReader["TGW_ID"].ToString(), GroupID = (int)sqlReader["NET_TagWordGroup"]
});
}
}
private void FillObjectTypes(Business.Registration item, SqlDataReader sqlReader)
{
if (item != null)
{
int objectType = Convert.ToInt32(sqlReader["OBJ_Type"]);
item.ObjectTypeList.Add(new _4screen.CSB.Notification.Business.ObjType(item.ObjectTypeList, objectType)
{
Availably = true, Checked = true, Identifier = objectType
});
}
}
private Business.Registration CopyConfig(Business.Configuration itemConfig, Business.RegistrationList list, bool global)
{
Business.Role itemRole = itemConfig.FindRole(list.CurrentRoles);
if (itemRole == null)
{
return(null);
}
Business.Registration itemReg = new Business.Registration(list.CurrentUser.UserID);
itemReg.Identifier = itemConfig.Identifier;
itemReg.IsGlobal = global;
foreach (CarrierType soll in itemRole.CarrierTypes)
{
Business.Carrier itemCarr = new Business.Carrier(itemReg.Carriers);
itemCarr.Type = soll;
itemCarr.Availably = list.CurrentUser.Carriers.Item(soll).IsValid;
itemReg.Carriers.Add(itemCarr);
}
foreach (Business.ObjType itemObjectType in itemConfig.ObjTypes)
{
Business.ObjType objType = new Business.ObjType(itemReg.ObjectTypeList, itemObjectType.Identifier);
if (!itemConfig.IsObjectTypeAvailably(itemObjectType.Identifier, global))
{
objType.Availably = false;
}
/*else if (!global && objectType.IndexOf(string.Format(",{0},", (int)itemObjectType.Identifier)) == -1)
* objType.Availably = false;*/
itemReg.ObjectTypeList.Add(objType);
}
itemReg.ObjectTypeList.SetChecked(itemReg.ObjectTypeList.GetChecked());
return(itemReg);
}
public void Save(Business.Registration item)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
try
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "hisp_Notification_RegisteredEvent_Update";
if (string.IsNullOrEmpty(item.ID))
{
item.ID = Guid.NewGuid().ToString();
}
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@NRE_ID", SqlDbType.UniqueIdentifier, new Guid(item.ID)));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@USR_ID", SqlDbType.UniqueIdentifier, item.CurrentUserID));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@Identifier", SqlDbType.Int, (int)item.Identifier));
if (item.ObjectID.HasValue)
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@ObjectID", SqlDbType.UniqueIdentifier, item.ObjectID.Value));
}
else
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@ObjectID", SqlDbType.UniqueIdentifier));
}
if (item.UserID.HasValue)
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@UserID", SqlDbType.UniqueIdentifier, item.ObjectID.Value));
}
else
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@UserID", SqlDbType.UniqueIdentifier));
}
if (item.CommunityID.HasValue)
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CommunityID", SqlDbType.UniqueIdentifier, item.ObjectID.Value));
}
else
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CommunityID", SqlDbType.UniqueIdentifier));
}
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@IsGlobal", SqlDbType.Bit, item.IsGlobal ? 1 : 0));
if (!string.IsNullOrEmpty(item.Title))
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@Title", SqlDbType.NVarChar, item.Title));
}
else
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@Title", SqlDbType.NVarChar));
}
Business.Carrier objCarrier = item.Carriers.CheckedCarrier();
if (objCarrier != null && objCarrier.Type != CarrierType.None)
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@Carrier", SqlDbType.Int, (int)objCarrier.Type));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CarrierCollect", SqlDbType.Int, (int)objCarrier.Collect));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CollectValue", SqlDbType.Int, (int)objCarrier.CollectValue));
}
else
{
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@Carrier", SqlDbType.Int, 0));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CarrierCollect", SqlDbType.Int, 0));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@CollectValue", SqlDbType.Int, 0));
}
DateTime datNext;
if (objCarrier.Collect == CarrierCollect.Daily)
{
datNext = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day).AddDays(1);
}
else if (objCarrier.Collect == CarrierCollect.Weekly)
{
int days = (int)DateTime.Now.DayOfWeek;
datNext = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day).AddDays(7 - days);
}
else if (objCarrier.Collect == CarrierCollect.Monthly)
{
datNext = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1);
}
else
{
datNext = new DateTime(1900, 1, 1);
}
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@NextSend", SqlDbType.DateTime, datNext));
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
if (objCarrier != null && objCarrier.Type != CarrierType.None)
{
foreach (Business.ObjType objectTypeItem in item.ObjectTypeList.GetEnumeratorOnlyAvailably)
{
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "hisp_Notification_RegisteredEventObjectType_Update";
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@NRE_ID", SqlDbType.UniqueIdentifier, new Guid(item.ID)));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@OBJ_Type", SqlDbType.Int, (int)objectTypeItem.Identifier));
sqlCommand.ExecuteNonQuery();
}
foreach (Business.TagWord tagWord in item.TagWords)
{
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "hisp_Notification_RegisteredEventTagWord_Update";
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@NRE_ID", SqlDbType.UniqueIdentifier, new Guid(item.ID)));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@TGW_ID", SqlDbType.UniqueIdentifier, new Guid(tagWord.TagID)));
sqlCommand.Parameters.Add(SqlHelper.AddParameter("@NET_TagWordGroup", SqlDbType.Int, tagWord.GroupID));
sqlCommand.ExecuteNonQuery();
}
}
}
finally
{
sqlConnection.Close();
}
}
