internal static int Add(IEntity entity)
{
Publish publishEntity = (Publish)(entity);
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_PUBLISH_ADD, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_PUBLISH_CREATED_BY, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = publishEntity.CreatedBy;
sqlCommand.Parameters.Add(sqlParameter);
double days = 0;
double seconds = 0;
CMSCoreHelper.GetDaySecondsNumber(publishEntity.FromDate, out days, out seconds);
sqlParameter = new SqlParameter(PN_PUBLISH_FROM_DAY, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)days;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_FROM_SEC, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)seconds;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Output;
sqlParameter.Value = 0;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_LANGUAGE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = publishEntity.LanguageID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_MODULE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = publishEntity.ModuleID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_OBJECT_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = publishEntity.ObjectID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_PORTAL_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = publishEntity.PortalID;
sqlCommand.Parameters.Add(sqlParameter);
days = 0;
seconds = 0;
CMSCoreHelper.GetDaySecondsNumber(publishEntity.ToDate, out days, out seconds);
sqlParameter = new SqlParameter(PN_PUBLISH_TO_DAY, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)days;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_TO_SEC, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)seconds;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PUBLISH_TYPE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)publishEntity.PublishType;
sqlCommand.Parameters.Add(sqlParameter);
try
{
sqlCommand.Connection.Open();
sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
if (sqlCommand.Parameters[PN_PUBLISH_ID].Value != DBNull.Value)
publishEntity.ID = Convert.ToInt32(sqlCommand.Parameters[PN_PUBLISH_ID].Value);
}
catch (Exception ex)
{
throw ex;
}
}
return publishEntity.ID;
}