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