public virtual CustomerSession InsertCustomerSession(CustomerSession entity) { CustomerSession other = new CustomerSession(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into CustomerSession ( [CustomerID] ,[SessionName] ,[SessionValue] ,[ipaddr] ,[LastActivity] ,[LoggedOut] ,[CustomerSessionGUID] ,[CreatedOn] ,[ExpiresOn] ) Values ( @CustomerID , @SessionName , @SessionValue , @ipaddr , @LastActivity , @LoggedOut , @CustomerSessionGUID , @CreatedOn , @ExpiresOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CustomerSessionID", entity.CustomerSessionId) , new SqlParameter("@CustomerID", entity.CustomerId) , new SqlParameter("@SessionName", entity.SessionName) , new SqlParameter("@SessionValue", entity.SessionValue ?? (object)DBNull.Value) , new SqlParameter("@ipaddr", entity.Ipaddr ?? (object)DBNull.Value) , new SqlParameter("@LastActivity", entity.LastActivity) , new SqlParameter("@LoggedOut", entity.LoggedOut ?? (object)DBNull.Value) , new SqlParameter("@CustomerSessionGUID", entity.CustomerSessionGuid) , new SqlParameter("@CreatedOn", entity.CreatedOn) , new SqlParameter("@ExpiresOn", entity.ExpiresOn) }; 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(GetCustomerSession(Convert.ToInt32(identity))); } return(entity); }
public virtual CustomerSession UpdateCustomerSession(CustomerSession entity) { if (entity.IsTransient()) { return(entity); } CustomerSession other = GetCustomerSession(entity.CustomerSessionId); if (entity.Equals(other)) { return(entity); } string sql = @"Update CustomerSession set [CustomerID]=@CustomerID , [SessionName]=@SessionName , [SessionValue]=@SessionValue , [ipaddr]=@ipaddr , [LastActivity]=@LastActivity , [LoggedOut]=@LoggedOut , [CustomerSessionGUID]=@CustomerSessionGUID , [CreatedOn]=@CreatedOn , [ExpiresOn]=@ExpiresOn where CustomerSessionID=@CustomerSessionID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CustomerSessionID", entity.CustomerSessionId) , new SqlParameter("@CustomerID", entity.CustomerId) , new SqlParameter("@SessionName", entity.SessionName) , new SqlParameter("@SessionValue", entity.SessionValue ?? (object)DBNull.Value) , new SqlParameter("@ipaddr", entity.Ipaddr ?? (object)DBNull.Value) , new SqlParameter("@LastActivity", entity.LastActivity) , new SqlParameter("@LoggedOut", entity.LoggedOut ?? (object)DBNull.Value) , new SqlParameter("@CustomerSessionGUID", entity.CustomerSessionGuid) , new SqlParameter("@CreatedOn", entity.CreatedOn) , new SqlParameter("@ExpiresOn", entity.ExpiresOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetCustomerSession(entity.CustomerSessionId)); }