public virtual SystemProcess UpdateSystemProcess(SystemProcess entity)
{
if (entity.IsTransient()) return entity;
SystemProcess other = GetSystemProcess(entity.SystemProcessId);
if (entity.Equals(other)) return entity;
string sql=@"Update SystemProcess set [Name]=@Name
, [Description]=@Description
, [Enabled]=@Enabled
, [DisplayOrder]=@DisplayOrder
, [Ip]=@Ip
, [Port]=@Port
where SystemProcessID=@SystemProcessID";
SqlParameter[] parameterArray=new SqlParameter[]{
new SqlParameter("@Name",entity.Name)
, new SqlParameter("@Description",entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Enabled",entity.Enabled)
, new SqlParameter("@DisplayOrder",entity.DisplayOrder)
, new SqlParameter("@Ip",entity.Ip ?? (object)DBNull.Value)
, new SqlParameter("@Port",entity.Port ?? (object)DBNull.Value)
, new SqlParameter("@SystemProcessID",entity.SystemProcessId)};
SqlHelper.ExecuteNonQuery(this.ConnectionString,CommandType.Text,sql,parameterArray);
return GetSystemProcess(entity.SystemProcessId);
}
public virtual SystemProcess InsertSystemProcess(SystemProcess entity)
{
SystemProcess other=new SystemProcess();
other = entity;
if(entity.IsTransient())
{
string sql=@"Insert into SystemProcess ( [Name]
,[Description]
,[Enabled]
,[DisplayOrder]
,[Ip]
,[Port] )
Values
( @Name
, @Description
, @Enabled
, @DisplayOrder
, @Ip
, @Port );
Select scope_identity()";
SqlParameter[] parameterArray=new SqlParameter[]{
new SqlParameter("@Name",entity.Name)
, new SqlParameter("@Description",entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Enabled",entity.Enabled)
, new SqlParameter("@DisplayOrder",entity.DisplayOrder)
, new SqlParameter("@Ip",entity.Ip ?? (object)DBNull.Value)
, new SqlParameter("@Port",entity.Port ?? (object)DBNull.Value)};
var identity=SqlHelper.ExecuteScalar(this.ConnectionString,CommandType.Text,sql,parameterArray);
if(identity==DBNull.Value) throw new DataException("Identity column was null as a result of the insert operation.");
return GetSystemProcess(Convert.ToInt32(identity));
}
return entity;
}